Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the server beyond simple SELECT/INSERT/UPDATE/DELETE 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 MCP Server for Marketo Stored Procedures
| Name | Description |
| ActivateSmartCampaign | Activates a trigger smart campaign. |
| ApproveAsset | Approves the asset based on the given asset type and id. |
| AssociateLead | Associates a known Marketo lead record to a munchkin cookie and its associated web activity history. |
| BulkExportActivities | A combination of CreateExportJob, EnqueueExportJob, PollExportJobStatus and GetExportJobFile. |
| BulkExportCustomObjects | A combination of CreateExportJob, EnqueueExportJob, PollExportJobStatus and GetExportJobFile. |
| BulkExportLeads | A combination of CreateExportJob, EnqueueExportJob, PollExportJobStatus and GetExportJobFile. |
| BulkExportProgramMembers | A combination of CreateExportJob, EnqueueExportJob, PollExportJobStatus and GetExportJobFile. |
| BulkImportCustomObjects | Imports the custom object records from the provided file, waits for the job to finish and returns the job completion details. |
| BulkImportLeads | Imports the lead records from the provided file, waits for the job to finish and returns the job completion details. |
| BulkImportProgramMembers | Imports the program member records from the provided file, waits for the job to finish and returns the job completion details. |
| CancelExportJob | Cancel a bulk export job. |
| CreateActivitiesExportJob | Create an activities export job based on the given filters. |
| CreateCustomObjectsExportJob | Create a custom object export job based on the given filters. Only 1 filter type can be specified. |
| CreateCustomObjectsImportJob | Imports the program custom object records from the provided file. |
| CreateEmailTemplate | Creates a new email template. |
| CreateExportJob | Create an export job for the search criteria defined via the filter aggregate input. Returns the 'JobId' which can be 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. |
| CreateLeadsExportJob | Create a leads export job based on the given filters. Only 1 filter type can be specified. |
| CreateLeadsImportJob | Imports the lead records from the provided file. |
| CreateProgramMembersExportJob | Create a program members export job based on the given filters. |
| CreateProgramMembersImportJob | Imports the program member records from the provided file. |
| DeactivateSmartCampaign | Deactivates a trigger smart campaign. |
| DeleteInvitedUser | Delete pending user. A pending user is a user that has not yet accepted invitation. Requires permissions: Access User Management Api and Access Users. |
| EnqueueExportJob | Puts an export job in queue and starts the job when computing resources become available. |
| GetEmailFullContent | Returns the serialized HTML version of the email. |
| GetEmailTemplateContent | Returns the content for a given email template. |
| GetExportJobFile | Returns the file generated by the bulk job with the given Id. |
| GetExportJobStatus | Returns the status of an export job. Job status is available for 30 days after Completed or Failed status was reached. |
| GetImportJobFailures | Returns the list of failures for the import batch job |
| GetImportJobStatus | Returns the status of an import job. |
| GetImportJobWarnings | Returns the list of warnings for the import batch job |
| GetInvitedUserById | Retrieve a single pending user record through its Id. A pending user is a user that has not yet accepted invitation. Requires permissions: Access User Management Api and Access Users. |
| GetOAuthAccessToken | Get an access token from Marketo. |
| GetSnippetContent | Returns the content for a given snippet. |
| InviteUser | Send an email invitation to new user. Requires permissions: Access User Management Api and Access Users. |
| MergeLeads | Merges two or more known lead records into a single lead record. |
| PollExportJobStatus | Continuously polls the bulk API for the status of the export job until one of the following statuses is returned: Completed, Cancelled, Failed. |
| PollImportJobStatus | Will continuously poll the bulk API for the status of the import job until one of the following statuses is returned: Complete, Failed. |
| ScheduleCampaign | Passes a set of leads to a trigger campaign to run through the campaign's flow. |
| SendEmailSample | Sends a sample email to the given email address. Leads may be impersonated to populate data for tokens and dynamic content. |
| TriggerCampaign | Remotely schedules a batch campaign to run at a given time. |
| UnApproveAsset | Revokes approval based on the given asset type and id. |
| UpdateEmailContent | Updates the content of an email. |
| UpdateEmailFullContent | Replaces the HTML of an Email that has had its relationship broken from its template. |
| UpdateEmailTemplateContent | Updates the content of the given email template. |
| UpdateFile | Updates the content of the given file. |
| UpdateLandingPageTemplateContent | Updates the content for the target landing page template. |
| UpdateLeadPartition | Update the lead partition for a list of leads. |
| UpdateLeadProgramStatus | Changes the program status for a list of leads in a target program. Only existing members of the program may have their status changed with this procedure. |
| UpdateSnippetContent | Updates the content of a snippet. |