Marketo — Docs — Datachef

Connect Marketo with a REST API client, and sync leads and activities through Bulk Extract.

Before you start

In Marketo, an admin needs to create an API-only user and a LaunchPoint custom service for it (Admin → Integration → LaunchPoint). The service gives you a Client ID and Client secret. The REST endpoint is under Admin → Integration → Web Services.

Connection fields

Field	Example
REST endpoint	`https://123-ABC-456.mktorest.com`
Client ID
Client secret
Sync data from	Defaults to one year ago. Data before this date isn't synced.

Tables

Datachef reads Marketo through its Bulk Extract API, which exports three kinds of data:

Table	Sync modes	Cursor
`leads`	Incremental or full refresh	`updatedAt`
`activities`	Incremental or full refresh	`activityDate`
`activity_types`	Full refresh only

For activities, choose the Activity types to sync. Marketo exports at most 10 activity types per job.

Marketo exports run in 30-day windows. A first sync that reaches back a year runs as a series of windows, so it takes longer than the syncs after it.

What isn't available

Bulk Extract can't export campaigns, programs, companies or opportunities, so they aren't offered as tables. Program membership and campaign responses still show up as activities.