JSON data size fix
- 4 years ago
I assume you are using the JSON Formatter to write the file, yes? But how are you formatting it? And what application are you using to try to open the file?
By default, the JSON Formatter will use a very compressed format with no line breaks. Some editors don’t deal well with a file where all the data is on one very long line.
You could enable “Pretty Print” on the formatter, which produces a much more readable and verbose format like this:
But this format can also be a challenge for some JSON-capable applications since all of the data is inside a single JSON array.You might want to consider the “JSON Lines” format, where each line is a compactly formatted JSON object representing one document:
This is often the best choice when dealing with a “log”. Each JSON line corresponds to a line of your CSV file. See https://jsonlines.org/