Marketo

This connector captures data from Marketo into Flow collections.

It is available for use in the Flow web application. For local development or open-source workflows, ghcr.io/estuary/source-marketo:dev provides the latest version of the connector as a Docker image. You can also follow the link in your browser to see past image versions.

This connector is based on an open-source connector from a third party, with modifications for performance in the Flow system.

Supported data resources

This connector can be used to sync the following tables from Marketo:

• activities_X where X is an activity type contains information about lead activities of the type X. For example, activities_send_email contains information about lead activities related to the activity type send_email. See the Marketo docs for a detailed explanation of what each column means.
• activity_types. Contains metadata about activity types. See the Marketo docs for a detailed explanation of columns.
• campaigns. Contains info about your Marketo campaigns. Marketo docs.
• leads. Contains info about your Marketo leads. Marketo docs.
• lists. Contains info about your Marketo static lists. Marketo docs.
• programs. Contains info about your Marketo programs. Marketo docs.

By default, each resource is mapped to a Flow collection through a separate binding.

Prerequisites

• (Optional) allowlist the Estuary IP addresses if needed
• An API-only Marketo User Role
• An Estuary Marketo API-only user
• A Marketo API Custom Service
• Marketo Client ID & Client Secret
• Marketo Base URL

Configuration

You configure connectors either in the Flow web app, or by directly editing the catalog specification file. See connectors to learn more about using connectors. The values and specification sample below provide configuration details specific to the Marketo source connector.

Properties

Endpoint

Property	Title	Description	Type	Required/Default
/client_id	Client ID	The Client ID of your Marketo developer application.	string	Required
/client_secret	Client Secret	The Client Secret of your Marketo developer application.	string	Required
/start_date	Start Date	UTC date and time in the format 2021-01-25T00:00:00Z. Any data before this date will not be replicated.	string	Required
/domain_url	Domain URL	Your Marketo Base URL.	string	Required

Bindings

Property	Title	Description	Type	Required/Default
/stream	Stream	Resource of your Marketo project from which collections are captured.	string	Required
/syncMode	Sync Mode	Connection method.	string	Required

Sample

captures:
  ${PREFIX}/${CAPTURE_NAME}:
    endpoint:
      connector:
        image: ghcr.io/estuary/source-marketo:dev
        config:
          client_id: <secret>
          client_secret: <secret>
          start_date: 2017-01-25T00:00:00Z
          domain_url: <your domain URL>
    bindings:
      - resource:
          stream: leads
          syncMode: full_refresh
        target: ${PREFIX}/leads
      {...}