Oracle Eloqua Version Support

The connector models the Oracle Eloqua REST API as bidirectional tables. Bulk operations are supported through version 2.0 of the Bulk API.

Authenticating to Oracle Eloqua

Connect via Login

To connect via Login, set AuthScheme to Basic. The standard method of authentiation to Oracle Eloqua is via the login method. The Login method requires you to set Company and to set User, and Password to the credentials you use to log in. This method uses HTTP Basic authentication over SSL.

Use the OAuth authentication standard to connect to Oracle Eloqua. OAuth requires the authenticating user to interact with Oracle Eloqua using the browser.

Custom Credentials

You will need to register an app to obtain the OAuthClientId and OAuthClientSecret. See Custom Credentials for a procedure.

Creating a Custom OAuth App

You may want to create a custom OAuth app to change the information displayed when users log into the Oracle Eloqua. You can register an app to obtain the OAuthClientId and OAuthClientSecret,.

See Creating a Custom OAuth App for a procedure.

This section describes desktop authentication using the credentials for your custom OAuth app. See Creating a Custom OAuth App for more information.

Desktop Authentication with your OAuth App

Follow the steps below to authenticate with the credentials for a custom OAuth app. See Creating a Custom OAuth App.

Get an OAuth Access Token

After setting the following, you are ready to connect:

• OAuthClientId: Set this to the Client ID in your app settings.
• OAuthClientSecret: Set this to the Client Secret in your app settings.
• CallbackURL: Set this to the Redirect URL in your app settings.
• InitiateOAuth: Set this to GETANDREFRESH. You can use InitiateOAuth to avoid repeating the OAuth exchange and manually setting the OAuthAccessToken.

When you connect the connector opens the OAuth endpoint in your default browser. Log in and grant permissions to the application. The connector then completes the OAuth process:

1. Extracts the access token from the callback URL and authenticates requests.
2. Saves OAuth values in OAuthSettingsLocation to be persisted across connections.

The Password GrantType

When setting the OAuthGrantType to password, an OAuth flow may be triggered that passes user credentials. In this case, there will be no browser window to authorize. Instead, the following connection properties will need to be set:

• User - Set this to the user name.
• User - Set this to the password.
• Company - Set the company for the user.
• OAuthClientId: Set this to the Client ID in your app settings.
• OAuthClientSecret: Set this to the Client Secret in your app settings.
• OAuthGrantType: Set this to password.
• InitiateOAuth: Set this to GETANDREFRESH. You can use InitiateOAuth to avoid repeating the OAuth exchange and manually setting the OAuthAccessToken.

Using OAuth on a Headless Machine

To create Oracle Eloqua data sources on headless servers or other machines on which the connector cannot open a browser, you need to authenticate from another machine. Authentication is a two-step process.

1. Instead of installing the connector on another machine, you can follow the steps below to obtain the OAuthVerifier value. Or, you can install the connector on another machine and transfer the OAuth authentication values, after you authenticate through the usual browser-based flow.
2. You can then configure the connector to automatically refresh the access token from the headless machine.

Using the Credentials for a Custom OAuth App

Create a Custom OAuth App

See Creating a Custom OAuth App for a procedure. You can then follow the procedures below to authenticate and connect to data.

Obtain a Verifier Code

Set the following properties on the headless machine:

• InitiateOAuth: Set this to OFF.
• OAuthClientId: Set this to the App ID in your app settings.
• OAuthClientSecret: Set this to the App Secret in your app settings.

You can then follow the steps below to authenticate from another machine and obtain the OAuthVerifier connection property.

1. Call the GetOAuthAuthorizationUrl stored procedure* with the CallbackURL input parameter set to the exact Redirect URI you specified in your app settings.
2. Open the returned URL in a browser. Log in and grant permissions to the connector. You are then redirected to the callback URL, which contains the verifier code.
3. Save the value of the verifier code. You will set this in the OAuthVerifier connection property.

On the headless machine, set the following connection properties to obtain the OAuth authentication values:

• OAuthClientId: Set this to the consumer key in your app settings.
• OAuthClientSecret: Set this to the consumer secret in your app settings.
• OAuthVerifier: Set this to the verifier code.
• OAuthSettingsLocation: Set this to persist the encrypted OAuth authentication values to the specified file.
• InitiateOAuth: Set this to REFRESH.

Connect to Data

After the OAuth settings file is generated, set the following properties to connect to data:

• OAuthSettingsLocation: Set this to the file containing the encrypted OAuth authentication values. Make sure this file gives read and write permissions to the provider to enable the automatic refreshing of the access token.
• InitiateOAuth: Set this to REFRESH.

Transfer OAuth Settings

Follow the steps below to install the connector on another machine, authenticate, and then transfer the resulting OAuth values.

On a second machine, install the connector and connect with the following properties set:

• OAuthSettingsLocation: Set this to a writable text file.
• InitiateOAuth: Set this to GETANDREFRESH.
• OAuthClientId: Set this to the Client ID in your app settings.
• OAuthClientSecret: Set this to the Client Secret in your app settings.
• CallbackURL: Set this to the Callback URL in your app settings.

Test the connection to authenticate. The resulting authentication values are written, encrypted, to the path specified by OAuthSettingsLocation. Once you have successfully tested the connection, copy the OAuth settings file to your headless machine. On the headless machine, set the following connection properties to connect to data:

• InitiateOAuth: Set this to REFRESH.
• OAuthSettingsLocation: Set this to the path to your OAuth settings file. Make sure this file gives read and write permissions to the connector to enable the automatic refreshing of the access token.

To obtain an OAuthClientId, OAuthClientSecret, CallbackURL, and you first need to create an app linked to your Oracle Eloqua account.

Create and Configure a Custom OAuth App

You can follow the procedure below to obtain the client credentials, the client ID (app Id) and client secret:

1. Log in to Oracle Eloqua.
2. Click Settings -> AppCloud Developer (under Platform Extensions) -> Create New App.
3. Enter a name, icon, and description for the app to be displayed to users when they connect to Oracle Eloqua. The OAuthClientId and OAuthClientSecret will be displayed.
4. Set the CallbackURL to http://localhost:3000, or another port of your choice.

When you connect the add-in opens the OAuth endpoint in your default browser. Log in and grant permissions to the application.

Fine Tuning Data Access

You can use the following properties to gain more granular control over how the connector surfaces the functionality of the underlying Oracle Eloqua APIs.
The connector uses the bulk API when possible; you can fine-tune the connectivity to the bulk API with the following connection properties:

• UseBulkAPI
• BulkPollingInterval
• BulkQueryTimeout
• DataRetentionDuration

Additionally, the following properties are useful to circumvent failed bulk API requests:

• RetryCount
• RetryInterval

Oracle Eloqua accepts characters for table and column names that must be escaped in SQL. You can set UseSimpleNames to true to report nonalphanumeric characters as underscores.

Stored Procedures

• The stored procedures features described in this documentation are not currently supported.
• Because stored procedures are not currently supported, any feature dependent on stored procedures is also currently not supported.

Configuration Files and Their Paths

• All references to adding configuration files and their paths refer to files and locations on the Jitterbit Harmony Agent where the connector is installed. These paths are to be adjusted as appropriate depending on the agent and the operating system. If multiple agents are used in an agent group, identical files will be required on each agent.

This section details a selection of advanced features of the Oracle Eloqua connector.

User Defined Views

The connector allows you to define virtual tables, called user defined views, whose contents are decided by a pre-configured query. These views are useful when you cannot directly control queries being issued to the drivers. See User Defined Views for an overview of creating and configuring custom views.

SSL Configuration

Use SSL Configuration to adjust how connector handles TLS/SSL certificate negotiations. You can choose from various certificate formats; see the SSLServerCert property under "Connection String Options" for more information.

Proxy

To configure the connector using Private Agent proxy settings, select the Use Proxy Settings checkbox on the connection configuration screen.

The Jitterbit Connector for Oracle Eloqua allows you to define a virtual table whose contents are decided by a pre-configured query. These are called User Defined Views, which are useful in situations where you cannot directly control the query being issued to the driver, e.g. when using the driver from Jitterbit. The User Defined Views can be used to define predicates that are always applied. If you specify additional predicates in the query to the view, they are combined with the query already defined as part of the view.

There are two ways to create user defined views:

• Create a JSON-formatted configuration file defining the views you want.
• DDL statements.

Defining Views Using a Configuration File

User Defined Views are defined in a JSON-formatted configuration file called UserDefinedViews.json. The connector automatically detects the views specified in this file.

You can also have multiple view definitions and control them using the UserDefinedViews connection property. When you use this property, only the specified views are seen by the connector.

This User Defined View configuration file is formatted as follows:

• Each root element defines the name of a view.
• Each root element contains a child element, called query, which contains the custom SQL query for the view.

For example:

{
	"MyView": {
		"query": "SELECT * FROM Contact WHERE MyColumn = 'value'"
	},
	"MyView2": {
		"query": "SELECT * FROM MyTable WHERE Id IN (1,2,3)"
	}
}

Use the UserDefinedViews connection property to specify the location of your JSON configuration file. For example:

"UserDefinedViews", "C:\Users\yourusername\Desktop\tmp\UserDefinedViews.json"

Schema for User Defined Views

User Defined Views are exposed in the UserViews schema by default. This is done to avoid the view's name clashing with an actual entity in the data model. You can change the name of the schema used for UserViews by setting the UserViewsSchemaName property.

Working with User Defined Views

For example, a SQL statement with a User Defined View called UserViews.RCustomers only lists customers in Raleigh:

