The GoSquared API is an incredibly powerful way for you to retrieve any of the data available in the GoSquared apps, Now, Trends and (soon!) People Analytics.
Our customers use our API in a wide variety of different scenarios, from real-time on-the-fly promotion of website content, to complex offline analysis as part of a larger workflow.
Today we’re introducing the ability to specify exactly what formats should be used for dates in our API responses. By specifying a dateFormat
parameter in any API request, with any format string allowed by Moment.js, you can now ensure that the data you retrieve from our API is in a format that works best for you.
By default, the format used for dates will stay as ISO 8601 (YYYY-MM-DDTHH:mm:ssZ
) for JSON responses, but for CSVs (including CSV exports from People Analytics) it will change to YYYY-MM-DD HH:mm:ss
. This now means that common spreadsheet applications like Excel or Google Sheets can interpret these values properly without any pre-processing.
On its own, this change is fairly small, but we hope that it will enable you to use your GoSquared data in a wider variety of applications and workflows.