Forum Discussion

akarsh's avatar
akarsh
New Contributor III
2 years ago
Solved

Best way to read the data from JSON list and process it one by one to a rest call

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" ...
  • SpiroTaleski's avatar
    SpiroTaleski
    2 years ago

    akarsh 

    You just need to split the array using the JSON Splitter Snap, once you read the file and parse the content, so you will have the nested structure split and pipeline will process the records one by one. Then you can proceed with developing the rest of the logic.

    Note: You should use REST API Mode within the Salesforce Snaps, in order records to be processed one by one. 

SpiroTaleski's avatar
SpiroTaleski
Valued Contributor
2 years ago
Copy LinkReport

akarsh 

Yes, you can utilize Group By N Snap in order to have a list with all records inside. You can specify also the size of each group within the snap. 

akarsh's avatar
akarsh
New Contributor III
2 years ago
Copy LinkReport

As mentioned above 

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 as you mentioned 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?