`

Matillion ETL Data Model for Oracle Eloqua
Version - 18.0.6886

Note: Data models are true for the latest version of Matillion ETL. If you are on an older version or using a component from an old job, your experience may differ.




Connection String OptionsBack To Top

  1. Auto Cache
  2. Batch Size
  3. Bulk Polling Interval
  4. Bulk Query Timeout
  5. Cache Connection
  6. Cache Driver
  7. Cache Location
  8. Cache Metadata
  9. Cache Query Result
  10. Cache Tolerance
  11. Callback URL
  12. Company
  13. Connection Life Time
  14. Connect On Open
  15. Data Retention Duration
  16. Firewall Password
  17. Firewall Port
  18. Firewall Server
  19. Firewall Type
  20. Firewall User
  21. Initiate OAuth
  22. Location
  23. Logfile
  24. Map Data Cards Case Sensitive Match
  25. Map Data Cards Relation Ship
  26. Max Log File Size
  27. Max Rows
  28. OAuth Access Token
  29. OAuth Client Id
  30. OAuth Client Secret
  31. OAuth Refresh Token
  32. OAuth Settings Location
  33. OAuth Verifier
  34. Offline
  35. Other
  36. Pagesize
  37. Password
  38. Pool Idle Timeout
  39. Pool Max Size
  40. Pool Min Size
  41. Pool Wait Time
  42. Proxy Auth Scheme
  43. Proxy Auto Detect
  44. Proxy Exceptions
  45. Proxy Password
  46. Proxy Port
  47. Proxy Server
  48. Proxy SSL Type
  49. Proxy User
  50. Pseudo Columns
  51. Readonly
  52. Retry Count
  53. Retry Interval
  54. RTK
  55. SSL Server Cert
  56. State
  57. Support Enhanced SQL
  58. Tables
  59. Timeout
  60. Use Bulk API
  61. Use Connection Pooling
  62. User
  63. Use Simple Names
  64. Verbosity
  65. Views



Auto Cache

Automatically caches the results of SELECT queries into a cache database specified by either CacheLocation or both of CacheConnection and CacheProvider . Configured with CacheQueryResult .
Data Type

bool

Default Value

false

Remarks

When AutoCache is set, the driver automatically maintains a cache of your table's data in the database of your choice. By default, the driver incrementally updates the cache, retrieving only changes since the last SELECT query was run if the length of time since the last run has exceeded the CacheTolerance. After the cache is updated, the query is executed against the cached data. With CacheQueryResult additionally set, the driver updates the cache when you execute a SELECT query and returns the live results from the Eloqua data.

Explicitly Caching SELECT Results

CacheQueryResult is a way to query Eloqua in real time while maintaining a cache for offline use. Set CacheQueryResult to update the cache whenever you execute a SELECT statement. When you execute a SELECT statement with AutoCache and CacheQueryResult set, the driver executes the query to the remote data and caches the results; rows that already exist are overwritten. That is, SELECT statements are used to create and refresh the cache, not to query it. Data manipulation commands are executed to the remote data as well.

To query the cached data, set the Offline property. If you need to query the cached data in an online connection, you can append #CACHE to the table name. For example:

SELECT * FROM [Contact#CACHE]

Setting the Caching Database

When AutoCache is set, the driver caches to a simple, file-based cache. You can configure its location or cache to a different database with the following properties:

See Also





Batch Size

The maximum size of each batch operation to submit.
Data Type

int

Default Value

0

Remarks

When BatchSize is set to a value greater than 0, the batch operation will split the entire batch into separate batches of size BatchSize. The split batches will then be submitted to the server individually. This is useful when the server has limitations on the size of the request that can be submitted.

Setting BatchSize to 0 will submit the entire batch as specified.





Bulk Polling Interval

The time interval between requests that check the availability of the bulk query response. The default value is 200 ms.
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

The timeout in minutes for which the provider will wait for a bulk query response. The default value is 25 minutes.
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

The connection string for the cache database. Always used in conjunction with CacheProvider . Setting both properties will override the value set for CacheLocation for caching data.
Data Type

string

Default Value

""

Remarks

The cache database is determined based on the CacheDriver and CacheConnection properties. Both properies are required to use the cache database. Examples of common cache database settings can be found below. For more information on setting the caching database's driver, refer to CacheDriver.

The connection string specified in the CacheConnection property is passed directly to the underlying CacheDriver. Consult the documentation for the specific JDBC driver for more information on the available properties. Make sure to include the JDBC driver in your application's classpath.

Derby and Java DB

The driver simplifies caching to Derby, only requiring you to set the CacheLocation property to make a basic connection.

Alternatively, you can configure the connection to Derby manually using CacheProvider and CacheConnection. Below is the Derby JDBC URL syntax:

jdbc:derby:[subsubprotocol:][databaseName][;attribute=value[;attribute=value] ... ]
For example, to cache to an in-memory database, use the following:
jdbc:derby:memory

SQLite

To cache to SQLite, you can use the SQLite JDBC driver. Below is the syntax of the JDBC URL:

jdbc:sqlite:dataSource

MySQL

The installation includes the CData JDBC Driver for MySQL. Below is an example JDBC URL:

jdbc:mysql:User=root;Password=root;Server=localhost;Port=3306;Database=cache
Below are typical connection properties:

SQL Server

The JDBC URL for the Microsoft JDBC Driver for SQL Server has the following syntax:

jdbc:sqlserver://[serverName[\instance][:port]][;database=databaseName][;property=value[;property=value] ... ]
For example:
jdbc:sqlserver://localhost\sqlexpress:1433;integratedSecurity=true
Below are typical SQL Server connection properties:
Oracle

Below is the conventional JDBC URL syntax for the Oracle JDBC Thin driver:

jdbc:oracle:thin:[userId/password]@[//]host[[:port][:sid]]
For example:
jdbc:oracle:thin:scott/tiger@myhost:1521:orcl
Below are typical connection properties:
PostgreSQL

Below is the JDBC URL syntax for the official PostgreSQL JDBC driver:

jdbc:postgresql:[//[host[:port]]/]database[[?option=value][[&option=value][&option=value] ... ]]
For example, the following connection string connects to a database on the default host (localhost) and port (5432):
jdbc:postgresql:postgres
Below are typical connection properties:





Cache Driver

The database driver to be used to cache data.
Data Type

string

Default Value

""

Remarks

You can cache to any database for which you have a JDBC driver, including CData JDBC drivers.

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

Note that you must also add the CacheDriver JAR to the classpath.

The following examples show how to cache to several major databases. Refer to CacheConnection for more information on the JDBC URL syntax and typical connection properties.

Derby and Java DB

The driver simplifies Derby configuration. Java DB is the Oracle distribution of Derby. The JAR is shipped in the JDK. You can find the JAR, derby.jar, in the db subfolder of the JDK installation. In most caching scenarios, you need to specify only the following, after adding derby.jar to the classpath.

jdbc:eloqua:CacheLocation='c:/Temp/cachedir';User=user;Password=password;Company=MyCompany
To customize the Derby JDBC URL, use CacheDriver and CacheConnection. For example, to cache to an in-memory database, use a JDBC URL like the following:
jdbc:eloqua:CacheDriver=org.apache.derby.jdbc.EmbeddedDriver;CacheConnection='jdbc:derby:memory';User=user;Password=password;Company=MyCompany
SQLite

Below is a JDBC URL for the SQLite JDBC driver:

jdbc:eloqua:CacheDriver=org.sqlite.JDBC;CacheConnection='jdbc:sqlite:C:/Temp/sqlite.db';User=user;Password=password;Company=MyCompany
MySQL

Below is a JDBC URL for the included CData JDBC Driver for MySQL:

  jdbc:eloqua:Cache Driver=cdata.jdbc.mysql.MySQLDriver;Cache Connection='jdbc:mysql:Server=localhost;Port=3306;Database=cache;User=root;Password=123456';User=user;Password=password;Company=MyCompany
  
The CData JDBC Driver for MySQL is located in the lib subfolder of the CData JDBC Driver for Eloqua 2018 installation directory.
SQL Server

The following JDBC URL uses the Microsoft JDBC Driver for SQL Server:

jdbc:eloqua:Cache Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver;Cache Connection='jdbc:sqlserver://localhost\sqlexpress:7437;user=sa;password=123456;databaseName=Cache';User=user;Password=password;Company=MyCompany
Oracle

Below is a JDBC URL for the Oracle Thin Client:

jdbc:eloqua:Cache Driver=oracle.jdbc.driver.OracleDriver;CacheConnection='jdbc:oracle:thin:scott/tiger@localhost:1521:orcldb';User=user;Password=password;Company=MyCompany
PostgreSQL

The following JDBC URL uses the official PostgreSQL JDBC driver:

jdbc:eloqua:CacheDriver=org.postgresql.Driver;CacheConnection='jdbc:postgresql://localhost:5433/postgres?user=postgres&password=admin';User=user;Password=password;Company=MyCompany





Cache Location

Specifies the path to the cache when caching to a file.
Data Type

string

Default Value

""

Remarks

The CacheLocation is a simple, file-based cache. The driver uses Java DB, Oracle's distribution of the Derby database. To cache to Java DB, you will need to add the Java DB JAR to the classpath. The JAR, derby.jar, is shipped in the JDK and located in the db subfolder of the JDK installation.

CacheLocation defaults to the directory specified by the Location setting.

See Also





Cache Metadata

Whether or not to cache the table metadata to a file store.
Data Type

bool

Default Value

false

Remarks

As you execute queries with this property set, table metadata in the Eloqua catalog are cached to the file store specified by CacheLocation if set or the user's home directory otherwise. A table's metadata will be retrieved only once, when the table is queried for the first time.

When to Use CacheMetadata

The driver automatically persists metadata in memory for up to two hours when you first discover the metadata for a table or view and therefore, CacheMetadata is generally not required. CacheMetadata becomes useful when metadata operations are expensive such as when you are working with large amounts of metadata or when you have many short-lived connections.

When Not to Use CacheMetadata





Cache Query Result

With AutoCache set, caches each row read from a SELECT query's results. Without this, the provider will attempt to fully replicate the table before executing the actual query against the replication database.
Data Type

bool

Default Value

false

Remarks

When CacheQueryResult and AutoCache are set, the rows returned from a SELECT query are cached in the cache database. The driver handles caching in a streaming fashion with each row being processed into the cache database from the original result set as you read the row from the returned ResultSet object. This ensures that the live data is not queried twice. Note that any rows you do not read from the returned ResultSet will not be updated in the cache.





Cache Tolerance

The tolerance for stale data in the cache specified in seconds when using AutoCache .
Data Type

string

Default Value

"600"

Remarks

The tolerance for stale data in the cache specified in seconds. This only applies when AutoCache is used. The driver will check with the data source for newer records after the tolerance interval has expired. Otherwise it will return the data directly from the cache.





Callback URL

The OAuth callback URL to return to when authenticating. This value must match the callback URL you specify in your app settings.
Data Type

string

Default Value

""

Remarks

During the authentication process, the OAuth authorization server redirects the user to this URL. This value must match the callback URL you specify in your app settings.





Company

The company of the Eloqua account. This field is used to authenticate the user.
Data Type

string

Default Value

""

Remarks

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





Connection Life Time

The maximum lifetime of a connection in seconds. Once the time has elapsed, the connection object is disposed.
Data Type

string

Default Value

"0"

Remarks

The maximum lifetime of a connection in seconds. Once the time has elapsed, the connection object is disposed. The default is 0 which indicates there is no limit to the connection lifetime.





Connect On Open

Species whether to connect to the Eloqua when the connection is opened.
Data Type

bool

Default Value

false

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

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

A password used to authenticate to a proxy-based firewall.
Data Type

string

Default Value

""

Remarks

This property is passed to the proxy specified by FirewallServer and FirewallPort, following the authentication method specified by FirewallType.





Firewall Port

The TCP port for a proxy-based firewall.
Data Type

string

Default Value

""

Remarks

This specifies the TCP port for a proxy allowing traversal of a firewall. Use FirewallServer to specify the name or IP address. Specify the protocol with FirewallType.





Firewall Server

The name or IP address of a proxy-based firewall.
Data Type

string

Default Value

""

Remarks

This property specifies the IP address, DNS name, or host name of a proxy allowing traversal of a firewall. The protocol is specified by FirewallType: Use FirewallServer with this property to connect through SOCKS or do tunneling. Use ProxyServer to connect to an HTTP proxy.

Note that the driver uses the system proxy by default. To use a different proxy, set ProxyAutoDetect to false.





Firewall Type

The protocol used by a proxy-based firewall.
Data Type

string

Default Value

"NONE"

Remarks

This property specifies the protocol that the driver will use to tunnel traffic through the FirewallServer proxy. Note that by default the driver connects to the system proxy; to disable this behavior and connect to one of the following proxy types, set ProxyAutoDetect to false.

Type Default Port Description
TUNNEL 80 When this is set, the driver opens a connection to Eloqua and traffic flows back and forth through the proxy.
SOCKS4 1080 When this is set, the driver sends data through the SOCKS 4 proxy specified by FirewallServer and FirewallPort and passes the FirewallUser value to the proxy, which determines if the connection request should be granted.
SOCKS5 1080 When this is set, the driver sends data through the SOCKS 5 proxy specified by FirewallServer and FirewallPort. If your proxy requires authentication, set FirewallUser and FirewallPassword to credentials the proxy recognizes.

To connect to HTTP proxies, use ProxyServer and ProxyPort. To authenticate to HTTP proxies, use ProxyAuthScheme, ProxyUser, and ProxyPassword.





Firewall User

The user name to use to authenticate with a proxy-based firewall.
Data Type

string

Default Value

""

Remarks

The FirewallUser and FirewallPassword properties are used to authenticate against the proxy specified in FirewallServer and FirewallPort, following the authentication method specified in FirewallType.





Initiate OAuth

Set this property to initiate the process to obtain or refresh the OAuth access token when you connect.
Data Type

string

Default Value

"OFF"

Remarks

The following options are available:

  1. OFF: Indicates that the OAuth flow will be handled entirely by the user. An OAuthAccessToken will be required to authenticate.
  2. GETANDREFRESH: Indicates that the entire OAuth Flow will be handled by the driver. If no token currently exists, it will be obtained by prompting the user via the browser. If a token exists, it will be refreshed when applicable.
  3. REFRESH: Indicates that the driver will only handle refreshing the OAuthAccessToken. The user will never be prompted by the driver to authenticate via the browser. The user must handle obtaining the OAuthAccessToken and OAuthRefreshToken initially.





Location

A path to the directory that contains the schema files defining tables, views, and stored procedures.
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 are deployed alongside the driver 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

A path to the log file.
Data Type

string

Default Value

""

Remarks

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





Map Data Cards Case Sensitive Match

Whether or not to use case sensitive match in data card mapping.
Data Type

bool

Default Value

false

Remarks

Whether or not to use case sensitive match in data card mapping. Only has an effect if MapDataCardsRelationShip is set.





Map Data Cards Relation Ship

Comma-separated list of the relationships between the Custom Object tables and the Entity tables.
Data Type

string

Default Value

""

Remarks

Comma-separated list of the relationships between the Custom Object tables and the Entity tables. The format of these relationships is '<custom_object>.<source_field>=<entity_type>.<entity_field>'. For example: Custom_MyCustomObject.Email_Address=Contact.C_EmailAddress





Max Log File Size

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.
Data Type

string

Default Value

"100MB"

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. The default limit is 100MB. Values lower than 100kB will use 100kB as the value instead.





Max Rows

Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.
Data Type

string

Default Value

"-1"

Remarks

Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.





OAuth Access Token

The access token for connecting using OAuth.
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

The client Id assigned when you register your application with an OAuth authorization server.
Data Type

string

Default Value

""

Remarks

As part of registering an OAuth application, you will receive the OAuthClientId value, sometimes also called a consumer key, and a client secret, the OAuthClientSecret.





OAuth Client Secret

The client secret assigned when you register your application with an OAuth authorization server.
Data Type

string

Default Value

""

Remarks

As part of registering an OAuth application, you will receive the OAuthClientId, also called a consumer key. You will also receive a client secret, also called a consumer secret. Set the client secret in the OAuthClientSecret property.





OAuth Refresh Token

The OAuth refresh token for the corresponding OAuth access token.
Data Type

string

Default Value

""

Remarks

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





OAuth Settings Location

The location of the settings file where OAuth values are saved when InitiateOAuth is set to GETANDREFRESH or REFRESH. Alternatively, this can be held in memory by specifying a value starting with memory://.
Data Type

string

Default Value

"%APPDATA%\\CData\\Eloqua Data Provider\\OAuthSettings.txt"

Remarks

When InitiateOAuth is set to GETANDREFRESH or REFRESH, the driver saves OAuth values to avoid requiring the user to manually enter OAuth connection properties and allowing the credentials to be shared across connections or processes. The default OAuthSettingsLocation is a settings file located in the %AppData%\CData folder. Alternatively to specifying a file path, memory storage can be used instead. Memory locations are specified by using a value starting with 'memory://' followed by a unique identifier for that set of credentials (ex: memory://user1). The identifier can be anything you choose but should be unique to the user. Unlike with the file based storage, you must manually store the credentials when closing the connection with memory storage to be able to set them in the connection when the process is started again. The OAuth property values can be retrieved with a query to the sys_connection_props system table. If there are multiple connections using the same credentials, the properties should be read from the last connection to be closed.





OAuth Verifier

The verifier code returned from the OAuth authorization URL.
Data Type

string

Default Value

""

Remarks

The verifier code returned from the OAuth authorization URL. This can be used on systems where a browser cannot be launched such as headless systems.

Authentication on Headless Machines

See the Getting Started section to obtain the OAuthVerifier value.

Set OAuthSettingsLocation along with OAuthVerifier. When you connect, the driver exchanges the OAuthVerifier for the OAuth authentication tokens and saves them, encrypted, to the specified file. Set InitiateOAuth to GETANDREFRESH automate the exchange.

Once the OAuth settings file has been generated, you can remove OAuthVerifier from the connection properties and connect with OAuthSettingsLocation set.

To automatically refresh the OAuth token values, set OAuthSettingsLocation and additionally set InitiateOAuth to REFRESH.





Offline

Use offline mode to get the data from the cache instead of the live source.
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

Hidden properties needed only in specific use cases.
Data Type

string

Default Value

""

Remarks

The properties listed below are available for specific use cases. Normal driver use cases and functionality should not require these properties.

Specify multiple properties in a semicolon-separated list.

Caching Configuration

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

Integration and Formatting

DefaultColumnSizeSets the default length of string fields when the data source does not provide column length in the metadata. The default value is 2000.
ConvertDateTimeToGMTWhether to convert date-time values to GMT, instead of the local time of the machine.
RecordToFile=filenameRecords the underlying socket data transfer to the specified file.





Pagesize

The maximum number of results to return per page from Eloqua.
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

The password of the Eloqua account used to authenticate.
Data Type

string

Default Value

""

Remarks

This field is used to authenticate against the Eloqua servers.





Pool Idle Timeout

The allowed idle time for a connection before it is closed.
Data Type

string

Default Value

""

Remarks

The allowed idle time a connection can remain in the pool until the connection is closed. The default is 60 seconds.





Pool Max Size

The maximum connections in the pool.
Data Type

string

Default Value

"100"

Remarks

The maximum connections in the pool. The default is 100. To disable this property, set the property value to 0 or less.





Pool Min Size

The minimum number of connections in the pool.
Data Type

string

Default Value

"1"

Remarks

The minimum number of connections in the pool. The default is 1.





Pool Wait Time

The max seconds to wait for an available connection.
Data Type

string

Default Value

""

Remarks

The max seconds to wait for a connection to become available. If a new connection request is waiting for an available connection and exceeds this time, an error is thrown. By default, new requests wait forever for an available connection.





Proxy Auth Scheme

The authentication type to use to authenticate to the ProxyServer proxy.
Data Type

string

Default Value

"BASIC"

Remarks

This value specifies the authentication type to use to authenticate to the HTTP proxy specified by ProxyServer and ProxyPort.

Note that the driver will use the system proxy settings by default, without further configuration needed; if you want to connect to another proxy, you will need to set ProxyAutoDetect to false, in addition to ProxyServer and ProxyPort. To authenticate, set ProxyAuthScheme and set ProxyUser and ProxyPassword, if needed.

The authentication type can be one of the following:

If you need to use another authentication type, such as SOCKS 5 authentication, see FirewallType.





Proxy Auto Detect

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

bool

Default Value

true

Remarks

By default, the driver uses the system HTTP proxy. Set this to false if you want to connect to another proxy.

To connect to an HTTP proxy, see ProxyServer.

For other proxies, such as SOCKS or tunneling, see FirewallType.





Proxy Exceptions

A semicolon separated list of hosts or IPs that will be exempt from connecting through the ProxyServer .
Data Type

string

Default Value

""

Remarks

The ProxyServer will be used for all addresses, except for addresses defined in this property. Use semicolons to separate entries.

Note that the driver will use the system proxy settings by default, without further configuration needed; if you want to explicitly configure proxy exceptions for this connection, you will need to set ProxyAutoDetect to false, and configure ProxyServer and ProxyPort. To authenticate, set ProxyAuthScheme and set ProxyUser and ProxyPassword, if needed.





Proxy Password

A password to be used to authenticate to the ProxyServer proxy.
Data Type

string

Default Value

""

Remarks

This property is used to authenticate to an HTTP proxy server that supports NTLM (Windows), Kerberos, or HTTP authentication. To specify the HTTP proxy, you can set ProxyServer and ProxyPort. To specify the authentication type, set ProxyAuthScheme.

If you are using HTTP authentication, additionally set ProxyUser and ProxyPassword to HTTP proxy.

If you are using NTLM authentication, set ProxyUser and ProxyPassword to your Windows password. You may also need these to complete Kerberos authentication.

For SOCKS 5 authentication or tunneling, see FirewallType.

By default, the driver uses the system proxy. If you want to connect to another proxy, set ProxyAutoDetect to false.





Proxy Port

The TCP port the ProxyServer proxy is running on.
Data Type

string

Default Value

"80"

Remarks

The port the HTTP proxy is running on that you want to redirect HTTP traffic through. Specify the HTTP proxy in ProxyServer. For other proxy types, see FirewallType.





Proxy Server

The hostname or IP address of a proxy to route HTTP traffic through.
Data Type

string

Default Value

""

Remarks

The hostname or IP address of a proxy to route HTTP traffic through. The driver can use the HTTP, Windows (NTLM), or Kerberos authentication types to authenticate to an HTTP proxy.

If you need to connect through a SOCKS proxy or tunnel the connection, see FirewallType.

By default, the driver uses the system proxy. If you need to use another proxy, set ProxyAutoDetect to false.





Proxy SSL Type

The SSL type to use when connecting to the ProxyServer proxy.
Data Type

string

Default Value

"AUTO"

Remarks

This property determines when to use SSL for the connection to an HTTP proxy specified by ProxyServer. This value can be AUTO, ALWAYS, NEVER, or TUNNEL. The applicable values are the following:

AUTODefault setting. If the URL is an HTTPS URL, the driver will use the TUNNEL option. If the URL is an HTTP URL, the component will use the NEVER option.
ALWAYSThe connection is always SSL enabled.
NEVERThe connection is not SSL enabled.
TUNNELThe connection is through a tunneling proxy: The proxy server opens a connection to the remote host and traffic flows back and forth through the proxy.





Proxy User

A user name to be used to authenticate to the ProxyServer proxy.
Data Type

string

Default Value

""

Remarks

The ProxyUser and ProxyPassword options are used to connect and authenticate against the HTTP proxy specified in ProxyServer.

You can select one of the available authentication types in ProxyAuthScheme. If you are using HTTP authentication, set this to the username of a user recognized by the HTTP proxy. If you are using Windows or Kerberos authentication, set this property to a username in one of the following formats:

user@domain
domain\user





Pseudo Columns

Indicates whether or not to include pseudo columns as columns to the table.
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., "*=*".





Readonly

You can use this property to enforce read-only access to Eloqua from the provider.
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

The maximum number of times to retry a Bulk API request that fails due to an HTTP 500 status code (Internal Server Error).
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

The time interval between attempts to retry a Bulk API request that failed with an HTTP 500 status code (Internal Server Error).
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

The runtime key used for licensing.
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

The certificate to be accepted from the server when connecting using TLS/SSL.
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 property can take the forms:

Description Example
A full PEM Certificate (example shortened for brevity) -----BEGIN CERTIFICATE----- MIIChTCCAe4CAQAwDQYJKoZIhv......Qw== -----END CERTIFICATE-----
A path to a local file containing the certificate C:\cert.cer
The public key (example shortened for brevity) -----BEGIN RSA PUBLIC KEY----- MIGfMA0GCSq......AQAB -----END RSA PUBLIC KEY-----
The MD5 Thumbprint (hex values can also be either space or colon separated) ecadbdda5a1529c58a1e9e09828d70e4
The SHA1 Thumbprint (hex values can also be either space or colon separated) 34a929226ae0819f2ec14b4a3d904f801cbb150d

If not specified, any certificate trusted by the machine will be accepted. Use '*' to signify to accept all certificates (not recommended for security concerns).





State

An optional value that has meaning for your OAuth App.
Data Type

string

Default Value

""

Remarks

Used in OAuth authentication: This is an optional value that has meaning for your OAuth App.





Support Enhanced SQL

Enhances SQL functionality beyond what can be supported through the API directly, by enabling in-memory client-side processing.
Data Type

bool

Default Value

true

Remarks

When SupportEnhancedSQL is set to true, the driver offloads as much of the SELECT statement processing as possible to Eloqua and then processes the rest of the query in memory. In this way the driver can execute unsupported predicates, joins, and aggregation.

When SupportEnhancedSQL is set to false, the driver limits SQL execution to what is supported by the Eloqua API.

Execution of Predicates

The driver determines which of the clauses are supported by the data source and then pushes them to the source to get the smallest superset of rows that would satisfy the query. It then filters the rest of the rows locally. The filter operation is streamed, which enables the driver to filter effectively for even very large datasets.

Execution of Joins

The driver uses various techniques to join in memory. The driver trades off memory utilization against the requirement of reading the same table more than once.

Execution of Aggregates

The driver retrieves all rows necessary to process the aggregation in memory.





Tables

Restrict the tables reported to a subset of the available tables. For example: Tables=TableA,TableB,TableC.
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.

This property can also be used as an alternative to automatically listing views if you already know which ones you want to work with and there would otherwise be too many to work with.

Specify the tables you want in a comma-separated list. For example: Tables=TableA,TableB,TableC





Timeout

The value in seconds until the timeout error is thrown, canceling the operation.
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

Whether or not the bulk API is used for retrieving data.
Data Type

string

Default Value

"Auto"

Remarks

Whether or not the bulk API is used for retrieving data. When UseBulkAPI is set to "True", the driver will always attempt to use the bulk API. However, there are several restrictions to accessible tables and columns. See Data Model for more information.

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, consider the following query:

SELECT * FROM Activity_EmailOpen
In this case, the driver will use the Bulk API (because the ContactId is not specified), whereas the following query will use the REST API:
SELECT * FROM Activity_EmailOpen ContactId='...'

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.





Use Connection Pooling

Enables connection pooling.
Data Type

bool

Default Value

false

Remarks

Enables connection pooling. The default is false. See Connection Pooling for information on using connection pools.





User

The user of the Eloqua account. This field is used to authenticate the user.
Data Type

string

Default Value

""

Remarks

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





Use Simple Names

Boolean determining if simple names should be used for tables and columns.
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

The verbosity level that determines the amount of detail included in the log file.
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:

1Setting 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.
2Setting Verbosity to 2 will log everything included in Verbosity 1, cache queries, and additional information about the request, if applicable, such as HTTP headers.
3Setting Verbosity to 3 will additionally log the body of the request and the response.
4Setting Verbosity to 4 will additionally log transport-level communication with the data source. This includes SSL negotiation.
5Setting 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.





Views

Restrict the views reported to a subset of the available tables. For example: Views=ViewsA,ViewsB,ViewsC.
Data Type

string

Default Value

""

Remarks

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

This property can also be used as an alternative to automatically listing views if you already know which ones you want to work with and there would otherwise be too many to work with.

Specify the views you want in a comma-separated list. For example: For example: Views=ViewsA,ViewsB,ViewsC





TablesBack To Top

  1. Account
  2. AccountGroup
  3. Campaign
  4. Contact
  5. ContactEmailSubscription
  6. ContactSegment
  7. ContentSection
  8. Custom
  9. Email
  10. EmailFooter
  11. EmailGroup
  12. EmailHeader
  13. Event
  14. ExternalActivity
  15. ExternalAsset
  16. Folder
  17. Form
  18. Hyperlink
  19. LandingPage
  20. Microsite
  21. 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.





AccountGroup

Retrieve Account group.

Columns

Name Type ReadOnly Description
ID [KEY] Long True

The unique identifier for the account group.

Name String False

The name of the account group.

Type String False

The type of the account group.

Permissions String False

The permissions of the account group.

CreatedAt Datetime True

Date the account group was created.

IsArchived String False

The Id of the user who created the account group.

FolderId String True

The folderId of the account group.

UpdatedAt Datetime True

Date the account group was updated.

Description String True

The description of the accountgroup.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
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.





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

The Date Created of the contact.

Date Modified Date True

The Date Modified of the contact.

Eloqua Contact ID String True

The Eloqua Contact ID of the contact.

SFDC Account ID String False

The SFDC Account ID of the contact.

Last Modified by CRM System Date True

The Last Modified by CRM System of the contact.

Last SFDC Campaign ID String False

The Last SFDC Campaign ID of the contact.

Last SFDC Campaign Status String False

The Last SFDC Campaign Status of the contact.

Company Revenue String False

The Company Revenue of the contact.

SFDC Email Opt Out String False

The SFDC Email Opt Out of the contact.

Lead Source - Most Recent String False

The Lead Source - Most Recent of the contact.

Lead Source - Original String False

The Lead Source - Original of the contact.

Industry String False

The Industry of the contact.

Annual Revenue String False

The Annual Revenue of the contact.

Lead Status String False

The Lead Status of the contact.

Job Role String False

The Job Role of the contact.

Lead Score - High Value Website Content Double False

The Lead Score - High Value Website Content of the contact.

Lead Score Date - Engagement - Most Recent Date False

The Lead Score Date - Engagement - Most Recent of the contact.

Integrated Marketing and Sales Funnel Stage String False

The Integrated Marketing and Sales Funnel Stage of the contact.

Product/Solution of Interest String False

The Product/Solution of Interest of the contact.

Region String False

The Region of the contact.

PURL Name (Default Hypersite) String True

The PURL Name (Default Hypersite) of the contact.

Lead Rating - Combined String False

The Lead Rating - Combined of the contact.

Email Address Domain String True

The Email Address Domain of the contact.

First and Last Name String True

The First and Last Name of the contact.

Company Size String False

The Company Size of the contact.

Lead Score - Last High Touch Event Date Date False

The Lead Score - Last High Touch Event Date of the contact.

Lead Rating - Profile (Explicit) String False

The Lead Rating - Profile (Explicit) of the contact.

Lead Rating - Engagement (Implicit) String False

The Lead Rating - Engagement (Implicit) of the contact.

Lead Score - Profile (Explicit) Double False

The Lead Score - Profile (Explicit) of the contact.

Lead Score - Engagement (Implicit) Double False

The Lead Score - Engagement (Implicit) of the contact.

Lead Score Date - Profile - Most Recent Date False

The Lead Score Date - Profile - Most Recent of the contact.

Employees Double False

The Employees of the contact.

Territory String False

The Territory of the contact.

Lead Score String False

The Lead Score of the contact.

PURL Name String True

The PURL Name of the contact.

MD5 Hashed Email Address String True

The MD5 Hashed Email Address of the contact.

SHA256 Hashed Email Address String True

The SHA256 Hashed Email Address of the contact.

MD5 Hashed Business Phone String True

The MD5 Hashed Business Phone of the contact.

SHA256 Hashed Business Phone String True

The SHA256 Hashed Business Phone of the contact.

MD5 Hashed Mobile Phone String True

The MD5 Hashed Mobile Phone of the contact.

SHA256 Hashed Mobile Phone String True

The SHA256 Hashed Mobile Phone of the contact of the contact.





ContactEmailSubscription

Retrieve all email group subscription status for the specific contact.

Columns

Name Type ReadOnly Description
ID [KEY] Long True

The unique identifier for Email Group.

ContactID [KEY] Long False

The unique identifier for the contact.

Name String True

The name of the email group.

Description String True

The description of the email group.

IsSubScribed Boolean False

The subscribed status.

The default value is false.

Permissions String True

The permissions of the email group.

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.





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.





Custom

Create and delete custom.

Columns

Name Type ReadOnly Description
Id [KEY] String False

The id of the custom.

Name String False

The name of the custom.

EmailAddressFieldId String False

The field id that contains the Email Address. Use the desired custom object field's negative id as the value for this parameter.

EventGroupByFieldId String False

The id of the field used to organize multiple sessions. Use the desired custom object field's negative id as the value for this parameter.

FolderId String True

The folder id of the folder which contains the custom.

Fields String False

Array consisting of custom field properties

Description String False

The description of the custom.

RecordCount Integer True

The amount of records within the custom.

CreatedAt Datetime True

Date the custom was created.

CreatedBy String True

The Id of the user who created the custom.

UpdatedAt Datetime True

Date the custom was last updated.

UpdatedBy String True

The Id of the user who last updated the custom.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
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_ContentSource String False

The raw HTML contentSorce for the content of the email.

HtmlContent_CssHeader String False

The raw HTML cssHeader for the content of the email.

HtmlContent_DocType String False

The raw HTML docType for the content of the email.

HtmlContent_DocumentDescription String False

The raw HTML documentDescription for the content of the email.

HtmlContent_HtmlBody String False

The raw HTML Body for the content of the email.

HtmlContent_MetaTags String True

The raw HTML metaTags for the content of the email.

HtmlContent_Root String False

The raw HTML root for the content of the email.

HtmlContent_SystemHeader String False

The raw HTML systemHeader for the content of the email.

HtmlContent_Type String False

The raw HTML type for the content of the email.

IsPlainTextEditable Boolean False

Identifies whether the email is plaintext editable.

IsTracked Boolean False

Identifies whether the email is tracked.

PlainText String False

The plaintext version of the email.

BouncebackEmail String False

The bounce-back email address.

ReplyToEmail String False

The email address in the reply-to line of the email.

ReplyToName String False

The name in the reply-to line of the email.

SenderEmail String False

The email address of the sender.

SenderName String False

The name of the sender.

SenderPlainTextOnly Boolean False

Identifies whether the plaintext version should be sent.

Subject String False

The subject of the email.

Description String False

The description of the email.

FolderId Long False

The Id of the folder for the email.

Permissions String False

The permissions of the email.

CreatedAt Datetime True

Date the email was created.

CreatedBy String True

The Id of the user who created the email.

AccessedAt Datetime False

Date the email was accessed.

CurrentStatus String False

The current status of the email.

Depth String False

The depth of the email.

UpdatedAt Datetime True

Date the email was updated.

UpdatedBy String True

The Id of the user who last updated the email.

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.





Event

Create and delete Event.

Columns

Name Type ReadOnly Description
Id [KEY] String False

The Id of the event.

Name String False

The name of the event.

EmailAddressFieldId String False

The field Id that contains the Email Address. Use the negative id of the desired custom object field as the value for this parameter.

EventGroupByFieldId String False

The Id of the field used to organize multiple sessions. Use the negative Id of the desired custom object field as the value for this parameter.

FolderId String True

The folder Id of the folder which contains the event.

Fields String False

Array consisting of event field properties.

Description String False

The description of the event.

RecordCount Integer True

The amount of records within the event.

CreatedAt Datetime True

Date the event was created.

CreatedBy String True

The Id of the user who created the event.

UpdatedAt Datetime True

Date the event was last updated.

UpdatedBy String True

The Id of the user who last updated the event.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
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.





ExternalActivity

Create and query External Activities.

Columns

Name Type ReadOnly Description
ID [KEY] Long True

The unique identifier of the external activity.

Type String False

The type of the external activity.

Name String False

The Name of the external activity.

ActivityType String False

The Type of external activity.

ContactId Long False

The Id of the contact who performed the external activity.

CampaignId Long False

The Id of the campaign associated with this external activity.

AssetName String False

The AssetName of the external activity.

AssetType String False

The AssetType of the external activity.

AssetId Long False

The AssetId of the external activity.

ActivityDate Datetime False

The Date of the external activity.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Depth String

The depth of information requested from Eloqua.





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.

CreatedAt Datetime True

Date the folder was created.

UpdatedAt Datetime True

Date the folder was last updated.

UpdatedBy String True

The Id of the user who last updated the folder.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
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.

FolderId Long False

The Id of the folder for the form.

SourceTemplatedId Long False

The Id of the source template of the form.

Permissions String False

The permissions of the form.

CreatedAt Datetime True

Date the form was created.

CreatedBy String True

The Id of the user who created the form.

CurrentStatus String False

The current status of the form.

UpdatedAt Datetime True

Date the form was last updated.

UpdatedBy String True

The Id of the user who last updated the form.

HtmlName String False

The HTML name of the form.

ProcessingType String False

The processing type of the data lookup for the form.

SubmitFailedLandingPageId Long False

The submit failed landing page Id of the form.

Html String False

The HTML of the form.

Style String False

The style of the form.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
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.

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.

MicrositeId Long False

The unique identifier for this page's microsite.

RefreshedAt Datetime False

Date the landing page was refreshed.

RelativePath String False

The relative path to the landing page.

Style String False

The style of the landing page.

Description String False

The description of the landing page.

FolderId Long False

The Id of the folder for the landing page

Permissions String False

The permissions list for the landing page.

CreatedAt Datetime True

Date the landing page was created.

CreatedBy String True

The Id of the user who created the landing page.

AccessedAt Datetime False

Date the landing page was accessed.

CurrentStatus String False

The current status of the landing page.

Depth String False

The depth of the landing page.

UpdatedAt Datetime True

Date the landing page was updated.

UpdatedBy String True

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

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.





ViewsBack To Top

  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. ContactSegmentData
  23. ContactSegmentFolder
  24. ContactView
  25. ContentSectionFolder
  26. Dependencies
  27. DynamicContent
  28. DynamicContentFolder
  29. EmailDeployment
  30. EmailFolder
  31. EmailFooterFolder
  32. EmailHeaderFolder
  33. ExternalType
  34. FieldMerge
  35. FieldMergeFolder
  36. FormElement
  37. FormFolder
  38. FormProcessingStep
  39. HyperlinkFolder
  40. Image
  41. ImageFolder
  42. ImportedFile
  43. ImportedFileFolder
  44. LandingPageFolder
  45. LeadScoringModel
  46. PageTag
  47. PageTagGroup
  48. Program
  49. Style
  50. Template
  51. TemplateCategory
  52. TrackedUrl
  53. User
  54. Visitor
  55. VisitorProfileField



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.
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.
EmailRecipientId String The Email Recipient Id associated with the email activity. Only supported in bulk mode.
SmtpErrorCode String The Smtp Error Code associated with the email activity. Only supported in bulk mode.
SmtpStatusCode String The Smtp Status Code associated with the email activity. Only supported in bulk mode.
SmtpMessage String The Smtp Message associated with the email activity. Only supported in bulk mode.
DeploymentId String The email deployment Id associated with the email activity. Only supported in bulk mode.
FirstName String The FirstName of the contact associated with the bounceback activity.
LastName String The LastName of the contact associated with the bounceback activity.
Company String The Company of the contact associated with the bounceback activity.
City String The City of the contact associated with the bounceback activity.
ContactCreatedAt Datetime The date and time the contact associated with the bounceback activity was created.
ContactModifiedAt Datetime The date and time the contact associated with the bounceback activity was created.
Address1 String The first line address of the contact associated with the bounceback activity.
Address2 String The second line address of the contact associated with the bounceback activity.
Title String The Title of the contact associated with the bounceback activity.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
ExportToken String The token returned from CreateExportDefinition. If Eloqua has not finished processing the request, the query will wait until the server has finished before returning data.
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.
FirstName String The FirstName of the contact associated with the email click-through activity.
LastName String The LastName of the contact associated with the email click-through activity.
Company String The Company of the contact associated with the email click-through activity.
City String The City of the contact associated with the email click-through activity.
ContactCreatedAt Datetime The date and time the contact associated with the email click-through activity was created.
ContactModifiedAt Datetime The date and time the contact associated with the email click-through activity was created.
Address1 String The first line address of the contact associated with the email click-through activity.
Address2 String The second line address of the contact associated with the email click-through activity.
Title String The Title of the contact associated with the email click-through activity.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
ExportToken String The token returned from CreateExportDefinition. If Eloqua has not finished processing the request, the query will wait until the server has finished before returning data.
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.
FirstName String The FirstName of the contact associated with the email open activity.
LastName String The LastName of the contact associated with the email open activity.
Company String The Company of the contact associated with the email open activity.
City String The City of the contact associated with the email open activity.
ContactCreatedAt Datetime The date and time the contact associated with the email open activity was created.
ContactModifiedAt Datetime The date and time the contact associated with the email open activity was created.
Address1 String The first line address of the contact associated with the email open activity.
Address2 String The second line address of the contact associated with the email open activity.
Title String The Title of the contact associated with the email open activity.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

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

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
ExportToken String The token returned from CreateExportDefinition. If Eloqua has not finished processing the request, the query will wait until the server has finished before returning data.
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.
FirstName String The FirstName of the contact associated with the email subscribe activity.
LastName String The LastName of the contact associated with the email subscribe activity.
Company String The Company of the contact associated with the email subscribe activity.
City String The City of the contact associated with the email subscribe activity.
ContactCreatedAt Datetime The date and time the contact associated with the email subscribe activity was created.
ContactModifiedAt Datetime The date and time the contact associated with the email subscribe activity was created.
Address1 String The first line address of the contact associated with the email subscribe activity.
Address2 String The second line address of the contact associated with the email subscribe activity.
Title String The Title of the contact associated with the email subscribe activity.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
ExportToken String The token returned from CreateExportDefinition. If Eloqua has not finished processing the request, the query will wait until the server has finished before returning data.
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.
FirstName String The FirstName of the contact associated with the email unsubscribe activity.
LastName String The LastName of the contact associated with the email unsubscribe activity.
Company String The Company of the contact associated with the email unsubscribe activity.
City String The City of the contact associated with the email unsubscribe activity.
ContactCreatedAt Datetime The date and time the contact associated with the email unsubscribe activity was created.
ContactModifiedAt Datetime The date and time the contact associated with the email unsubscribe activity was created.
Address1 String The first line address of the contact associated with the email unsubscribe activity.
Address2 String The second line address of the contact associated with the email unsubscribe activity.
Title String The Title of the contact associated with the email unsubscribe activity.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
ExportToken String The token returned from CreateExportDefinition. If Eloqua has not finished processing the request, the query will wait until the server has finished before returning data.
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.
FirstName String The FirstName of the contact associated with the form submit activity.
LastName String The LastName of the contact associated with the form submit activity.
Company String The Company of the contact associated with the form submit activity.
City String The City of the contact associated with the bounceback activity.
ContactCreatedAt Datetime The date and time the contact associated with the form submit activity was created.
ContactModifiedAt Datetime The date and time the contact associated with the form submit activity was created.
Address1 String The first line address of the contact associated with the form submit activity.
Address2 String The second line address of the contact associated with the form submit activity.
Title String The Title of the contact associated with the form submit activity.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
ExportToken String The token returned from CreateExportDefinition. If Eloqua has not finished processing the request, the query will wait until the server has finished before returning data.
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.
FirstName String The FirstName of the contact associated with the page view activity.
LastName String The LastName of the contact associated with the page view activity.
Company String The Company of the contact associated with the page view activity.
City String The City of the contact associated with the page view activity.
ContactCreatedAt Datetime The date and time the contact associated with the page view activity was created.
ContactModifiedAt Datetime The date and time the contact associated with the page view activity was created.
Address1 String The first line address of the contact associated with the page view activity.
Address2 String The second line address of the contact associated with the page view activity.
Title String The Title of the contact associated with the page view activity.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
ExportToken String The token returned from CreateExportDefinition. If Eloqua has not finished processing the request, the query will wait until the server has finished before returning data.
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.
FirstName String The FirstName of the contact associated with the Web visit activity.
LastName String The LastName of the contact associated with the Web visit activity.
Company String The Company of the contact associated with the Web visit activity.
City String The City of the contact associated with the Web visit activity.
ContactCreatedAt Datetime The date and time the contact associated with the Web visit activity was created.
ContactModifiedAt Datetime The date and time the contact associated with the Web visit activity was created.
Address1 String The first line address of the contact associated with the Web visit activity.
Address2 String The second line address of the contact associated with the Web visit activity.
Title String The Title of the contact associated with the Web visit activity.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
ExportToken String The token returned from CreateExportDefinition. If Eloqua has not finished processing the request, the query will wait until the server has finished before returning data.
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.





ContactSegmentData

Retrieve Eloqua Contact Segment Data.

Columns

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

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.





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.





LeadScoringModel

Query Lead Scoring Models.

Columns

Name Type Description
ID [KEY] Integer The unique identifier for the landing page.
Name String The name of the landing page.
Status String The status of the lead scoring model.
Rating String The rating of the lead scoring model.
ProfileScore String The profiles core of the lead scoring model.
EngagementScore String The engagement score of the lead scoring model.
Uri String The URI of the lead scoring model.
CreatedBy String The Id of the user who created the lead scoring model.
UpdatedBy String The Id of the user who updated the lead scoring model.
CreatedAt Timestamp Date the lead scoring model was created.
UpdatedAt Timestamp Date the lead scoring model was updated.

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.





VisitorProfileField

Retrieve all of the visitor profile fields.

Columns

Name Type Description
Id [KEY] Long The Id of the visitor profile field.
Type String The type of the visitor profile field.
name String The name of the visitor profile field.
DataType String The datatype of the visitor profile field.
InternalName String The internal name of the visitor profile field.
Length Long The length of the visitor profile 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.
Depth String The depth of information requested from Eloqua.