Parse REST API date range query

Question

I am trying to figure out how I can make a request to the REST API for Parse that can accept a range against the createdAt column. I can issue the following constraint which works but when I try a compound query that tries to do a GT and a LT constraint I get a Bad Request error.

var requestParams = 'where={ "createdAt": { "$gt": { "__type": "Date", "iso": "' + startDate + '" } } } ';

Is this possible with the REST API?

C-- · Accepted Answer · 2014-07-30 07:16:34Z

9

I'm not quite sure in what format you are passing the startDate. The correct example to do such a thing is as follows.

curl
    -X GET
    -H "X-Parse-Application-Id: [APP_ID]"
    -H "X-Parse-REST-API-Key: [KEY]"
    -G --data-urlencode 'where={"createdAt":{"$gte":{ "__type": "Date", "iso": "2014-07-28T07:57:03.900Z" }}}'   
    https://api.parse.com/1/classes/[YOUR CLASS]

The example below shows how to do this using their Javascript SDK

Javascript query using greaterThan "createdAt"

answered Jul 30, 2014 at 7:16

C--

16.6k6 gold badges57 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Kevin Over a year ago

Thank you for your response. Sorry, I should have been more clear. The date format is an ISO format and my where clause that I posted works. What I am trying to do now is perform a $gt and $lt on createdAt. By the looks of everything I have read, this is not possible with the REST API.

brit503 · Accepted Answer · 2021-07-30 05:26:10Z

2

I think you can query a date range by combining multiple conditions for the date column rather than listing the column multiple times, which is what I tried and what I assume you tried. This worked for me:

{
  "createdAt": {
    "$gte": {
      "__type": "Date",
      "iso": "2019-01-15"
    },
    "$lte": {
      "__type": "Date",
      "iso": "2019-07-15"
    }
  }
}

answered Jul 30, 2021 at 5:26

brit503

538 bronze badges

Collectives™ on Stack Overflow

Parse REST API date range query

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related