Strange looking date representation in JSON response for sel

Posted by Mike Fechner on 11-Nov-2013 01:16

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?

All Replies

Posted by Santosh Patel on 12-Nov-2013 03:32

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.

Posted by Santosh Patel on 30-Apr-2014 14:30

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

This thread is closed