Skip to Content
Author's profile photo Vijai Reghunath

Successfactors Odata API : JSON Query Issue

Successfactors Odata service uses Edm.DateTime ( January 1, 1753 to December 31, 9999) and the date is stored in the database in same format. Successfactors Odata api supports two formats : ATOM and JSON. When we query the database in ATOM (Atom XML) format there won’t be any issues as it returns values in date-time format. See below sample queries.

In ATOM format



 In JSON format.


It returns Date value in epoch. Date(0) is returned because its 0 seconds elapsed since 1970-01-01 T00:00:00 UTC.

Now we will do a query which will return date = 31.12.9999.


In ATOM format


In JSON format



Date(253402300799000) is Jan 11, 1978, here it went wrong. So if you are dealing with dates, always prefer using ATOM format.

The maximum possible date value that could passed successfully in JSON format is Nov 16, 5138, l call it as “Year 5138 Problem” !!!




Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.