FileTriggerTypeLastPull
Provides information about the most recent retrieval of file-trigger activity for each trigger type. This view helps track when a file-based trigger was last evaluated
View-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) queries are processed server side:
SELECT * FROM FileTriggerTypeLastPull WHERE ObjectID = 'nzxcaslkjd-123'
SELECT * FROM FileTriggerTypeLastPull WHERE ObjectID IN ('nzxcaslkjd-123', 'nzxcaslkjd-456')
Columns
| Name | Type | Description |
| Client_ID | Long | Specifies the client identifier (Id) that associates the record with the correct Salesforce Marketing Cloud account context. This value ensures that file-trigger pull tracking is scoped to the appropriate business unit or enterprise environment. |
| ObjectID [KEY] | String | Stores the system-controlled text string Id that uniquely identifies this file-trigger pull record. This identifier is read-only and ensures consistency when referencing the record across internal processes and API interactions. |
| ExternalReference | String | Captures an optional external reference value that can link this file-trigger pull record to outside systems, configuration inputs, or workflow components that participate in file-trigger activity. |
| Type | String | Indicates the type that is associated with the file-trigger category. This value helps classify how the trigger source should be interpreted and ensures that pull history is grouped according to its functional role. |
| LastPullDate | Datetime | Indicates the most recent date and time when the system attempted to retrieve or evaluate files for the specified trigger type. This timestamp supports auditing, monitoring, and troubleshooting of file-trigger operations. |