Get all files from a specific folder(drive) in Sharepoint site.

[MathavanN]

Describe the bug

I am trying to get files from a specific folder(drive) in Sharepoint.

Microsoft.Graph V5.63.0

First I am getting the DriveItem.

My Code:

string filter = $"tolower(Name) eq '{folderName.ToLower()}' and endswith(tolower(WebUrl),'{parentFolderPath.ToLower()}/{folderName.ToLower()}')";
DriveItemCollectionResponse driveItemCollectionResponse = await _graphClient.Drives[_driveId].Items.GetAsync(delegate (RequestConfiguration<ItemsRequestBuilder.ItemsRequestBuilderGetQueryParameters> reqConfig)
{
    reqConfig.QueryParameters.Filter = filter;
}, cancellationToken);
if (driveItemCollectionResponse != null && driveItemCollectionResponse.Value != null && driveItemCollectionResponse.Value.Count > 0)
{
    driveItem = driveItemCollectionResponse.Value.First();
}

I am using QueryParameters filter to get the specific folder. I have tested this code and I am sure that the filter works. Application has been running in Live for a while.

Last 2 days (from Dec 14, 2024), I see that the filter is not working. driveItemCollectionResponse contains all files and folders from Sharepoint site.

Result from 14th Dec, 2024

Expected behavior

Expected to filter by folder name and webUrl.

How to reproduce

Get items from a sharepoint drive and apply filter.

SDK Version

5.63.0

Latest version known to work for scenario above?

5.63.0

Known Workarounds

No response

Debug output

Click to expand log

```

</details>


### Configuration

_No response_

### Other information

_No response_

[MathavanN]

tested in https://developer.microsoft.com/en-us/graph/graph-explorer

[jeglinski]

Hello,

i have also noticed this error.

Both programmatically in C# (.NET9) with 'Microsoft.Graph” (version 5.68.0) and with the help of a WebAPI test tool:

GET “https://graph.microsoft.com/v1.0/drives/{drive-id}/items?$filter=name+eq+%27Test%27” returns all results. The filtering is not taken into account.

When will this error be solved?
Thomas

(See https://learn.microsoft.com/en-us/answers/questions/2133340/sharepoint-api-odata-filter-is-not-working)

[martinlingstuyl]

Hi guys, I have run into the same issues on my end.

I've succeeded in reaching someone from Microsoft on this. The response boils down to this:

The /drives/{id}/items endpoint only supports filtering by /listitem/fields/{fieldName} and there's an option to scope the query to a folder (immediate children) by specifying $filter=parentReference/id eq '{folderItemId}'. Both built-in and custom fields are supported for filtering.

So it appears to be by design. Even if your queries used to work correctly before.
A docs update on this should be in the making.

I hope this gets you unstuck...
In your case you could filter by listItem/fields/FileLeafRef instead of name

[rkodev]

Hi everyone,

Thank you all for reaching out and trying the SDK. As @martinlingstuyl correctly noted, this is not an issue with the SDK but an issue with the service team. This repo is dedicated to changes to the SDK but not service issue. For future reference, you can always file a service issue here so as to notify the service team

[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.