Get events (v4) - Invalid filter clause

[Michal]

When I use the following parameters in Get events (v4)

• Filter Query: showAs ne 'oof' AND showAs ne 'tentative' AND isAllDay eq 'false'
• Order By: Start/DateTime asc

I got the following error:
  "status": 400,
  "message": "Invalid filter clause"

When I am using the following parameters it works OK:

• Filter Query: showAs ne 'oof' AND showAs ne 'tentative'
• Order By: Start/DateTime asc

The "Start/DateTime asc" I borrowed from this solution. Thank you @BeeBee 

When I tried the following it also returns the same error:

• Filter Query: isAllDay eq 'false'
• Order By: Start/DateTime asc

Any tips?

[Michal · Accepted solution]

OK. I found it. 

• Filter Query: isAllDay eq false

It should be without ' ' '😣

[Michal]

But I have another issue. 

How to filter events for the last 7 days or even greater than today.  

I am trying to use:

• Filter Query: Start/DateTime gt 'utcNow('yyyy-MM-ddT00:00:00')'

It throws the same error. (Invalid filter clause)

If I use this:

• Filter Query: Start/DateTime gt 'utcNow()'

It throws the error: "The value 'utcNow()' of parameter 'DateTime' is invalid."

I have failed also using the

• Start/DateTime gt addDays(utcNow('yyyy-mm-ddThh:mm:ss');-7)
• Start/DateTime gt addDays(utcNow();-7) 
• Start/DateTime gt 'addDays(utcNow('yyyy-mm-ddThh:mm:ss');-7)'
• Start/DateTime gt 'addDays(utcNow();-7)' 

Any tips?

[BeeBee]

Have you tried SubtractFromTime()?

Watch this youtube video for tutorial.

For addDays, the format is like this if you want to add 7 days:

'addDays(utcNow(),7,'yyyy-MM-ddT00:00:00')'

Hope this helps

[VB2023]

Hello Guys,

Can someone help me with this error ? I am not getting body in output.

 "statusCode": 400,

    "headers": {

        "Transfer-Encoding": "chunked",

        "Vary": "Accept-Encoding",

        "Strict-Transport-Security": "max-age=31536000",

        "request-id": "5b9f454c-228c-4570-93b9-2917d7e867ad",

        "client-request-id": "5b9f454c-228c-4570-93b9-2917d7e867ad",

        "x-ms-ags-diagnostic": "{\"ServerInfo\":{\"DataCenter\":\"Australia Southeast\",\"Slice\":\"E\",\"Ring\":\"4\",\"ScaleUnit\":\"001\",\"RoleInstance\":\"ML1PEPF00006B90\"}}",

        "Timing-Allow-Origin": "*",

        "x-ms-apihub-cached-response": "true",

        "x-ms-apihub-obo": "false",

        "Date": "Tue, 21 Mar 2023 07:07:21 GMT",

        "Content-Type": "application/json",

        "Content-Length": "285"

    },

    "body": {

        "error": {

            "code": "BadRequest",

            "message": "Invalid filter clause",

            "innerError": {

                "date": "2023-03-21T07:07:22",

                "request-id": "5b9f454c-228c-4570-93b9-2917d7e867ad",

                "client-request-id": "5b9f454c-228c-4570-93b9-2917d7e867ad"

            }