Json splitter for multiple array objects

Question

I have a Json input that contains multiple array objects within it. Json sample given below. I'm trying to flatten this data into table rows, I use two json splitter to achieve this.First Json splitter with Split path $ServiceCompanyArray and then a mapper to map the split value and then another Json splitter with split path $ServiceCompanyDetailArray and then another mapper to Writer.Note: this is an xample Json, the actual Json could have multiple array fields, so should we always use N number of json splitters.{&nbsp;&nbsp;&nbsp;&nbsp;"Vehicle_Id":&nbsp;"_Id4",&nbsp;&nbsp;&nbsp;&nbsp;"InceptionDt":&nbsp;"2023-08-03",&nbsp;&nbsp;&nbsp;&nbsp;"ServiceCompanyArray":&nbsp;[&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"@_Id":&nbsp;"_Id5",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"$":&nbsp;"ServiceCompany45"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;},&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"@_Id":&nbsp;"_Id6",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"$":&nbsp;"ServiceCompany47"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;&nbsp;&nbsp;&nbsp;],&nbsp;&nbsp;&nbsp;&nbsp;"ServiceCompanyDetailArray":&nbsp;[&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"ServiceCompanyAddressLine1":&nbsp;"ServiceCompanyAddressLine150",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"ServiceCompanyPhone":&nbsp;"ServiceCompanyPhone26",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"ServiceCompanyPostalCode":&nbsp;"ServiceCompanyPostalCode2"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;},&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"ServiceCompanyAddressLine1":&nbsp;"ServiceCompanyAddressLine163",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"ServiceCompanyPhone":&nbsp;"ServiceCompanyPhone9",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"ServiceCompanyPostalCode":&nbsp;"ServiceCompanyPostalCode15"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;&nbsp;&nbsp;&nbsp;]}

rogersramkoski · Answer

Hi&nbsp;neelamanikandan,&nbsp;thank you for joining the SnapLogic Community within the last few weeks and for sharing how you split multiple array objects. I just want to double check, did you have a question about how you split the JSON arrays or were you just sharing a solution?

neelamanikandan · Answer

Hi&nbsp;RogerSramkoski&nbsp; It was a question, in the above example I had 2 (Servicecompany and Servicecompanydetail) fields that had values in array, so I have used 2 JSON splitters in the pipeline. But if my input JSON contains multiple(eg. 10) array fields should I always use multiple (10 JSON splitters) in the pipeline? Is there alternate Snap that can flatten all the Array elements at one go, or is there an alternative approach to use the JSON splitter to flatten all arrays

ssapa · Answer

neelamanikandan&nbsp;May I know what is you expected output?

neelamanikandan · Answer

Vehicle_IdInceptionDt@_Id$ServiceCompanyAddressLine1ServiceCompanyPhoneServiceCompanyPostalCode_Id408/03/2023_Id5ServiceCompany45ServiceCompanyAddressLine150ServiceCompanyPhone26ServiceCompanyPostalCode2_Id408/03/2023_Id5ServiceCompany45ServiceCompanyAddressLine163ServiceCompanyPhone9ServiceCompanyPostalCode15_Id408/03/2023_Id6ServiceCompany47ServiceCompanyAddressLine150ServiceCompanyPhone26ServiceCompanyPostalCode2_Id408/03/2023_Id6ServiceCompany47ServiceCompanyAddressLine163ServiceCompanyPhone9ServiceCompanyPostalCode15

alchemiz · Answer

Hi&nbsp;neelamanikandan&nbsp;,Good day, see if this will work place the expression in a mapper&nbsp;sl.ensureArray($ServiceCompanyArray).map(c=&gt; sl.ensureArray($ServiceCompanyDetailArray).map(d=&gt; {'Vehicle_Id': $Vehicle_Id, 'InceptionDt': $InceptionDt}.merge(c.merge(d)))).reduce((a,b)=&gt; a.concat(b),[])Thanks,EmEm

Forum Discussion

Json splitter for multiple array objects

6 Replies

Recent Discussions

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?

Multipart Reader failure - 'content-type' was not found

Vehicle_Id	InceptionDt	@_Id	$	ServiceCompanyAddressLine1	ServiceCompanyPhone	ServiceCompanyPostalCode
_Id4	08/03/2023	_Id5	ServiceCompany45	ServiceCompanyAddressLine150	ServiceCompanyPhone26	ServiceCompanyPostalCode2
_Id4	08/03/2023	_Id5	ServiceCompany45	ServiceCompanyAddressLine163	ServiceCompanyPhone9	ServiceCompanyPostalCode15
_Id4	08/03/2023	_Id6	ServiceCompany47	ServiceCompanyAddressLine150	ServiceCompanyPhone26	ServiceCompanyPostalCode2
_Id4	08/03/2023	_Id6	ServiceCompany47	ServiceCompanyAddressLine163	ServiceCompanyPhone9	ServiceCompanyPostalCode15