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" }, { "IFA": "IFA2", "voltage": "200", "power": "100", "equipid": "1234ABC", "SN": "SalesForce-1" } ] }

I have to read this file and process the Items one by one. 
First I have to get the IFA number and then do Salesforce lookup to get the Id from sales force .

Then the output Id from the salesforce should be mapped to accountID  field and this along with other data in the file should be passed to SalesForce upsert snap.

can anyone help me on how to do this? I am new to snaplogic