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