Mike Maughan
Posts: 0
Joined: Wed Feb 19, 2014 10:55 pm

REST API service where clause on _createdAt

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...

Illya Stepanov
Posts: 0
Joined: Mon Mar 18, 2013 8:48 am

REST API service where clause on _createdAt

Hi Mike,

We are working on it, we'll get back to you with an update.

Evgene Karachevtsev
Posts: 12
Joined: Mon Apr 28, 2014 1:12 pm

REST API service where clause on _createdAt

Hello Mike,

Such queries cannot be applied to predefined columns _createdAt and _updatedAt. only to custom ones.

Mike Maughan
Posts: 0
Joined: Wed Feb 19, 2014 10:55 pm

REST API service where clause on _createdAt

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?

Evgene Karachevtsev
Posts: 12
Joined: Mon Apr 28, 2014 1:12 pm

REST API service where clause on _createdAt

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.

Return to “Issues”