Stored Procedures

Stored procedures are function-like interfaces that extend the functionality of the connector beyond simple SELECT operations with Marketo.

Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Marketo, along with an indication of whether the procedure succeeded or failed.

CData Power BI Connector for Marketo Stored Procedures


Name	Description
AddLandingPageContentSection	Adds a content section to the target landing page.
AddLeadsToList	Adds leads to a list in Marketo.
AssociateLead	Associates a known Marketo lead record to a munchkin cookie and its associated web activity history
CancelExportJob	Cancels an export job.
CreateEmailTemplate	Creates a new email template.
CreateExportJob	Create export job for search criteria defined via filter parameter. Returns the 'JobId' which is passed as a parameter in subsequent calls to Bulk Export Activities. Use EnqueueExportJob to queue the export job for processing. Use GetExportJobStatus to retrieve status of export job.
CreateFile	Creates a new file from the included payload.
DeleteLandingPageContentSection	Deletes the section of the landing page content in Marketo.
EnqueueExportJob	Places an export job in queue and starts the job when computing resources become available.
GetExportJobFile	Returns the file content of an export job. The export job must be in 'Completed' state. Use GetExportJobStatus to get the status of an export job.
GetExportJobStatus	Returns the status of an export job. Job status is available for 30 days after Completed or Failed status was reached.
GetImportCustomObjectsFailures	Downloads and saves the import custom objects failures file from Marketo.
GetImportCustomObjectsStatus	Gets the status of an import custom objects from file operation for Marketo.
GetImportCustomObjectsWarnings	Downloads and saves the import custom objects warnings file from Marketo.
GetImportLeadsFailures	Downloads and saves the import leads failures file from Marketo.
GetImportLeadsStatus	Gets the status of an import leads from file operation for Marketo.
GetImportLeadsWarnings	Downloads and saves the import leads warnings file from Marketo.
GetImportProgramMembersFailures	Downloads and saves the import program members failures file from Marketo.
GetImportProgramMembersStatus	Gets the status of an import program members from file operation for Marketo.
GetImportProgramMembersWarnings	Downloads and saves the import program members warnings file from Marketo.
GetOAuthAccessToken	Gets an authentication token from Marketo.
ImportCustomObjectsFromFile	Imports custom objects from a file into Marketo.
ImportLeadsFromFile	Imports leads from a file into Marketo.
ImportProgramMembersFromFile	Imports program members from a file into Marketo.
ListMembersOfList	Determines whether leads are contained within a list in Marketo.
MergeLeads	Merges two or more known lead records into a single lead record.
RefreshOAuthAccessToken	Gets an authentication token from Marketo.
RemoveLeadsFromList	Removes leads from a list in Marketo.
ScheduleCampaign	Remotely schedules a batch campaign to run at a given time.
UpdateEmailContent	Updates the content of an email
UpdateEmailFullContent	Updates the content of an email
UpdateEmailTemplateContent	Updates the content of the given email template.
UpdateFile	Replaces the current content of the file with the included payload
UpdateLandingPageContentSection	Add or update the section of the landing page content in Marketo.
UpdateLandingPageTemplateContent	Updates the content for the target landing page template.
UpdateLeadProgramStatus	Changes the program status of a list of leads in a target program. Only existing members of the program may have their status changed with this API.