vb.net - Listing files in SharePoint Folder - Stack Overflow

admin管理员组

文章数量:1352158

I'm building a library with methods to use against the on-prem api for SharePoint, I'll skip the part on how we authenticate since I know that is working for other methods. We're using a HttpClient to do the request.

What I want to achieve is a method that returns a list of all files in a specific folder. I've found several post stating that this url should work but I don't get any files. "/_api/web/GetFolderByServerRelativeUrl('MyRoom/Document/MyFolder')/Files" neither does this one: "/_api/web/GetFolderByServerRelativeUrl('MyRoom/Document/MyFolder')"

I parsed the result into xml and saved it to a file. I was expecting to see the existing files somewhere in that xml, I do not. This is a part of the xml:

<content type="application/xml">
    <m:properties>
        <Exists m:type="Edm.Boolean">true</Exists>
        <IsWOPIEnabled m:type="Edm.Boolean">false</IsWOPIEnabled>
        <ItemCount m:type="Edm.Int32">3</ItemCount>
        <Name>_FromBizTalk</Name>
        <ProgID m:null="true"/>
        <ServerRelativeUrl>/MyRoom/Document/MyFolder</ServerRelativeUrl>
        <TimeCreated m:type="Edm.DateTime">2025-01-22T13:08:42Z</TimeCreated>
        <TimeLastModified m:type="Edm.DateTime">2025-03-28T13:42:56Z</TimeLastModified>
        <UniqueId m:type="Edm.Guid">a8c8dda7-a7e2-44ed-ade4-82f878332b58</UniqueId>
        <WelcomePage/>
    </m:properties>
</content>

It gets the numbers of files right at least, ItemCount tag.

I also tried to use CSOM and the following code:

Function ListFilesInFolder(in_Context As ClientContext, in_SharePointFolderAndRoom As String) As List(Of String)
    Dim out_List As List(Of String) = New List(Of String)

    Try
        Dim web As Web = in_Context.Web
        Dim folder As Folder = web.GetFolderByServerRelativeUrl(in_SharePointFolderAndRoom)

        in_Context.Load(folder.Files)
        in_Context.ExecuteQuery()

        For Each file As File In folder.Files
            out_List.Add(file.Name)
        Next

    Catch ex As Exception
        Throw New Exception("Error when listing files: " + ex.Message)
    End Try

    Return out_List
End Function

But it returns an empty list, debugging shows that the variable folder is empty. It is the same SharePoint room and folder I'm using to upload/download files to the folder so I know the folder exists.

Is it possible that there is a setting in SharePoint that prevents me from listing files? More likely I'm doing something wrong, but what?

本文标签： vbnetListing files in SharePoint FolderStack Overflow