Uploaded image for project: 'Camel'
  1. Camel
  2. CAMEL-10193

add support for lookup field using an sObject external id

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Resolved
    • Priority: Major
    • Resolution: Implemented
    • Affects Version/s: 2.17.2
    • Fix Version/s: 2.22.0
    • Component/s: camel-salesforce
    • Labels:
      None
    • Estimated Complexity:
      Moderate

      Description

      A SalesForce object can have a field of type called "lookup".
      This field is used to by a record in a SalesForce object to reference a record in another SalesForce object.
      The value of this field could be a string in which case it would be the record id of the other record or it could be an object in which case it would contain the other Object's external field name and its value in that other record.

      Doing lookup/reference by external id is very useful specially for insert/upsert operations as otherwise one has to maintain record id of each of the records in the other Object.

      Camel SalesForce component supports lookup by record id.
      There is no support for the second type that is the external field name and value type.

      See here for more information on this
      https://developer.salesforce.com/docs/atlas.en-us.api_rest.meta/api_rest/dome_upsert.htm
      Section "Upserting Records and Associating with an External ID"

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                zregvart Zoran Regvart
                Reporter:
                ssatguru Satguru Srivastava
              • Votes:
                0 Vote for this issue
                Watchers:
                8 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: