Automation
Defines automations created within Automation Studio in Salesforce Marketing Cloud. Each automation specifies a sequence of scheduled or triggered activities such as imports, sends, or data updates. This view provides visibility into configured automation workflows.
View-Specific Information
Select
The connector uses the Salesforce Marketing Cloud APIs to process the following WHERE clause operators for all but DateTime values: =, !=, <>, >, >=, <, <=, IN. For DateTime values, only > and < are supported. The connector processes other filters client-side within the connector.
For example, the following (but not only) queries are processed server side:
SELECT * FROM Automation WHERE ObjectID = 123 SELECT * FROM Automation WHERE ObjectID IN (123, 456) SELECT * FROM Automation WHERE CreatedDate > '2017/01/25'
Columns
| Name | Type | Description |
| ObjectID [KEY] | String | Specifies the system-controlled, read-only text string that uniquely identifies the automation object. This value remains consistent across API interactions and is used to reference the automation in programmatic workflows. |
| Name | String | Specifies the display name that is assigned to the automation. This value appears in Automation Studio and in API responses. |
| Description | String | Provides a human-readable explanation of the automation's purpose or behavior. This value helps administrators understand how and when the automation is intended to run. |
| Schedule_ID | Int | Specifies the read-only identifier (Id) of the schedule that is associated with the automation. This Id links the automation to its configured recurrence pattern. |
| CustomerKey | String | Specifies the user-supplied unique Id for the automation within its object type. This value enables external systems to reference the automation consistently across environments. |
| Client_ID | Long | Specifies the Id of the client context to which this automation belongs. This value determines the business unit and organizational scope in which the automation executes. |
| IsActive | Bool | Returns a value of 'true' when the automation is active and eligible to run. It returns a value of 'false' when the automation is inactive or paused. |
| CreatedDate | Datetime | Indicates the system-assigned date and time when the automation record was created. This value assists with auditing and lifecycle tracking. |
| Client_CreatedBy | Int | Specifies the Id of the user who created the automation. This value supports administrative traceability. |
| ModifiedDate | Datetime | Indicates the most recent date and time when the automation record was updated. This value reflects configuration changes or status updates. |
| Client_ModifiedBy | Int | Specifies the Id of the user who most recently modified the automation. This value supports auditing of administrative actions. |
| Status | Int | Indicates the current operational status of the automation. This value reflects whether the automation is running, paused, failed, or completed based on Automation Studio processing. |
| Client_EnterpriseID | Long | Specifies an internal enterprise-level Id that is associated with the automation's client context. This value is reserved for system-level configuration and does not participate in standard customer workflows. |