Power BI Connector for Oracle Eloqua

Build 24.0.8963

OptionList

Create, update, delete, and query Option 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 ReadOnly Description
ID [KEY] Long True

The unique Id of the option list.

Name String False

The name of the option list item.

Depth String False

The depth of the option list item.

Permissions String False

The permissions of the option list item.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963