1

I am querying records from Salesforce and trying to return the record set as a JSON array of records.

enter image description here

enter image description here Unfortunately, it returns every record as if it was a single record as the complete JSON rather than an array element in the same JSON object.

{
  "AppointmentID": "a046g00000Nyk6oAAB"
}{
  "AppointmentID": "a046g00000NyjhfAAB"
}{
  "AppointmentID": "a046g00000NygSfAAJ"
}

There are no commas between the records. So I built the array into the JSON response and get:

{
  "Appointments": [
    {
      "AppointmentID": "a046g00000Nyk6oAAB"
    }
  ]
}{
  "Appointments": [
    {
      "AppointmentID": "a046g00000NyjhfAAB"
    }
  ]
}{
  "Appointments": [
    {
      "AppointmentID": "a046g00000NygSfAAJ"
    }
  ]
}

and it sends each record as the entire JSON template rather than a element of the array. Again, it also does not send commas back between the elements. I can work with a less than ideal structure but I need valid JSON returned.

Lastly, I tried to modify the results with a Data Process Shape using s Search and Replace

searching for: \}\{ 
replacing with \}\,\{

trying for force a comma between the braces, but the search never finds any matches even though this is a valid Javascript regex search.

Any suggestions would be greatly appreciated.

Final/Fixed Map enter image description here

Vincent James
  • 1,120
  • 3
  • 16
  • 27

1 Answers1

3

It's likely that the destination profile is incorrect and that you manually created the JSON profile. I would write the JSON out that you're expecting with all of the fields and then import (when you open the JSON profile, it's a blue button in the top right).

Also, Salesforce usually returns each record as 1 document and not combined. So, it's likely multiple documents are coming out of the map and you'll need to do a combine (data process shape).

Adam Bedenbaugh
  • 56
  • 1
  • "Salesforce usually returns each record as 1 document and not combined" That was it so I selected Batch Results on the Advanced tab of the Salesforce Operations shape and added a wrapper element around the Response XML Profile. This made the mapping to JSON destination profile work correctly. TY – Vincent James Sep 28 '20 at 15:25