Eloqua integration summary

Stitch’s Eloqua integration replicates data using the Oracle Eloqua Marketing Cloud Service REST API and Eloqua bulk export API. Refer to the Replication section for a list of objects and the API Stitch uses to extract data from them.

Refer to the Schema section for a list of objects available for replication.

Eloqua feature snapshot

A high-level look at Stitch's Eloqua integration, including release status, useful links, and the features supported in Stitch.

STITCH
Release Status

Open Beta

 Supported By

Singer Community
Stitch Plan

Free

 Singer GitHub Repository

Eloqua Repository

DATA SELECTION
Table Selection

Supported

 Column Selection

Supported
REPLICATION SETTINGS
Anchor Scheduling

Supported

 Advanced Scheduling

Unsupported
Table-level Reset

Unsupported

 Configurable Replication Methods

Unsupported
TRANSPARENCY
Extraction Logs

Supported

 Loading Reports

Supported

Connecting Eloqua

Step 1: Add Eloqua as a Stitch data source

  1. Sign into your Stitch account.

  2. On the Stitch Dashboard page, click the Add Integration button.

  3. Click the Eloqua icon.

  4. Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.

    For example, the name “Stitch Eloqua” would create a schema called stitch_eloqua in the destination. Note: Schema names cannot be changed after you save the integration.

Step 2: Define the historical sync

The Sync Historical Data setting will define the starting date for your Eloqua integration. This means that data equal to or newer than this date will be replicated to your data warehouse.

Change this setting if you want to replicate data beyond Eloqua’s default setting of 1 year. For a detailed look at historical replication jobs, check out the Syncing Historical SaaS Data guide.

Step 3: Create a replication schedule

In the Replication Frequency section, you’ll create the integration’s replication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.

Eloqua integrations support the following replication scheduling methods:

To keep your row usage low, consider setting the integration to replicate less frequently. See the Understanding and Reducing Your Row Usage guide for tips on reducing your usage.

Step 4: Authorize Stitch to access Eloqua

  1. Next, you’ll be prompted to sign into your Eloqua account. Click Sign In to sign in.
  2. Enter your Eloqua credentials and click Sign In again.
  3. The next page will display the application (Stitch) requesting access to Eloqua. Click Sign In to continue.
  4. The next page will display the company and user you are currently logged into Eloqua as. Click Accept.
  5. After the authorization process is successfully completed, you’ll be directed back to Stitch.
  6. Click All Done.

Step 5: Set tables and columns to replicate

To complete the setup, you’ll need to select the tables and columns you want to replicate to your data warehouse.

Check out the Schema section to learn more about the available tables in Eloqua and how they replicate.

  1. In the list of tables that displays - or in the Tables to Replicate tab, if you skipped this step during setup - locate a table you want to replicate.

  2. To track a table, click the checkbox next to the table’s name. A green checkmark means the table is set to replicate.

  3. To track a column, click the checkbox next to the column’s name. A green checkmark means the column is set to replicate.

  4. Repeat this process for all the tables and columns you want to replicate.
  5. When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.

Note: If you change these settings while a replication job is still in progress, they will not be used until the next job starts.

Initial and historical replication jobs

After you finish setting up Eloqua, its Sync Status may show as Pending on either the Stitch Dashboard or in the Integration Details page.

For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial replication job for the integration. This may take some time to complete.

Free historical data loads

The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.

Eloqua Replication

In this section:

Tables using the Eloqua Bulk API

Stitch uses the Eloqua Bulk API to replicate data for the following tables:

Tables using the Eloqua REST API

Stitch uses the Eloqua Application REST API to replicate data for the following tables:

Custom objects and fields

Stitch’s Eloqua integration supports replicating custom fields and objects.

For each custom object in your Eloqua account, Stitch will display a table as available for selection. The name of the table will be the normalized name of the object, using snake case (spaces replaced with underscores) and removing special characters. For example: If your account contains an Enrichement Attributes custom object, there will be a corresponding enrichment_attributes available for selection in Stitch.

Eloqua table schemas

accounts

Replication Method :

Key-based Incremental

 Replication Key :

UpdatedAt
Primary Key :

Id

 API endpoint :

Bulk: Create an account export definition

The accounts table contains info about the accounts, or companies, in your Eloqua account.

Note: This table is replicated using the Eloqua Bulk API.

Custom accounts fields

If applicable, Stitch will replicate custom fields related to accounts in Eloqua.

accounts table schema

Id
STRING

The account ID.

UpdatedAt
DATE-TIME

The Unix timestamp for the date and time the account was last updated.

CompanyIDExt
STRING

CreatedAt
DATE-TIME

The date and time the account was created, expressed in Unix time.

Custom Fields
VARIES

Custom fields associated with accounts in your Eloqua account.

activity_bounceback

Replication Method :

Key-based Incremental

 Replication Key :

updatedAt
Primary Key :

id

 API endpoint :

Bulk: Create an activity export definition

The activity_bounceback table contains info about Bounceback contact activities.

Note: This table is replicated using the Eloqua Bulk API.

activity_bounceback table schema

