Sharepoint 2013 GetListItems web service returning a list of folders in library, instead of list of files within a folder

Question

I'm having a problem being able to get the list of items within a folder, it keeps giving me the list of folders in the library, and not the list of files within the specified folder.

I'm using a C# program, using the following method to call the web service GetListItems, and it all seems to work up to a point:

[System.Web.Services.Protocols.SoapDocumentMethodAttribute("http://schemas.microsoft.com/sharepoint/soap/GetListItems", RequestNamespace="http://schemas.microsoft.com/sharepoint/soap/", ResponseNamespace="http://schemas.microsoft.com/sharepoint/soap/", Use=System.Web.Services.Description.SoapBindingUse.Literal, ParameterStyle=System.Web.Services.Protocols.SoapParameterStyle.Wrapped)]
public System.Xml.XmlNode GetListItems(string listName, string viewName, System.Xml.XmlNode query, System.Xml.XmlNode viewFields, string rowLimit, System.Xml.XmlNode queryOptions, string webID) {
    object[] results = this.Invoke("GetListItems", new object[] {
                listName,
                viewName,
                query,
                viewFields,
                rowLimit,
                queryOptions,
                webID});
    return ((System.Xml.XmlNode)(results[0]));
    }

The values of the parameters are as follows:

listName = "Letters"
viewName = null
query = null
viewFields.OuterXml = "
                             
                            
                            
                            
                            
                            
                            
                        "
rowLimit = null
queryOptions.OuterXml = "
                            FALSE
                            http://D3TVCAPP-APP02.test.local/Letters/ABBOTT, Nash  _489611
                            TRUE
                         "
webID = null

And it actually returns a result, it is hitting the service ok, the result looks like this:

results.OuterXml =  
    "
        
            
            
        
    "

Apologies for the wall of code, I just hope that someone can help me and want to provide as much info as possible. I can't figure this one out, I feel like I'm doing everything right. Anyone got any idea what I 'm doing wrong?

user_10549791 · Answer

C# Programming give for developers two options to consumes SharePoint data; seeing your code, I think you try to consume SharePoint data using REST API approach. The REST API approach is commonly used to make interfaces with SharePoint and external Systems written by other programming languages (different of C#) and not used a lot by C# developer community in frequency; but, it's need to be clear: it's not a rule and it's not impossible to consumes SharePoint data using REST API from C#, but this is more "difficultly" comparing with CSOM approach.

Now, I will show you an example using CSOM approach to get files from specific folder, and you get your conclusions:

First of all, download and install SharePoint 2013 Client SDK;
After installed SDK, create some standalone app, like a Console App using .NET Framework 4.5 or later;
Add in References (search in Framework) two DLLs: Microsoft.SharePoint.Client.dll and Microsoft.SharePoint.Client.Runtime.dll;
Add this code-file bellow in your Console App Project:

using System;
using System.Net;
using System.Security;
using System.Collections.Generic;
using Microsoft.SharePoint.Client;

namespace SharePoint.Csom.Approach
{
    public class SharePointDocumentModel
    {
        public string FileName { get; set; }

        public string Url { get; set; }

        public string Version { get; set; }
    }

    public class SharePointDocuments : IDisposable
    {
        private bool _disposed = false;

        protected readonly ClientContext _clientContext;

        public SharePointDocuments(string sharepointSiteUrl, string user, SecureString password)
        {
            if (string.IsNullOrWhiteSpace(sharepointSiteUrl) || !sharepointSiteUrl.StartsWith("http"))
            {
                throw new InvalidOperationException("Impossible to connect with invalid URL.");
            }
            this._clientContext = new ClientContext(sharepointSiteUrl);
            this._clientContext.AuthenticationMode = ClientAuthenticationMode.Default;
            this._clientContext.Credentials = new NetworkCredential(user, password);
        }

        public IEnumerable GetFiles(string folderRelativeURL)
        {
            Web web = this._clientContext.Web;
            this._clientContext.Load(web);
            this._clientContext.ExecuteQuery();
            Folder folder = web.GetFolderByServerRelativeUrl(web.ServerRelativeUrl + folderRelativeURL);
            this._clientContext.Load(folder);
            this._clientContext.ExecuteQuery();
            FileCollection fileCol = folder.Files;
            this._clientContext.Load(fileCol);
            this._clientContext.ExecuteQuery();
            foreach (File file in fileCol)
            {
                string fileVersion = null;
                FileVersionCollection oFileVersionCollection = file.Versions;
                this._clientContext.Load(oFileVersionCollection);
                this._clientContext.ExecuteQuery();
                foreach (FileVersion oFileVersion in oFileVersionCollection)
                {
                    fileVersion = oFileVersion.VersionLabel;
                }
                yield return new SharePointDocumentModel()
                {
                    FileName = file.Name,
                    Url = file.ServerRelativeUrl,
                    Version = fileVersion
                };
            }
        }

        public void Dispose()
        {
            this.Dispose(true);
        }

        private void Dispose(bool disposing)
        {
            if (this._disposed)
            {
                return;
            }
            if (disposing)
            {
                if (null != this._clientContext)
                {
                    this._clientContext.Dispose();
                }
            }
            this._disposed = true;
        }

        ~SharePointDocuments()
        {
            this.Dispose(false);
        }
    }
}

At Program class and in Main method, add this code:

List files = new List





Voilá!

After made your tests, give us the feedback.
Thanks.

Sharepoint 2013 GetListItems web service returning a list of folders in library, instead of list of files within a folder

1 Answers