AnsweredAssumed Answered

Converting flat file to Array structure

Question asked by prsingh218 on Jan 10, 2018
Latest reply on Jan 11, 2018 by leif_jacobsen

Hi, I have a JSON which is having all records in same structure(JSON shown below).
While inserting records to salesforce i need to separate records based on number and perform the operation.
[
{
"AccountNumber1":"123",
"Name1":"Pushed from DellBoomi Account 1",
"BillingCountry1":"Canada",
"Description1":"Test 1",
"NumberOfEmployees1":"10",
"ParentId1":" ",
"ShippingCountry1":"Canada",
"ExternalId1":"Canada Canada",
"AccountNumber2":"12345678",
"Name2":"Pushed from DellBoomi Account 2",
"BillingCountry2":"Canada",
"Description2":"Test Child",
"NumberOfEmployees2":"10",
"ParentId2":"Canada Canada",
"ShippingCountry2":"Australia",
"ExternalId2":"Canada Australia"
}
]

Kindly help me out as am very new to Dell Boomi. Quick response is appreciable. Thank You!

Outcomes