Supporting JSON has been on our backlog for some versions now, with List & Label 25 we’ll finally deliver. Usage is quite straightforward – given a typical list-based report like this
you can now choose JSON from the export formats:
You can choose to ignore List & Label’s original page wrapping and print to an infinite page, also a new LL25 feature. Also, similar to the Excel export the JSON export can try and convert your data types to the best matching type in JSON.
The JSON result for the list above looks like this:
Note that there is only one page in the pages array due to usage of the infinite page feature. All numbers have been converted to numeric values instead of preserving the string syntax within the resuling UTF-8 encoded file.
Of course, exporting to JSON is also available from the API and in the Report Server – now go and create the next big thing :)!