ExternalActivity
Create and query External Activities.
Table Specific Information
Select
This table requires that either Id or ContactId be specified to retrieve data:
SELECT * FROM ExternalActivity WHERE Id = '1111' SELECT * FROM ExternalActivity WHERE ContactId = '11'
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | Long | True |
The unique identifier of the external activity. |
| Type | String | False |
The type of the external activity. |
| Name | String | False |
The Name of the external activity. |
| ActivityType | String | False |
The Type of external activity. |
| ContactId | Long | False |
The ID of the contact who performed the external activity |
| CampaignId | Long | False |
The ID of the campaign associated with this external activity. |
| AssetName | String | False |
The AssetName of the external activity. |
| AssetType | String | False |
The AssetType of the external activity. |
| AssetId | Long | False |
The AssetId of the external activity. |
| ActivityDate | Datetime | False |
The Date of the external activity. |
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 |
| Depth | String |
The depth of information requested from Eloqua. |