Salesforce REST API get a list of updated records

1
votes

I want to have a list of records under accounts object from a particular time to a particular time

say for example this my api query: https://ax1.salesforce.com/services/data/v29.0/sobjects/Account/updated/?start=2015-06-30T06%3A49%3A00%2B00%3A00&end=2015-06-30T16%3A30%3A26%2B00%3A00

In my salesforce the time I have chosen is Indian Time which is UTC + 5:30

I created an account at 16:45 pm on 30th June in Indian time(as per salesforce this time is shown in the created by field of the account)

but for the above query in which I have chosen the start time and end time is 06:49 AM and 16:30 PM respectively

I got the record id which I have added at 16 45 pm Indian time but it shouldn't come in the response

The following is the response: "ids": [ "0019000001QeOINAA3" ], "latestDateCovered": "2015-06-30T09:00:00.000+0000" }

Also the latestDateCovered it says 09 AM only

I don't understand this system

Could somebody help me on how this works?

1
apirestsalesforce

1 Answers

1
votes

The API REST API will be working with UTC DateTime values.

So you searched for records between:

  • 2015-06-30 06:49:00 UTC
  • 2015-06-30 16:30:26 UTC

Which I make to be:

  • 2015-06-30 12:19:00 IST
  • 2015-06-30 22:00:26 IST

So it would make sense that a record created at 16:45 pm on the 30th of June IST would appear in the results.

Try checking the SystemModStamp and LastModifiedDate fields in the API for the record in question, as the values will also be in UTC there.