REST API service where clause on _createdAt
Posted: Mon Aug 11, 2014 10:33 pm
by Mike Maughan
I have a REST API service where clause with $date (accessing _createdAt) and I want to add a $gt so that the response is only rows that were created after a specific _createdAt date/time.
What would the cURL command look like?
Here is where I've been looking for an answer:
http://devcenter.appery.io/wp-content...
http://devcenter.appery.io/documentat...
REST API service where clause on _createdAt
Posted: Mon Aug 11, 2014 11:38 pm
by Illya Stepanov
Hi Mike,
We are working on it, we'll get back to you with an update.
REST API service where clause on _createdAt
Posted: Tue Aug 12, 2014 12:15 pm
by Evgene Karachevtsev
Hello Mike,
Such queries cannot be applied to predefined columns _createdAt and _updatedAt. only to custom ones.
REST API service where clause on _createdAt
Posted: Tue Aug 12, 2014 1:01 pm
by Mike Maughan
Thanks. And as an alternative, is id sequential such that I could find the MAX(id) and it be the most recent entry in the collection?
REST API service where clause on _createdAt
Posted: Tue Aug 12, 2014 1:24 pm
by Evgene Karachevtsev
Mike,
Perhaps, it would be more correct to add the field "time" with time, as in the example, and use described in the documentation methods.