Oracle Eloqua Data Model

Connection String Options

  1. Auto Cache
  2. Bulk Polling Interval
  3. Bulk Query Timeout
  4. Cache Connection
  5. Cache Driver
  6. Cache Location
  7. Cache Metadata
  8. Company
  9. Connect On Open
  10. Data Retention Duration
  11. Firewall Password
  12. Firewall Port
  13. Firewall Server
  14. Firewall Type
  15. Firewall User
  16. Location
  17. Logfile
  18. Max Log File Size
  19. OAuth Access Token
  20. OAuth Client Id
  21. OAuth Client Secret
  22. OAuth Refresh Token
  23. Offline
  24. Other
  25. Pagesize
  26. Password
  27. Proxy Auth Scheme
  28. Proxy Auto Detect
  29. Proxy Password
  30. Proxy Port
  31. Proxy Server
  32. Proxy SSL Type
  33. Proxy User
  34. Pseudo Columns
  35. Query Cache
  36. Readonly
  37. Retry Count
  38. Retry Interval
  39. RTK
  40. SSL Server Cert
  41. Support Enhanced SQL
  42. Tables
  43. Timeout
  44. Use Bulk API
  45. User
  46. Use Simple Names
  47. Verbosity

Auto Cache

Data Type

bool

Default Value

false

Remarks

When AutoCache is set, the driver automatically caches the results of SELECT queries to a cache specified by the CacheLocation option. CacheLocation defines the path to a simple, file-based cache.

AutoCache is the simplest caching configuration available, however, like any caching scheme, using a cache is not without pitfalls such as reporting on stale data. The driver is designed to be fully functional without relying on caching.

The following sections outline how and when to use AutoCache. Understanding how AutoCache works and its limitations will help you choose an effective caching strategy. For more information on deploying other caching strategies, see Caching Data.

How AutoCaching Works

 

When you execute a SELECT statement with AutoCache set, the driver executes the query to the remote data and persists the results; rows and columns that already exist are overwritten. That is, SELECT statements are used to create and refresh the cache, not to query it.

Non-queries (such as UPDATE/INSERT/DELETE statements) are executed to the remote data as well; these statements will not modify the data in the cache at all, regardless of the value set for AutoCache.

To work with the local data, append #CACHE to the table name. For example:

