Marketo Bulk Extract¶
Marketo provides interfaces for retrieval of large sets of person and person related data, called Bulk Extract. The Marketo bulk extract templates configures the access for the following entities:
Lead
Activity
Program
Bulk extract is performed by creating a job, defining the set of data to retrieve, queuing the job, waiting for the job to complete writing a file, and then retrieving the file over HTTP. These jobs are executed asynchronously, and can be polled to retrieve the status of the export.
Importing Artifacts¶
To create the Marketo bulk extract views, click the menu File > New > Data source and select Marketo bulk extract.
Marketo bulk extract wizard¶
Enter the following parameters:
Database. Name of the database in which the Marketo bulk extract views will be created.
Client ID. The client id provided by your Marketo instance.
Client Secret. The client secret provided by your Marketo instance.
Scope. The Marketo user with API access permissions.
Marketo instance. Your Marketo instance.
Now, click Execute import to create the data sources and the views to query Marketo.
Important
The set of Stored Procedures included are used by final views and are in charge of the task of asking for new access tokens when the older ones expire. So, ONLY the FINAL VIEWS are meant to be directly used.
Marketo bulk extract views¶
Activity
create_export_activity_job. Creates a job for exporting Marketo activities. The parameter
startatdefines the time when the job starts and theendatparameter, the time when the job finishes..enqueue_export_activity_job. Enqueue export job. This will place export job in queue, and will start the job when computing resources become available. The job must be in “Created” state.
export_activity_file. Returns the file content of an export job. The export job must be in “Completed” state.
export_activity_job. Returns a list of export jobs that were created in the past 7 days.
get_status_export_activity_job. Returns status of an export job. Job status is available for 30 days after Completed or Failed status was reached.
cancel_export_activity_job. Cancels the export job.
Lead
create_export_lead_job. Creates a job for exporting Marketo leads. The parameter
startatdefines the time when the job starts and theendatparameter, the time when the job finishes..create_export_lead_job. Enqueue export job. This will place export job in queue, and will start the job when computing resources become available. The job must be in “Created” state.
export_lead_file. Returns the file content of an export job. The export job must be in “Completed” state.
get_export_lead_jobs. Returns a list of export jobs that were created in the past 7 days.
get_status_export_lead_job. Returns status of an export job. Job status is available for 30 days after Completed or Failed status was reached.
cancel_export_lead_job. Cancels the export job.
Program
create_export_program_job. Creates a job for exporting Marketo programs. The parameter
startatdefines the time when the job starts and theendatparameter, the time when the job finishes..enqueue_export_program_job. Enqueue export job. This will place export job in queue, and will start the job when computing resources become available. The job must be in “Created” state.
export_program_file. Returns the file content of an export job. The export job must be in “Completed” state.
get_export_program_jobs. Returns a list of export jobs that were created in the past 7 days.
get_status_export_program_job. Returns status of an export job. Job status is available for 30 days after Completed or Failed status was reached.
cancel_export_program_job. Cancels the export job.
Query Example¶
Now, you can execute queries over the Marketo views that have been created:
Marketo create bulk extract Activity job query¶
Marketo create bulk extract Activity job query result¶
Marketo enqueue bulk extract Activity job query¶
Marketo enqueue bulk extract Activity job query result¶
Marketo get status bulk extract Activity job query¶
Marketo get status bulk extract Activity job query result¶
Marketo export bulk extract Activity job query¶
Marketo export bulk extract Activity job query result¶
Marketo export bulk extract Activity job file query¶
Marketo export bulk extract Activity job file query result¶