Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the driver beyond simple SELECT/INSERT/UPDATE/DELETE operations with Salesforce Marketing Cloud.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Salesforce Marketing Cloud, along with an indication of whether the procedure succeeded or failed.
CData ODBC Driver for Salesforce Marketing Cloud Stored Procedures
| Name | Description |
| CheckDataExtensionJobStatus | Retrieve the status of a request to insert or upsert rows in a data extension. |
| CreateDataExtensionJob | Insert or upsert data into a data extension asynchronously by key or ID. |
| CreateImportSendDeliveryReport | Generates a .csv fiie containing information regarding SMS message delivery for a specific MessageList and places the report in the Enhanced FTP location for the Marketing Cloud account. |
| CreateKeyword | Creates a keyword on an account. |
| CreateMessageListDeliveryReport | Triggers a delivery report for messageList API. |
| CreateOptInMessage | Creates an SMS opt-in message permitting contacts to subscribe to further SMS messages. |
| CreateTriggeredSend | Create a triggered send object which represents a specific instance of a triggered email send. |
| DeleteKeyword | Deletes a keyword on an account. |
| FireEntryEvent | Fire the entry event that initiates the journey. |
| GetChannelViewHtml | Returns the requested channel view's compiled HTML for the asset. |
| GetDataExtensionJobResults | Retrieve the results of a request to insert or upsert rows in a data extension. |
| GetDeliveryStatusOfQueuedMO | Retrieves the delivery status of a queued MO. |
| GetFileForAnAsset | Gets the binary file for an asset. |
| GetHeaderFooterAccount | Gets the default header and footer for an account. |
| GetHeaderFooterEmail | Gets the header and footer for an email. |
| GetImportSendStatus | Retrieves the status of a ImportSend automation. |
| GetImportStatus | Retrieves the status of an import job. |
| GetJourneyPublicationStatus | Retrieves the status of a journey publication. |
| GetMessageContactHistory | Retrieves the last message sent to a mobile number. |
| GetMessageContactStatus | Retrieves the overall delivery status of a message to a contact. |
| GetMessageListStatus | Returns status for a message sent to a group of mobile numbers. |
| GetMessageSendStatus | Gets the send status for a message. |
| GetOAuthAccessToken | Gets an authentication token from SalesforceMarketingCloud. |
| GetOAuthAuthorizationURL | Gets the authorization URL that must be opened separately by the user to grant access to your application. Only needed when developing Web apps. |
| GetRefreshListStatus | Retrieves the refresh list status. |
| GetSubscriptionStatus | Returns subscription status for mobile numbers or subscriber keys. |
| GetTrackingHistoryOfQueuedMO | Retrieves the tracking history of a queued MO. |
| ImportAndSendMessage | Imports and sends. |
| PostMessageToList | Initiates a message to one or more contact lists. |
| PostMessageToNumber | Initiates a message to one or more mobile numbers. |
| PublishJourney | Publishes a journey version asynchronously. |
| QueueContactImport | Queues a contact import. |
| QueueMoMessage | Queues an MO message for send. |
| RefreshList | Refreshes a list. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication with SalesforceMarketingCloud. |
| SendMessageToRecipient | Send an OTT message to the recipient. Supported OTT networks are Facebook Messenger and LINE. |
| SendTransactionalMessageToMultipleRecipients | Sends a message to a single recipient via a send definition. |
| SendTransactionalMessageToRecipient | Sends a message to a single recipient via a send definition. |
| StopJourney | Stop a running journey. |