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%'"
}

Answer:

Probably the Name field 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 Sa Oct 2022