TDV Adapter for Oracle Eloqua

Build 22.0.8462

ContactList

Create, update, delete, and query Contact Lists.

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
ID [KEY] Long The unique identifier for the contact list.
Name String The name of the contact list.
Count String The count of the contact list.
DataLookupId String The Id of the data lookup for the contact list.
MembershipAdditions String The number of contact membership additions in the contact list.
Scope String The contact list's scope: either local or global.
Description String The description of the contact list.
FolderId Long The Id of the folder for the contact list.
ScheduledFor Datetime The date and time scheduled for the contact list.
SourceTemplatedId Long The Id of the source template of the contact list.
Permissions String The permissions of the contact list.
CreatedAt Datetime Date the contact list was created.
CreatedBy String The Id of the user who created the contact list.
AccessedAt Datetime Date the contact list was accessed.
CurrentStatus String The current status of the contact list.
Depth String The depth of the contact list.
UpdatedAt Datetime Date the contact list was updated.
UpdatedBy String The Id of the user who created the contact list.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462