CRM Connector - Salesforce State and Country Picklists

[Former Community Member]

We're running the CRM connector in Campaign 6.1, connecting to a Salesforce Org which has State and Country Picklists enabled.  We're not able to see the fields MailingStateCode and MailingCountryCode on the Contact record.  We know they're available in the API, but cannot see them in Campaign - where should we be looking?

[Amit_Kumar]

Hi Alastaird514,

MailingStateCode or MailingCountryCode is actually a part of address field which is a compound field , A compound field is comprised of several different fields. When referencing any of compound fields there are some limitations i.e

• Compound fields are read-only. To update field values, modify the individual field components(you have to asks salesforce developer to grant your users the edit access from sales-force).

Read more about the limitations here: Salesforce Developers

Best regards,
Amit

[Former Community Member]

Hi Amit,

to expand on the issue, we're able to access all the other fields within the Address, such as MailingStreet, MailingCity and MailingState, however, the MailingStateCode isn't visible in the Campaign interface.  It is visible through other tools which are using the Salesforce API.

Thoughts?

[Former Community Member · Accepted solution]

We've isolated the issue: Adobe Campaign is using Salesforce API v.21, and State & Country Picklists were only released in v.27 - we need to upgrade (note the current API is v.40)

[Amit_Kumar]

Thanks for the update, Did you upgraded?

[Former Community Member]

Amit Kumar​ we have to test before upgrading, but this is in progress.