Upsert fields must be defined as unique External ID fields in Salesforce - Heroku Connect

Question

I got this error:

Error:Read-write mappings require an upsert field for syncing. Upsert fields must be defined as unique External ID fields in Salesforce.More Info... Warning:Fields needed for insertion to Salesforce need to be mapped: LastName

after changing plan from Developer to Professional when creating mapping in Heroku for Contact object.

Even after chaning to plan higher than Professional, the same error appears.

It was possible with Developer plan.

Answer 1

You can use either the Salesforce record Id or a custom field as the unique identifier when performing an Upsert transaction. If you utilise a custom field in Salsesforce, that field must be declared as Unique. By going to Setup and modifying the field, you can accomplish this. A checkbox to indicate it as Unique and as an External Id is available.

Also, it appears that you are not filling in all needed fields, particularly the LastName column on the Contact.

Hope it will help!

Looking to learn more? Go for the salesforce admin training created by professionals.