Where can I find message about the reason of failed insertions?

Question.

I am using following configuration:

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

and it fails, but showing only this comment:
[Job# REST:Insert] {Commitment__c} The job has been created.
WARNING: [WARN] [Batch# REST:Insert] {Commitment__c} Incompleted. 0 records succeeded, 46 records failed.

Where should I look?

Answer.

To get information about failed records you need to look in /target subdirectory that should be created by the Plugin where your export.json sits.
Find the file named Commitment__c_insert_target.csv, you have Error column says what's the error message on each row.

Make sure that you also set createTargetCSVFiles: true


See also:

Full export.json format.

The Target CSV files

Last updated on Tu May 2022