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