Microsoft Graph: how to filter drive items by createdDateTime?

Question

Hello! Is it possible to filter the drive items in a request to site/drive (Sharepoint) by createdDateTime? I tried this one:
GET https://graph.microsoft.com/v1.0/sites/{ourSiteId}/drive/root:/customFolder/children?$filter=createdDateTime le 2023-11-09T07:23:05.004Z

But got 400 'Invalid request'. The same was when I tried to change the date format to createdDateTime le 2023-11-09T07:23:05Z

When I call this endpoint without $filter=createdDateTime le 2023-11-09T07:23:05.004Z it works fine.

Is filtering by createdDateTime supported for drive items at all?

Thank you!

Answer 1

Hi @Anastasiia Ilina

Filtering drive items based on the createdDateTime property is not currently supported, you can try getting a collection of child items and filtering locally.

Using graph SDK:

var items = await graphClient.Drives["{drive id}"].Items["{item id}"].Children.GetAsync();

var date = DateTimeOffset.Parse("2023-10-20T08:27:26Z");

foreach (var item in items.Value) {

    if (item.CreatedDateTime <= date) {

        Console.WriteLine("{" +  "id: " + item.Id + "\r\n" + "createdDateTime: " + item.CreatedDateTime + "}" + "\r\n");
    
    }
}

Hope this helps.

If the reply is helpful, please click Accept Answer and kindly upvote it. If you have additional questions about this answer, please click Comment.