Why no records inserted?

Question

I am attempting to insert new records into a system. There are 46 records available in the source, but the process inserts 0 records, and I cannot determine the reason. Here is my configuration:

{
    "operation": "Insert",
    "externalId": "Name",
    "query": "SELECT Id, Name FROM Commitment__c where Deal__r.Name LIKE 'MigVax%'"
}

What could be the issue?

Answer

The issue likely stems from the use of the Name field as an external ID in your Commitment__c object, which might be an auto-number field. This configuration means there are no updatable fields in your SOQL query.

To successfully insert or update records, ensure your query includes at least one updatable field.

Last updated on 20th Apr 2024