how to list all files at sites/site_id/drives/drive_id/dira/dirb in sharepoint?

[davidxiaodev]

Let's say I have a directory at sharepoint like below, and i like to list all files under "dira/dirb"
sites/site_id/drives/drive_id/dira/dirb/....
I could get site_id and drive_id via source code,
But not found a way to list all files(or directories) under "dira/dirb", any advice?

Thanks very much

[bochap]

I wasn't able to figure this out the correct way but it appears that the API doesn't really provide such searches out of the box. If your app is given Files.Read.All then there is a good chance you might be able to use the search feature. if not I was able to do a poor man's hack with something like the following (PS this is not really documented and I don't even understand what is correct in the documentations)

    try:
        # uses `root:/{path}` where path is the relative path to the directory from the selected drive
        # refer to the cryptic documentation at https://docs.microsoft.com/en-us/graph/api/driveitem-get?view=graph-rest-1.0&tabs=http
        # titled Path-based addressing within a drive Path-based addressing within a drive
        # and this issue https://github.com/microsoftgraph/msgraph-sdk-python/issues/40#issuecomment-1380361845
        item = await client.drives.by_drive_id(
            drive_id
        ).items.by_drive_item_id(f"root:/{path}").get()        
    except ODataError as error:
        if error.response_status_code != 404:
            raise error

    drive_items = await client.drives.by_drive_id(
        drive_id
    ).items.by_drive_item_id(
        item.id
    ).children.get()

You will need to call the API twice since relative path resolution doesn't return the children. And if you try to access that it will blow that. It seems that the Graph API is trying to gather everything in a massive blob and the functionality is kind of lacking. Documentation is a mess too and you really have to guess what it is trying to do.

[musale]

@bochap is right that you will have to query the API twice in most implementations. Alternatively you can try and add query parameters to filter or select specific fields

from kiota_abstractions.request_configuration import BaseRequestConfiguration

def configure_request(request_info):
    request_info.headers.try_add("Content-Type", "application/json")
    request_info.query_parameters["$select"] = ["name,webUrl,size,lastModifiedDateTime"]
    request_info.query_parameters["$orderby"] = "name"

# Add to the children.get() call:
children = await graph_client.sites.by_site_id(site_id)\
    .drives.by_drive_id(drive_id)\
    .items.by_drive_item_id(folder.id)\
    .children\
    .get(request_configuration=configure_request)

[microsoft-github-policy-service]

This issue has been automatically marked as stale because it has been marked as requiring author feedback but has not had any activity for 4 days. It will be closed if no further activity occurs within 3 days of this comment.