SELECT * FROM Customers WHERE City = 'Raleigh';

An example of a query to the driver:

SELECT * FROM UserViews.RCustomers WHERE Status = 'Active';

Resulting in the effective query to the source:

SELECT * FROM Customers WHERE City = 'Raleigh' AND Status = 'Active';

That is a very simple example of a query to a User Defined View that is effectively a combination of the view query and the view definition. It is possible to compose these queries in much more complex patterns. All SQL operations are allowed in both queries and are combined when appropriate.

Customizing the SSL Configuration

By default, the connector attempts to negotiate SSL/TLS by checking the server's certificate against the system's trusted certificate store.

To specify another certificate, see the SSLServerCert property for the available formats to do so.

The Jitterbit Connector for Oracle Eloqua models the Bulk API and the REST API as relational tables, views, and stored procedures. For example, Oracle Eloqua activity types are represented by the corresponding views. Views are tables that cannot be modified.

Working with Oracle Eloqua APIs as Tables

All tables are accessible with the REST API, including custom tables. A limited number of tables and views can be used with the Bulk API. The connector supports version 2.0 of the Bulk API and version 2.0 of the REST API.

Custom Tables and Columns

The connector can expose custom tables, views, and columns from Oracle Eloqua that are not mentioned in the Tables and Views. The data model illustrates a sample of what your Oracle Eloqua data model might look like. The actual data model will be obtained dynamically based on your user credentials and Oracle Eloqua account. For example, the Account, Campaign, and Contact tables are dynamic: These tables contain the columns described and your custom columns.

Tables Available in the Bulk API

The following tables and views, including custom tables, are supported with the Bulk API:

• Account
• Activity_Bounceback
• Activity_EmailClickThrough
• Activity_EmailOpen
• Activity_EmailSend
• Activity_EmailSubscribe
• Activity_EmailUnsubscribe
• Activity_FormSubmit
• Activity_PageView
• Activity_WebVisit
• Contact
• Custom tables
• CampaignResponses

Stored Procedures

NOTE: Stored procedures are not currently supported. See the above note for details.

Stored Procedures are function-like interfaces to Oracle Eloqua that complement the data available from Oracle Eloqua tables. Stored procedures* implement actions available in the Bulk API and other API functionality that cannot be expressed as SELECT, INSERT, UPDATE, or DELETE statements.

API SQL Limitations

Table-specific API limitations and requirements are documented in Tables and Views; you can use the SupportEnhancedSQL feature, set by default, to circumvent most of these limitations. For both the Bulk and REST APIs, 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 throw an error.

Bulk API Limitations

DELETE and UPDATE are not supported by the Bulk API. Additionally, the column count must be <250 for SELECT and must be <= 100 for INSERT.

REST API Limitations

Bulk updates are only supported in the Bulk API.

Custom Table Limitations

Custom tables are read-only in the REST API. In the Bulk API, SELECT and INSERT are supported.

The connector models the data in Oracle Eloqua into a list of tables that can be queried using standard SQL statements.

Generally, querying Oracle Eloqua tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.

Jitterbit Connector for Oracle Eloqua Tables

Name	Description
Account	Create, update, delete, and query Accounts. This table is supported in bulk mode.
AccountGroup	Retrieve Account group.
Campaign	Create, update, delete, and query Campaigns.
CampaignResponses	Create, delete, and query Campaign Responses. This table is only supported in bulk mode.
Contact	Create, update, delete, and query Contacts. This table is supported in bulk mode.
ContactEmailSubscription	Retrieve all email group subscription status for the specific contact.
ContactSegment	Create, update, delete, and query Contact Segments.
ContentSection	Create, update, delete, and query Content Sections.
Custom	Create and delete custom.
Email	Create, update, delete, and query Emails.
EmailFooter	Create, update, delete, and query Email Footers.
EmailGroup	Create, update, delete, and query Email Groups.
EmailHeader	Create, update, delete, and query Email Headers.
Event	Create and delete Event.
ExternalActivity	Create and query External Activities. This table is not supported in bulk mode.
ExternalAsset	Create, update, delete, and query External Assets.
Folder	Create, update, delete, and query Folders.
Form	Create, update, delete, and query Forms.
Hyperlink	Create, update, delete, and query Hyperlinks.
LandingPage	Create, update, delete, and query Landing Pages.
Microsite	Create, update, delete, and query Microsites.
OptionList	Create, update, delete, and query Option Lists.

The connector can expose custom tables, views, and columns from Oracle Eloqua that are not mentioned in the Tables and Views. The data model illustrates a sample of what your Oracle Eloqua data model might look like. The actual data model will be obtained dynamically based on your user credentials and Oracle Eloqua account.

Create, update, delete, and query Accounts. This table is supported in bulk mode.

Columns

Name	Type	ReadOnly	Description
ID [KEY]	Long	True	The unique identifier of the account.
Company Name	String	False	The Name of the account.
Country	String	False	The country of the account.
Address	String	False	The address of the account.
City	String	False	The city of the address for the account.
State or Province	String	False	The state or province of the address for the account.
Zip or Postal Code	String	False	The zip or postal code of the address for the account.
Business Phone	String	False	The business phone number of the account.
Eloqua Company ID	String	True	The Eloqua company ID of the account
Date Created	Datetime	True	Date and time the account was created.
Date Modified	Datetime	True	Date and time the account was last updated.
Company Category	Double	False	The category of the company
SFDC Account ID	String	False	The Salesforce ID of the account
Last Modified by CRM System	Datetime	True	Date and time the account was last updated by the CRM system.
Address 2	String	False	The second address of the account.
Address 3	String	False	The third address of the account.
Industry	String	False	The industry of the account.
PURL Name (Default Hypersite)	String	True	The URL of the account.
Annual Revenue	String	False	The annual revenue of the account.
Fax	String	False	The fax number of the account.
Employees	Double	False	The number of employees of the account
Website	String	False	The website of the account.
Account Rating	String	False	The account rating of the account.

Retrieve Account group.

Columns

Name	Type	ReadOnly	Description
ID [KEY]	Long	True	The unique identifier for the account group.
Name	String	False	The name of the account group.
Type	String	False	The type of the account group.
Permissions	String	False	The permissions of the account group.
CreatedAt	Datetime	True	Date the account group was created.
IsArchived	String	False	The ID of the user who created the account group.
FolderId	String	True	The folderId of the account group.
UpdatedAt	Datetime	True	Date the account group was updated.
Description	String	True	The description of the accountgroup.

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.

Create, update, delete, and query Campaigns.

Columns

Name	Type	ReadOnly	Description
ID [KEY]	Long	True	The unique identifier of the campaign.
Name	String	False	The name of the campaign.
ActualCost	Double	False	The actual cost of the campaign.
BudgetedCost	Double	False	The budgeted cost for the Campaign.
CrmId	String	False	The unique ID of the campaign in your CRM.
EndAt	Datetime	False	The campaign's end date.
EndValues	String	False	The end values of the campaign.
IsMemberAllowedReEntry	Boolean	False	Determines whether a member can reenter the campaign.
IsReadOnly	Boolean	False	Whether the campaign is read-only.
StartAt	Datetime	False	The campaign's start date.
CreatedAt	Datetime	False	The date and time the campaign was created.
CreatedBy	String	False	The ID of the user who created the Campaign.
AccessedAt	Datetime	False	Date the campaign was accessed.
CurrentStatus	String	False	The current status of the campaign.
Depth	String	False	The depth of the campaign.
UpdatedAt	Datetime	False	Date the campaign was updated.
UpdatedBy	String	False	The ID of the user who last updated the Campaign.
Permissions	String	False	The permissions of the campaign.
ScheduledFor	Datetime	False	The date and time scheduled for the campaign.
SourceTemplatedId	String	False	The ID of the source template for the campaign.
FolderId	Long	False	The ID of the folder for the campaign.
Campaign Type	String	False	The type of campaign.
Product	String	False	The product of the campaign.
Region	String	False	The region of the campaign.
Five	String	False	The fifth value for the campagin.
Four	String	False	The fourth value for the campagin.
Three	String	False	The third value for the campagin.
Two	String	False	The second value for the campagin.
CLR End Date	Datetime	False	The CLR end date.

Create, delete, and query Campaign Responses. This table is only supported in bulk mode.

Columns

Name	Type	ReadOnly	Description
ID	Long	False	The unique identifier for the campaign responses.
Member Status	String	False	The status of the campaign member.
Integration Return Value	String	False	The return value of the campaign responses.
Created At	Long	False	The created time of the campaign responses.
Add At	String	False	The added time of the campaign responses.

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
ServiceInstanceId	String	The AppCloud action service instance ID. It is necessary to insert or select this table
ExecutionId	String	The execution ID of service instance.It is necessary to select this table

Create, update, delete, and query Contacts. This table is supported in bulk mode.

Table Specific Information

The EmailAddress column is required for inserts and updates.

Columns

