REST Data Model
The CData ADO.NET Provider for Salesforce Marketing Cloud models Salesforce Marketing Cloud data as an easy-to-use SQL database. There are three parts to the data model: tables, views, and stored procedures.
Tables
The Tables section, which details standard SQL tables, and the Views section, which lists read-only SQL tables, describe the schema exposed through the Salesforce Marketing Cloud.com API. The available data depends on your account credentials and access level.
The tables shipped with the CData ADO.NET Provider for Salesforce Marketing Cloud include:
| Table | Description |
| Assets | Provides access to digital assets within Salesforce Marketing Cloud. Assets include reusable content elements such as images, templates, or code snippets that are stored and managed in Content Builder. |
| AssetTypes | Returns the available asset types configured in Salesforce Marketing Cloud. Each asset type defines the structure, behavior, and rendering rules for specific types of content elements. |
| Callbacks | Manages event notification callbacks that are configured in Salesforce Marketing Cloud. |
| CampaignAssets | Maintains relationships between campaigns and their associated assets in Salesforce Marketing Cloud. |
| Campaigns | Represents campaigns in Salesforce Marketing Cloud. Each campaign groups related marketing efforts and performance metrics under a single initiative. |
| Categories | Stores category information (also known as folders) within Content Builder in Salesforce Marketing Cloud. |
| Contact | Retrieves detailed information for a specific contact in Salesforce Marketing Cloud. A contact represents an individual subscriber or customer who interacts with your marketing campaigns. |
| Contacts | Retrieves a comprehensive list of all contacts in Salesforce Marketing Cloud. Each contact represents a unique individual with associated communication preferences and subscription data. |
| EventDefinitions | Manages event definitions within Salesforce Marketing Cloud. An event definition specifies a trigger, such as a form submission or API call, that initiates an automated process like a journey entry or data update. |
| FacebookMessengerProperties | Defines properties for Facebook Messenger integrations in Salesforce Marketing Cloud. These properties control how messages are formatted, delivered, and tracked within Facebook channels. |
| JourneyActivities | Contains details about journey activities in Salesforce Marketing Cloud. A journey activity represents an action or decision point in a customer journey, such as sending an email or evaluating a contact attribute. |
| JourneyAuditLogs | Returns audit logs for journeys and their versions in Salesforce Marketing Cloud. |
| JourneyHistory | Retrieves the historical execution records of customer journeys in Salesforce Marketing Cloud. Each record reflects the runtime status, performance, and event details of a specific journey instance. |
| Journeys | Represents customer journeys in Salesforce Marketing Cloud. |
| LineMessengerProperties | The table that defines configuration properties for LINE messenger integrations in Salesforce Marketing Cloud. These properties determine how messages are delivered and tracked within LINE communication channels. |
| MobileApplications | Returns the list of mobile applications (apps) configured in a Salesforce Marketing Cloud account. |
| SmsStatusCodes | Returns Short Message Service (SMS) status codes recognized by Salesforce Marketing Cloud. |
| SendDefinitions | Stores send definitions in Salesforce Marketing Cloud. |
| Subscriptions | Manages event notification subscriptions within Salesforce Marketing Cloud. |
| TransactionalMessages | Retrieves a paginated list of transactional messages that are not successfully sent in Salesforce Marketing Cloud. |