Why no records inserted?


Question.

I am trying to insert new records.

In the Source there are 46 records however the process insert 0 records and I cant find the reason.

This is my configuration:

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

What's wrong ?


Answer.

Probably the Name field (as it's also defined as an external Id) of your object Commitment__c is auto-number.  So you have no any updatable field in the SOQL query.

To make the records inserted or updated, you must include at least one updatable field in your object's query.

Last updated on 15th Mar 2024