Name	Type	ReadOnly	Description
ID [KEY]	Long	True	The unique identifier of the contact.
Email Address [KEY]	String	False	The Email Address of the contact.
First Name	String	False	The First Name of the contact.
Last Name	String	False	The Last Name of the contact.
Company	String	False	The Company of the contact.
Email Display Name	String	False	The Email Display Name of the contact.
Address 1	String	False	The Address 1 of the contact.
Address 2	String	False	The Address 2 of the contact.
Address 3	String	False	The Address 3 of the contact.
City	String	False	The City of the contact.
State or Province	String	False	The State or Province of the contact.
Zip or Postal Code	String	False	The Zip or Postal Code of the contact.
Country	String	False	The Country of the contact.
Business Phone	String	False	The Business Phone of the contact.
Mobile Phone	String	False	The Mobile Phone of the contact.
Fax	String	False	The Fax of the contact.
Title	String	False	The Title of the contact.
Salutation	String	False	The Salutation of the contact.
Salesperson	String	False	The Salesperson of the contact.
SFDC Contact ID	String	False	The SFDC Contact ID of the contact.
SFDC Lead ID	String	False	The SFDC Lead ID of the contact.
Date Created	Date	True	The Date Created of the contact.
Date Modified	Date	True	The Date Modified of the contact.
Eloqua Contact ID	String	True	The Eloqua Contact ID of the contact.
SFDC Account ID	String	False	The SFDC Account ID of the contact.
Last Modified by CRM System	Date	True	The Last Modified by CRM System of the contact.
Last SFDC Campaign ID	String	False	The Last SFDC Campaign ID of the contact.
Last SFDC Campaign Status	String	False	The Last SFDC Campaign Status of the contact.
Company Revenue	String	False	The Company Revenue of the contact.
SFDC Email Opt Out	String	False	The SFDC Email Opt Out of the contact.
Lead Source - Most Recent	String	False	The Lead Source - Most Recent of the contact.
Lead Source - Original	String	False	The Lead Source - Original of the contact.
Industry	String	False	The Industry of the contact.
Annual Revenue	String	False	The Annual Revenue of the contact.
Lead Status	String	False	The Lead Status of the contact.
Job Role	String	False	The Job Role of the contact.
Lead Score - High Value Website Content	Double	False	The Lead Score - High Value Website Content of the contact.
Lead Score Date - Engagement - Most Recent	Date	False	The Lead Score Date - Engagement - Most Recent of the contact.
Integrated Marketing and Sales Funnel Stage	String	False	The Integrated Marketing and Sales Funnel Stage of the contact.
Product/Solution of Interest	String	False	The Product/Solution of Interest of the contact.
Region	String	False	The Region of the contact.
PURL Name (Default Hypersite)	String	True	The PURL Name (Default Hypersite) of the contact.
Lead Rating - Combined	String	False	The Lead Rating - Combined of the contact.
Email Address Domain	String	True	The Email Address Domain of the contact.
First and Last Name	String	True	The First and Last Name of the contact.
Company Size	String	False	The Company Size of the contact.
Lead Score - Last High Touch Event Date	Date	False	The Lead Score - Last High Touch Event Date of the contact.
Lead Rating - Profile (Explicit)	String	False	The Lead Rating - Profile (Explicit) of the contact.
Lead Rating - Engagement (Implicit)	String	False	The Lead Rating - Engagement (Implicit) of the contact.
Lead Score - Profile (Explicit)	Double	False	The Lead Score - Profile (Explicit) of the contact.
Lead Score - Engagement (Implicit)	Double	False	The Lead Score - Engagement (Implicit) of the contact.
Lead Score Date - Profile - Most Recent	Date	False	The Lead Score Date - Profile - Most Recent of the contact.
Employees	Double	False	The Employees of the contact.
Territory	String	False	The Territory of the contact.
Lead Score	String	False	The Lead Score of the contact.
PURL Name	String	True	The PURL Name of the contact.
MD5 Hashed Email Address	String	True	The MD5 Hashed Email Address of the contact.
SHA256 Hashed Email Address	String	True	The SHA256 Hashed Email Address of the contact.
MD5 Hashed Business Phone	String	True	The MD5 Hashed Business Phone of the contact.
SHA256 Hashed Business Phone	String	True	The SHA256 Hashed Business Phone of the contact.
MD5 Hashed Mobile Phone	String	True	The MD5 Hashed Mobile Phone of the contact.
SHA256 Hashed Mobile Phone	String	True	The SHA256 Hashed Mobile Phone of the contact of the contact.

Retrieve all email group subscription status for the specific contact.

Columns

Name	Type	ReadOnly	Description
ID [KEY]	Long	True	The unique identifier for Email Group.
ContactID [KEY]	Long	False	The unique identifier for the contact.
Name	String	True	The name of the email group.
Description	String	True	The description of the email group.
IsSubScribed	Boolean	False	The subscribed status. The default value is false.
Permissions	String	True	The permissions of the email group.

Create, update, delete, and query Contact Segments.

Columns

Name	Type	ReadOnly	Description
ID [KEY]	Long	True	The unique identifier for the contact segment.
Name	String	False	The name of the contact segment.
Description	String	False	The description of the contact segment.
FolderId	Long	False	The ID of the folder for the contact segment.
ScheduledFor	Datetime	False	The date and time scheduled for the contact segment.
SourceTemplatedId	Long	False	The ID of the source template of the contact segment.
Permissions	String	False	The permissions of the contact segment.
CreatedAt	Datetime	True	Date the contact segment was created.
CreatedBy	String	True	The ID of the user who created the contact segment.
AccessedAt	Datetime	False	Date the contact segment was accessed.
CurrentStatus	String	False	The current status of the contact segment.
UpdatedAt	Datetime	True	Date the contact segment was last updated.
UpdatedBy	String	True	The ID of the user who last updated the contact segment.
LastCalculatedAt	Datetime	False	Date the contact segment was last calculated.

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.

Create, update, delete, and query Content Sections.

Columns

Name	Type	ReadOnly	Description
ID [KEY]	Long	True	The unique identifier for the content section.
Name	String	False	The name of the content section.
Description	String	False	The description of the content section.
FolderId	Long	False	The ID of the folder for the content section.
ScheduledFor	Datetime	False	The date and time scheduled for the content section.
SourceTemplatedId	Long	False	The ID of the source template of the content section.
Permissions	String	False	The permissions of the content section.
CreatedAt	Datetime	True	Date the content section was created.
CreatedBy	String	True	The ID of the user who created the content section.
AccessedAt	Datetime	False	Date the content section was accessed.
CurrentStatus	String	False	The current status of the content section.
UpdatedAt	Datetime	True	Date the content section was updated.
UpdatedBy	String	True	The ID of the user who last updated the content section.
ContentHtml	String	False	The content HTML of the content section.
ContentText	String	False	The content text of the data lookup for the content section.
Scope	String	False	A list of contact Ids to be removed from the content section.

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.

Create and delete custom.

Columns

Name	Type	ReadOnly	Description
Id [KEY]	String	False	The ID of the custom.
Name	String	False	The name of the custom.
EmailAddressFieldId	String	False	The field ID that contains the Email Address. Use the desired custom object field's negative ID as the value for this parameter.
EventGroupByFieldId	String	False	The ID of the field used to organize multiple sessions. Use the desired custom object field's negative ID as the value for this parameter.
FolderId	String	True	The folder ID of the folder which contains the custom.
Fields	String	False	Array consisting of custom field properties
Description	String	False	The description of the custom.
RecordCount	Integer	True	The amount of records within the custom.
CreatedAt	Datetime	True	Date the custom was created.
CreatedBy	String	True	The ID of the user who created the custom.
UpdatedAt	Datetime	True	Date the custom was last updated.
UpdatedBy	String	True	The ID of the user who last updated the custom.

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.

Create, update, delete, and query Emails.

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 throw an error.

Columns

Name	Type	ReadOnly	Description
ID [KEY]	Long	True	The unique identifier of the email.
Name	String	False	The name of the email.
EmailGroupId	Long	False	The ID of the email group.
HtmlContent_ContentSource	String	False	The raw HTML contentSorce for the content of the email.
HtmlContent_CssHeader	String	False	The raw HTML cssHeader for the content of the email.
HtmlContent_DocType	String	False	The raw HTML docType for the content of the email.
HtmlContent_DocumentDescription	String	False	The raw HTML documentDescription for the content of the email.
HtmlContent_HtmlBody	String	False	The raw HTML Body for the content of the email.
HtmlContent_MetaTags	String	True	The raw HTML metaTags for the content of the email.
HtmlContent_Root	String	False	The raw HTML root for the content of the email.
HtmlContent_SystemHeader	String	False	The raw HTML systemHeader for the content of the email.
HtmlContent_Type	String	False	The raw HTML type for the content of the email.
IsPlainTextEditable	Boolean	False	Identifies whether the email is plaintext editable.
IsTracked	Boolean	False	Identifies whether the email is tracked.
PlainText	String	False	The plaintext version of the email.
BouncebackEmail	String	False	The bounce-back email address.
ReplyToEmail	String	False	The email address in the reply-to line of the email.
ReplyToName	String	False	The name in the reply-to line of the email.
SenderEmail	String	False	The email address of the sender.
SenderName	String	False	The name of the sender.
SenderPlainTextOnly	Boolean	False	Identifies whether the plaintext version should be sent.
Subject	String	False	The subject of the email.
Description	String	False	The description of the email.
FolderId	Long	False	The ID of the folder for the email.
Permissions	String	False	The permissions of the email.
CreatedAt	Datetime	True	Date the email was created.
CreatedBy	String	True	The ID of the user who created the email.
AccessedAt	Datetime	False	Date the email was accessed.
CurrentStatus	String	False	The current status of the email.
Depth	String	False	The depth of the email.
UpdatedAt	Datetime	True	Date the email was updated.
UpdatedBy	String	True	The ID of the user who last updated the email.

Create, update, delete, and query Email Footers.

Columns

