TrackingLogs
Retrieve trackingLogs for the specific contact or all contacts
Table Specific Information
Select
The add-in uses the ActiveCampaign API to process search criteria that refer to the Id and ContactId columns. The add-in processes other filters client-side within the driver. For example, the following queries are processed server side:
SELECT * FROM TrackingLogs WHERE Id = 1000 SELECT * FROM TrackingLogs WHERE ContactId = 1003
Columns
| Name | Type | Description |
| Id [KEY] | String | The Id column of the TrackingLogs table. |
| ContactId | String | The ContactId column of the TrackingLogs table. |
| Hash | String | The Hash column of the TrackingLogs table. |
| ContactLink | String | The ContactLink column of the TrackingLogs table. |
| SubscriberidLink | String | The SubscriberidLink column of the TrackingLogs table. |
| TstampLink | Datetime | The TstampLink column of the TrackingLogs table. |
| TypeLink | String | The TypeLink column of the TrackingLogs table. |
| ValueLink | String | The ValueLink column of the TrackingLogs table. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| UDateLink | Datetime |