Forum Discussion

Qrew Member

3 years ago

JSON Fetch > Iterate over JSON Records > Create Records

I'm having issues getting a pipeline to add records for each JSON object. I think it has to do with the JSON schema example in the Iterate over JSON records step, but I've tried a few different option...

DougHenning1

Community Manager

3 years ago

Hi Addie,

The JSON schema sample should only contain the schema for a single record structure. The purpose of the schema is to help you reference the fields for drag and drop in later steps. So in your case, you can use this for a schema:

{
"id": 0,
"first_name": "",
"last_name": "",
"email": "",
"location": "",
"employee_id": "",
"is_active": true,
"company_groups_ids": [ "", "" ]
}

The values don't have to be populated with real data, but the value defines the field type (e.g. "" for a text field, true or false for boolean, etc.)

Then you should see the fields specified in the schema in following steps to create new records:

Hope that helps!

------------------------------
Doug Henning
------------------------------

AddieBrunson
Qrew Member
3 years ago
Hi Doug,

Thanks for the quick reply! I changed the schema with your recommendation, but still getting 1 record created that is completely blank. Below is what I'm getting when running the pipeline. The pipeline is also going idle after a few seconds...

------------------------------
Addie Brunson
------------------------------
- DougHenning1
  Community Manager
  3 years ago
  Forgot to mention you need to set the records path. The list of objects is in /results so put that in the JSON Records Path
  
  ------------------------------
  Doug Henning
  ------------------------------