Name	Type	ReadOnly	Description
ID [KEY]	Long	True	The unique identifier for the email footer.
Name	String	False	The name of the email footer.
Body	String	False	The body of the email footer.
Hyperlinks	String	True	A list of hyperlinks.
FieldMerges	String	True	A list of field merges.
Text	String	False	The text of the email footer.
Permissions	String	False	The permissions of the email footer.
Description	String	False	The description of the email footer.
FolderId	Long	False	The ID of the folder for the email footer.
CreatedAt	Datetime	True	Date the email footer was created.
CreatedBy	String	True	The ID of the user who created the email footer.
AccessedAt	Datetime	False	Date the email footer was accessed.
CurrentStatus	String	False	The current status of the email footer.
Depth	String	False	The depth of the email footer.
UpdatedAt	Datetime	True	Date the email footer was updated.
UpdatedBy	String	True	The ID of the user who last updated the email footer.
PlainText	String	True	The plain text of the email footer.

Create, update, delete, and query Email Groups.

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 throw an error.

Columns

Name	Type	ReadOnly	Description
ID [KEY]	Long	True	The unique identifier of the email group.
Name	String	False	The name of the email.
DisplayName	String	False	The display name of the email group.
EmailFooterId	Long	False	The ID of the email footer of the email group.
EmailIds	String	False	The Ids of the emails in the email group.
IsVisibleInOutlookPlugin	Boolean	False	Identifies whether the email group is visible in the Outlook plugin.
IsVisibleInPublicSubscriptionList	Boolean	False	Identifies whether the email group is visible in public subscription list.
SubscriptionLandingPageId	Long	False	The ID of the landing page used to subscribe to the email group.
SubscriptionListId	Long	False	The ID of the subscription list for the email group.
UnsubscriptionLandingPageId	Long	False	The ID of the landing page used to unsubscribe for the email group.
UnsubscriptionListId	Long	False	The ID of the unsubscription list for the email group.
UnsubscriptionListDataLookupId	String	False	The ID of the data lookup for the unsubscription list for the email group.
Description	String	False	The description of the email group.
FolderId	Long	False	The folder ID for the email group.
Permissions	String	False	The permissions list of the email group.
CreatedAt	Datetime	True	Date the email group was created.
CreatedBy	String	True	The ID of the user who created the email group.
AccessedAt	Datetime	False	Date the email group was accessed.
CurrentStatus	String	False	The current status of the email group.
Depth	String	False	The depth of the email group.
UpdatedAt	Datetime	True	Date the email group was updated.
UpdatedBy	String	True	The ID of the user who last updated the email group.

Create, update, delete, and query Email Headers.

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 throw an error.

Columns

Name	Type	ReadOnly	Description
ID [KEY]	Long	True	The unique identifier for the email header.
Name	String	False	The name of the email header.
Body	String	False	The body of the email header.
Hyperlinks	String	True	A list of hyperlinks.
FieldMerges	String	True	A list of field merges.
Text	String	False	The text of the email header.
Permissions	String	False	The permissions of the email header.
Description	String	False	The description of the email header.
FolderId	Long	False	The ID of the folder for the email header.
CreatedAt	Datetime	True	Date the email header was created.
CreatedBy	String	True	The ID of the user who created the email header.
AccessedAt	Datetime	False	Date the email header was accessed.
CurrentStatus	String	False	The current status of the email header.
Depth	String	False	The depth of the email header.
UpdatedAt	Datetime	True	Date the email header was updated.
UpdatedBy	String	True	The ID of the user who last updated the email header.

Create and delete Event.

Columns

Name	Type	ReadOnly	Description
Id [KEY]	String	False	The ID of the event.
Name	String	False	The name of the event.
EmailAddressFieldId	String	False	The field ID that contains the Email Address. Use the negative ID of the desired custom object field as the value for this parameter.
EventGroupByFieldId	String	False	The ID of the field used to organize multiple sessions. Use the negative ID of the desired custom object field as the value for this parameter.
FolderId	String	True	The folder ID of the folder which contains the event.
Fields	String	False	Array consisting of event field properties.
Description	String	False	The description of the event.
RecordCount	Integer	True	The amount of records within the event.
CreatedAt	Datetime	True	Date the event was created.
CreatedBy	String	True	The ID of the user who created the event.
UpdatedAt	Datetime	True	Date the event was last updated.
UpdatedBy	String	True	The ID of the user who last updated the event.

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.

Create and query External Activities. This table is not supported in bulk mode.

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.

Create, update, delete, and query External Assets.

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 throw an error.

Columns

Name	Type	ReadOnly	Description
ID [KEY]	Long	True	The unique identifier of the external asset.
Name	String	False	The name of the external asset.
CreatedAt	Datetime	True	Date the external asset was created.
CreatedBy	String	True	The ID of the user who created the external asset.
Depth	String	False	The depth of the external asset.
UpdatedAt	Datetime	True	Date the external asset was updated.
UpdatedBy	String	True	The ID of the user who last updated the external asset.

Create, update, delete, and query Folders.

Columns

Name	Type	ReadOnly	Description
ID [KEY]	Long	True	The unique identifier for the folder.
Name	String	False	The name of the folder.
IsSystem	Boolean	False	Identifies a system-generated folder.
Description	String	False	The description of the folder.
CreatedAt	Datetime	True	Date the folder was created.
UpdatedAt	Datetime	True	Date the folder was last updated.
UpdatedBy	String	True	The ID of the user who last updated the folder.

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.

Create, update, delete, and query Forms.

Columns

Name	Type	ReadOnly	Description
ID [KEY]	Long	True	The unique identifier for the form.
Name	String	False	The name of the form.
FolderId	Long	False	The ID of the folder for the form.
SourceTemplatedId	Long	False	The ID of the source template of the form.
Permissions	String	False	The permissions of the form.
CreatedAt	Datetime	True	Date the form was created.
CreatedBy	String	True	The ID of the user who created the form.
CurrentStatus	String	False	The current status of the form.
UpdatedAt	Datetime	True	Date the form was last updated.
UpdatedBy	String	True	The ID of the user who last updated the form.
HtmlName	String	False	The HTML name of the form.
ProcessingType	String	False	The processing type of the data lookup for the form.
SubmitFailedLandingPageId	Long	False	The submit failed landing page ID of the form.
Html	String	False	The HTML of the form.
Style	String	False	The style of the form.

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.

Create, update, delete, and query Hyperlinks.

Columns

Name	Type	ReadOnly	Description
ID [KEY]	Long	True	The unique identifier for the hyperlink.
Name	String	False	The name of the hyperlink.
IsSystem	Boolean	False	Identifies a system-generated hyperlink.
UpdatedAt	Datetime	True	Date the hyperlink was updated.
UpdatedBy	String	True	The ID of the user who last updated the hyperlink.
FolderId	Long	False	The folder ID of the hyperlink.
CreatedAt	Datetime	True	Date the hyperlink was created.
CreatedBy	String	True	The ID of the user who created the hyperlink.
Href	String	False	The href of the hyperlink.
HyperlinkType	String	False	The type of the hyperlink.

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.

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 throw 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.
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.

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 throw 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.

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 throw 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.

Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure* is available to update the data if such functionality is applicable to the data source.

Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard. To find out more about tables and stored procedures, please navigate to their corresponding entries in this help document.

Jitterbit Connector for Oracle Eloqua Views

Name	Description
AccountField	Retrieve Account Fields.
AccountView	Retrieve Account Views.
Activity_Bounceback	Retrieve Bounceback Activities. This table is only supported in bulk mode.
Activity_CampaignMembership	Retrieve Campaign Membership Activities.
Activity_EmailClickThrough	Retrieve Email Click Through Activities.
Activity_EmailOpen	Retrieve Email Open Activities.
Activity_EmailSend	Retrieve Email Send Activities.
Activity_EmailSubscribe	Retrieve Email Subscribe Activities.
Activity_EmailUnsubscribe	Retrieve Email Unsubscribe Activities.
Activity_FormSubmit	Retrieve Form Submit Activities.
Activity_PageView	Retrieve Page View Activities. This table is only supported in bulk mode.
Activity_WebVisit	Retrieve Web Visit Activities.
CampaignElement	Retrieve Campaign Elements.
CampaignField	Retrieve Campaign Fields.
CampaignFolder	Retrieve Campaign Folders.
ContactField	Retrieve Contact Fields.
ContactFilter	Retrieve Contact Filters.
ContactFilterFolder	Retrieve Contact Filter Folders.
ContactList	Create, update, delete, and query Contact Lists.
ContactListFolder	Retrieve Contact List Folders.
ContactScoringModelFolder	Retrieve Contact Scoring Model Folders.
ContactSegmentData	Retrieve Contact Segment Data. Note: The pseudo column SegmentID must be specified to retrieve the data of this table. This SegmentID can be retrieved from the ContactSegment table's ID column.
ContactSegmentFolder	Retrieve Contact Segment Folders.
ContactView	Retrieve Contact Views.
ContentSectionFolder	Retrieve Content Section Folders.
Dependencies	Retrieve Dependencies.
DynamicContent	Retrieve Dynamic Contents.
DynamicContentFolder	Retrieve Dynamic Content Folders.
EmailDeployment	Retrieve email deployments.
EmailFolder	Retrieve Email Folders.
EmailFooterFolder	Retrieve Email Footer Folders.
EmailHeaderFolder	Retrieve Email Header Folders.
ExternalType	Retrieve External Types.
FieldMerge	Retrieve Field Merges.
FieldMergeFolder	Retrieve Field Merge Folders.
FormElement	Retrieve Form Elements.
FormFolder	Retrieve Form Folders.
FormProcessingStep	Retrieve Form Processing Steps.
HyperlinkFolder	Retrieve Hyperlink Folders.
Image	Retrieve Image.
ImageFolder	Retrieve Image Folders.
ImportedFile	Retrieve Imported Files.
ImportedFileFolder	Retrieve Imported File Folders.
LandingPageFolder	Retrieve Landing Page Folders.
LeadScoringModel	Query Lead Scoring Models.
PageTag	Retrieve Page Tags.
PageTagGroup	Retrieve Page Tag Groups.
Program	Retrieve Programs.
Style	Retrieve Styles.
Template	Retrieve Templates.
TemplateCategory	Retrieve Template Categories.
TrackedUrl	Retrieve Tracked Urls.
User	Retrieve Users.
Visitor	Retrieve Visitors.
VisitorProfileField	Retrieve all of the visitor profile fields.

