Skip to main content
Jun 12, 2017 10:12 PM UTC
Solved

CRM Connector - Salesforce State and Country Picklists

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Accepted solution
Jun 14, 2017 1:24 AM UTC

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)

5 replies

Amit_Kumar
Level 10
Jun 12, 2017 11:58 PM UTC

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

Translate
Jun 13, 2017 12:12 PM UTC

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?

Translate
Accepted solution
Jun 14, 2017 1:24 AM UTC

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)

Translate
Amit_Kumar
Level 10
Jun 15, 2017 7:35 AM UTC

Thanks for the update, Did you upgraded?

Translate
Jun 18, 2017 1:07 PM UTC

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

Translate