id
STRING

The bounceback activity ID.

updatedAt
DATE-TIME

The Unix timestamp for the date and time the activity was last updated.

ActivityId
STRING

The activity ID.

ActivityType
STRING

The type of the activity. This value will be Bounceback.

ActivityDate
DATE-TIME

The date the activity was performed expressed in 10 digit integer Unix time.

AssetId
STRING

The ID of the associated asset.

AssetName
STRING

The name of the associated asset.

AssetType
STRING

The type of the associated asset.

CampaignId
INTEGER

The ID of the campaign associated with the activity.

Reference:

ContactId
STRING

The ID of the contact associated with the activity.

Reference:

EmailAddress
STRING

The email address of the contact who performed the activity.

EmailRecipientId
STRING

The recipient ID associated with the activity.

ExternalId
STRING

The GUID of the visitor who performed the activity.

DeploymentId
STRING

The ID of the email deployment for an email activity.

SmtpErrorCode
STRING

The SMTP status code for the email bounceback.

SmtpStatusCode
STRING

The SMTP response code for the email bounceback.

Type
STRING

The asset’s type in Eloqua.

activity_email_clickthrough

Replication Method :

Key-based Incremental

 Replication Key :

updatedAt
Primary Key :

id

 API endpoint :

Bulk: Create an activity export definition

The activity_email_clickthrough table contains info about EmailClickthrough contact activities.

Note: This table is replicated using the Eloqua Bulk API.

activity_email_clickthrough table schema

id
STRING

The email clickthrough activity ID.

updatedAt
DATE-TIME

The Unix timestamp for the date and time the activity was last updated.

ActivityDate
DATE-TIME

The date the activity was performed expressed in 10 digit integer Unix time.

ActivityId
STRING

The unique identifier of the activity per activity type.

ActivityType
STRING

The type of the activity. This value will be EmailClickthrough.

AssetId
STRING

The ID of the associated asset.

AssetName
STRING

The name of the associated asset.

AssetType
STRING

The type of the associated asset.

CampaignId
INTEGER

The ID of the campaign associated with the activity.

Reference:

ContactId
STRING

The ID of the contact associated with the activity.

Reference:

EmailAddress
STRING

The email address of the contact who performed the activity.

EmailClickedThruLink
STRING

The link clicked through for an activity.

EmailRecipientId
STRING

The recipient ID associated with the activity.

EmailSendType
STRING

The type of email send for an email activity. Possible values include:

  • BatchWizard
  • Quicksend
  • SOAPAPI
  • Salestools
  • FormProcessingStep
  • DCOServicesStep
  • ExternalTest
  • TestCenter
  • Deliverability
  • LowVolumeAPI
  • Campaign

EmailWebLink
STRING

The link for viewing the email in a web browser window for an email activity.

ExternalId
STRING

The GUID of the visitor who performed the activity.

DeploymentId
STRING

The ID of the email deployment for an email activity.

IpAddress
STRING

The IP address of the visitor who performed the activity.

SubjectLine
STRING

The subject line for an email activity.

Type
STRING

The asset’s type in Eloqua.

VisitorId
STRING

The ID of the visitor who performed the activity.

VisitorExternalId
STRING

The GUID of the visitor who performed the activity.

activity_email_open

Replication Method :

Key-based Incremental

 Replication Key :

updatedAt
Primary Key :

id

 API endpoint :

Bulk: Create an activity export definition

The activity_email_open table contains info about EmailOpen contact activities.

Note: This table is replicated using the Eloqua Bulk API.

activity_email_open table schema

id
STRING

The activity ID.

updatedAt
DATE-TIME

The Unix timestamp for the date and time the activity was last updated.

ActivityDate
DATE-TIME

The date the activity was performed expressed in 10 digit integer Unix time.

ActivityType
STRING

The type of the activity. This value will be EmailOpen.

AssetId
STRING

The ID of the associated asset.

AssetName
STRING

The name of the associated asset.

AssetType
STRING

The type of the associated asset.

CampaignId
INTEGER

The ID of the campaign associated with the activity.

Reference:

ContactId
STRING

The ID of the contact associated with the activity.

Reference:

EmailAddress
STRING

The email address of the contact who performed the activity.

EmailRecipientId
STRING

The recipient ID associated with the activity.

EmailWebLink
STRING

The link for viewing the email in a web browser window for an email activity.

ExternalId
STRING

The GUID of the visitor who performed the activity.

DeploymentId
STRING

The ID of the email deployment for an email activity.

IpAddress
STRING

The IP address of the visitor who performed the activity.

Type
STRING

The asset’s type in Eloqua.

VisitorId
STRING

The ID of the visitor who performed the activity.

VisitorExternalId
STRING

The GUID of the visitor who performed the activity.

activity_email_send

Replication Method :

Key-based Incremental

 Replication Key :

updatedAt
Primary Key :

id

 API endpoint :

Bulk: Create an activity export definition

The activity_email_send table contains info about EmailSend contact activities.

Note: This table is replicated using the Eloqua Bulk API.

activity_email_send table schema

