Visitor
Retrieve Visitors.
Table Specific Information
Select
The following limitation exists for filtering on datetime columns: The "=" operator cannot be used with datetime columns in the WHERE clause. However, the "<", ">", ">=", and "<=" operators can be used to filter on datetime columns.
Additionally, the UpdatedAt column only supports filtering with the '>' operator.
Oracle Eloqua also has limited support on multiple conditions. In many tables the AND condition between filters is not supported. If AND is included the server might not return any results, nor will it return an error.
Columns
| Name | Type | Description |
| VisitorId [KEY] | Long | The Id of the visitor profile. |
| CreatedAt | Datetime | Date the visitor profile was created. |
| V_IPAddress | String | IP address of the visitor. |
| V_LastVisitDateAndTime | Datetime | Date of last visit to an Eloqua asset for this profile. |
| ExternalId | String | Customer GUID for this visitor profile. |
| ContactId | Long | The Id of the contact associated with this profile, if any. |
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. |