Exporting Data through Analytics Cloud API does not return valid JSON

Issue

1. Export data based on Requesting a Data Export
2. It will download a zip file for you with a JSON file
3. Open the JSON file with a text editor

Result: The data format is not valid JSON.

 

Environment

• Liferay DXP 7.0+
• Analytics Cloud

 

Resolution

• The format used is known as JSON lines, where each line is a valid JSON object.

• This offers a multitude of advantages when it comes to streaming processing, large amounts of data and parallel processing.

• Most libraries can easily work with this format including the well known Jackson.