SELECT * FROM [Contact#CACHE]
Limitations of AutoCache

 

In the following scenarios, consider the alternatives listed below:

  • When you need to work with the cache transparently: Because AutoCache requires a special syntax to utilize the cache, it is not suitable for use with BI, analytics, and reporting. Many of these tools generate SQL statements for you; these generated statements will still be executed to Eloqua instead of the cache.

    In these situations, one solution is to use the Offline property. When this is set, all queries are executed locally. See Caching: Best Practices for examples.

    One downside of this approach is that it requires a separate connection. As an alternative, consider using the CData Sync tool to maintain a local database that is kept fresh with scheduled updates.

     

  • When you need more control over cached data: The AutoCache feature does not have the ability to remove rows from the cache that were deleted from the remote data. It also does not support dropping a table from the cache or more advanced cache maintenance such as changing the cached table schemas.

    In this scenario, consider REPLICATE Statements and CACHE Statements. REPLICATE statements leverage incremental update support in the Eloqua API. With incremental updates, only the changeset needs to be retrieved from Eloqua, so the driver is able to merge any changes into the cache much more quickly. For more granular control, use CACHE statements.

    CACHE statements can remove cached rows that no longer exist in Eloqua.

    See Caching Explicitly for more information on how to use CACHE statements.

  • When you need to work with an RDBMS: AutoCache can only be used with the default database, JavaDB or SQLite. Many enterprises will need to use an RDBMS to support more concurrent writes or integrate with existing infrastructure. You can specify a database driver with CacheConnection and CacheDriver.

 

 

Bulk Polling Interval

Data Type

string

Default Value

"200"

Remarks

The time interval between requests that check the availability of the bulk query response. When UseBulkAPI is set, the driver requests Eloqua to prepare a response to the query. It then waits for the response to be ready by periodically polling the server to check status. This property controls the frequency of polling.

 

Bulk Query Timeout

Data Type

string

Default Value

"25"

Remarks

The timeout in minutes for which the driver will wait for a bulk query response. The default value is 25 minutes. When UseBulkAPI is set, the driver requests Eloqua to prepare a response to the query. It then waits for the response to be ready by periodically polling the server to check status. This property controls the total time the driver will wait for a response.

Note that this property is very different from Timeout. The Timeout is an inactivity timeout that controls the time to wait for any response. This property controls the total length of time to wait for a bulk query to execute. ;

 

Cache Connection

Data Type

string

Default Value

""

Remarks

The cache database is determined based on the CacheDriver and CacheConnection properties. The CacheConnection defines the connection properties necessary to connect to the cache database.

Cache Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver;Cache Connection='jdbc:sqlserver://localhost:7437;user=sa;password=123456;databaseName=Cache'

 

 

 

Cache Driver

Data Type

string

Default Value

""

Remarks

You can cache to any database that you have a JDBC driver for. The driver has been tested with SQL Server, Derby and Java DB, MySQL, Oracle, and SQLite.

The cache database is determined based on CacheDriver and the CacheConnection properties. The CacheDriver is the name of the JDBC driver class that you would like to use to cache data. The example below caches to SQL Server:

Cache Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver;Cache Connection='jdbc:sqlserver://localhost:7437;user=sa;password=123456;databaseName=Cache'
Note that the driver JAR must be specified on the classpath.

 

 

Cache Location

Data Type

string

Default Value

""

Remarks

If AutoCache is set but the cache location is not specified, CacheLocation defaults to the cache folder on the directory specified by the Location setting.

The CacheLocation is a simple, file-based cache. See the CacheConnection and CacheDriver properties to cache to other databases.

 

Cache Metadata

Data Type

bool

Default Value

false

Remarks

The cache.db file will be created in the location specified by the CacheConnection or if that is not set, the CacheLocation.

 

Company

Data Type

string

Default Value

""

Remarks

This field is used to provide authentication for the user to the Eloqua servers.

 

Connect On Open

Data Type

bool

Default Value

true

Remarks

When set to 'true', a connection will be made to Eloqua when the connection is opened. This property enables the 'Test Connection' feature available in various database tools.

This feature acts as a NOOP command as it is used to verify a connection can be made to Eloqua and nothing from this initial connection is maintained.

Setting this property to 'false' may provide performance improvements (depending upon the number of times a connection is opened).

 

Data Retention Duration

Data Type

string

Default Value

"24"

Remarks

The length of time (in hours) that bulk data is stored on the server. Valid values are from 1 hour to 2 weeks. The default value is 24 hours.

 

Firewall Password

Data Type

string

Default Value

""

Remarks

If FirewallServer is specified, the FirewallUser and FirewallPassword properties are used to connect and authenticate to the given firewall.

 

Firewall Port

Data Type

string

Default Value

""

Remarks

Note that the driver sets the FirewallPort to the default port associated with the specified FirewallType. See the description of the FirewallType option for details.

 

Firewall Server

Data Type

string

Default Value

""

Remarks

If this property is set to a domain name, a DNS request is initiated and the name is translated to the corresponding IP address.

 

Firewall Type

Data Type

string

Default Value

"NONE"

Remarks

The applicable values are:

 

   
Firewall Type Default FirewallPort
TUNNEL 80
SOCKS4 1080
SOCKS5 1080

 

 

Firewall User

Data Type

string

Default Value

""

Remarks

If the FirewallServer is specified, the FirewallUser and FirewallPassword properties are used to connect and authenticate against the firewall.

 

Location

Data Type

string

Default Value

""

Remarks

The path to a directory which contains the schema files for the driver (.rsd files for tables and views, .rsb files for stored procedures). The Location property is only needed if you would like to customize definitions (e.g., change a column name, ignore a column, etc.) or extend the data model with new tables, views, or stored procedures.

The schema files used in your application must be deployed with other assemblies. You must also ensure that Location points to the folder that contains the schema files. The folder location can be a relative path from the location of the executable.

 

Logfile

Data Type

string

Default Value

""

Remarks

For more control over what is written to the log file, take a look at Verbosity.

 

Max Log File Size

Data Type

string

Default Value

""

Remarks

A string specifying the maximum size in bytes for a log file (ex: 10MB). When the limit is hit, a new log is created in the same folder with the date and time appended to the end. There is no limit by default. Values lower than 100kB will use 100kB as the value instead.

 

OAuth Access Token

Data Type

string

Default Value

""

Remarks

The OAuthAccessToken property is used to connect using OAuth. The OAuthAccessToken is retrieved from the OAuth server as part of the authentication process. It has a server-dependent timeout and can be reused between requests.

The access token is used in place of your username and password. The access token protects your credentials by keeping them on the server.

 

OAuth Client Id

Data Type

string

Default Value

""

Remarks

OAuth requires you to register your application. As part of the registration, you will receive a client Id, sometimes also called a consumer key, and a client secret. You must specify both the OAuthClientId and OAuthClientSecret to connect to an OAuth server.

 

OAuth Client Secret

Data Type

string

Default Value

""

Remarks

OAuth requires you to register your application. As part of the registration you will receive a client Id and a client secret, sometimes also called a consumer secret. You must specify both the OAuthClientId and OAuthClientSecret to connect to an OAuth server.

 

OAuth Refresh Token

Data Type

string

Default Value

""

Remarks

The OAuthRefreshToken property is used to refresh the OAuthAccessToken when using OAuth authentication.

 

Offline

Data Type

bool

Default Value

false

Remarks

When Offline is set to TRUE, all queries execute against the cache as opposed to the live data source. In this mode, certain queries like INSERT, UPDATE, DELETE, and CACHE are not allowed.

 

Other

Data Type

string

Default Value

""

Remarks

The Other property is a semicolon-separated list of name-value pairs used in connection parameters specific to a data source.

Caching Configuration

 

   
CachePartial=True Caches only a subset of columns, which you can specify in your query.
QueryPassthrough=True Passes the specified query to the cache database instead of using the SQL parser of the driver.

 

Integration and Formatting

 

   
SupportAccessLinkedMode In Access' linked mode, it is generally a good idea to always use a cache as most data sources do not support multiple Id queries. However if you want to use the driver in Access but not in linked mode, this property must be set to False to avoid using a cache of a SELECT * query for the given table.
ConvertDateTimesToGMT Whether to convert date-time values to GMT, instead of the local time of the machine.
RecordToFile=filename Records the underlying socket data transfer to the specified file.
ClientCulture This property can be used to specify the format of data (e.g., currency values) that is accepted by the client application. This property can be used when the client application does not support the machine's culture settings. For example, Microsoft Access requires 'en-US'.
Culture This setting can be used to specify culture settings that determine how the driver interprets certain data types that are passed into the driver. For example, setting Culture='de-DE' will output German formats even on an American machine.

 

 

Pagesize

Data Type

string

Default Value

"500"

Remarks

The Pagesize property affects the maximum number of results to return per page from Eloqua when executing a query. A higher value will return more results per page, but may also cause a timeout exception. The maximum page size supported by Eloqua is 1000.

 

Password

Data Type

string

Default Value

""

Remarks

This field is used to authenticate against the Eloqua servers.

 

 

Proxy Auth Scheme

Data Type

string

Default Value

"BASIC"

Remarks

This value may be BASIC, DIGEST, NONE, NTLM, NEGOTIATE or PROPRIETARY.

 

Proxy Auto Detect

Data Type

bool

Default Value

true

Remarks

This indicates whether to use the default system proxy settings or not. Set ProxyAutoDetect to FALSE to use custom proxy settings. This takes precedence over other proxy settings.

 

Proxy Password

Data Type

string

Default Value

""

Remarks

If the ProxyServer is specified, the ProxyUser and ProxyPassword properties are used to connect and authenticate against the firewall.

 

Proxy Port

Data Type

string

Default Value

"80"

Remarks

See the description of the ProxyServer field for details.

 

Proxy Server

Data Type

string

Default Value

""

Remarks

If this property is set to a domain name, a DNS request is initiated and the name is translated to the corresponding address.

 

Proxy SSL Type

Data Type

string

Default Value

"AUTO"

Remarks

This value may be AUTO, ALWAYS, NEVER, or TUNNEL.

 

Proxy User

Data Type

string

Default Value

""

Remarks

If a ProxyServer is specified, the ProxyUser and ProxyPassword options are used to connect and authenticate against the firewall.

 

Pseudo Columns

Data Type

string

Default Value

""

Remarks

This setting is particularly helpful in Entity Framework, which does not allow you to set a value for a pseudo column unless it is a table column. The value of this connection setting is of the format "Table1=Column1, Table1=Column2, Table2=Column3". You can use the "*" character to include all tables and all columns; i.e., "*=*".

 

Query Cache

Data Type

string

Default Value

""

Remarks

The QueryCache allows you to cache the results of a query in-memory and use them until the cache expires. Setting the QueryCache can improve performance if the same or similar (see below) queries are executed often. The in-memory query cache is shared across connections, so it can help with performance even if more than one connection is being used.

The cache manager for QueryCache will not only use the results in the cache for exactly the same query, but also for queries that represent a subset of data in the cached query. For example, in the following queries, the cache created while executing Query A will be used to obtain the results for both Query B and Query C.

SELECT * from Account; // Query A
SELECT * from Account WHERE Name LIKE '%John'; // Query B
SELECT Id, Name from from Account LIMIT 10; // Query C

 

Setting the QueryCache to zero disables in-memory caching.

 

Readonly

Data Type

bool

Default Value

false

Remarks

If this property is set to true, the driver will allow only SELECT queries. INSERT, UPDATE, DELETE, and stored procedure queries will cause an error to be thrown.

 

Retry Count

Data Type

string

Default Value

"5"

Remarks

When UseBulkAPI is set to "Auto" or "True", the driver will attempt to retry any requests that fail due to an HTTP 500 status code (Internal Server Error). This property defintes maximum number of time the driver will retry a Bulk API request that failed. By default the driver will retry the request 5 times.

 

Retry Interval

Data Type

string

Default Value

"200"

Remarks

When UseBulkAPI is set to "Auto" or "True", the driver will attempt to retry any requests that fail due to an HTTP 500 status code (Internal Server Error). This property defines the time interval between attempts to retry a Bulk API request that failed. The default value is 200 ms.

 

RTK

Data Type

string

Default Value

""

Remarks

The RTK property may be used to license a build. Please see the included licensing file to see how to set this property. The runtime key is only available if you purchased an OEM license.

 

SSL Server Cert

Data Type

string

Default Value

""

Remarks

If using a TLS/SSL connection, this property can be used to specify the TLS/SSL certificate to be accepted from the server. Any other certificate that is not trusted by the machine will be rejected. This can take the form of a full PEM certificate, the path to a file containing the certificate, the public key, the MD5 thumbprint, or the SHA1 thumbprint. If not specified, any trusted certificate will be accepted. Use '*' to signify to accept all certificates (not recommended for security concerns).

 

Support Enhanced SQL

Data Type

bool

Default Value

true

Remarks

Use QueryCache to cache in memory for a given time in seconds or to disable in-memory caching.

 

Tables

Data Type

string

Default Value

""

Remarks

Listing the tables from some databases can be expensive. Providing a list of tables in the connection string improves the performance of the driver.

 

Timeout

Data Type

string

Default Value

"60"

Remarks

If the Timeout property is set to 0, operations do not time out: They run until they complete successfully or encounter an error condition.

If Timeout expires and the operation is not yet complete, the driver throws an exception.

 

Use Bulk API

Data Type

string

Default Value

"Auto"

Remarks

Whether or not bulk API is used for retrieving data. When UseBulkAPI is set to "True", the driver will always attempt to use the Bulk API, including the restrictions to accessible tables and columns. When set to "False", the driver will use the REST API for all requests. When set to "Auto", the driver will use whichever API is most appropriate for the request. For example:

SELECT * FROM Activity_EmailOpen
will use the Bulk API (because the ContactId is not specified), whereas:
SELECT * FROM Activity_EmailOpen ContactId='...'
will use the REST API.

 

Using the Bulk API starts with the driver sending a request to Eloqua to prepare a response to the query. It then waits for the response to be ready by periodically polling the server to check status. BulkPollingInterval and BulkQueryTimeout control the frequency and duration of polling respectively.

 

User

Data Type

string

Default Value

""

Remarks

This field is used to provide authentication for the user to the Eloqua servers.

 

 

Use Simple Names

Data Type

bool

Default Value

false

Remarks

Boolean determining if simple names should be used for tables and columns. Eloqua objects can have special characters in names that are normally not allowed in standard databases. UseSimpleNames makes the driver easier to use with traditional database tools.

Setting UseSimpleNames to true will simplify the names of tables and columns returned making them easier to work with. If set to false, the tables and columns will appear as they do in Eloqua.

 

Verbosity

Data Type

string

Default Value

"1"

Remarks

The verbosity level determines the amount of detail that the driver reports to the Logfile. Verbosity levels from 1 to 5 are supported. These are described below:

 

   
1 Setting Verbosity to 1 will log the query, the number of rows returned by it, the start of execution and the time taken, and any errors.
2 Setting Verbosity to 2 will log everything included in Verbosity 1, cache queries, and HTTP headers.
3 Setting Verbosity to 3 will additionally log the body of the HTTP requests.
4 Setting Verbosity to 4 will additionally log transport-level communication with the data source. This includes SSL negotiation.
5 Setting Verbosity to 5 will additionally log communication with the data source and additional details that may be helpful in troubleshooting problems. This includes interface commands.

The Verbosity should not be set to greater than 1 for normal operation. Substantial amounts of data can be logged at higher verbosities, which can delay execution times.




 

Tables

  1. Account
  2. Campaign
  3. Contact
  4. ContactSegment
  5. ContentSection
  6. Email
  7. EmailFooter
  8. EmailGroup
  9. EmailHeader
  10. ExternalActivity
  11. ExternalAsset
  12. Folder
  13. Form
  14. Hyperlink
  15. LandingPage
  16. Microsite
  17. OptionList

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.

 

 

 

Campaign

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.

 

 

 

Contact

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 Datetime True

The Date Created of the contact.

Date Modified Datetime 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 Datetime 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 Datetime 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 Datetime 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 Datetime 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.

 

 

 

ContactSegment

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
rows@next String

This is used to page through multiple pages of results and should not be set manually.

Depth String

The depth of information requested from Eloqua.

 

 

 

ContentSection

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
rows@next String

This is used to page through multiple pages of results and should not be set manually.

Depth String

The depth of information requested from Eloqua.

 

 

 

Email

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.

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 String False

The raw HTML 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.

 

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
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

EmailFooter

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.

 

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
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

EmailGroup

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.

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.

 

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
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

EmailHeader

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.

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.

 

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
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

ExternalActivity

Create and query External Activities.

 

Columns

 

 

 

   
Name Type ReadOnly Description
ID [KEY] Long True

The unique identifier 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.

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.

 

 

 

ExternalAsset

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.

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.

 

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
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

Folder

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.

Permissions String False

The permissions of the folder.

CreatedAt Datetime True

Date the folder was created.

CreatedBy String True

The Id of the user who created the folder.

AccessedAt Datetime False

Date the folder was accessed.

CurrentStatus String False

The current status of the folder.

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
rows@next String

This is used to page through multiple pages of results and should not be set manually.

Depth String

The depth of information requested from Eloqua.

 

 

 

Form

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.

Description String False

The description of the form.

FolderId Long False

The Id of the folder for the form.

ScheduledFor Datetime False

The date and time scheduled 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.

AccessedAt Datetime False

Date the form was accessed.

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.

EmailAddressFormFieldId Long False

The email address form field Id of 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
rows@next String

This is used to page through multiple pages of results and should not be set manually.

Depth String

The depth of information requested from Eloqua.

 

 

 

Hyperlink

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.

Description String False

The description of the 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
rows@next String

This is used to page through multiple pages of results and should not be set manually.

Depth String

The depth of information requested from Eloqua.

 

 

 

LandingPage

Create, update, delete, and query Landing Pages.

 

Table Specific Information

 

 

Select

 

The following limitation exists for filtering on datetime columns: The "=" operator cannot be used with datetime columns in the WHERE clause. However, the "<", ">", ">=", and "<=" operators can be used to filter on datetime columns.

Additionally, the UpdatedAt column only supports filtering with the '>' operator.

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.

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

 

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
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

Microsite

Create, update, delete, and query Microsites.

 

Table Specific Information

 

 

Select

 

The following limitation exists for filtering on datetime columns: The "=" operator cannot be used with datetime columns in the WHERE clause. However, the "<", ">", ">=", and "<=" operators can be used to filter on datetime columns.

Additionally, the UpdatedAt column only supports filtering with the '>' operator.

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.

 

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
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

OptionList

Create, update, delete, and query Option Lists.

 

Table Specific Information

 

 

Select

 

The following limitation exists for filtering on datetime columns: The "=" operator cannot be used with datetime columns in the WHERE clause. However, the "<", ">", ">=", and "<=" operators can be used to filter on datetime columns.

Additionally, the UpdatedAt column only supports filtering with the '>' operator.

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.

 

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
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 




 

Views

  1. AccountField
  2. AccountView
  3. Activity_Bounceback
  4. Activity_CampaignMembership
  5. Activity_EmailClickThrough
  6. Activity_EmailOpen
  7. Activity_EmailSend
  8. Activity_EmailSubscribe
  9. Activity_EmailUnsubscribe
  10. Activity_FormSubmit
  11. Activity_PageView
  12. Activity_WebVisit
  13. CampaignElement
  14. CampaignField
  15. CampaignFolder
  16. ContactField
  17. ContactFilter
  18. ContactFilterFolder
  19. ContactList
  20. ContactListFolder
  21. ContactScoringModelFolder
  22. ContactSegmentFolder
  23. ContactView
  24. ContentSectionFolder
  25. Dependencies
  26. DynamicContent
  27. DynamicContentFolder
  28. EmailDeployment
  29. EmailFolder
  30. EmailFooterFolder
  31. EmailHeaderFolder
  32. ExternalType
  33. FieldMerge
  34. FieldMergeFolder
  35. FormElement
  36. FormFolder
  37. FormProcessingStep
  38. HyperlinkFolder
  39. Image
  40. ImageFolder
  41. ImportedFile
  42. ImportedFileFolder
  43. LandingPageFolder
  44. PageTag
  45. PageTagGroup
  46. Program
  47. Style
  48. Template
  49. TemplateCategory
  50. TrackedUrl
  51. User
  52. Visitor

AccountField

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.
Description String The description 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.

 

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
rows@next String This is used to page through multiple pages of results and should not be set manually.

 

 

 

AccountView

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
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

Activity_Bounceback

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.

 

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.
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

Activity_CampaignMembership

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.
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

Activity_EmailClickThrough

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.

 

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.
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

Activity_EmailOpen

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.

 

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.
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

Activity_EmailSend

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
ID [KEY] Long The unique identifier of the email send activity.
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.
ExternalId String The ExternalId associated with the email send activity. Only supported in bulk mode.

 

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.
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

Activity_EmailSubscribe

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.
ContactId Long The Id of the contact who performed the email subscribe activity. Not supported in bulk mode.
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.

 

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.
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

Activity_EmailUnsubscribe

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.
ContactId Long The Id of the contact who performed the email unsubscribe activity. Not supported in bulk mode.
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.

 

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.
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

Activity_FormSubmit

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.

 

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.
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

Activity_PageView

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.

 

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.
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

Activity_WebVisit

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.

 

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.
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

CampaignElement

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
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

CampaignField

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.

 

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
rows@next String This is used to page through multiple pages of results and should not be set manually.

 

 

 

CampaignFolder

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
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

ContactField

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.

 

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
rows@next String This is used to page through multiple pages of results and should not be set manually.

 

 

 

ContactFilter

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.

 

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
rows@next String This is used to page through multiple pages of results and should not be set manually.

 

 

 

ContactFilterFolder

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
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

ContactList

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.

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 A list of contact Ids to be added to the contact list.
Scope String A list of contact Ids to be removed from the contact list.
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.

 

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
rows@next String This is used to page through multiple pages of results and should not be set manually.

 

 

 

ContactListFolder

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
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

ContactScoringModelFolder

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
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

ContactSegmentFolder

Retrieve Contact Segment 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
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

ContactView

Retrieve Contact Views.

 

Columns

 

 

 

   
Name Type Description
ID [KEY] Long The unique identifier for the contact view.
Name String The name of the contact view.
Description String The description of the contact view.
Permissions String The permissions of the contact view.
CreatedAt Datetime Date the contact view was created.
CreatedBy String The Id of the user who created the contact view.
AccessedAt Datetime Date the contact view was accessed.
UpdatedAt Datetime Date the contact view was updated.
UpdatedBy String The Id of the user who last updated the contact 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
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

ContentSectionFolder

Retrieve Content Section 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
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

Dependencies

Retrieve Dependencies.

 

Columns

 

 

 

   
Name Type Description
ID [KEY] Long TBD.
Name String TBD.
Permissions String The permissions of the contact list.
Depth String The depth of the field.
Type String The type of the field.

 

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
rows@next String This is used to page through multiple pages of results and should not be set manually.
ObjectName String TDB
ObjectId String TBD

 

 

 

DynamicContent

Retrieve Dynamic Contents.

 

Columns

 

 

 

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

 

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
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

DynamicContentFolder

Retrieve Dynamic Content 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
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

EmailDeployment

Retrieve email deployments.

 

Columns

 

 

 

   
Name Type Description
ID [KEY] Long The unique identifier for the email deployment.
Name String The name of the email deployment.
CurrentStatus String The current status of the email deployment.
SuccessfulSendCount Int The successful send count of the email deployment.
FailedSendCount Int The failed send count of the email deployment.
ContactId String The contact ID of the email deployment.
SendFromUserId String The sent user ID of the email deployment.
EndAt Datetime Date the email deployment ended.
Permissions String The permissions of the email deployment.
Email_ID Long The unique identifier of the email.
Email_Name String The name of the email.
Email_EmailGroupId Long The Id of the email group.
Email_IsPlainTextEditable Boolean Identifies whether the email is plaintext editable.
Email_IsTracked Boolean Identifies whether the email is tracked.
Email_PlainText String The plaintext version of the email.
Email_BouncebackEmail String The bounce-back email address.
Email_ReplyToEmail String The email address in the reply-to line of the email.
Email_ReplyToName String The name in the reply-to line of the email.
Email_SenderEmail String The email address of the sender.
Email_SenderName String The name of the sender.
Email_SendPlainTextOnly Boolean Identifies whether the plaintext version should be sent.
Email_Subject String The subject of the email.
Email_Description String The description of the email.
Email_FolderId Long The Id of the folder for the email.
Email_Permissions String The permissions of the email.
Email_CreatedAt Datetime Date the email was created.
Email_CreatedBy String The Id of the user who created the email.
Email_CurrentStatus String The current status of the email.
Email_UpdatedAt Datetime Date the email was updated.
Email_UpdatedBy String The Id of the user who last updated the email.
Email_HtmlContent_Type String The type for the content of the email.
Email_HtmlContent_ContentSource String The content source for the content of the email.
Email_HtmlContent_DocType String The doc type for the content of the email.
Email_HtmlContent_HTMLBody String The HTML body for the content of the email.
Email_HtmlContent_Root String The root for the content of the email.
Email_HtmlContent_MetaTags String The meta tags for the content of the email.
Email_HtmlContent_SystemHeader String The system header for the content of the email.

 

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
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

EmailFolder

Retrieve Email Folders.

 

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.

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 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
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

EmailFooterFolder

Retrieve Email Footer 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
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

EmailHeaderFolder

Retrieve Email Header 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
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

ExternalType

Retrieve External Types.

 

Columns

 

 

 

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

 

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
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

FieldMerge

Retrieve Field Merges.

 

Columns

 

 

 

   
Name Type Description
ID [KEY] Long The unique identifier for the field merge.
Name String The name of the field merge.
Description String The description of the field merge.
FolderId Long The Id of the folder for the field merge.
ScheduledFor Datetime The date and time scheduled for the field merge.
SourceTemplatedId Long The Id of the source template of the field merge.
Permissions String The permissions of the field merge.
CreatedAt Datetime Date the field merge was created.
CreatedBy String The Id of the user who created the field merge.
AccessedAt Datetime Date the field merge was accessed.
CurrentStatus String The current status of the field merge.
UpdatedAt Datetime Date the field merge was updated.
UpdatedBy String The Id of the user who last updated the field merge.
Syntax String The syntax of the field merge.
DefaultValue String The default value of the data lookup for the field merge.
ContactFieldId Long The contact field Id of the field merge.
AccountFieldId Long The account field Id of the field merge.
EventId Long The event Id of the field merge.
EventFieldId Long The event field Id of the field merge.
EventSessionFieldId Long The event session field Id of the field merge.
MergeType String The merge type of the field merge.

 

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
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

FieldMergeFolder

Retrieve Field Merge 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
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

FormElement

Retrieve Form Elements.

 

Columns

 

 

 

   
Name Type Description
ID [KEY] Long The unique identifier for the form element.
CreatedFromContactFieldId Long The contact field Id which created the form element.
Name String The name of the form element.
Type String The type of the form element.
DataType String The data type of the form element.
HTMLName String The HTML name of the form element.
Style String The style of the form element.
Instructions String The instructions of the form element.
Validations String The validations of the form 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
rows@next String This is used to page through multiple pages of results and should not be set manually.
FormId String TBD
Depth String The depth of information requested from Eloqua.

 

 

 

FormFolder

Retrieve Form 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
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

FormProcessingStep

Retrieve Form Processing Steps.

 

Columns

 

 

 

   
Name Type Description
ID [KEY] Long The unique identifier for the form processing step.
Name String The name of the form processing step.
Type String The type of the form processing step.
Condition String The condition of the form processing step.
execute String The execute of the form processing step.
Mappings String The mappings of the form processing step.
keyFieldMapping String The key field mapping of the form processing step.

 

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
rows@next String This is used to page through multiple pages of results and should not be set manually.
FormId String TBD
Depth String The depth of information requested from Eloqua.

 

 

 

HyperlinkFolder

Retrieve Hyperlink 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
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

Image

Retrieve Image.

 

Columns

 

 

 

   
Name Type Description
ID [KEY] Long The unique identifier for the image.
Name String The name of the image.
Permissions String The permissions of the image.
Description String The description of the image.
FolderId Long The folder Id of the image.
CreatedAt Datetime Date the image was created.
CreatedBy String The Id of the user who created the image.
UpdatedAt Datetime Date the image was last updated.
UpdatedBy String The Id of the user who last updated the image.
FullImageUrl String The full image URL of the image.
ThumbNailUrl String The thumb nail URL of the image.

 

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
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

ImageFolder

Retrieve Image 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
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

ImportedFile

Retrieve Imported Files.

 

Columns

 

 

 

   
Name Type Description
ID [KEY] Long The unique identifier for the imported file.
Name String The name of the imported file.
Type String The type of the imported file.
FolderId Long The folder Id of the imported file.
FileName String The file name of the imported file.
Link String The link of the imported file.
TrackedLink String The tracked link of the imported file.
Permissions String The permissions of the imported file.
CreatedAt Datetime Date the imported file was created.
CreatedBy String The Id of the user who created the imported file.
AccessedAt Datetime Date the imported file was accessed.
Depth String The depth of the imported file.
UpdatedAt Datetime Date the imported file was updated.
UpdatedBy String The Id of the user who last updated the imported file.

 

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
rows@next String This is used to page through multiple pages of results and should not be set manually.

 

 

 

ImportedFileFolder

Retrieve Imported File 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
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

LandingPageFolder

Retrieve Landing Page 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
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

PageTag

Retrieve Page Tags.

 

Columns

 

 

 

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

 

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
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

PageTagGroup

Retrieve Page Tag Groups.

 

Columns

 

 

 

   
Name Type Description
ID [KEY] Long The unique identifier for the page tag group.
Name String The name of the page tag group.
Description String The description of the page tag group.
Permissions String The permissions of the page tag group.
CreatedAt Datetime Date the page tag group was created.
CreatedBy String The Id of the user who created the page tag group.
AccessedAt Datetime Date the page tag group was accessed.
CurrentStatus String The current status of the page tag group.
UpdatedAt Datetime Date the page tag group was updated.
UpdatedBy String The Id of the user who last updated the page tag group.

 

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
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

Program

Retrieve Programs.

 

Columns

 

 

 

   
Name Type Description
ID [KEY] Long The unique identifier for the program.
Name String The name of the program.
Description String The description of the program.
FolderId Long The Id of the folder for the program.
ScheduledFor Datetime The date and time scheduled for the program.
SourceTemplatedId Long The Id of the source template of the program.
Permissions String The permissions of the program.
CreatedAt Datetime Date the program list was created.
CreatedBy String The Id of the user who created the program.
AccessedAt Datetime Date the program was accessed.
UpdatedAt Datetime Date the program was updated.
UpdatedBy String The Id of the user who last updated the program.

 

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
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

Style

Retrieve Styles.

 

Columns

 

 

 

   
Name Type Description
ID [KEY] Long The unique identifier for the style.
Name String The name of the style.
Description String The description of the style.
UpdatedAt Datetime Date the style was last updated.
CreatedAt Datetime Date the style was created.
Body String The body of the style.
Column1 String Column 1 of the style.
Column2 String Column 2 of the style.
Column3 String Column 3 of the style.
Footer String The footer of the style.
Header String The header of the style.
Headline String The headline of the style.
Icon String The icon of the style.
Page String The page of the style.

 

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
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

Template

Retrieve Templates.

 

Columns

 

 

 

   
Name Type Description
ID [KEY] Long The unique identifier for the template.
Name String The name of the template.
Description String The description of the template.
FolderId Long The Id of the folder for the template.
ScheduledFor Datetime The date and time scheduled for the template.
SourceTemplateId Long The source template Id of the template.
Permissions String The permissions of the template.
CreatedAt Datetime Date the template was created.
CreatedBy String The Id of the user who created the template.
AccessedAt Datetime Date the template was accessed.
CurrentStatus String The current status of the template.
UpdatedAt Datetime Date the template was last updated.
UpdatedBy String The Id of the user who last updated the template.
AssetType String The asset type of the template.
AssetId Long The asset Id of the template.
CategoryId Long The category Id of the template.
DocumentAtionTitle String The documentation title of the template.
DocumentAtionUrl String The documentation URL of the template.
IsContentProtected Boolean Identifies whether the template is content protected.
UseThumbnail Boolean Identifies whether the template uses a thumbnail.
IconUrl String The icon URL of the template.

 

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
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

TemplateCategory

Retrieve Template Categories.

 

Columns

 

 

 

   
Name Type Description
ID [KEY] Long The unique identifier for the template category.
Name String The name of the template.
Description String The description of the template category.
FolderId Long The Id of the folder for the template category.
ScheduledFor Datetime The date and time scheduled for the template category.
SourceTemplateId Long The source template Id of the template category.
Permissions String The permissions of the template category.
CreatedAt Datetime Date the template category was created.
CreatedBy String The Id of the user who created the template category.
AccessedAt Datetime Date the template category was accessed.
CurrentStatus String The current status of the template category.
UpdatedAt Datetime Date the template category was updated.
UpdatedBy String The Id of the user who last updated the template category.
SiteId Long The site Id of the template category.
DefaultTemplateIconUrl String The default template icon URL of the template category.
IconUrl String The icon URL of the template category.
Publisher String The publisher of the template category.
Campaigns Int The campaigns of the template category.
ContactSegments Int The contact segments of the template category.
Forms Int The forms of the template category.
LandingPages Int The landing pages of the template category.
Emails Int The emails of the template category.

 

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
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.

 

 

 

TrackedUrl

Retrieve Tracked Urls.

 

Columns

 

 

 

   
Name Type Description
ID [KEY] Long The unique identifier for the tracked URL.
Name String The name of the tracked URL.
Description String The description of the tracked URL.
FolderId Long The Id of the folder for the tracked URL.
ScheduledFor Datetime The date and time scheduled for the tracked URL.
SourceTemplatedId Long The Id of the source template of the tracked URL.
Permissions String The permissions of the tracked URL.
CreatedAt Datetime Date the tracked URL was created.
CreatedBy String The Id of the user who created the tracked URL.
AccessedAt Datetime Date the tracked URL was accessed.
CurrentStatus String The current status of the tracked URL.
Depth String The depth of the tracked URL.
UpdatedAt Datetime Date the tracked URL was last updated.
UpdatedBy String The Id of the user who last updated the tracked URL.
Url String The URL of the tracked URL.

 

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
rows@next String This is used to page through multiple pages of results and should not be set manually.

 

 

 

User

Retrieve Users.

 

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.

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 this user.
Name String The name of the user.
Company String The company of the user.
Capabilities String The capabilities of the user.
BetaAccess String The beta access flag for the user.
DefaultAccountViewId Long The Id of the default account view for the user.
DefaultContactViewId Long The Id of the default contact view for the user.
EmailAddress String The email address of the user.
LoggedInAt String When the user last logged in.
LoginName String The login name of the user.
Preferences String The preferences for the user.
ProductPermissions String The product permissions for the user.
TypePermissions String The type permissions for the user.
ScheduledFor Datetime The date and time scheduled for the user.
SourceTemplatedId Long The Id of the source template for the user.
Description String The description of the user.
FolderId Long The Id of the folder for the user.
Permissions String The permissions of the user.
CreatedAt Datetime Date the user was created.
CreatedBy String The Id of the user that created the user.
AccessedAt Datetime Date the user was accessed.
CurrentStatus String The current status of the user.
Depth String The depth of the user.
UpdatedAt Datetime Date the user was updated.
UpdatedBy String The Id of the user who last updated the user.

 

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
rows@next String This is used to page through multiple pages of results and should not be set manually.

 

 

 

Visitor

Retrieve Visitors.

 

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.

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
VisitorId [KEY] Long The Id of the visitor profile.
CreatedAt Datetime Date the visitor profile was created.
V_IPAddress String IP address of the visitor.
V_LastVisitDateAndTime Datetime Date of last visit to an Eloqua asset for this profile.
ExternalId String Customer GUID for this visitor profile.
ContactId Long The Id of the contact associated with this profile, if any.

 

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
rows@next String This is used to page through multiple pages of results and should not be set manually.
Depth String The depth of information requested from Eloqua.