Stored Procedures
Stored procedures are available to complement the data available from the Data Model. It may be necessary to update data available from a view using a stored procedure because the data does not provide for direct, table-like, two-way updates. In these situations, the retrieval of the data is done using the appropriate view or table, while the update is done by calling a stored procedure. Stored procedures take a list of parameters and return back a dataset that contains the collection of tuples that constitute the response.
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. |
| StopJourney | Stop a running journey. |