Excel Add-In for Salesforce Marketing Cloud

Build 20.0.7695

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 Excel Add-In 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.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7695