id
STRING

The activity ID.

updatedAt
DATE-TIME

The Unix timestamp for the date and time the activity was last updated.

ActivityDate
DATE-TIME

The date the activity was performed expressed in 10 digit integer Unix time.

ActivityId
STRING

The unique identifier of the activity per activity type.

ActivityType
STRING

The type of the activity. This value will be EmailSend.

AssetId
STRING

The ID of the associated asset.

AssetName
STRING

The name of the associated asset.

AssetType
STRING

The type of the associated asset.

CampaignId
INTEGER

The ID of the campaign associated with the activity.

Reference:

ContactId
STRING

The ID of the contact associated with the activity.

Reference:

EmailAddress
STRING

The email address of the contact who performed the activity.

EmailRecipientId
STRING

The recipient ID associated with the activity.

EmailSendType
STRING

The type of email send for an email activity. Possible values include:

  • BatchWizard
  • Quicksend
  • SOAPAPI
  • Salestools
  • FormProcessingStep
  • DCOServicesStep
  • ExternalTest
  • TestCenter
  • Deliverability
  • LowVolumeAPI
  • Campaign

EmailWebLink
STRING

The link for viewing the email in a web browser window for an email activity.

ExternalId
STRING

The GUID of the visitor who performed the activity.

DeploymentId
STRING

The ID of the email deployment for an email activity.

SubjectLine
STRING

The subject line for an email activity.

Type
STRING

The asset’s type in Eloqua.

activity_form_submit

Replication Method :

Key-based Incremental

 Replication Key :

updatedAt
Primary Key :

id

 API endpoint :

Bulk: Create an activity export definition

The activity_form_submit table contains info about FormSubmit contact activities.

Note: This table is replicated using the Eloqua Bulk API.

activity_form_submit table schema

id
STRING

The activity ID.

updatedAt
DATE-TIME

The Unix timestamp for the date and time the activity was last updated.

ActivityDate
DATE-TIME

The date the activity was performed expressed in 10 digit integer Unix time.

ActivityType
STRING

The type of the activity. This value will be FormSubmit.

AssetId
STRING

The ID of the associated asset.

AssetName
STRING

The name of the associated asset.

AssetType
STRING

The type of the associated asset.

CampaignId
INTEGER

The ID of the campaign associated with the activity.

Reference:

ContactId
STRING

The ID of the contact associated with the activity.

Reference:

ExternalId
STRING

The GUID of the visitor who performed the activity.

RawData
STRING

The raw data submitted with a FormSubmit activity. Includes the HTML field name and the submitted values in a query string format.

Type
STRING

The asset’s type in Eloqua.

VisitorId
STRING

The ID of the visitor who performed the activity.

VisitorExternalId
STRING

The GUID of the visitor who performed the activity.

activity_page_view

Replication Method :

Key-based Incremental

 Replication Key :

updatedAt
Primary Key :

id

 API endpoint :

Bulk: Create an activity export definition

The activity_page_view table contains info about PageView contact activities.

Note: This table is replicated using the Eloqua Bulk API.

activity_page_view table schema

id
STRING

The activity ID.

updatedAt
DATE-TIME

The Unix timestamp for the date and time the activity was last updated.

ActivityDate
DATE-TIME

The date the activity was performed expressed in 10 digit integer Unix time.

ActivityId
STRING

The unique identifier of the activity per activity type.

ActivityType
STRING

The type of the activity. This value will be PageView.

AssetId
STRING

The ID of the associated asset.

AssetName
STRING

The name of the associated asset.

AssetType
STRING

The type of the associated asset.

CampaignId
INTEGER

The ID of the campaign associated with the activity.

Reference:

ContactId
STRING

The ID of the contact associated with the activity.

Reference:

ExternalId
STRING

The GUID of the visitor who performed the activity.

IpAddress
STRING

The IP address of the visitor who performed the activity.

Type
STRING

The asset’s type in Eloqua.

Url
STRING

The URL viewed with a PageView activity.

VisitorId
STRING

The ID of the visitor who performed the activity.

VisitorExternalId
STRING

The GUID of the visitor who performed the activity.

WebVisitId
STRING

The ID of the WebVisit associated with a PageView activity.

activity_subscribe

Replication Method :

Key-based Incremental

 Replication Key :

updatedAt
Primary Key :

id

 API endpoint :

Bulk: Create an activity export definition

The activity_subscribe table contains info about Subscribe contact activities.

Note: This table is replicated using the Eloqua Bulk API.

activity_subscribe table schema

id
STRING

The activity ID.

updatedAt
DATE-TIME

The Unix timestamp for the date and time the activity was last updated.

ActivityDate
DATE-TIME

The date the activity was performed expressed in 10 digit integer Unix time.

ActivityId
STRING

The unique identifier of the activity per activity type.

ActivityType
STRING

The type of the activity. This value will be Subscribe.

AssetId
STRING

The ID of the associated asset.

AssetName
STRING

The name of the associated asset.

AssetType
STRING

The type of the associated asset.

CampaignId
INTEGER

The ID of the campaign associated with the activity.