Retrieve Account Fields.

Columns

Name	Type	Description
ID [KEY]	Long	The unique identifier for the account field.
Name	String	The name of the account field.
DataType	String	The data type of the account field.
DisplayType	String	The display type of the account field.
InternalName	String	The country of the account field.
IsReadOnly	Boolean	Identifies whether the account field is read-only.
IsRequired	Boolean	Identifies whether the account field is required.
IsStandard	Boolean	Identifies whether the account field is standard.
OptionListId	Long	The ID of the option list for the account field.
OutputFormatId	Long	The ID of the output format for the account field.
CreatedAt	Datetime	Date the account field was created.
CreatedBy	String	The ID of the user who created the account field.
Depth	String	The depth of the account field.
UpdatedAt	Datetime	Date the account field was updated.
UpdatedBy	String	The ID of the user who last updated the account field.

Retrieve Account Views.

Columns

Name	Type	Description
ID [KEY]	Long	The unique identifier for the account view.
Name	String	The name of the account view.
Description	String	The description of the account view.
Permissions	String	The permissions of the account view.
CreatedAt	Datetime	Date the account view was created.
CreatedBy	String	The ID of the user who created the account view.
AccessedAt	Datetime	Date the account view was accessed.
UpdatedAt	Datetime	Date the account view was updated.
UpdatedBy	String	The ID of the user who last updated the account view.

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.

Retrieve Bounceback Activities. This table is only supported in bulk mode.

Columns

Name	Type	Description
ID [KEY]	Long	The unique identifier of the bounceback activity.
CreatedAt	Datetime	The date and time the bounceback activity was created.
Type	String	The type of the activity associated with the bounceback activity.
AssetName	String	The name of the asset associated with the bounceback activity.
AssetId	Long	The ID of the asset associated with the bounceback activity.
AssetType	String	The type of the asset associated with the bounceback activity.
CampaignId	Long	The ID of the campaign associated with the bounceback activity.
EmailAddress	String	The address of the email.
ExternalId	String	The ExternalId associated with the email activity. Only supported in bulk mode.
EmailRecipientId	String	The Email Recipient ID associated with the email activity. Only supported in bulk mode.
SmtpErrorCode	String	The Smtp Error Code associated with the email activity. Only supported in bulk mode.
SmtpStatusCode	String	The Smtp Status Code associated with the email activity. Only supported in bulk mode.
SmtpMessage	String	The Smtp Message associated with the email activity. Only supported in bulk mode.
DeploymentId	String	The email deployment ID associated with the email activity. Only supported in bulk mode.
ContactId	Long	The ID of the contact associated with the bounceback activity.
FirstName	String	The FirstName of the contact associated with the bounceback activity.
LastName	String	The LastName of the contact associated with the bounceback activity.
Company	String	The Company of the contact associated with the bounceback activity.
City	String	The City of the contact associated with the bounceback activity.
ContactCreatedAt	Datetime	The date and time the contact associated with the bounceback activity was created.
ContactModifiedAt	Datetime	The date and time the contact associated with the bounceback activity was created.
Address1	String	The first line address of the contact associated with the bounceback activity.
Address2	String	The second line address of the contact associated with the bounceback activity.
Title	String	The Title of the contact associated with the bounceback 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
ExportToken	String	The token returned from CreateExportDefinition. If Eloqua has not finished processing the request, the query will wait until the server has finished before returning data.
Depth	String	The depth of information requested from Eloqua.

Retrieve Campaign Membership Activities.

Table Specific Information

This table is the only activity table not available in the Bulk API.

Select

ContactId is required to query Activity tables.

Columns

Name	Type	Description
ID [KEY]	Long	The unique identifier of the campaign membership activity.
Name	String	The name of the campaign membership activity.
CreatedAt	Datetime	The date and time the campaign membership activity was created.
Type	String	The type of campaign membership activity.
AssetId	Long	The ID of the asset associated with the campaign membership activity.
AssetType	String	The type of the asset associated with the campaign membership activity.
AssetName	String	The name of the asset associated with the email campaign membership activity.
ContactId	Long	The ID of the contact who performed the campaign membership activity.
Responded	String	Whether the campaign membership activity has been responded to.
CampaignName	String	The campaign name of the campaign membership activity.
LeadStage	String	The lead stage of the campaign membership activity.
CampaignId	Long	The campaignId of the campaign membership 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
ExportToken	String	The token returned from CreateExportDefinition. If Eloqua has not finished processing the request, the query will wait until the server has finished before returning data.
Depth	String	The depth of information requested from Eloqua.

Retrieve Email Click Through Activities.

Table Specific Information

Select

If you are not using the Bulk API, ContactId is required to query Activity tables.

Additionally, the COUNT function is supported for this table in bulk mode.

Columns

Name	Type	Description
ID [KEY]	Long	The unique identifier of the email click-through activity.
Name	String	The name of the email click-through activity. Not supported in bulk mode.
CreatedAt	Datetime	The date and time the email click-through activity was created.
Type	String	The type of the email click-through activity.
AssetId	Long	The ID of the asset associated with the email click-through activity.
AssetName	String	The name of the asset associated with the email click-through activity.
AssetType	String	The type of the asset associated with the email click-through activity.
ContactId	Long	The ID of the contact who performed the email click-through activity.
EmailClickedThruLink	String	The click-through link in the email.
EmailName	String	The name of the email. Not supported in bulk mode.
EmailWebLink	String	The Web link of the email.
SubjectLine	String	The subject line of the email.
EmailRecipientId	String	The ID of the recipient of the email.
EmailSendType	String	The send type of the email. Only supported in bulk mode.
EmailAddress	String	The address of the email. Only supported in bulk mode.
IpAddress	String	The IP address of the email activity. Only supported in bulk mode.
CampaignId	Long	The ID of the campaign associated with the email click-through activity. Only supported in bulk mode.
DeploymentId	Long	The deployment ID associated with the email open activity. Only supported in bulk mode.
VisitorId	Long	The ID of the visitor associated with the email open activity. Only supported in bulk mode.
VisitorExternalId	String	The ExternalId of the visitor associated with the email open activity. Only supported in bulk mode.
ExternalId	String	The ExternalId associated with the email open activity. Only supported in bulk mode.
FirstName	String	The FirstName of the contact associated with the email click-through activity.
LastName	String	The LastName of the contact associated with the email click-through activity.
Company	String	The Company of the contact associated with the email click-through activity.
City	String	The City of the contact associated with the email click-through activity.
ContactCreatedAt	Datetime	The date and time the contact associated with the email click-through activity was created.
ContactModifiedAt	Datetime	The date and time the contact associated with the email click-through activity was created.
Address1	String	The first line address of the contact associated with the email click-through activity.
Address2	String	The second line address of the contact associated with the email click-through activity.
Title	String	The Title of the contact associated with the email click-through 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
ExportToken	String	The token returned from CreateExportDefinition. If Eloqua has not finished processing the request, the query will wait until the server has finished before returning data.
Depth	String	The depth of information requested from Eloqua.

Retrieve Email Open Activities.

Table Specific Information

Select

If you are not using the Bulk API, ContactId is required to query Activity tables.

Columns

Name	Type	Description
ID [KEY]	Long	The unique identifier of the email open activity.
Name	String	The name of the email open activity. Not supported in bulk mode.
EmailAddress	String	The email address of the contact.
CreatedAt	Datetime	The date and time the email open activity was created.
Type	String	The type of the activity associated with the email open activity.
AssetName	String	The name of the asset associated with the email open activity.
AssetId	Long	The ID of the asset associated with the email open activity.
AssetType	String	The type of the asset associated with the email open activity.
ContactId	Long	The ID of the contact who performed the email open activity.
EmailName	String	The name of the email. Not supported in bulk mode.
EmailWebLink	String	The Web link of the email.
EmailRecipientId	String	The ID of the recipient of the email.
EmailSendType	String	The send type of the email. Only supported in bulk mode.
IPAddress	String	The IP address of the sender.
SubjectLine	String	The subject line of the email.
CampaignId	Long	The ID of the campaign associated with the email open activity. Only supported in bulk mode.
DeploymentId	Long	The deployment ID associated with the email open activity. Only supported in bulk mode.
VisitorId	Long	The ID of the visitor associated with the email open activity. Only supported in bulk mode.
VisitorExternalId	String	The ExternalId of the visitor associated with the email open activity. Only supported in bulk mode.
ExternalId	String	The ExternalId associated with the email open activity. Only supported in bulk mode.
FirstName	String	The FirstName of the contact associated with the email open activity.
LastName	String	The LastName of the contact associated with the email open activity.
Company	String	The Company of the contact associated with the email open activity.
City	String	The City of the contact associated with the email open activity.
ContactCreatedAt	Datetime	The date and time the contact associated with the email open activity was created.
ContactModifiedAt	Datetime	The date and time the contact associated with the email open activity was created.
Address1	String	The first line address of the contact associated with the email open activity.
Address2	String	The second line address of the contact associated with the email open activity.
Title	String	The Title of the contact associated with the email open 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
ExportToken	String	The token returned from CreateExportDefinition. If Eloqua has not finished processing the request, the query will wait until the server has finished before returning data.
Depth	String	The depth of information requested from Eloqua.

