SSIS Components for Oracle Eloqua

Build 24.0.8963

Microsite

Create, update, delete, and query Microsites.

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 of the microsite.

Name String False

The name of the microsite.

Domains String False

A list of domains for this micosite.

ScheduledFor Datetime False

The date and time scheduled for the microsite.

SourceTemplatedId Long False

The Id of the source template for the microsite.

DefaultLandingPageId Long False

The Id of the default landing page for the microsite.

Description String False

The description of the microsite.

FolderId Long False

The Id of the folder for the microsite

Permissions String False

The permissions of the microsite.

CreatedAt Datetime True

Date the microsite was created.

CreatedBy String True

The Id of the user who created the microsite.

AccessedAt Datetime False

Date the microsite was accessed.

CurrentStatus String False

The current status of the microsite.

Depth String False

The depth of the microsite.

UpdatedAt Datetime True

Date the microsite was updated.

UpdatedBy String True

The Id of the user who last updated the microsite.

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