Getting error "invalidRequest" when filtering based on lastModifiedDateTime (Microsoft Graph API)

Question

I am using the below filters for the graph api request.

?$filter=lastModifiedDateTime ge 2023-10-06T06:48:54Z&$select=name,lastModifiedDateTime,@microsoft.graph.downloadUrl

I am getting the following error:

{
    "error": {
        "code": "invalidRequest",
        "message": "Invalid request"
    }
}

The request cannot be fulfilled due to bad syntax.

This is the list of items without the filter condition.

{
    "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#Collection(driveItem)",
    "value": [
        {
            "@odata*.etag": "***",
            "lastModifiedDateTime": "2023-10-06T06:48:54Z",
            "name": "Archive"
        },
        {
            "@odata.etag": "**",
            "lastModifiedDateTime": "2024-05-07T06:53:10Z",
            "name": "Pricing_Reference_Data_from_Source_Report.xlsx"
        }
    ]
}

Could you please help me understand what the issue with the above syntax is? Thanks in advance.

Does putting single quotes around the date do something? '2023-10-06T06:48:54Z' — ninadepina
– ninadepina, Commented Nov 9 at 17:43
I get this error { "error": { "code": "BadRequest", "message": "Invalid filter clause: A binary operator with incompatible types was detected. Found operand types 'Edm.DateTimeOffset' and 'Edm.String' for operator kind 'GreaterThanOrEqual'.", "innerError": { "date": "2025-11-09T17:02:32", "request-id": "6f2740ce-e395-4d49-94f4-949d487624af", "client-request-id": "6f2740ce-e395-4d49-94f4-949d487624af" } } } — user31845738
– user31845738, Commented Nov 9 at 18:14
And adding 'datetime' before the date? datetime'2023-10-06T06:48:54Z' — ninadepina
– ninadepina, Commented Nov 9 at 18:27
This error: { "error": { "code": "BadRequest", "message": "Invalid filter clause: Syntax error at position 55 in 'lastModifiedDateTime ge datetime '2023-10-06T06:48:54Z''.", "innerError": { "date": "2025-11-09T18:30:51", "request-id": "b599b2c9-5105-4472-9374-8525b63c41e6", "client-request-id": "b599b2c9-5105-4472-9374-8525b63c41e6" } } } — user31845738
– user31845738, Commented Nov 9 at 18:31

martinm · Accepted Answer · 2025-11-10 08:26:31Z

1

For your query to work, you need to specify the Prefer request header with the value TryFilterLastModifiedDateTimeTimeWarningMayFailRandomly,apiversion=2.1.

GET /v1.0/sites/{site_id}/drives/{drive_id}/root:/{folder_name}:/children?$filter=lastModifiedDateTime ge datetime '2023-10-06T06:48:54Z'&$select=name,lastModifiedDateTime,@microsoft.graph.downloadUrl

Prefer: TryFilterLastModifiedDateTimeTimeWarningMayFailRandomly,apiversion=2.1

The apiversion=2.1 will ensure that your request is routed to internal beta SharePoint API . Because it's internal beta API, it's not recommended for the production.

The TryFilterLastModifiedDateTimeTimeWarningMayFailRandomly will ensure that you can filter drive items by lastModifiedDateTime, but as the name says, the filtering can fail randomly.

answered Nov 10 at 8:26

martinm

22.1k4 gold badges45 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user31845738 Nov 10 at 9:05

Thanks a lot. This seems to be working. Another question unrelated to the previous one: I am adding @microsoft.graph.downloadUrl to the select param, but I don't get it in the response. I get @odata.etag instead. What is the reason for that? How can I select @microsoft.graph.downloadUrl

Collectives™ on Stack Overflow

Getting error "invalidRequest" when filtering based on lastModifiedDateTime (Microsoft Graph API)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related