REST API - Date Discrepancy
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.
- 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.