Reltio Integration Hub

Hello - I am using RIH - JSON Parser by Workato to parse a json document (containing nested arrays list) and reading that json parse output to load into an Entity in Reltio. The output of the JSON Parser looks right with the multiple nested array list. However when I try to read the output of the json document to read in my next step to "Create record in Entity" I cannot see the array list anymore, only the first value in the list is what I see and that is what is getting loaded into Reltio Entity. How can I get the array list loaded into Reltio Entity?

Hi Anu,

You can use the pluck function(retrieving nested fields) to propagate through each value of the nested array  to be populated for that attribute
https://docs.workato.com/formulas/array-list-formulas.html#pluck

Thank You!

Hi Anu,

Another possibility...If the target has a field with 'source list' above it (similar to screen shot below)... and you're just mapping a list (array) to a target list(array).  In addition to mapping the individual attribute you'll need to map the array into that source list field so it knows what list to get all elements of the list from.  Feel free to post some screen shots if either this or the previous suggestion doesn't work for you.

Thank you both. I got it working. For each of the nested arrays, I used the list collection and then mapped the collection when loading to the entity.