Salesforce Sync Error
Could not complete your Salesforce sync!
Why: The following required fields are hidden from the Salesforce sync account
Contact.AccountId
Opportunity.AccountId
When I first received this error in Marketo I created Contact.AccountId and Opportunity.AccountId custom text fields in SFDC, made them visible to MKTO sync user and assigned them the following formula: AccountId (Text) = AccountId
But this morning I received the same error again.
Turns out I need to update System Mod Stamp (SystemModstamp) as AccountId are formula fields. The link in the docs is out of date https://help.salesforce.com/apex/HTViewSolution?id=000181490&language=en_US
Can you help me perform this update? Is this a SOQL command or can it be done on the front end of SFDC?
Thanks
Sean
Solved! Go to Solution.
The account ID is a red herring.
The solution: resolved by making 'Contact.Account Name' and 'Opportunity.Account Name' visible to my MKTO sync user.
Hi Sean
Creating custom fields in not the solution at all.
The missing fields are SFDC Standard fields that are hidden from the Marheto user profile. You need to grant right on these fields.
-Greg
Hi Greg
Thanks for your comments. When I got to "Contact Field-Level Security for profile" there is no AccountId field. If I also look in the "Contacts->fields" there is no field called AccountId there either. I am logged in as Admin.
Can you tell me where I would find the Contact.AccountId field so I can make it visible to my MKTO sync user?
thanks
Sean
It's the standard "Account" field. Accountid is the API name of that field.
With regards to the Object field, I think it's on the activity object.
-Greg
Hi
Thanks again, esp for the quick reply. However, I have been using MKTO and SFDC for about 1 week so brief answers only fuel more questions. I didn't have any trouble with any other part of the integration so if explained fully I will understand and follow instructions.
Why would my MKTO error message be as follows if it was in any way relating to the activity object? What is the activity object even for? It's not one that I've come across.
Why: The following required fields are hidden from the Salesforce sync account marketo@xxx.com:
Object | Field |
Contact | AccountId |
Opportunity | AccountId |
thanks
Sean
Sorry, it was not clear from your first email that object field where columns header
-Greg
Oh I see! It lost it's formatting when I copied and pasted it.
Do you have any further insight now that we've cleared that up?
Which what I told you to do BTW...
-Greg