airbyte/airbyte-integrations/connectors/source-marketo/bootstrap.md

Core streams

Marketo is a REST based API. Connector is implemented with Airbyte CDK.

Connector has such core streams, and all of them except Activity_types support full refresh and incremental sync:

• Activity_types.
• Campaigns.
• Lists.
• Programs.

Bulk export streams

Connector also has bulk export streams, which support incremental sync.

• Activities_X.
• Leads.

To be able to pull export data you need to generate 3 separate requests. See Marketo docs.

• First - to create a job

• Second - to enqueue job

• Third - to poll export data

For get status of extracting see Status - the status is only updated once every 60 seconds. Job timeout - 180 min.

Connector uses createdAt and updatedAt config for initial reports sync depend on connector and current date as an end data.

Connector has window_in_days config which allows set the amount of days for each data-chunk begining from start_date. Default: 30 days. Max: 30 days.

See this link for the nuances about the connector.