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
739 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.
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 are reserved ...READ MORE

answered Mar 2, 2022 in SalesForce by surbhi
• 3,810 points
3,033 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
253 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
652 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
658 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,437 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
532 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
380 views
0 votes
2 answers

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

Hi @Vardhan, I took Edureka's Salesforce Training that covers all ...READ MORE

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

edited Dec 22, 2021 by Soumya 424 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
584 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,236 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