how to filter a collection by date column on GET method REST api

I need to obtain a collection of Person objects filtered by the XDateLastUpdated higher than specific date, for this im using the Where query parameter like this

api/entities/Person?where=XDateUpdated>2023-04-19&limit=100, this returns a very big response containing Persons items with any UpdateDate so i assume there is an error on the way im writing my where parameter

Any tips on how to create this filter properly ?

Environment is 1IM 8.1

0 hector bernal over 1 year ago

This is just a PoC on how to obtain this data, the final goal is to do the same on top of a custom view instead of Person
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 hector bernal over 1 year ago

[Answer] Just enclose the parameter value in single quotes as /api/entities/Person?where=XDateUpdated%3E'2023-03-01'&orderBy=XDateUpdated
Cancel
Up 0 Down

Reply

Verify Answer

Reject Answer

Cancel

Endpoint Privilege Management

how to filter a collection by date column on GET method REST api