Marketo Salesforce

We worked in Marketo JavaScript Marketo API where we have to export all forms and their fields from our Marketo database. With custom API extraction, we are able to export all Forms and their Fields from our Marketo database which we tested through the API which is shown in the attached images.

Login into marketo.com and click admin >> Then Integration >> LaunchPoint where you will see a list of Service. If you already have created the API the service then click the “View Details”, then click the “GET TOKEN”

Get API token Marketo

This is the access token “7a96ebb0-58dd-45cd-8614-f5b2242664fd:sj” which is TOKENGENERATEDINMARKETOAPI in the URL. MARKETOID is the Marketo account id, you can get the REST API endpoint at admin >> Integration >> Web Services where you can find the endpoint URL like https://MARKETOID.mktorest.com/rest

To get all the forms the endpoint URL is

https://MARKETOID.mktorest.com/rest/asset/v1/forms.json?access_token=TOKENGENERATEDINMARKETOAPI

All forms Marketo

It pulls all of the forms from the Marketo database which are published. One of the form detail is like below:

{
    "id": 1424,
    "name": "2018.FORM-Request",
    "description": "",
    "createdAt": "2018-07-30T18:02:04Z+0000",
    "updatedAt": "2018-07-30T18:02:04Z+0000",
    "url": "https://app-sj44.marketo.com/#FO1424",
    "status": "approved",
    "theme": "simple",
    "language": "English",
    "locale": "en_US",
    "progressiveProfiling": true,
    "labelPosition": "above",
    "fontFamily": "Helvetica",
    "fontSize": "14px",
    "folder": {
        "type": "Folder",
        "value": 1408,
        "folderName": "Form"
    },
    "knownVisitor": {
        "type": "form",
        "template": null
    },
    "thankYouList": [
        {
            "followupType": "none",
            "followupValue": null,
            "default": true
        }
    ],
    "buttonLocation": 10,
    "buttonLabel": "CONTACT ME",
    "waitingLabel": "PLEASE WAIT..."
}

To get fields of a form the endpoint URL is

With the above JSON, we can get the ID of the form like “id”: 1424 then we pull the fields of that form with the following endpoint URL

https://MARKETOID.mktorest.com/rest/asset/v1/form/1424/fields.json?access_token=TOKENGENERATEDINMARKETOAPI

Forms fields Marketo

You will get the JSON response like below, as per below JSON the form has 3 fields First Name, Last Name and Email.

{
    "success": true,
    "errors": [],
    "requestId": "16376#1715271cde8",
    "warnings": [],
    "result": [
        {
            "id": "FirstName",
            "label": "First Name:",
            "labelWidth": 420,
            "fieldWidth": 420,
            "dataType": "text",
            "validationMessage": "This field is required.",
            "rowNumber": 0,
            "columnNumber": 0,
            "maxLength": 255,
            "required": true,
            "formPrefill": true,
            "visibilityRules": {
                "ruleType": "alwaysShow"
            }
        },
        {
            "id": "LastName",
            "label": "Last Name:",
            "labelWidth": 420,
            "fieldWidth": 420,
            "dataType": "text",
            "validationMessage": "This field is required.",
            "rowNumber": 1,
            "columnNumber": 0,
            "maxLength": 255,
            "required": true,
            "formPrefill": true,
            "visibilityRules": {
                "ruleType": "alwaysShow"
            }
        },
        {
            "id": "Email",
            "label": "Email Address:",
            "labelWidth": 420,
            "fieldWidth": 420,
            "dataType": "email",
            "validationMessage": "Must be valid email. <span class='mktoErrorDetail'>example@yourdomain.com</span>",
            "rowNumber": 2,
            "columnNumber": 0,
            "required": true,
            "formPrefill": true,
            "visibilityRules": {
                "ruleType": "alwaysShow"
            }
        }
    ]
}

In this way, we can export all forms and their fields from our Marketo database. The time taking part can be how you want the data to show. Please don’t forget to post your questions or comments or errors so that we can help you. You can follow us at our twitter account @rupaknpl. Click to see other Salesforce Marketo blog posts.

LEAVE A REPLY

Please enter your comment!
Please enter your name here