FileTrigger
Reserved for future use. This table does not suport deletes.
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 |
System-controlled, text string identifier for object. |
| CustomerKey | String | False |
User-supplied unique identifier for an object within an object type. |
| Client_ID | Long | False |
The Id of the client. |
| ExternalReference | String | False |
Reserved for future use. |
| Name | String | False |
Name of the object or property. |
| Description | String | False |
Describes and provides information regarding the object. |
| Type | String | False |
Indicates type of specific list. Valid values include Public, Private, Salesforce, GlobalUnsubscribe, and Master. |
| Status | String | False |
Defines status of the object. |
| StatusMessage | String | False |
Describes the status of an API call. |
| RequestParameterDetail | String | False |
Reserved for future use. |
| ResponseControlManifest | String | False |
Reserved for future use. |
| FileName | String | False |
Indicates name of file associated with the object. |
| LastPullDate | Datetime | False |
Reserved for future use. |
| ScheduledDate | Datetime | False |
Reserved for future use. |
| IsActive | Bool | False |
Specifies whether or not the object is active. |
| CreatedDate | Datetime | False |
Indicated the date and time of the object's creation. |
| ModifiedDate | Datetime | False |
Indicates the last time object information was modified. |
| Client_CreatedBy | Int | False |
Returns user ID for user who created object |
| Client_ModifiedBy | Int | False |
Returns user ID for user who modified object. |