Reference:

ContactId
STRING

The ID of the contact associated with the activity.

Reference:

EmailAddress
STRING

The email address of the contact who performed the activity.

EmailRecipientId
STRING

The recipient ID associated with the activity.

ExternalId
STRING

The GUID of the visitor who performed the activity.

Type
STRING

The asset’s type in Eloqua.

activity_unsubscribe

Replication Method :

Key-based Incremental

 Replication Key :

updatedAt
Primary Key :

id

 API endpoint :

Bulk: Create an activity export definition

The activity_unsubscribe table contains info about Unsubscribe contact activities.

Note: This table is replicated using the Eloqua Bulk API.

activity_unsubscribe table schema

id
STRING

The activity ID.

updatedAt
DATE-TIME

The Unix timestamp for the date and time the activity was last updated.

ActivityDate
DATE-TIME

The date the activity was performed expressed in 10 digit integer Unix time.

ActivityId
STRING

The unique identifier of the activity per activity type.

ActivityType
STRING

The type of the activity. This value will be Unsubscribe.

AssetId
STRING

The ID of the associated asset.

AssetName
STRING

The name of the associated asset.

AssetType
STRING

The type of the associated asset.

CampaignId
INTEGER

The ID of the campaign associated with the activity.

Reference:

ContactId
STRING

The ID of the contact associated with the activity.

Reference:

EmailAddress
STRING

The email address of the contact who performed the activity.

EmailRecipientId
STRING

The recipient ID associated with the activity.

ExternalId
STRING

The GUID of the visitor who performed the activity.

Type
STRING

The asset’s type in Eloqua.

activity_web_visit

Replication Method :

Key-based Incremental

 Replication Key :

updatedAt
Primary Key :

id

 API endpoint :

Bulk: Create an activity export definition

The activity_web_visit table contains info about WebVisit contact activities.

Note: This table is replicated using the Eloqua Bulk API.

activity_web_visit table schema

id
STRING

The activity ID.

updatedAt
DATE-TIME

The Unix timestamp for the date and time the activity was last updated.

ActivityDate
DATE-TIME

The date the activity was performed expressed in 10 digit integer Unix time.

ActivityType
STRING

The type of the activity. The value of this field will correspond with the suffix in the table’s name. For example: If the table is namedactivity_web_visit, this value would be WebVisit.

AssetId
STRING

The ID of the associated asset.

AssetType
STRING

The type of the associated asset.

ContactId
STRING

The ID of the contact associated with the activity.

Reference:

Type
STRING

The asset’s type in Eloqua.

assets

View table schema on GitHub
Replication Method :

Key-based Incremental

 Replication Key :

updatedAt
Primary Key :

id

 API endpoint :

Retrieve a list of external assets

The assets table contains info about the external assets associated with your Eloqua account. External assets are non-Eloqua, or offline, activities performed by your contacts or prospects.

Note: This table is replicated using the Eloqua Application REST API.

assets table schema

id
STRING

The ID of the external asset.

Reference:

updatedAt
DATE-TIME

The Unix timestamp for the date and time the external asset was last updated.

accessedAt
DATE-TIME

The date and time the external asset was last accessed, expressed in Unix time.

createdAt
DATE-TIME

The date and time the external asset was created, expressed in Unix time.

createdBy
STRING

The login ID of the user who created the external asset.

currentStatus
STRING

The external asset’s current status.

depth
STRING

Level of detail returned by the request. Eloqua APIs can retrieve entities at three different levels of depth: minimal, partial, and complete. Any other values passed are reset to complete by default. Refer to Eloqua’s documentation for more info.

description
STRING

The description of the external asset.

externalAssetTypeId
STRING

The ID of the external asset type.

folderId
STRING

The ID of the folder that contains the external asset.

name
STRING

The name of the external asset.

permissions
ARRAY

The permissions for the external asset granted to your current instance.

Click to expand permissions

value
STRING

The permission for the external asset.
assets (table), permissions (attribute)

scheduledFor
STRING

The date the external asset is scheduled.

sourceTemplateId
STRING

The ID of the template used to create the external asset.

type
STRING

The asset’s type in Eloqua.

updatedBy
STRING

The ID of the user that last updated the external asset.

campaigns

View table schema on GitHub
Replication Method :

Key-based Incremental

 Replication Key :

updatedAt
Primary Key :

id

 API endpoint :

Retrieve a list of campaigns

The campaigns table contains info about the campaigns in your Eloqua account. Campaigns are comprised of different elements (such as segments, emails, landing pages, etc.) that are used to perform a variety of functions.

Note: This table is replicated using the Eloqua Application REST API.

campaigns table schema

id
STRING

The campaign ID.

Reference:

updatedAt
DATE-TIME

The Unix timestamp for the date and time the campaign was last updated.

accessedAt
DATE-TIME

The date and time the campaign was last accessed, expressed in Unix time.

actualCost
STRING

The campaign’s actual cost.

badgeId
STRING

The badge ID of the campaign.

budgetedCost
STRING

The campaign’s projected cost.

campaignCategory
STRING

