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

Connecting AC with Salesforce

Jaspreet_Kaur1
Level 3
Level 3

Tagging florentlb​ as have seen a similar post resolved by you.

Hello Friends,

M Trying to update the records in salesforce schema, using the salesforce activity.

Requirement is to match the key between two systems sachems and update a column ([Contact/Email_Opt_Out_Date_Time__c]) in SF schema.

Getting this error in the salesforce activity.

02/10/2017 17:48:42 sfdcWorkflow processed: 0, inserted: 0, updated: 0, rejected: 0, deleted: 0, ignored: 0.

02/10/2017 17:48:42 sfdcWorkflow -53

02/10/2017 17:48:42 sfdcWorkflow A remote key must be defined on a remote field and a local field. A local change date must be defined on a remote field an a local field.

Under the mapping area, I have defined the property as Unique Remote key, Remote modification date, Unique Local key, Reconciliation Key as in the screen shot.

1316349_pastedImage_2.png

Is there anything I am missing to add or doing incorrectly?

5 Replies
Jean-Serge_Biro
Community Advisor
Community Advisor

Hi Jaspreet,

Sorry my current customer doesn't have the Salesforce module, I can't help you efficiently.

But perhaps on Unique remote key line should you define it as [Contact/ID_18_Digit_Format__c] otherwise AC would consider ID_18_Digit_Format__c as local field?

And I don't understand the difference between your 2 local fiels @id and @ID_18_Digit_Format__c, wouldn't be the same?

Regards

JS

Jaspreet_Kaur1
Level 3
Level 3

This field is coming from the expression and I am not entering it manually.So, it seems if its been used once, then after that the system is taking only the field name and not the schema and therefore its ID_18_Digit_Format__c and not [Contact/ID_18_Digit_Format__c].

@id is my auto generated Adobe Primary key and ID_18_Digit_Format__c is the unique key. Both are different.

I am not very confident on mapping these as my requirement is to update 2 fields on SF based on the ID_18_Digit_Format__c field present.

Could not even find any document which describes these.

florentlb
Level 10
Level 10

Hi Jas,

I don't have a Salesforce account available right now but will investigate this further as soon as I can.

In the meantime, can you try matching the following "structure" (for example in this example both camapign and CRM fields are defined for the remote key and modification date. Make sure that the remote fields are correctly defined compared to how they are named in salesforce.

Issue in CRM Connector activity of Adobe Campaign v6

I'll update you if I have any more info on this. Can you try this in the meantime?

Florent

Jaspreet_Kaur1
Level 3
Level 3

Thanks for your inputs,

I have tried with all the mappings, unfortunately no luck.

Will wait for your further inputs.