Skip to main content

I am using Upload CRM objects (/v2/crm/entities) to Upload Accounts & Contacts data. For that i need to create a LDJSON file.
1) Need help in creating this LDJSON file. what should the extension of this file be? ndjson??. If possible can i get an example of how LDJSON looks


2) In Accounts & Contact entities, “objectId” & “modifiedDate” are mandatory fields. Users must create the objectid? how does gong identify whether a record is being updated or newly added. Also how to avoid users giving wrong “modifiedDate”

3)let's say i have 10000+ records to upload to “Contact”. can upload multiple dataFile of size 200MB each? or what is the approach you suggest?

Hi ​@Sanketh Kanugu! I pinged our team and here’s what they said: 

1.a the extension is "json"
1.b the file simply contains rows of json objects separated by ",":
{"objectId":"obj1", "key1":"val1"},
{"objectId":"obj2", "key2":"val2"} 

2.a We identify is record is new or updated by the "objectId" field - if it exists in our DB then it's an update, otherwise it's new entity

3. 10000+ records are much less than 200MB - you can upload hundreds of thousands of records in a single file, but this is not advisable, since in case of errors it will be hard to detect and fix them in such a large file. I recommend splitting to files of up to 10000 records.

@Molly Kipinis
1.a The "json" extension didn’t work; "jsonl" worked instead.
1.b The file simply contains rows of json 
{"objectId":"obj1", "key1":"val1"}
{"objectId":"obj2", "key2":"val2"} 

Reply


Terms & ConditionsCookie settings