Power BI Connector for Oracle Eloqua

Build 24.0.8963

ExternalActivity

Create and query External Activities.

Table Specific Information

Select

This table requires that either Id or ContactId be specified to retrieve data:

SELECT * FROM ExternalActivity WHERE Id = '1111'
SELECT * FROM ExternalActivity WHERE ContactId = '11'

Columns

Name Type ReadOnly Description
ID [KEY] Long True

The unique identifier of the external activity.

Type String False

The type of the external activity.

Name String False

The Name of the external activity.

ActivityType String False

The Type of external activity.

ContactId Long False

The ID of the contact who performed the external activity

CampaignId Long False

The ID of the campaign associated with this external activity.

AssetName String False

The AssetName of the external activity.

AssetType String False

The AssetType of the external activity.

AssetId Long False

The AssetId of the external activity.

ActivityDate Datetime False

The Date of the external activity.

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.

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