Is there a limitation on fields used in composite external IDs in SFDMU?

Question:

I am using the Composite External Id feature in SFDMU and specifying a large number of fields in the externalId fields chain for each SOQL query.

Are there any limitations on the number of external IDs that can be used in a composite external ID in these queries?

Answer:

While SFDMU itself does not impose a strict limit on the number of fields you can include in a composite external ID, the practical limitation comes from the Salesforce API.

Each field in the composite external ID chain increases the length of the SOQL query, which is sent as a GET request. Salesforce REST API has a maximum URI length limit, which could be exceeded if too many fields are used.

Therefore, it's advisable to carefully select only the necessary fields for your composite external IDs to avoid potential issues with URI length.

Last updated on 29th Apr 2024