ストアドプロシージャ
ストアドプロシージャはファンクションライクなインターフェースで、Salesforce Marketing Cloud の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品 の機能を拡張します。
ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにSalesforce Marketing Cloud から関連するレスポンスデータを返します。
CData JDBC Driver for Salesforce Marketing Cloud ストアドプロシージャ
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. |