Skip to main content
Rita_J
Rita_J
Level 2
July 13, 2021
Solved

Possible to export fields synced with CRM?

Hey community, is it possible to extract the list of fields we sync between Marketo and CRM? We sync roughly about 350 fields and need to extract them for review/audit. 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Aleks-Kenins
Aleks-KeninsAccepted solution
Level 1
September 27, 2021
Thanks for reminding me. Guess I never implemented that, so much to do... will bookmark.

I've found a simple way to do it without needing any code at all.

  • Open the Network panel in your browser
  • Select Fetch/XHR in the filters
  • Navigate to Integration > Microsoft Dynamics in the Admin panel in Marketo
  • Click "Edit" under Field Sync Details
  • Back in the Network panel a request named "getFieldsForSelection" will appear
  • Select it and hit "Preview"
  • Right-click on "entityFields" and select "Copy  object"
  • Paste into an empy JSON file

All of the synced fields have the "selected" key marked as "true".

View in thread

9 replies

Michael_Florin-2
Michael_Florin-2
Level 10
July 13, 2021

I don't think that's possible. Admin --> Field Management --> Field Mapping --> Export will give you the list of fields that were initially synced with Salesforce, but not the current status.

 

Marketo Support can do that for you, though. And of course you can do it manually by going through your fields one by one and look at "CRM Field Map".

Translate
SanfordWhiteman
SanfordWhiteman
Level 10
July 13, 2021
I'll post some JS tomorrow that you can run from the F12 Console. (Similar to my code to dump Users and Roles.)
Translate
Jo_Pitts1
Community Advisor
Jo_Pitts1Community Advisor
Community Advisor
July 13, 2021

@rita_j ,

What is the CRM you are using?

If it is something 'sane' like dynamics or salesforce, then the approach from Sanford will work will.

If it is something more 'bespoke', and depending on how it is built you may have to:

  • Find the appropriate webhook (in Admin) and find the fields in the template.
  • Find out if the API is being polled for updated records and then speak to the developer about the fields they are pulling out.

I hope it is one of the 'sane' options 🙂

Cheers

Jo

Translate
    SanfordWhiteman
    SanfordWhiteman
    Level 10
    July 14, 2021

    This is a good point by Jo. Before I continue, please confirm you’re using one of the native connectors.

     

    Otherwise, Marketo would have no idea that a field is synced to/from some remote CRM, because the “sync” is enabled at another layer.

    Translate
    BlaneMM
    BlaneMM
    Level 2
    September 8, 2021

    @sanfordwhiteman did you post the code?  I am using SFDC, so your standard code would be super helpful.

    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...