Defines whether a campaign is simple or multi-step. Possible values are:

  • emailMarketing - Used for simple campaigns
  • contact - Used for multi-step campaigns

campaignType
STRING

The campaign’s type.

clrEndDate
DATE-TIME

The end date of the clr.

createdAt
DATE-TIME

The date and time the campaign was created, expressed in Unix time.

createdBy
STRING

The ID of the user who created the campaign.

crmId
STRING

The ID of the customer relationship management application.

currentStatus
STRING

The campaign’s current status. Possible values are:

  • Active
  • Draft
  • Scheduled
  • Completed

depth
STRING

Level of detail returned by the request. Eloqua APIs can retrieve entities at three different levels of depth: minimal, partial, and complete. Any other values passed are reset to complete by default. Refer to Eloqua’s documentation for more info.

description
STRING

The description of the campaign.

endAt
DATE-TIME

The date and time the campaign will end.

firstActivation
DATE-TIME

The date and time the campaign was originally activated.

folderId
STRING

The ID of the folder containing the campaign.

isEmailMarketingCampaign
STRING

Indicates whether the campaign is an email marketing campaign.

isIncludedInROI
STRING

Indicates whether the campaign is included in return on investment.

isMemberAllowedReEntry
STRING

Indicates whether members are allowed to re-enter the campaign.

isReadOnly
STRING

Indicates whether the campaign is read only.

isSyncedWithCRM
STRING

Indicates whether the campaign is synced with a customer relationship management application.

memberCount
STRING

The amount of members in the campaign.

name
STRING

The name of the campaign.

permissions
ARRAY

The permissions for the campaign granted to your current instance.

Click to expand permissions

value
STRING

The permission for the campaign.
campaigns (table), permissions (attribute)

product
STRING

The campaign’s product value.

region
STRING

The campaign’s region value.

runAsUserId
STRING

The ID of the user to activate the campaign.

scheduledFor
DATE-TIME

The date the campaign is scheduled.

sourceTemplateId
STRING

The ID of the template used to create the asset.

startAt
DATE-TIME

The date time for which the campaign will activate.

type
STRING

The asset’s type in Eloqua.

updatedBy
STRING

The ID of the user that last updated the campaign.

contacts

Replication Method :

Key-based Incremental

 Replication Key :

UpdatedAt
Primary Key :

Id

 API endpoint :

Bulk: Create a contact export definition

The contacts table contains info the contacts in your Eloqua account.

Note: This table is replicated using the Eloqua Bulk API.

Custom contacts fields

If applicable, Stitch will replicate custom fields related to contacts in Eloqua.

contacts table schema

Id
STRING

The contact ID.

Reference:

UpdatedAt
DATE-TIME

The Unix timestamp for the date and time the contact was last updated.

ContactIDExt
STRING

CreatedAt
DATE-TIME

The date and time the contact was created, expressed in Unix time.

Custom Fields
VARIES

Custom fields associated with accounts in your Eloqua account.

Custom Objects

Replication Method :

Key-based Incremental

 Replication Key :

UpdatedAt
Primary Key :

id

 API endpoint :

Bulk: Create an export definition for a custom object

For each custom object in your Eloqua account, Stitch will display a table as available for selection. The name of the table will be the normalized name of the object, using snake case (spaces replaced with underscores) and removing special characters. For example: If your account contains an Enrichement Attributes custom object, there will be a corresponding enrichment_attributes available for selection in Stitch.

Note: This table is replicated using the Eloqua Bulk API.

Custom Objects table schema

id
STRING

The custom object ID.

UpdatedAt
DATE-TIME

The Unix timestamp for the date and time the record was last updated.

CreatedAt
DATE-TIME

The date and time the record was created, expressed in Unix time.

DataCardIDExt
STRING

Custom Fields
VARIES

The fields associated with the custom object in your Eloqua account.

emails

View table schema on GitHub
Replication Method :

Key-based Incremental

 Replication Key :

updatedAt
Primary Key :

id

 API endpoint :

Retrieve a list of emails

The emails table contains details about the emails sent from your Eloqua account.

Note: This table is replicated using the Eloqua Application REST API.

emails table schema

id
STRING

The email ID.

updatedAt
DATE-TIME

The Unix timestamp for the date and time the email was last updated.

accessedAt
DATE-TIME

The date and time the email was last accessed, expressed in Unix time.

archive
BOOLEAN

bounceBackEmail
STRING

The email address which is notified if the email is undeliverable.

createdAt
DATE-TIME

The date and time the email was created, expressed in Unix time.

createdBy
STRING

The ID of the user who created the email.

currentStatus
STRING

The asset’s current status.

depth
STRING

Level of detail returned by the request. Eloqua APIs can retrieve entities at three different levels of depth: minimal, partial, and complete. Any other values passed are reset to complete by default. Refer to Eloqua’s documentation for more info.

description
STRING

The description of the email.

dynamicContents
ARRAY

A list of associated dynamic content.

Click to expand dynamicContents

createdAt
DATE-TIME

The date and time the dynamic content was created, expressed in Unix time.

