When running a selectQuery like:
https://www.rollbase.com/rest/api/selectQuery?sessionId=yoursessionidhere &output=json&query=SELECT%20name,%20CustNum,%20createdAt%20FROM%20Customer4
(SELECT name, CustNum, createdAt FROM Customer4)
The response may look like this:
[ [ "Lift Tours", 1, new Date("Wed Oct 23 2013 17:53:33 (EDT)")] ]
According to http://en.wikipedia.org/wiki/Json#Unsupported_native_data_types all date values must be passed as a supported data type - most likely string.
So as, the new Date("Wed Oct 23 2013 17:53:33 (EDT)" expression does not comply with the JSON Standard (http://tools.ietf.org/html/rfc4627) I consider the output to be buggy. And as a matter of fact the ABL JsonObjectModel Parser does not like the response without preprocessing with is against the purpose of a standarized document format.
Or am I missing a point here?
Indeed the value should have been
"new Date('Wed Oct 23 2013 17:53:33 (EDT)')"
This has been logged as a bug and will be tracked.
Hello Mike,
This issue has been fixed in 2.2 release (26th April 2014) of the product. Dates are now returned in a Javascript parsable format.
Thanks,
Santosh