How to investigate Data Loader "Failed to parse content as JSON" error?

Problem

We have done an ingestion or data load using the data loader. We are facing an issue: "Failed to parse content as JSON". We have tried using the command prompt, but still facing the same issue.

Solution

We have an input file with, say, 200 records, and a test tenant to run the data load. The data load with this file fails with the "Failed to parse content as JSON" error. 

1. First of all, we need to find an exact record in the file that caused the error. To do this we need to split the file into 2 parts and run dataload with each part. One of them will fail. Then we need to get the failed file and split it again. Repeat these operations until we find the affected record. As a result, we should get the dataload input file with 1 record only.
2. We can validate the JSON by any JSON validation tool. If it passes the validation, we should run the POST /entities or /relations request, depending on what type of object was loaded, with the parameters from the data loader (e.g., partialOverride)
3. The above steps should help to identify the affected record.

Related Documentation:

Our Doc Links can change over time, so please search for the Documentation based on the titles shared below. Thank you.

• JSON file loading example