AddieBrunson
3 years agoQrew Member
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 options without success. Here's what I'm looking at:
Below is an example of the data from a user data call. This has 2 employee objects (or arrays? I'm not sure...) I'd like to create a record for each employee, pulling their email address from the data into a field. When I enter the example below in the JSON Schema Sample and run the pipeline, I get only a record created for employee 1.
I've tried altering the JSON schema sample to what's shown below. When I take this approach, I get a record created, but it is completely blank (no email).
Any help would be much appreciated!
------------------------------
Addie Brunson
------------------------------
Below is an example of the data from a user data call. This has 2 employee objects (or arrays? I'm not sure...) I'd like to create a record for each employee, pulling their email address from the data into a field. When I enter the example below in the JSON Schema Sample and run the pipeline, I get only a record created for employee 1.
I've tried altering the JSON schema sample to what's shown below. When I take this approach, I get a record created, but it is completely blank (no email).
Any help would be much appreciated!
------------------------------
Addie Brunson
------------------------------