One Star

[resolved] Error in component "tSalesforceOutput" when i do "Upsert" for Id colum

Hello community!
I want copy my producction data into my "Sandbox".
I have my job created but i get an error when i try "upsert" the module"Cases" with custom field "Id_Prod__c", where i have the production case Id.
I will paste the error:
Exception in component tSalesforceOutput_1
java.lang.Exception: com.salesforce.soap.partner.InvalidFieldFault: INVALID_FIELD: Field name provided, id_prod__c does not match an External ID, Salesforce Id, or indexed field for Case
Can you help me? If you need more information or screenshots tell me please
Thanks in advance! Regards
1 ACCEPTED SOLUTION

Accepted Solutions
Five Stars

Re: [resolved] Error in component "tSalesforceOutput" when i do "Upsert" for Id colum

To upsert in this way your custom field needs to be defined in Salesforce as an external I'd. It will be a unique index field.
2 REPLIES
Five Stars

Re: [resolved] Error in component "tSalesforceOutput" when i do "Upsert" for Id colum

To upsert in this way your custom field needs to be defined in Salesforce as an external I'd. It will be a unique index field.
One Star

Re: [resolved] Error in component "tSalesforceOutput" when i do "Upsert" for Id colum

Yes! now works! thank you so much!!