CRM Connector - Salesforce State and Country Picklists

Avatar

Avatar
Validate 1
Level 1
alastaird514
Level 1

Likes

2 likes

Total Posts

4 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 1
alastaird514
Level 1

Likes

2 likes

Total Posts

4 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
alastaird514
Level 1

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
Validate 1
Level 1
alastaird514
Level 1

Likes

2 likes

Total Posts

4 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 1
alastaird514
Level 1

Likes

2 likes

Total Posts

4 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
alastaird514
Level 1

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
Validate 1
Level 1
alastaird514
Level 1

Likes

2 likes

Total Posts

4 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 1
alastaird514
Level 1

Likes

2 likes

Total Posts

4 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
alastaird514
Level 1

18-06-2017

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

Avatar

Avatar
Springboard
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct reply

231 solutions
Top badges earned
Springboard
Ignite 5
Ignite 3
Ignite 1
Validate 10
View profile

Avatar
Springboard
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct reply

231 solutions
Top badges earned
Springboard
Ignite 5
Ignite 3
Ignite 1
Validate 10
View profile
Amit_Kumar
MVP

15-06-2017

Thanks for the update, Did you upgraded?

Avatar

Avatar
Validate 1
Level 1
alastaird514
Level 1

Likes

2 likes

Total Posts

4 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 1
alastaird514
Level 1

Likes

2 likes

Total Posts

4 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
alastaird514
Level 1

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
Springboard
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct reply

231 solutions
Top badges earned
Springboard
Ignite 5
Ignite 3
Ignite 1
Validate 10
View profile

Avatar
Springboard
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct reply

231 solutions
Top badges earned
Springboard
Ignite 5
Ignite 3
Ignite 1
Validate 10
View profile
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