cancel
Showing results for 
Search instead for 
Did you mean: 

Group the data after using json splitter

akarsh
New Contributor III

I have a input json file like below please see the dummy example below

{ "totalCount": 2, "dataList": [ { "IFA": "IFA1", "voltage": "200", "power": "100", "equipid": "1234ABC", "SN": "SalesForce-1" }, { "IFA": "IFA2", "voltage": "200", "power": "100", "equipid": "1234ABC", "SN": "SalesForce-1" } ] } 

this will be split using json splitter and sent to salesforce through API which returns an output.

Output from salesforce will be like this

[{"assetguid":"test","sfdcid":"id","status":"SUCCESS","updatedTime":"2023-11-24T08:59:34.167Z"}]

I want to collect these output in single file . I tried Group By N but it doesn't return any output. 

my group by n snap looks like this

akarsh_0-1700821147104.png

as you can see group by n got 2 documents but there was not output

akarsh_1-1700821186299.png

can you please help me here? what am I doing wrong here?

1 REPLY 1

akarsh
New Contributor III

can anyone please help here please?