elasticio / salesforce-component-v2

Apache License 2.0
2 stars 2 forks source link

Investigation: Salesforce Lookup Objects problem #55

Closed A3a3e1 closed 1 year ago

A3a3e1 commented 1 year ago

Describe the task you are investigating.

The conversation in Slack started here: https://elasticio.slack.com/archives/C01FLMQ0PB5/p1666993400394219

In summary

Infobip has a simple flow WebHook-> CBR -> Salesforce -> HTTP Reply

  1. WebHook receives a campaignId with a value like this:
{
  "campaignId": "70126000000hBMlAAM"
}
  1. CBR checks if he request has the campaignId ($exists(campaignId)) from WebHook and passes further.
  2. Salesforce does Lookup Objects in the Campaign Member Status with the following mapping:
{
  "sTerm_1": {
    "fieldName": "Campaign ID",
    "condition": "=",
    "fieldValue": $getPassthrough()."step_1".body.campaignId
  }
}
  1. HTTP Reply returns the value.

Customer reports that the flow works with valid IDs and fails to process with invalid IDs.