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, if applicable, any relevant response data from Salesforce Marketing Cloud, along with an indication of whether the procedure succeeded or failed.
CData JDBC Driver for Salesforce Marketing Cloud Stored Procedures
| Name | Description |
| 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. |
| 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. |
| 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. |
| 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. |
| SendTransactionalMessageToRecipient | Sends a message to a single recipient via a send definition. |
| StopJourney | Stop a running journey. |