You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

REST API - Date Discrepancy

Received Response
edited Aug 4, 2017 3:05PM in Integrations and APIs 3 comments


Hi all,

We are extracting data (custom object) from Oracle Service Cloud, via REST API, and into a CSV file.

Two of the attributes/fields are Start Date and End Date. And unfortunately we are finding discrepancies on these.

For example:

  • In Oracle Service Cloud (in the workspace) we can see
    • Start Date: 01/05/2017
    • End Date: 30/04/1018
  • But the response back from the API is
    • Start Date: 30/04/2017
    • End Date: 29/04/1018

i.e. it seems that is is "robbing" one day to each of the dates. And we cannot find any reason for this to be happening. As all we are doing is adding the REST API response to a string to a cell. The response comes in to the code and we simply convert it from a JSON encoded string to an excel cell, and also a CSV file.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!