Extract or Flatten JSON Array data as columns

[GanguP]

Need help in to pulling data from the below JSON and also from the Array (Tags) below.   I also went through the documentation but unable to get to the solution.    


"entity":
{
"totalRecords":20
"_links":
{
"self":"https://HostName/incontactapi/services/v29.0/contacts?startDate=2024-01-24T00:00:00&endDate=2024-01-...","next":null,"previous":null
}
"businessUnitId":4605487
"lastPollTime":"2024-01-30T12:18:14.604Z"
"contacts":
[
{
"abandoned":false
"abandonSeconds":0.0
"acwSeconds":0.0
"agentId":null
"agentSeconds":0.0
"tags":
[
{
"tagId":561,"tagName":"DEV"
}
]
}

[GanguP · Accepted solution]

This worked perfectly fine. I do have questions though,
1) will this methodology work for multiple tags(arrays)?
2) Adding the second JSON splitter makes it easier,  I did provide a small number of columns in the sample but it has lot morefields. If we have to add 100's of fields it becomes tedious.  Is there another option or an easier way to do this?

[Aleksandar_A]

Hello @GanguP,

You can try before splitting the tags array, to map it to include all of the parent fields in a Mapper Snap then split it.

And about the first question, I'm not sure if I understand it, so could you please clarify it?

Let me know if this helps.

Regards,

Aleksandar.

You can refer to the attached pipeline below.

[GanguP]

Thank you so much @Alexsandar.  Appreciate your help.

[koryknick · Accepted solution]

@GanguP - rather than specify the individual columns to retain, you can select the "Include scalar parents" checkbox.  As long as the element is a primitive datatype (i.e. not array or object), it will automatically let it pass through.

[GanguP]

 Thank you so much @Kory  .  Appreciate your quick response