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.