FileTrigger
Represents configuration data that defines file-based automation triggers within Salesforce Marketing Cloud. A file trigger initiates an automation when a file is placed in a designated Enhanced FTP location, enabling automated imports or other workflow actions that begin upon file detection. This table does not support delete operations.
Table-Specific Information
Select
The connector uses the Salesforce Marketing Cloud APIs to process the following WHERE clause operators for all but date-time values: =, !=, <>, >, >=, <, <=, IN. For date-time values, only > and < are supported. The connector processes other filters client-side within the connector.
For example, the following (but not only) query is processed server side:
SELECT * FROM FileTrigger WHERE CreatedDate > '2017/01/25'
Insert
You must specify the following fields when inserting to this table: Name.
INSERT INTO FileTrigger (Name) VALUES ('Testing')
Update
You must specify the ObjectId in the WHERE clause when executing an update against this table.
UPDATE FileTrigger SET Name = 'Changed' WHERE ObjectId = 'nzxcaslkjd-123'
Columns
| Name | Type | ReadOnly | Description |
| ObjectID [KEY] | String | False |
Contains the system-controlled text string identifier (Id) that uniquely represents the file-trigger configuration across internal services and API operations. |
| CustomerKey | String | False |
Specifies the user-supplied unique Id for the file-trigger configuration within its object type. |
| Client_ID | Long | False |
Specifies the Id of the client account that owns the file-trigger configuration. |
| ExternalReference | String | False |
Provides an external reference value that is reserved for future integration or orchestration scenarios. |
| Name | String | False |
Defines the display name that is assigned to the file-trigger configuration in the user interface. |
| Description | String | False |
Provides a descriptive explanation of the file-trigger configuration and its intended purpose within data import or automation workflows. |
| Type | String | False |
Indicates the list type that is associated with the file-trigger configuration. Valid values include Public, Private, Salesforce, GlobalUnsubscribe, and Master. |
| Status | String | False |
Defines the current operational state of the file-trigger configuration (for example, active, inactive, or processing). |
| StatusMessage | String | False |
Contains a system-generated message that describes the most recent status returned by an API call or automation process. |
| RequestParameterDetail | String | False |
Contains supplemental request-parameter information that is captured during file-trigger processing. This value provides additional context for downstream automation, tracking, or diagnostic workflows that evaluate how the trigger was invoked. |
| ResponseControlManifest | String | False |
Captures system-generated response details that describe how the file-trigger operation was handled. This value provides structured information that downstream automation or monitoring tools can reference when evaluating trigger outcomes or execution paths. |
| FileName | String | False |
Specifies the name of the file that is associated with the file-trigger configuration, including its extension. |
| LastPullDate | Datetime | False |
Indicates the most recent date and time when the system attempted to retrieve or evaluate a file that is associated with the file-trigger configuration. This value helps track historical pull activity for auditing or troubleshooting. |
| ScheduledDate | Datetime | False |
Indicates the date and time when the file-trigger process is scheduled to execute according to its configuration. This timestamp helps align trigger activity with expected automation timing and supports auditing or monitoring workflows. |
| IsActive | Bool | False |
Returns a value of 'true' when the file-trigger configuration is enabled for evaluation or processing. It returns a value of 'false' when the configuration is disabled or inactive. |
| CreatedDate | Datetime | False |
Indicates the date and time when the file-trigger configuration was created. |
| ModifiedDate | Datetime | False |
Indicates the date and time when the file-trigger configuration was last modified. |
| Client_CreatedBy | Int | False |
Returns the Id of the user who created the file-trigger configuration. |
| Client_ModifiedBy | Int | False |
Returns the Id of the user who last modified the file-trigger configuration. |