SSIS Components for Oracle Eloqua

Build 24.0.9060

LandingPage

Create, update, delete, and query Landing Pages.

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 identifier for the landing page.

Name String False

The name of the landing page.

DeployedAt Datetime False

Date the landing page was deployed.

HtmlContent String False

The raw HTML for the content of the landing page.

MicrositeId Long False

The unique identifier for this page's microsite.

RefreshedAt Datetime False

Date the landing page was refreshed.

RelativePath String False

The relative path to the landing page.

Style String False

The style of the landing page.

Description String False

The description of the landing page.

FolderId Long False

The Id of the folder for the landing page

Permissions String False

The permissions list for the landing page.

CreatedAt Datetime True

Date the landing page was created.

CreatedBy String True

The Id of the user who created the landing page.

AccessedAt Datetime False

Date the landing page was accessed.

CurrentStatus String False

The current status of the landing page.

AutoRedirectUrl String False

The URL to redirect window used with autoRedirectWaitFor.

Depth String False

The depth of the landing page.

UpdatedAt Datetime True

Date the landing page was updated.

UpdatedBy String True

The Id of the user who last updated the landing page.

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