createdBy
STRING

The ID of the user who created the dynamic content.

currentStatus
STRING

The dynamic content’s current status.

defaultContentSection
STRING

depth
STRING

Level of detail returned by the request. Eloqua APIs can retrieve entities at three different levels of depth: minimal, partial, and complete. Any other values passed are reset to complete by default. Refer to Eloqua’s documentation for more info.

description
STRING

The description of the dynamic content.

folderId
STRING

id
STRING

The dynamic content ID.

name
STRING

The name of the dynamic content.

permissions
STRING

The permissions for the dynamic content granted to your current instance.

rules
STRING

The dynamic content’s rules.

type
STRING

The asset’s type in Eloqua.

updatedAt
DATE-TIME

The Unix timestamp for the date and time the dynamic content was last updated.

updatedBy
STRING

The ID of the user that last updated the dynamic content.
emails (table), dynamicContents (attribute)

emailFooterId
STRING

The ID of the email footer.

emailGroupId
STRING

The ID of the email group.

emailHeaderId
STRING

The ID of the email header.

encodingId
STRING

The ID of the encoding used.

fieldMerges
ARRAY

A list of associated field merges.

Click to expand fieldMerges

accessedAt
DATE-TIME

The date and time the field merge was last accessed, expressed in Unix time.

allowUrlsInValue
STRING

contactFieldId
STRING

The ID of the associated contact field.

createdAt
DATE-TIME

The date and time the field merge was created, expressed in Unix time.

createdBy
STRING

The ID of the user who created the field merge.

defaultValue
STRING

The default value of the field merge.

depth
STRING

Level of detail returned by the request. Eloqua APIs can retrieve entities at three different levels of depth: minimal, partial, and complete. Any other values passed are reset to complete by default. Refer to Eloqua’s documentation for more info.

description
STRING

The description of the campaign.

eventFieldId
STRING

The ID of the associated event field.

eventId
STRING

The ID of the associated event.

eventSessionFieldId
STRING

The ID of the associated event session field.

id
STRING

The ID of the field merge.

mergeType
STRING

The type of the field merge. Possible values include:

  • contactField
  • accountField
  • eventField
  • eventSessionField
  • customObjectField

name
STRING

The name of the field merge.

permissions
STRING

The permissions for the field merge granted to your current instance.

syntax
STRING

The syntax of the field merge.

type
STRING

The asset’s type in Eloqua.

updatedAt
DATE-TIME

The Unix timestamp for the date and time the field merge was last updated.

updatedBy
STRING

The ID of the user that last updated the field merge.
emails (table), fieldMerges (attribute)

files
ARRAY

A list of imported files.

Click to expand files

accessedAt
DATE-TIME

The date and time the imported file was last accessed, expressed in Unix time.

createdAt
DATE-TIME

The date and time the imported file was created, expressed in Unix time.

createdBy
STRING

The ID of the user who created the imported file.

currentStatus
STRING

The imported file’s current status.

depth
STRING

Level of detail returned by the request. Eloqua APIs can retrieve entities at three different levels of depth: minimal, partial, and complete. Any other values passed are reset to complete by default. Refer to Eloqua’s documentation for more info.

description
STRING

The description of the imported file.

fileName
STRING

The file name of the imported file.

id
STRING

The imported file ID.

link
STRING

The imported file’s complete URL.

name
STRING

The name of the imported file.

permissions
STRING

The permissions for the imported file granted to your current instance.

trackedLink
STRING

The imported file’s tracked complete URL.

type
STRING

The asset’s type in Eloqua.

updatedAt
DATE-TIME

The Unix timestamp for the date and time the imported file was last updated.

updatedBy
STRING

The ID of the user that last updated the imported file.
emails (table), files (attribute)

forms
ARRAY

A list of associated Form assets.

Click to expand forms

accessedAt
DATE-TIME

The date and time the form was last accessed, expressed in Unix time.

createdAt
DATE-TIME

The date and time the form was created, expressed in Unix time.

createdBy
STRING

The ID of the user who created the form.

currentStatus
STRING

The form’s current status. For example: draft, active, or complete.

depth
STRING

Level of detail returned by the request. Eloqua APIs can retrieve entities at three different levels of depth: minimal, partial, and complete. Any other values passed are reset to complete by default. Refer to Eloqua’s documentation for more info.

description
STRING

The description of the form.

elements
ARRAY

A list of form elements.

Click to expand elements

accessedAt
DATE-TIME

The date and time the form element was last accessed, expressed in Unix time.

createdAt
DATE-TIME

The date and time the form element was created, expressed in Unix time.

createdBy
STRING

The ID of the user who created the form element.

currentStatus
STRING

The form element’s current status. For example: draft, active, or complete.

depth
STRING

Level of detail returned by the request. Eloqua APIs can retrieve entities at three different levels of depth: minimal, partial, and complete. Any other values passed are reset to complete by default. Refer to Eloqua’s documentation for more info.

description
STRING

The description of the form element.

id
STRING

The form element ID.

instructions
STRING

The form element’s field instructions. Field instructions are optional instructions that help users fill in fields.

