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

0 votes

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.

Apr 5, 2022 in SalesForce by surbhi
• 3,810 points
1,003 views

1 answer to this question.

0 votes

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.

answered Apr 6, 2022 by CoolCoder
• 4,400 points

Related Questions In SalesForce

0 votes
1 answer

Json response to be deserialized in Apex salesforce lightning

Because some fields in Apex Salesforce are ...READ MORE

answered Mar 2, 2022 in SalesForce by surbhi
• 3,810 points
3,327 views
0 votes
0 answers

Upsert Bulk vs Batch Upsert in Salesforce

I'm attempting to import a significant amount ...READ MORE

Apr 5, 2022 in SalesForce by surbhi
• 3,810 points
343 views
0 votes
0 answers

How to take test.salesforce.com while deployment as salesforce login url for api connection logic app?

In logic app i'm using salesforce connector after deployment ...READ MORE

Mar 1, 2022 in SalesForce by surbhi
• 3,810 points
846 views
0 votes
1 answer

How to take test.salesforce.com while deployment as salesforce login url for api connection logic app?

you are not passing the parameterValues, use ...READ MORE

answered Mar 2, 2022 in SalesForce by surbhi
• 3,810 points
776 views
+2 votes
2 answers

Salesforce Interview questions

Here are some questions very important for ...READ MORE

answered Jan 11, 2019 in Career Counselling by Suresh
• 720 points
2,861 views
0 votes
1 answer

How to connect to salesforce from tableau?

Hi, follow these steps to connect to Salesforce: 1. ...READ MORE

answered Mar 25, 2019 in Tableau by Cherukuri
• 33,030 points
776 views
0 votes
1 answer

Power BI - Salesforce

Hi, Follow below steps: 1. Go to Data source. 2. ...READ MORE

answered Mar 25, 2019 in Power BI by Cherukuri
• 33,030 points
505 views
0 votes
2 answers

What is the best training for Salesforce ADM-201 Exam?

Hi @Vardhan, I took Edureka's Salesforce Online Training, ...READ MORE

answered Jun 3, 2021 in Others by Jaya
• 140 points

edited Dec 22, 2021 by Soumya 570 views
0 votes
1 answer

Environment variable as custom metadata type in Salesforce

What's the name of the external service ...READ MORE

answered Apr 1, 2022 in SalesForce by CoolCoder
• 4,400 points
749 views
0 votes
1 answer

Check string value in salesforce test class

Because the field objCase.standard_or_nonstandard_c is set to ...READ MORE

answered Mar 3, 2022 in SalesForce by CoolCoder
• 4,400 points
1,430 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP