ExternalActivity
Create and query External Activities. This table is not supported in bulk mode.
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. |