In this article you will find:
Simptoms
If you're receiving this error:
FIELD_INTEGRITY_EXCEPTION
You may be trying to insert an invalid value for a field such as BillingCountry or BillingState.
What Causes This?
Salesforce often uses restricted picklists for fields like BillingCountry and BillingState, which only accept specific predefined values (e.g., United States, California).
By default, UpLead sends ISO codes (e.g., US, CA, TX) for countries and states. If Salesforce is expecting the full name instead, the system rejects the data, resulting in this integrity error.
How to Fix It
If you are encountering this error, follow these steps:
Open a support ticket with UpLead
Include the following message in your request:
“I’m receiving FIELD_INTEGRITY_EXCEPTION errors when exporting to Salesforce. Please update my export mapping to use country and state names instead of codes for the following accounts: * Insert account emails here*.”
Our support team will apply the necessary configuration changes to your integration. Once that’s done, your exports will proceed without mapping issues.
Workaround
If you need to continue exporting before the fix is applied:
Exclude the problematic fields from your export temporarily:
Go to Profile > Customize Integration
Under the Company tab, uncheck Country and State
Click Save
Note: This will prevent those fields from being sent, avoiding validation errors, but keep in mind your CRM will not receive this data.
Next Steps
Still need help? Contact UpLead Support for further assistance.