name
STRING

The name of the form element.

permissions
STRING

The permissions for the form element granted to your current instance.

style
STRING

The asset’s main layout style.

type
STRING

The asset’s type in Eloqua.

updatedAt
DATE-TIME

The Unix timestamp for the date and time the form element was last updated.

updatedBy
STRING

The ID of the user that last updated the form element.
emails (table), elements (attribute)

emailAddressFormField
STRING

The email address form field entity’s unique identifier.

html
STRING

The asset’s raw HTML content.

id
STRING

The form ID.

Reference:

isHidden
STRING

Indicates whether the form is hidden or not.

name
STRING

The name of the form.

permissions
STRING

The permissions for the form granted to your current instance.

processingSteps
ARRAY

A list of the form’s processing steps.

processingType
STRING

A list of the form’s processing types. For example: externalEmail, externalWebsite, internallyHosted, internalAgentProxyForm.

style
STRING

The asset’s main layout style.

submitFailedLandingPageId
STRING

The landing page ID of the failed submit.

type
STRING

The asset’s type in Eloqua.

updatedAt
DATE-TIME

The Unix timestamp for the date and time the form was last updated.

updatedBy
STRING

The ID of the user that last updated the form.
emails (table), forms (attribute)

htmlContent
OBJECT

Details about the HTML content in the email.

Click to expand htmlContent

contentSource
STRING

cssHeader
STRING

docType
STRING

documentDescription
STRING

html
STRING

htmlBody
STRING

metaTags
ARRAY

Click to expand metaTags

value
STRING

emails (table), metaTags (attribute)

root
STRING

systemHeader
STRING

type
STRING

emails (table), htmlContent (attribute)

hyperlinks
ARRAY

A list of hyperlinks contained within the email.

Click to expand hyperlinks

createdAt
DATE-TIME

The date and time the hyperlink was created, expressed in Unix time.

createdBy
STRING

The ID of the user who created the hyperlink.

depth
STRING

Level of detail returned by the request. Eloqua APIs can retrieve entities at three different levels of depth: minimal, partial, and complete. Any other values passed are reset to complete by default. Refer to Eloqua’s documentation for more info.

folderId
STRING

The ID of the folder containing the hyperlink asset.

href
STRING

The href value of the hyperlink.

hyperlinkType
STRING

The type of hyperlink. Possible values include:

  • ExternalURL
  • ICSCalendarURL
  • LandingPageURL
  • ReferrerURL
  • RSSURL
  • TrackedExternalURL

id
STRING

The hyperlink ID.

name
STRING

The name of the hyperlink.

referencedEntityId
STRING

The ID of the referenced entity.

type
STRING

The asset’s type in Eloqua.

updatedAt
DATE-TIME

The Unix timestamp for the date and time the hyperlink was last updated.

updatedBy
STRING

The ID of the user that last updated the hyperlink.
emails (table), hyperlinks (attribute)

images
ARRAY

A list of associated Image assets.

Click to expand images

createdAt
DATE-TIME

The date and time the image was created, expressed in Unix time.

createdBy
STRING

The ID of the user who created the image.

currentStatus
STRING

The image’s current status.

depth
STRING

Level of detail returned by the request. Eloqua APIs can retrieve entities at three different levels of depth: minimal, partial, and complete. Any other values passed are reset to complete by default. Refer to Eloqua’s documentation for more info.

folderId
STRING

The ID of the folder containing the image.

fullImageUrl
STRING

The image’s complete URL.

id
STRING

The image ID.

name
STRING

The name of the image.

permissions
STRING

The permissions for the image granted to your current instance.

size
STRING

syncDate
DATE-TIME

thumbnailUrl
STRING

The image’s thumbnail URL.

type
STRING

The asset’s type in Eloqua.

updatedAt
DATE-TIME

The Unix timestamp for the date and time the image was last updated.

updatedBy
STRING

The ID of the user that last updated the image.
emails (table), images (attribute)

isContentProtected
BOOLEAN

Indicates whether the asset’s content is protected.

isPlainTextEditable
STRING

Indicates whether the asset’s text is editable.

isPrivate
BOOLEAN

isTracked
STRING

Indicates whether Eloqua will track the asset.

landingPages
ARRAY

A list of associated landing page assets.

layout
STRING

The email’s main layout.

name
STRING

The name of the email.

permissions
STRING

The permissions for the email granted to your current instance.

plainText
STRING

The email’s content in plain text.

renderMode
STRING

replyToEmail
STRING

The email address targeted when recipients click ‘reply’.

replyToName
STRING

The sender name recipients of the email will see.

sendPlainTextOnly
STRING

Indicates whether the sent email is plain text only.

senderEmail
STRING

The address the email will appear to be sent from.

senderName
STRING

The sender name recipients of the email will see.

sourceTemplateId
STRING

The ID of the template used to create the asset.

style
STRING

The email’s main layout style.

subject
STRING

The email’s subject line text.

type
STRING

The asset’s type in Eloqua.

updatedBy
STRING

The ID of the user that last updated the email.

