JSON Splitter

Question

Hi Snaplogic CommunityI have a reequipment where I need to fetch the data from the API and split the all the JSON object but we have a large JSON which we cant do it manually I just need any functional part where it will work without any manual work.Here I am just giving one example:We have splitter the entity JSON and the result is this . Here are so many object which we need to break.The result I just want is&nbsp;customer_resourceNamecustomercurrencyCodecampaign_resourceNamecampaign_statusadGroup_resourceNameadGroup_status11AA11AA11AA22BB22BB22BB33AA33AA33AA44BB44BB44BB55AA55AA55AA66BB66BB66BBCan anyone help me in this.alchemiz&nbsp;tlikarish&nbsp;SpiroTaleski&nbsp;Thanks in advance&nbsp;&nbsp;

pmancevski · Answer

Hi @Himani,
In my opinion the easiest way to achieve this is to have “Logging pipeline” and with “Pipeline execute” snap to pass the following parameters:

pipe.label (Executing master pipeline name)
pipe.instanceId (Executing master pipeline Id)
pipe.ruuid (Execution Id)

Settings for pipeline execute snap:

If you need to customize optional message some how, simply add mapper before pipeline execute.
If you need more information about “Pipeline Functions and Properties”, please check SnapLogic documentation:
https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1439352/Pipeline+Functions+and+Properties
Thanks,
Pero M.

Forum Discussion

JSON Splitter

Recent Discussions

Pagination and nextCursor in header

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?

customer_resourceName	customercurrencyCode	campaign_resourceName	campaign_status	adGroup_resourceName	adGroup_status
11	AA	11	AA	11	AA
22	BB	22	BB	22	BB
33	AA	33	AA	33	AA
44	BB	44	BB	44	BB
55	AA	55	AA	55	AA
66	BB	66	BB	66	BB