rpc1235x - take a look at the JSON Splitter snap. For your example, you will want to enable the "Include scalar parents" option to retain the name, color, and animal attributes.
JSON Splitter snap already set to Include scalar parents.
In the mapper I have Expression: $['wd:employee']['wd:first_name'] and Target path: first_name, but what is happening is that it only outputs the arrays that only contain one (the first one only) nested array in employee. It does not create the desired output of like in the example, two data arrays.
Yes you can do it. First setup the child object in the Related Object and Related External ID.
setup the objects like this
Hi Kishore,
Thank you for the revert.
I tried the way you have mentioned, but it is not working.
As of now I am using the following pipeline -
In the mapper snap I have mapped the contact and the account fields both and in the upsert snap, I have selected Contact as the object type and in the related object and field it was Account and External Id field respectively as suggested by the comment.
I also tried inserting the account first and then again reading the data from csv to insert the contact.
But the account insert snap and the file reader snap are not getting joined maybe because the output from insert snap is not a valid one for the file reader snap.
Is it possible if you can share the pipeline with me for reference?
Is XML Parser _very_ strict? | SnapLogic - Integration Nation - 18676
