Forum Discussion

akarsh's avatar
akarsh
New Contributor III
2 years ago

Group the data after using json splitter

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

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

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

1 Reply