Retrieve Email Send Activities.

Table Specific Information

Select

If you are not using the Bulk API, ContactId is required to query Activity tables.

Additionally, the COUNT function is supported for this table in bulk mode.

Columns

Name	Type	Description
ExternalId [KEY]	String	The ExternalId associated with the email send activity. Only supported in bulk mode.
ID	Long	The identifier of the email send activity. This is not unique.
Name	String	The name of the email send activity. Not supported in bulk mode.
CreatedAt	Datetime	The date and time when the email send activity was created.
Type	String	The activity type of the email send activity.
AssetName	String	The name of the asset associated with the email send activity.
AssetId	Long	The ID of the asset associated with the email send activity.
AssetType	String	The type of the asset associated with the email send activity.
ContactId	Long	The ID of the contact who performed the email send activity.
EmailName	String	The name of the email. Not supported in bulk mode.
EmailWebLink	String	The Web link of the email.
EmailRecipientId	String	The ID of the recipient of the email.
SubjectLine	String	The subject line of the email.
EmailAddress	String	The address of the email. Only supported in bulk mode.
EmailSendType	String	The send type of the email. Only supported in bulk mode.
CampaignId	Long	The ID of the campaign associated with the email send activity. Only supported in bulk mode.
DeploymentId	Long	The deployment ID associated with the email send activity. Only supported in bulk mode.
FirstName	String	The FirstName of the contact associated with the email send activity.
LastName	String	The LastName of the contact associated with the email send activity.
Company	String	The Company of the contact associated with the email send activity.
City	String	The City of the contact associated with the email send activity.
ContactCreatedAt	Datetime	The date and time the contact associated with the email send activity was created.
ContactModifiedAt	Datetime	The date and time the contact associated with the email send activity was created.
Address1	String	The first line address of the contact associated with the email send activity.
Address2	String	The second line address of the contact associated with the email send activity.
Title	String	The Title of the contact associated with the email send 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
ExportToken	String	The token returned from CreateExportDefinition. If Eloqua has not finished processing the request, the query will wait until the server has finished before returning data.
Depth	String	The depth of information requested from Eloqua.

Retrieve Email Subscribe Activities.

Table Specific Information

Select

If you are not using the Bulk API, ContactId is required to query Activity tables.

Additionally, the COUNT function is supported for this table in bulk mode.

Columns

Name	Type	Description
ID [KEY]	Long	The unique identifier of the email subscribe activity.
Name	String	The name of the email subscribe activity. Not supported in bulk mode.
CreatedAt	Datetime	The date and time the email subscribe activity was created.
Type	String	The activity type of the email subscribe activity.
AssetName	String	The name of the asset associated with the email subscribe activity.
AssetId	Long	The ID of the asset associated with the email subscribe activity.
AssetType	String	The type of the asset associated with the email subscribe activity.
CampaignName	String	The name of the campaign associated with the email subscribe activity. Not supported in bulk mode.
EmailCampaignId	String	The ID of the email campaign associated with the email subscribe activity. Not supported in bulk mode.
EmailAddress	String	The address of the email. Only supported in bulk mode.
EmailRecipientId	String	The ID of the recipient of the email.
CampaignId	Long	The ID of the campaign associated with the email subscribe activity. Only supported in bulk mode.
ExternalId	String	The ExternalId associated with the email subscribe activity. Only supported in bulk mode.
ContactId	Long	The ID of the contact associated with the bounceback activity.
FirstName	String	The FirstName of the contact associated with the email subscribe activity.
LastName	String	The LastName of the contact associated with the email subscribe activity.
Company	String	The Company of the contact associated with the email subscribe activity.
City	String	The City of the contact associated with the email subscribe activity.
ContactCreatedAt	Datetime	The date and time the contact associated with the email subscribe activity was created.
ContactModifiedAt	Datetime	The date and time the contact associated with the email subscribe activity was created.
Address1	String	The first line address of the contact associated with the email subscribe activity.
Address2	String	The second line address of the contact associated with the email subscribe activity.
Title	String	The Title of the contact associated with the email subscribe 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
ExportToken	String	The token returned from CreateExportDefinition. If Eloqua has not finished processing the request, the query will wait until the server has finished before returning data.
Depth	String	The depth of information requested from Eloqua.

Retrieve Email Unsubscribe Activities.

Table Specific Information

Select

If you are not using the Bulk API, ContactId is required to query Activity tables.

Additionally, the COUNT function is supported for this table in bulk mode.

Columns

Name	Type	Description
ID [KEY]	Long	The unique identifier of the email unsubscribe activity.
Name	String	The name of the email unsubscribe activity. Not supported in bulk mode.
CreatedAt	Datetime	The date and time the email unsubscribe activity was created.
Type	String	The type of email unsubscribe activity.
AssetName	String	The name of the asset associated with the email unsubscribe activity.
AssetId	Long	The ID of the asset associated with the email unsubscribe activity.
AssetType	String	The type of the asset associated with the email unsubscribe activity.
CampaignName	String	The name of the campaign associated with the email unsubscribe activity. Not supported in bulk mode.
EmailCampaignId	String	The ID of the email campaign associated with the email unsubscribe activity. Not supported in bulk mode.
EmailRecipientId	String	The ID of the recipient of the email.
EmailAddress	String	The address of the email. Only supported in bulk mode.
CampaignId	Long	The ID of the campaign associated with the email unsubscribe activity. Only supported in bulk mode.
ExternalId	String	The ExternalId associated with the email unsubscribe activity. Only supported in bulk mode.
ContactId	Long	The ID of the contact associated with the bounceback activity.
FirstName	String	The FirstName of the contact associated with the email unsubscribe activity.
LastName	String	The LastName of the contact associated with the email unsubscribe activity.
Company	String	The Company of the contact associated with the email unsubscribe activity.
City	String	The City of the contact associated with the email unsubscribe activity.
ContactCreatedAt	Datetime	The date and time the contact associated with the email unsubscribe activity was created.
ContactModifiedAt	Datetime	The date and time the contact associated with the email unsubscribe activity was created.
Address1	String	The first line address of the contact associated with the email unsubscribe activity.
Address2	String	The second line address of the contact associated with the email unsubscribe activity.
Title	String	The Title of the contact associated with the email unsubscribe 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
ExportToken	String	The token returned from CreateExportDefinition. If Eloqua has not finished processing the request, the query will wait until the server has finished before returning data.
Depth	String	The depth of information requested from Eloqua.

Retrieve Form Submit Activities.

Table Specific Information

Select

If you are not using the Bulk API, ContactId is required to query Activity tables.

Additionally, the COUNT function is supported for this table in bulk mode.

Columns

Name	Type	Description
ID [KEY]	Long	The unique identifier of the form submit activity.
Name	String	The name of the form submit activity. Not supported in bulk mode.
CreatedAt	Datetime	The date and time the form submit activity was created.
Type	String	The activity type of the form submit activity.
AssetName	String	The name of the asset associated with the form submit activity.
AssetId	Long	The ID of the asset associated with the form submit activity.
AssetType	String	The type of the asset associated with the form submit activity.
ContactId	Long	The ID of the contact who performed the form submit activity.
Collection	String	The collection of the form submit activity. Not supported in bulk mode.
FormName	String	The name of the form associated with the form submit activity. Not supported in bulk mode.
FormData	String	The data of the form associated with the form submit activity. Not supported in bulk mode.
RawData	String	The raw data of the form submit activity. Only supported in bulk mode.
CampaignId	Long	The ID of the campaign associated with the form submit activity. Only supported in bulk mode.
VisitorId	Long	The ID of the visitor associated with the form submit activity. Only supported in bulk mode.
VisitorExternalId	String	The ExternalId of the visitor associated with the form submit activity. Only supported in bulk mode.
ExternalId	String	The ExternalId associated with the form submit activity. Only supported in bulk mode.
FirstName	String	The FirstName of the contact associated with the form submit activity.
LastName	String	The LastName of the contact associated with the form submit activity.
Company	String	The Company of the contact associated with the form submit activity.
City	String	The City of the contact associated with the bounceback activity.
ContactCreatedAt	Datetime	The date and time the contact associated with the form submit activity was created.
ContactModifiedAt	Datetime	The date and time the contact associated with the form submit activity was created.
Address1	String	The first line address of the contact associated with the form submit activity.
Address2	String	The second line address of the contact associated with the form submit activity.
Title	String	The Title of the contact associated with the form submit 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
ExportToken	String	The token returned from CreateExportDefinition. If Eloqua has not finished processing the request, the query will wait until the server has finished before returning data.
Depth	String	The depth of information requested from Eloqua.

Retrieve Page View Activities. This table is only supported in bulk mode.

Table Specific Information

Select

COUNT is supported for this table.

Columns

