CRM Connector - Salesforce State and Country Picklists

Avatar

Avatar

alastaird514

Avatar

alastaird514

alastaird514

12-06-2017

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?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

alastaird514

Avatar

alastaird514

alastaird514

13-06-2017

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)

Answers (4)

Answers (4)

Avatar

Avatar

alastaird514

Avatar

alastaird514

alastaird514

18-06-2017

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

Avatar

Avatar

Amit_Kumar

MVP

Avatar

Amit_Kumar

MVP

Amit_Kumar
MVP

15-06-2017

Thanks for the update, Did you upgraded?

Avatar

Avatar

alastaird514

Avatar

alastaird514

alastaird514

13-06-2017

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?

Avatar

Avatar

Amit_Kumar

MVP

Avatar

Amit_Kumar

MVP

Amit_Kumar
MVP

12-06-2017

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