FIELD_INTEGRITY_EXCEPTION: There's a problem with this country, even though it may appear correct.

[Nina_Valtcheva5]

Is there a way to get a list of all of the records that have this error?

FIELD_INTEGRITY_EXCEPTION: There's a problem with this country, even though it may appear correct. Please select a country from the list of valid countries.: Country\n

Trying to clean up the database and I randomly see this error on some of our records that have US instead of United States (for example). How can I see all of the leads with this country error and what is the best way to standardize it? I am new to Marketo so any detailed advice is greatly appreciated!

[Rachit_Puri2]

Hi Nina

There is not a direct way to achieve this. If you know which smart campaign is pushing leads to Salesforce, you can simply do the following:
- Go to Campaign Results and add a filter for Salesforce.com
- Download all the results to an excel and use a filter for getting leads with Field Integrity Exception.
- Build a smartlist in MKTO where email address includes all the leads that were captured in the excel. 

How to fix this?
- Build a campaign in MKTO to normalize city, state and country values. The field exception error usually comes when the Country field is a drop-down and the value that you are passing from MKTO doesn't match any of the drop down values. The difference here could be as small as an extra space. 
Once you build and run these campaigns, most of these errors should be gone. 

If you have a large database, you may want to use one of our pre-built contact washing machines. Drop a line at rachitp@grazitti.com for more details.