Name	Type	Description
ID [KEY]	Long	The unique identifier of the page view activity.
CreatedAt	Datetime	The date and time the page view activityactivity was created.
Type	String	The type of the activity associated with the page view activity.
ContactId	Long	The ID of the contact who performed the page view activity.
IPAddress	String	The IP address of the sender.
Url	String	The URL of the page view activity.
CampaignId	Long	The ID of the campaign associated with the page view activity.
ReferrerUrl	String	The referrer URL of the page view activity.
VisitorId	Long	The visitor ID of the page view activity.
VisitorExternalId	String	The visitor external ID of the page view activity.
WebVisitId	Long	The Web visit ID of the page view activity.
IsWebTrackingOptedIn	Boolean	Whether the visitor who performed the page view activity has opted into Web tracking.
ExternalId	String	The ExternalId associated with the page activity. Only supported in bulk mode.
FirstName	String	The FirstName of the contact associated with the page view activity.
LastName	String	The LastName of the contact associated with the page view activity.
Company	String	The Company of the contact associated with the page view activity.
City	String	The City of the contact associated with the page view activity.
ContactCreatedAt	Datetime	The date and time the contact associated with the page view activity was created.
ContactModifiedAt	Datetime	The date and time the contact associated with the page view activity was created.
Address1	String	The first line address of the contact associated with the page view activity.
Address2	String	The second line address of the contact associated with the page view activity.
Title	String	The Title of the contact associated with the page view 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
ExportToken	String	The token returned from CreateExportDefinition. If Eloqua has not finished processing the request, the query will wait until the server has finished before returning data.
Depth	String	The depth of information requested from Eloqua.

Retrieve Web Visit Activities.

Table Specific Information

Select

If you are not using the Bulk API, ContactId is required to query Activity tables.

Additionally, the COUNT function is supported for this table in bulk mode.

Columns

Name	Type	Description
ID [KEY]	Long	The ID of the Web visit activity.
Name	String	The name of the Web visit activity. Not supported in bulk mode.
CreatedAt	Datetime	The date and time the Web visit activity was created.
Type	String	The type of Web visit activity.
AssetId	Long	The ID of the asset associated with the Web visit activity. Not supported in bulk mode.
AssetType	String	The type of the asset associated with the Web visit activity. Not supported in bulk mode.
ContactId	Long	The ID of the contact who performed the Web visit activity. Not supported in bulk mode.
Duration	String	The duration of the Web visit activity.
QueryString	String	The query string of the Web visit activity. Not supported in bulk mode.
QueryStringDisplay	String	The query string display of the Web visit activity. Not supported in bulk mode.
Thread	String	The thread of the Web visit activity. Not supported in bulk mode.
URL	String	The URL of the Web visit activity. Not supported in bulk mode.
ReferrerUrl	String	The Referrer URL of the Web visit activity. Only supported in bulk mode.
VisitorId	Long	The ID of the visitor associated with the Web visit activity. Only supported in bulk mode.
VisitorExternalId	String	The visitor external ID of the Web visit activity. Only supported in bulk mode.
ExternalId	String	The ExternalId associated with the Web visit activity. Only supported in bulk mode.
NumberOfPages	String	The number of pages of the Web visit activity. Only supported in bulk mode.
IpAddress	String	The IP address of the Web visit activity. Only supported in bulk mode.
FirstPageViewUrl	String	The first page view URL of the Web visit activity. Only supported in bulk mode.
FirstName	String	The FirstName of the contact associated with the Web visit activity.
LastName	String	The LastName of the contact associated with the Web visit activity.
Company	String	The Company of the contact associated with the Web visit activity.
City	String	The City of the contact associated with the Web visit activity.
ContactCreatedAt	Datetime	The date and time the contact associated with the Web visit activity was created.
ContactModifiedAt	Datetime	The date and time the contact associated with the Web visit activity was created.
Address1	String	The first line address of the contact associated with the Web visit activity.
Address2	String	The second line address of the contact associated with the Web visit activity.
Title	String	The Title of the contact associated with the Web visit 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
ExportToken	String	The token returned from CreateExportDefinition. If Eloqua has not finished processing the request, the query will wait until the server has finished before returning data.
Depth	String	The depth of information requested from Eloqua.

Retrieve Campaign Elements.

Columns

Name	Type	Description
ID [KEY]	Long	The unique identifier for the campaign element.
Name	String	The name of the campaign element.
Type	String	The type of the campaign element.
FolderId	Long	The folder ID of the campaign element.
FormId	String	The form ID of the campaign element.
EmailId	String	The email ID of the campaign element.
LandingPageId	String	The landing page ID of the campaign element.
SegmentId	String	The segment ID of the campaign element.
ListId	String	The list ID of the campaign element.
CampaignId	String	The campaign ID of the campaign element.
memberCount	Integer	The member count of the campaign element.

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.

Retrieve Campaign Fields.

Columns

Name	Type	Description
ID [KEY]	Long	The unique identifier for the campaign field.
Name	String	The name of the campaign field.
DataType	String	The data type of the campaign field.
Description	String	The description of the campaign field.
DisplayType	String	The display type of the campaign field.
DisplayIndex	String	The display index of the campaign field.
FolderId	Long	The folder ID of the campaign field.
IsReadOnly	Boolean	Identifies whether the campaign field is read-only.
IsRequired	Boolean	Identifies whether the campaign field is required.
CreatedAt	Datetime	Date the campaign field was created.
CreatedBy	String	The ID of the user who created the campaign field.
Depth	String	The depth of the campaign field.

Retrieve Campaign Folders.

Columns

Name	Type	Description
ID [KEY]	Long	The unique identifier for the folder.
Name	String	The name of the folder.
IsSystem	Boolean	Identifies a system-generated folder.
Description	String	The description of the folder.
Permissions	String	The permissions of the folder.
CreatedAt	Datetime	Date the folder was created.
CreatedBy	String	The ID of the user who created the folder.
AccessedAt	Datetime	Date the folder was accessed.
CurrentStatus	String	The current status of the folder.
UpdatedAt	Datetime	Date the folder was last updated.
UpdatedBy	String	The ID of the user who last updated the folder.

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.

Retrieve Contact Fields.

Table Specific Information

The EmailAddress column is required to insert into or to update the Contact table. For example,

UPDATE [Contact] SET emailAddress='example@test.com',firstName='test' WHERE ID = ?

Columns

Name	Type	Description
ID [KEY]	Long	The unique identifier for the contact field.
Name	String	The name of the contact field.
UpdateType	String	The update rule for when to update this field.
CheckedValue	String	The checked value of the contact field.
DataType	String	The data type of the contact field.
DefaultValue	String	The default value for the contact field.
Description	String	The description of the contact field.
DisplayType	String	The display type of the contact field.
FolderId	Long	The folder ID of the contact field.
InternalName	String	The country of the contact field.
IsReadOnly	Boolean	Identifies whether the contact field is read-only.
IsRequired	Boolean	Identifies whether the contact field is required.
IsStandard	Boolean	Identifies whether the contact field is standard.
OptionListId	Long	The ID of the option list for the contact field.
OutputFormatId	Long	The ID of the output format for the contact field.
ScheduledFor	String	The date and time scheduled for the contact field.
SourceTemplatedId	Long	The ID of the source template for the contact field
UncheckedValue	String	The unchecked value of the contact field.
Permissions	String	The permissions of the contact field.
CreatedAt	Datetime	Date the contact field was created.
CreatedBy	String	The ID of the user who created the contact field.
AccessedAt	Datetime	Date the contact field was accessed.
CurrentStatus	String	The current status of the contact field.
Depth	String	The depth of the contact field.
UpdatedAt	Datetime	Date the contact field was updated.
UpdatedBy	String	The ID of the user who last updated the contact field.

Retrieve Contact Filters.

Columns

Name	Type	Description
ID [KEY]	Long	The unique identifier for the contact filter.
Name	String	The name of the contact filter.
Type	String	The type of the contact filter.
FolderId	Long	The folder ID of the contact filter.
Description	String	The description of the contact filter.
ScheduledFor	String	The date and time scheduled for the contact filter.
Scope	String	The scope of the contact filter.
Statement	String	The statement of the contact filter.
Permissions	String	The permissions of the contact filter.
CreatedAt	Datetime	Date the contact filter was created.
CreatedBy	String	The ID of the user who created the contact filter.
AccessedAt	Datetime	Date the contact filter field was accessed.
CurrentStatus	String	The current status of the contact filter.
Depth	String	The depth of the contact filter.
UpdatedAt	Datetime	Date the contact filter was updated.
UpdatedBy	String	The ID of the user who last updated the contact filter.

Retrieve Contact Filter Folders.

Columns

Name	Type	Description
ID [KEY]	Long	The unique identifier for the folder.
Name	String	The name of the folder.
IsSystem	Boolean	Identifies a system-generated folder.
Description	String	The description of the folder.
Permissions	String	The permissions of the folder.
CreatedAt	Datetime	Date the folder was created.
CreatedBy	String	The ID of the user who created the folder.
AccessedAt	Datetime	Date the folder was accessed.
CurrentStatus	String	The current status of the folder.
UpdatedAt	Datetime	Date the folder was last updated.
UpdatedBy	String	The ID of the user who last updated the folder.

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.

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 throw 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.

Retrieve Contact List Folders.

Columns

Name	Type	Description
ID [KEY]	Long	The unique identifier for the folder.
Name	String	The name of the folder.
IsSystem	Boolean	Identifies a system-generated folder.
Description	String	The description of the folder.
Permissions	String	The permissions of the folder.
CreatedAt	Datetime	Date the folder was created.
CreatedBy	String	The ID of the user who created the folder.
AccessedAt	Datetime	Date the folder was accessed.
CurrentStatus	String	The current status of the folder.
UpdatedAt	Datetime	Date the folder was last updated.
UpdatedBy	String	The ID of the user who last updated the folder.

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.