virtualMTAId
STRING

forms

View table schema on GitHub
Replication Method :

Key-based Incremental

 Replication Key :

updatedAt
Primary Key :

id

 API endpoint :

Retrieve a list of forms

The forms table contains info about the forms in your Eloqua account.

Note: This table is replicated using the Eloqua Application REST API.

forms table schema

id
STRING

The form ID.

Reference:

updatedAt
DATE-TIME

The Unix timestamp for the date and time the form was last updated.

accessedAt
DATE-TIME

The date and time the form was last accessed, expressed in Unix time.

createdAt
DATE-TIME

The date and time the form was created, expressed in Unix time.

createdBy
STRING

The ID of the user who created the form.

currentStatus
STRING

The form’s current status. For example: draft, active, or complete.

customCSS
STRING

defaultKeyFieldMapping
STRING

depth
STRING

Level of detail returned by the request. Eloqua APIs can retrieve entities at three different levels of depth: minimal, partial, and complete. Any other values passed are reset to complete by default. Refer to Eloqua’s documentation for more info.

description
STRING

The description of the form.

elements
ARRAY

A list of elements associated with the form.

Click to expand elements

altText
STRING

createdFromContactFieldId
STRING

dataType
STRING

depth
STRING

Level of detail returned by the request. Eloqua APIs can retrieve entities at three different levels of depth: minimal, partial, and complete. Any other values passed are reset to complete by default. Refer to Eloqua’s documentation for more info.

displayType
STRING

fieldMergeId
STRING

fields
STRING

htmlName
STRING

id
STRING

The form element ID.

instructions
STRING

The form element’s field instructions. Field instructions are optional instructions that help users fill in fields.

name
STRING

numberOfFieldsToDisplay
STRING

onlyShowIncompleteFields
STRING

optionListId
STRING

randomizeFields
STRING

style
STRING

type
STRING

useGlobalSubscriptionStatus
STRING

validations
STRING

forms (table), elements (attribute)

emailAddressFormFieldId
STRING

The form element’s field instructions. Field instructions are optional instructions that help users fill in fields.

folderId
STRING

html
STRING

The asset’s raw HTML content.

htmlName
STRING

The asset’s raw HTML name.

name
STRING

The name of the form.

permissions
STRING

The permissions for the form granted to your current instance.

processingSteps
ARRAY

A list of the form’s processing steps.

Click to expand processingSteps

allowResend
BOOLEAN

campaignElementId
STRING

campaignId
STRING

description
STRING

emailAddressFormFieldId
STRING

emailId
STRING

eventId
STRING

execute
STRING

id
STRING

keyFieldId
STRING

keyFieldMapping
STRING

landingPageId
STRING

mappings
STRING

name
STRING

resendLimit
INTEGER

type
STRING

forms (table), processingSteps (attribute)

processingType
STRING

A list of the form’s processing types. For example: externalEmail, externalWebsite, internallyHosted, internalAgentProxyForm.

size
STRING

style
STRING

The asset’s main layout style.

submitFailedLandingPageId
STRING

The landing page ID of the failed submit.

type
STRING

The asset’s type in Eloqua.

updatedBy
STRING

The ID of the user that last updated the form.

visitors

View table schema on GitHub
Replication Method :

Key-based Incremental

 Replication Key :

V_LastVisitDateAndTime
Primary Key :

id

 API endpoint :

Retrieve visitor data

The visitors table contains info about your Eloqua visitors. According to Eloqua, “A visitor is a data entity that represents a unique cookie. The tracked activity data from that cookie is associated with the Visitor. There can be multiple visitors linked to a single contact.”

Note: This table is replicated using the Eloqua Application REST API.

visitors table schema

id
STRING

The visitor ID.

V_LastVisitDateAndTime
DATE-TIME

V_Browser_Type
STRING

V_CityFromIP
STRING

V_CompanyDNSName
STRING

V_CompanyNameFromIP1
STRING

V_CountryFromIP
STRING

V_CountryName
STRING

V_Current_Total_Pages
INTEGER

V_Current_Visit_Length
INTEGER

V_FirstPageInVisit
STRING

V_FirstVisitDateAndTime
DATE-TIME

V_HostName
STRING

V_IPAddress
STRING

V_ISPFromIP
STRING

V_LastPageInVisit
STRING

V_LatitudeFromIP
NUMBER

V_LongitudeFromIP
NUMBER

V_Name
STRING

V_ProvinceFromIP
STRING

V_TimeZone
STRING

V_TimeZoneOffsetMin
INTEGER

V_Total_Pages
INTEGER

V_Total_Time
INTEGER

V_Total_Visits
INTEGER

V_ZipCodeFromIP
STRING

contactId
STRING

The contact record ID associated to this profile, if any.

Reference:

createdAt
STRING

The date and time the visitor was created, expressed in Unix time.

currentStatus
STRING

The current status of the visitor.

externalId
STRING

type
STRING

The visitor’s type in Eloqua.

visitorId
STRING

The ID of the visitor profile.
Related Troubleshooting
Questions? Feedback?

Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.