Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in 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 Excel Add-In 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. |