Retrieve Contact Scoring Model Folders.

Columns

Name	Type	Description
ID [KEY]	Long	The unique identifier for the folder.
Name	String	The name of the folder.
IsSystem	Boolean	Identifies a system-generated folder.
Description	String	The description of the folder.
Permissions	String	The permissions of the folder.
CreatedAt	Datetime	Date the folder was created.
CreatedBy	String	The ID of the user who created the folder.
AccessedAt	Datetime	Date the folder was accessed.
CurrentStatus	String	The current status of the folder.
UpdatedAt	Datetime	Date the folder was last updated.
UpdatedBy	String	The ID of the user who last updated the folder.

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.

Retrieve Contact Segment Data. Note: The pseudo column SegmentID must be specified to retrieve the data of this table. This SegmentID can be retrieved from the ContactSegment table's ID column.

Columns

Name	Type	Description
ID [KEY]	Int64	The unique identifier of the content segment data.
AccountName	String	This field is generated dynamically and corresponds to the AccountName field in the API.
BouncebackDate	String	This field is generated dynamically and corresponds to the BouncebackDate field in the API.
IsBounceback	Boolean	This field is generated dynamically and corresponds to the IsBounceback field in the API.
IsSubscribed	Boolean	This field is generated dynamically and corresponds to the IsSubscribed field in the API.
SubscriptionDate	Datetime	This field is generated dynamically and corresponds to the SubscriptionDate field in the API.
UnsubscriptionDate	Datetime	This field is generated dynamically and corresponds to the UnsubscriptionDate field in the API.
CreatedAt	Datetime	This field is generated dynamically and corresponds to the CreatedAt field in the API.
CreatedBy	String	This field is generated dynamically and corresponds to the CreatedBy field in the API.
AccessedAt	Datetime	This field is generated dynamically and corresponds to the AccessedAt field in the API.
CurrentStatus	String	This field is generated dynamically and corresponds to the CurrentStatus field in the API.
Depth	String	This field is generated dynamically and corresponds to the Depth field in the API.
UpdatedAt	Datetime	This field is generated dynamically and corresponds to the UpdatedAt field in the API.
UpdatedBy	String	This field is generated dynamically and corresponds to the UpdatedBy field in the API.
Email Address	String	This field is generated dynamically and corresponds to the Email Address field in the API.
First Name	String	This field is generated dynamically and corresponds to the First Name field in the API.
Last Name	String	This field is generated dynamically and corresponds to the Last Name field in the API.
Company	String	This field is generated dynamically and corresponds to the Company field in the API.
Email Display Name	String	This field is generated dynamically and corresponds to the Email Display Name field in the API.
Address 1	String	This field is generated dynamically and corresponds to the Address 1 field in the API.
Address 2	String	This field is generated dynamically and corresponds to the Address 2 field in the API.
Address 3	String	This field is generated dynamically and corresponds to the Address 3 field in the API.
City	String	This field is generated dynamically and corresponds to the City field in the API.
State or Province	String	This field is generated dynamically and corresponds to the State or Province field in the API.
Zip or Postal Code	String	This field is generated dynamically and corresponds to the Zip or Postal Code field in the API.
Country	String	This field is generated dynamically and corresponds to the Country field in the API.
Business Phone	String	This field is generated dynamically and corresponds to the Business Phone field in the API.
Mobile Phone	String	This field is generated dynamically and corresponds to the Mobile Phone field in the API.
Fax	String	This field is generated dynamically and corresponds to the Fax field in the API.
Title	String	This field is generated dynamically and corresponds to the Title field in the API.
Salutation	String	This field is generated dynamically and corresponds to the Salutation field in the API.
Salesperson	String	This field is generated dynamically and corresponds to the Salesperson field in the API.
SFDC Contact ID	String	This field is generated dynamically and corresponds to the SFDC Contact ID field in the API.
SFDC Lead ID	String	This field is generated dynamically and corresponds to the SFDC Lead ID field in the API.
Date Created	Datetime	This field is generated dynamically and corresponds to the Date Created field in the API.
Date Modified	Datetime	This field is generated dynamically and corresponds to the Date Modified field in the API.
Eloqua Contact ID	String	This field is generated dynamically and corresponds to the Eloqua Contact ID field in the API.
SFDC Account ID	String	This field is generated dynamically and corresponds to the SFDC Account ID field in the API.
Last Modified by CRM System	Datetime	This field is generated dynamically and corresponds to the Last Modified by CRM System field in the API.
Last SFDC Campaign ID	String	This field is generated dynamically and corresponds to the Last SFDC Campaign ID field in the API.
Last SFDC Campaign Status	String	This field is generated dynamically and corresponds to the Last SFDC Campaign Status field in the API.
Company Revenue	String	This field is generated dynamically and corresponds to the Company Revenue field in the API.
SFDC Email Opt Out	String	This field is generated dynamically and corresponds to the SFDC Email Opt Out field in the API.
Lead Source - Most Recent	String	This field is generated dynamically and corresponds to the Lead Source - Most Recent field in the API.
Lead Source - Original	String	This field is generated dynamically and corresponds to the Lead Source - Original field in the API.
Industry	String	This field is generated dynamically and corresponds to the Industry field in the API.
Annual Revenue	String	This field is generated dynamically and corresponds to the Annual Revenue field in the API.
Lead Status	String	This field is generated dynamically and corresponds to the Lead Status field in the API.
Job Role	String	This field is generated dynamically and corresponds to the Job Role field in the API.
Lead Score - High Value Website Content	Double	This field is generated dynamically and corresponds to the Lead Score - High Value Website Content field in the API.
Lead Score Date - Engagement - Most Recent	Datetime	This field is generated dynamically and corresponds to the Lead Score Date - Engagement - Most Recent field in the API.
Integrated Marketing and Sales Funnel Stage	String	This field is generated dynamically and corresponds to the Integrated Marketing and Sales Funnel Stage field in the API.
Product/Solution of Interest	String	This field is generated dynamically and corresponds to the Product/Solution of Interest field in the API.
Region	String	This field is generated dynamically and corresponds to the Region field in the API.
PURL Name (Default Hypersite)	String	This field is generated dynamically and corresponds to the PURL Name (Default Hypersite) field in the API.
Lead Rating - Combined	String	This field is generated dynamically and corresponds to the Lead Rating - Combined field in the API.
Email Address Domain	String	This field is generated dynamically and corresponds to the Email Address Domain field in the API.
First and Last Name	String	This field is generated dynamically and corresponds to the First and Last Name field in the API.
Company Size	String	This field is generated dynamically and corresponds to the Company Size field in the API.
Lead Score - Last High Touch Event Date	Datetime	This field is generated dynamically and corresponds to the Lead Score - Last High Touch Event Date field in the API.
Lead Rating - Profile (Explicit)	String	This field is generated dynamically and corresponds to the Lead Rating - Profile (Explicit) field in the API.
Lead Rating - Engagement (Implicit)	String	This field is generated dynamically and corresponds to the Lead Rating - Engagement (Implicit) field in the API.
Lead Score - Profile (Explicit)	Double	This field is generated dynamically and corresponds to the Lead Score - Profile (Explicit) field in the API.
Lead Score - Engagement (Implicit)	Double	This field is generated dynamically and corresponds to the Lead Score - Engagement (Implicit) field in the API.
Lead Score Date - Profile - Most Recent	Datetime	This field is generated dynamically and corresponds to the Lead Score Date - Profile - Most Recent field in the API.
Employees	Double	This field is generated dynamically and corresponds to the Employees field in the API.
Territory	String	This field is generated dynamically and corresponds to the Territory field in the API.
Lead Score	String	This field is generated dynamically and corresponds to the Lead Score field in the API.
PURL Name	String	This field is generated dynamically and corresponds to the PURL Name field in the API.
MD5 Hashed Email Address	String	This field is generated dynamically and corresponds to the MD5 Hashed Email Address field in the API.
SHA256 Hashed Email Address	String	This field is generated dynamically and corresponds to the SHA256 Hashed Email Address field in the API.
MD5 Hashed Business Phone	String	This field is generated dynamically and corresponds to the MD5 Hashed Business Phone field in the API.
SHA256 Hashed Business Phone	String	This field is generated dynamically and corresponds to the SHA256 Hashed Business Phone field in the API.
MD5 Hashed Mobile Phone	String	This field is generated dynamically and corresponds to the MD5 Hashed Mobile Phone field in the API.
SHA256 Hashed Mobile Phone	String	This field is generated dynamically and corresponds to the SHA256 Hashed Mobile Phone field in the API.
onlineInsertTest	String	This field is generated dynamically and corresponds to the onlineInsertTest field in the API.
Survey Initial Meeting Date & Time	Datetime	This field is generated dynamically and corresponds to the Survey Initial Meeting Date & Time field in the API.
TestColumn1	String	This field is generated dynamically and corresponds to the TestColumn1 field in the API.
TestColumn2	String	This field is generated dynamically and corresponds to the TestColumn2 field in the API.
TestColumn3	String	This field is generated dynamically and corresponds to the TestColumn3 field in the API.
TestColumn4	String	This field is generated dynamically and corresponds to the TestColumn4 field in the API.
TestColumn5	String	This field is generated dynamically and corresponds to the TestColumn5 field in the API.