AnsweredAssumed Answered

No records returned using rest API and filtering by date_modified

Question asked by David Richards on Feb 3, 2017
Latest reply on Feb 6, 2017 by Francesca Shiekh

Hi,

 

I'm trying to retrieve all calls modified after a certain date. I have a record where the modified date is 2017-02-02T05:13:51-08:00

 

The following request successfully returns the record:

 

/Calls?filter[0][date_modified]][$gte]=2017-02-02T05:13:51-08:00

 

But if I change the month or day to any day prior it retuns nothing. For example:

 

/Calls?filter[0][date_modified]][$gte]=2017-01-02T05:13:51-08:00

or

/Calls?filter[0][date_modified]][$gte]=2017-02-01T05:13:51-08:00

 

I also tried this which does work:

 

/Calls?filter[0][date_modified]][$gte]=2017-02-02 

 

But again anything that is not exactly the modified date of the record returns nothing:

 

/Calls?filter[0][date_modified]][$gte]=2017-02-01

/Calls?filter[0][date_modified]][$gte]=2017-01-02 

 

Any help would be appreciated.

 

Thanks

 

Outcomes