10-15-2023 08:41 PM - edited 10-15-2023 08:48 PM
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
Solved! Go to Solution.
10-16-2023 01:24 AM
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.
11-24-2023 02:21 AM
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?