Move objects structure with in json

Question

Hello Community Folks,I've been trying to modify or re-structure the json payload that I'm getting using mapper snap. But I'm finding difficulty achieving it.&nbsp;&nbsp;Source JSON is --&gt;&nbsp;[&nbsp; {&nbsp; &nbsp; "entity": [&nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; "id": "6441225a5e40189adb5b7f3d_73114fa2-dcc7-441f-b14f-630742c1da1b",&nbsp; &nbsp; &nbsp; &nbsp; "state": "Stopped",&nbsp; &nbsp; &nbsp; &nbsp; "create_time": "2023-12-18T18:58:58.134000+00:00",&nbsp; &nbsp; &nbsp; &nbsp; "state_timestamp": "2023-12-18T18:59:02.134000+00:00",&nbsp; &nbsp; &nbsp; &nbsp; "path_id": "/Example-DEV/projects/User-Example-01",&nbsp; &nbsp; &nbsp; &nbsp; "documents": 0,&nbsp; &nbsp; &nbsp; &nbsp; "error_documents": 0,&nbsp; &nbsp; &nbsp; &nbsp; "label": "Example_11_JMS_Consumer_Example",&nbsp; &nbsp; &nbsp; &nbsp; "runtime_label": "ExampleGP",&nbsp; &nbsp; &nbsp; &nbsp; "user_id": "user01.email@Example.com",&nbsp; &nbsp; &nbsp; &nbsp; "runtime_path_id": "Example-DEV/rt/sidekick/Development",&nbsp; &nbsp; &nbsp; &nbsp; "subpipes": {&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; },&nbsp; &nbsp; &nbsp; &nbsp; "invoker": "manual",&nbsp; &nbsp; &nbsp; &nbsp; "has_lints": false,&nbsp; &nbsp; &nbsp; &nbsp; "child_has_lints": false,&nbsp; &nbsp; &nbsp; &nbsp; "duration": 5,&nbsp; &nbsp; &nbsp; &nbsp; "mode": "standard",&nbsp; &nbsp; &nbsp; &nbsp; "cc_label": "snaplogic-snaplogic-snaplex-jcc-75f756866-ml88n",&nbsp; &nbsp; &nbsp; &nbsp; "pipe_id": "0cba7387-e092-40ba-9434-836c19bafcc8",&nbsp; &nbsp; &nbsp; &nbsp; "parent_ruuid": null,&nbsp; &nbsp; &nbsp; &nbsp; "ccid": "656e1967b14606d6ee6cd31c"&nbsp; &nbsp; &nbsp; },&nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; "id": "6441225a5e40189adb5b7f3d_32e835df-19eb-40bc-b66b-2bc137f82ac0",&nbsp; &nbsp; &nbsp; &nbsp; "state": "Stopped",&nbsp; &nbsp; &nbsp; &nbsp; "create_time": "2023-12-18T20:21:52.332000+00:00",&nbsp; &nbsp; &nbsp; &nbsp; "state_timestamp": "2023-12-18T20:23:14.332000+00:00",&nbsp; &nbsp; &nbsp; &nbsp; "path_id": "/Example-DEV/projects/User-Example-01",&nbsp; &nbsp; &nbsp; &nbsp; "documents": 0,&nbsp; &nbsp; &nbsp; &nbsp; "error_documents": 0,&nbsp; &nbsp; &nbsp; &nbsp; "label": "Example_11_JMS_Consumer_Example",&nbsp; &nbsp; &nbsp; &nbsp; "runtime_label": "ExampleGP",&nbsp; &nbsp; &nbsp; &nbsp; "user_id": "user01.email@Example.com",&nbsp; &nbsp; &nbsp; &nbsp; "runtime_path_id": "Example-DEV/rt/sidekick/Development",&nbsp; &nbsp; &nbsp; &nbsp; "subpipes": {&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; },&nbsp; &nbsp; &nbsp; &nbsp; "invoker": "manual",&nbsp; &nbsp; &nbsp; &nbsp; "has_lints": false,&nbsp; &nbsp; &nbsp; &nbsp; "child_has_lints": false,&nbsp; &nbsp; &nbsp; &nbsp; "duration": 85,&nbsp; &nbsp; &nbsp; &nbsp; "mode": "standard",&nbsp; &nbsp; &nbsp; &nbsp; "cc_label": "snaplogic-snaplogic-snaplex-jcc-75f756866-ml88n",&nbsp; &nbsp; &nbsp; &nbsp; "pipe_id": "0cba7387-e092-40ba-9434-836c19bafcc8",&nbsp; &nbsp; &nbsp; &nbsp; "parent_ruuid": null,&nbsp; &nbsp; &nbsp; &nbsp; "ccid": "656e1967b14606d6ee6cd31c"&nbsp; &nbsp; &nbsp; },&nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; "id": "6441225a5e40189adb5b7f3d_6ec57a06-a635-4806-8000-815fbc506c48",&nbsp; &nbsp; &nbsp; &nbsp; "state": "Stopped",&nbsp; &nbsp; &nbsp; &nbsp; "create_time": "2023-12-18T20:23:41.205000+00:00",&nbsp; &nbsp; &nbsp; &nbsp; "state_timestamp": "2023-12-18T20:23:46.205000+00:00",&nbsp; &nbsp; &nbsp; &nbsp; "path_id": "/Example-DEV/projects/User-Example-01",&nbsp; &nbsp; &nbsp; &nbsp; "documents": 5,&nbsp; &nbsp; &nbsp; &nbsp; "error_documents": 0,&nbsp; &nbsp; &nbsp; &nbsp; "label": "Example_12_JMS_Subscribe_Topic",&nbsp; &nbsp; &nbsp; &nbsp; "runtime_label": "ExampleGP",&nbsp; &nbsp; &nbsp; &nbsp; "user_id": "user01.email@Example.com",&nbsp; &nbsp; &nbsp; &nbsp; "runtime_path_id": "Example-DEV/rt/sidekick/Development",&nbsp; &nbsp; &nbsp; &nbsp; "subpipes": {&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; },&nbsp; &nbsp; &nbsp; &nbsp; "invoker": "manual",&nbsp; &nbsp; &nbsp; &nbsp; "has_lints": false,&nbsp; &nbsp; &nbsp; &nbsp; "child_has_lints": false,&nbsp; &nbsp; &nbsp; &nbsp; "duration": 6,&nbsp; &nbsp; &nbsp; &nbsp; "mode": "standard",&nbsp; &nbsp; &nbsp; &nbsp; "cc_label": "snaplogic-snaplogic-snaplex-jcc-75f756866-ml88n",&nbsp; &nbsp; &nbsp; &nbsp; "pipe_id": "5689d737-0d6f-4fd1-9a97-ddfc2788e848",&nbsp; &nbsp; &nbsp; &nbsp; "parent_ruuid": null,&nbsp; &nbsp; &nbsp; &nbsp; "ccid": "656e1967b14606d6ee6cd31c"&nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; ]&nbsp; },&nbsp; {&nbsp; &nbsp; "entity": [&nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; "id": "5467839a5e40189adb5b7f3d_73114fa2-dcc7-441f-b14f-630742c1da56",&nbsp; &nbsp; &nbsp; &nbsp; "state": "Failed",&nbsp; &nbsp; &nbsp; &nbsp; "create_time": "2023-12-18T18:58:58.134000+00:00",&nbsp; &nbsp; &nbsp; &nbsp; "state_timestamp": "2023-12-18T18:59:02.134000+00:00",&nbsp; &nbsp; &nbsp; &nbsp; "path_id": "/Example-DEV/projects/User-Example-01",&nbsp; &nbsp; &nbsp; &nbsp; "documents": 0,&nbsp; &nbsp; &nbsp; &nbsp; "error_documents": 0,&nbsp; &nbsp; &nbsp; &nbsp; "label": "Example_21_JMS_Consumer_Example",&nbsp; &nbsp; &nbsp; &nbsp; "runtime_label": "ExampleGP",&nbsp; &nbsp; &nbsp; &nbsp; "user_id": "user01.email@Example.com",&nbsp; &nbsp; &nbsp; &nbsp; "runtime_path_id": "Example-DEV/rt/sidekick/Development",&nbsp; &nbsp; &nbsp; &nbsp; "subpipes": {&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; },&nbsp; &nbsp; &nbsp; &nbsp; "invoker": "manual",&nbsp; &nbsp; &nbsp; &nbsp; "has_lints": false,&nbsp; &nbsp; &nbsp; &nbsp; "child_has_lints": false,&nbsp; &nbsp; &nbsp; &nbsp; "duration": 5,&nbsp; &nbsp; &nbsp; &nbsp; "mode": "standard",&nbsp; &nbsp; &nbsp; &nbsp; "cc_label": "snaplogic-snaplogic-snaplex-jcc-75f756866-ml88n",&nbsp; &nbsp; &nbsp; &nbsp; "pipe_id": "0cba7387-e092-40ba-9434-836c19bafcc8",&nbsp; &nbsp; &nbsp; &nbsp; "parent_ruuid": null,&nbsp; &nbsp; &nbsp; &nbsp; "ccid": "656e1967b14606d6ee6cd31c"&nbsp; &nbsp; &nbsp; },&nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; "id": "2245673a5e40189adb5b7f3d_73114fa2-dcc7-441f-b14f-630742c1da09",&nbsp; &nbsp; &nbsp; &nbsp; "state": "Failed",&nbsp; &nbsp; &nbsp; &nbsp; "create_time": "2023-12-18T18:58:58.134000+00:00",&nbsp; &nbsp; &nbsp; &nbsp; "state_timestamp": "2023-12-18T18:59:02.134000+00:00",&nbsp; &nbsp; &nbsp; &nbsp; "path_id": "/Example-DEV/projects/User-Example-01",&nbsp; &nbsp; &nbsp; &nbsp; "documents": 0,&nbsp; &nbsp; &nbsp; &nbsp; "error_documents": 0,&nbsp; &nbsp; &nbsp; &nbsp; "label": "Example_22_JMS_Consumer_Example",&nbsp; &nbsp; &nbsp; &nbsp; "runtime_label": "ExampleGP",&nbsp; &nbsp; &nbsp; &nbsp; "user_id": "user01.email@Example.com",&nbsp; &nbsp; &nbsp; &nbsp; "runtime_path_id": "Example-DEV/rt/sidekick/Development",&nbsp; &nbsp; &nbsp; &nbsp; "subpipes": {&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; },&nbsp; &nbsp; &nbsp; &nbsp; "invoker": "manual",&nbsp; &nbsp; &nbsp; &nbsp; "has_lints": false,&nbsp; &nbsp; &nbsp; &nbsp; "child_has_lints": false,&nbsp; &nbsp; &nbsp; &nbsp; "duration": 5,&nbsp; &nbsp; &nbsp; &nbsp; "mode": "standard",&nbsp; &nbsp; &nbsp; &nbsp; "cc_label": "snaplogic-snaplogic-snaplex-jcc-75f756866-ml88n",&nbsp; &nbsp; &nbsp; &nbsp; "pipe_id": "0cba7387-e092-40ba-9434-836c19bafcc8",&nbsp; &nbsp; &nbsp; &nbsp; "parent_ruuid": null,&nbsp; &nbsp; &nbsp; &nbsp; "ccid": "656e1967b14606d6ee6cd31c"&nbsp; &nbsp; &nbsp; },&nbsp; &nbsp; ]&nbsp; &nbsp;}]&nbsp;After applying transformation/mapper, I would ideally like target json to be --&gt;&nbsp;[{"pipeline": {"path_id": "/Example-DEV/projects/User-Example-01","label": "Example_11_JMS_Consumer_Example","state": "Stopped","state_timestamp": "2023-12-18T18:59:02.134000+00:00"}},{"pipeline": {"path_id": "/Example-DEV/projects/User-Example-01","label": "Example_11_JMS_Consumer_Example","state": "Stopped","state_timestamp": "2023-12-18T20:23:14.332000+00:00"}},{"pipeline": {"path_id": "/Example-DEV/projects/User-Example-01","label": "Example_12_JMS_Subscribe_Topic","state": "Stopped","state_timestamp": "2023-12-18T20:23:46.205000+00:00"}},{"pipeline": {"path_id": "/Example-DEV/projects/User-Example-01","label": "Example_21_JMS_Consumer_Example","state": "Failed","state_timestamp": "2023-12-18T18:59:02.134000+00:00"}},{"pipeline": {"path_id": "/Example-DEV/projects/User-Example-01","label": "Example_22_JMS_Consumer_Example","state": "Failed","state_timestamp": "2023-12-18T18:59:02.134000+00:00"}}]&nbsp;, I've tried with numerous techniques like javascript map() function on arrays or using jsonPath() and other stuff but nothing seems to work, may be I'm not going on a right path so if someone can please help me here with this providing right path to look around for stuff or even an example of similar stuff will be great.&nbsp;&nbsp;The JSON that I'm generating is collecting all the "Name" for example in single name value pair if you guys know what I mean.&nbsp;Let me know if you want me to attach something here and show how I'm trying to achieve this.&nbsp;&nbsp;

bojanvelevski · Accepted Answer

Hi&nbsp;hasmukhp27What you need is a JSONSplitter snap set to split the entity arrays. The rest is easy, the output documents contain the data you need, and you just need to map it accordingly.&nbsp;Regards,Bojan

Forum Discussion

Move objects structure with in json

2 Replies

Recent Discussions

HTTP Client response formatted different from REST Get

Connecting Netsuite via restAPI or restlets

Issue with invoking triggered task using Groundplex URL

Trigger REST Get when status is completed

Triggered Task with Accept: application/octet-stream header