JSON export file not matching documentation, unable to fix
2024년 12월 29일에 게시됨
We're trying to parse the Zendesk JSON ticket export file that we downloaded from the admin center. The documentation article Why is my full JSON export not a valid JSON?, says the following:
“While the file is not a valid JSON, each line within the file is valid JSON…”
And later says…
“Copy and paste the result into a JSON Validator, such as jsonlint.com, to see the format of the data.”
Also, the export documentation says that the JSON export file has each line starting with…
“{"ticket":{"id":....}}”
…but we actually see…
“{"url":"https://xxxxxx.zendesk.com/api/v2/tickets/12345.json","id":12345,”
…which makes us think that something is wrong in the export file from our account.
Additionally, when using tools like jsonlint.com, for many lines of the NDJSON exported file, I'm getting errors. For example, I'm getting an error…
Error: Parse error on line 1:
...26T15:34:48.000Z"}},{"id":41234567889,"
-----------------------^
Expecting 'STRING', got ‘{’
…which is happening nearby the first of the comment nodes.
We really need to be able to parse the JSON, but it looks like it's malformed…and we can't seem to find a standard pattern to fix it. Any thoughts?
0
댓글 1개
로그인하세요.