Domenic Martha

Hello,

How to Fix and Parse It
Step 1: Convert NDJSON to Standard JSON
Since each line in the file is a valid JSON object, you can wrap the entire file into an array by:

Adding an opening [ at the top of the file.
Adding a closing ] at the bottom of the file.
Replacing every newline (\n) with a comma (,) except for the last line.
Example Python Script to Convert NDJSON:

python
Copy code
input_file = "export.ndjson"
output_file = "export.json"

with open(input_file, "r") as infile, open(output_file, "w") as outfile:
   outfile.write("[\n")
   lines = infile.readlines()
   for i, line in enumerate(lines):
       if i < len(lines) - 1:
           outfile.write(line.strip() + ",\n")
       else:
           outfile.write(line.strip() + "\n")
   outfile.write("]")
print(f"Converted NDJSON to JSON and saved as {output_file}")
Step 2: Validate and Clean Up JSON
After converting, validate the JSON file using a tool like JSONLint. If you encounter errors:

Check for Improper Escaping: Look for unescaped characters such as quotes ("), slashes (\), or other symbols in strings.
Malformed Entries: Investigate any incomplete or corrupted lines and manually fix them.
Step 3: Parse JSON Programmatically
Once converted, you can parse the JSON in any programming language. For Python:

python
Copy code
import json

with open("export.json", "r") as json_file:
   data = json.load(json_file)

# Access ticket data
for ticket in data:
   print(ticket)
Why the Difference in Expected Format?
The discrepancy between what the documentation mentions ({"ticket":{"id":....}}) and what you see ({"url":"https://xxxxxx.zendesk.com/api/v2/tickets/12345.json","id":12345,) could mean:

Zendesk recently updated their export format.
Specific configurations in your account are affecting the output.
If you suspect the format is truly incorrect, it may be worth reaching out to Zendesk Support with a sample of the file to confirm.