Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

CRM Connector - Salesforce State and Country Picklists

Anonymous
Not applicable

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?

1 Accepted Solution
Correct answer by
Anonymous
Not applicable

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)

View solution in original post

5 Replies
Amit_Kumar
Community Advisor
Community Advisor

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

Anonymous
Not applicable

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?

Correct answer by
Anonymous
Not applicable

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)

View solution in original post

Amit_Kumar
Community Advisor
Community Advisor

Thanks for the update, Did you upgraded?

Anonymous
Not applicable

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