Possible to export fields synced with CRM? | Community
Skip to main content
Rita_J
Rita_J
New Participant
July 13, 2021
Solved

Possible to export fields synced with CRM?

  • July 13, 2021
  • 3 replies
  • 4979 views

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.
Best answer by Aleks-Kenins
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".

3 replies

Jo_Pitts1
Jo_Pitts1
Community Manager
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

    SanfordWhiteman
    SanfordWhiteman
    New Participant
    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.

    BlaneMM
    BlaneMM
    New Participant
    September 8, 2021

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

    SanfordWhiteman
    SanfordWhiteman
    New Participant
    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.)
    Michael_Florin-2
    Michael_Florin-2
    New Participant
    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".

    Terms & ConditionsAccessibility statement

    Loading footer...