This integration is powered by Singer's Eloqua tap. For support, visit the GitHub repo or join the Singer Slack.
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 (v1) integration, including release status, useful links, and the features supported in Stitch.
STITCH | |||
Release status |
Released on April 26, 2019 |
Supported by | |
Stitch plan |
Standard |
API availability |
Available |
Singer GitHub repository | |||
REPLICATION SETTINGS | |||
Anchor Scheduling |
Supported |
Advanced Scheduling |
Supported |
Table-level reset |
Unsupported |
Configurable Replication Methods |
Unsupported |
DATA SELECTION | |||
Table selection |
Supported |
Column selection |
Supported |
Select all |
Supported |
||
TRANSPARENCY | |||
Extraction Logs |
Supported |
Loading Reports |
Supported |
Connecting Eloqua
Step 1: Add Eloqua as a Stitch data source
- Sign into your Stitch account.
-
On the Stitch Dashboard page, click the Add Integration button.
-
Click the Eloqua icon.
-
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 replication start date
The Sync Historical Data setting defines 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:
-
Advanced Scheduling using Cron (Advanced or Premium plans only)
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
- Next, you’ll be prompted to sign into your Eloqua account. Click Sign In to sign in.
- Enter your Eloqua credentials and click Sign In again.
- The next page will display the application (
Stitch
) requesting access to Eloqua. Click Sign In to continue. - The next page will display the company and user you are currently logged into Eloqua as. Click Accept.
- After the authorization process is successfully completed, you’ll be directed back to Stitch.
- Click All Done.
Step 5: Set objects to replicate
The last step is to select the tables and columns you want to replicate. Learn about the available tables for this integration.
Note: If a replication job is currently in progress, new selections won’t be used until the next job starts.
For Eloqua integrations, you can select:
-
Individual tables and columns
-
All tables and columns
Click the tabs to view instructions for each selection method.
- In the integration’s Tables to Replicate tab, locate a table you want to replicate.
-
To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.
-
To track a column, click the checkbox next to the column’s name. A blue checkmark means the column is set to replicate.
- Repeat this process for all the tables and columns you want to replicate.
- When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.
- Click into the integration from the Stitch Dashboard page.
-
Click the Tables to Replicate tab.
- In the list of tables, click the box next to the Table Names column.
-
In the menu that displays, click Track all Tables and Fields:
- Click the Finalize Your Selections button at the bottom of the page to save your data selections.
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.
Initial replication jobs with Anchor Scheduling
If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the Anchor Scheduling documentation for more information.
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:
accounts
activity_bounceback
activity_email_clickthrough
activity_email_open
activity_email_send
activity_form_submit
activity_page_view
activity_subscribe
activity_unsubscribe
activity_web_visit
contacts
- Custom object 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 reference
Schemas and versioning
Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.
The schema and info displayed below is for version 1 of this integration.
This is the latest version of the Eloqua integration.
Table and column names in your destination
Depending on your destination, table and column names may not appear as they are outlined below.
For example: Object names are lowercased in Redshift (CusTomERs
> customers
), while case is maintained in PostgreSQL destinations (CusTomERs
> CusTomERs
). Refer to the Loading Guide for your destination for more info.
accounts
Replication Method : |
Key-based Incremental |
Replication Key |
UpdatedAt |
Primary Key |
Id |
API endpoint : |
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.
Id
The account ID. |
UpdatedAt
The Unix timestamp for the date and time the account was last updated. |
CompanyIDExt
|
CreatedAt
The date and time the account was created, expressed in Unix time. |
Custom Fields
Custom fields associated with accounts in your Eloqua account. |
activity_bounceback
Replication Method : |
Key-based Incremental |
Replication Key |
updatedAt |
Primary Key |
id |
API endpoint : |
The activity_bounceback
table contains info about Bounceback
contact activities.
Note: This table is replicated using the Eloqua Bulk API.
id
The bounceback activity ID. |
updatedAt
The Unix timestamp for the date and time the activity was last updated. |
ActivityId
The activity ID. |
ActivityType
The type of the activity. This value will be |
ActivityDate
The date the activity was performed expressed in 10 digit integer Unix time. |
AssetId
The ID of the associated asset. Reference: |
AssetName
The name of the associated asset. |
AssetType
The type of the associated asset. |
CampaignId
The ID of the campaign associated with the activity. Reference:
|
ContactId
The ID of the contact associated with the activity. Reference: |
EmailAddress
The email address of the contact who performed the activity. |
EmailRecipientId
The ID of the recipient associated with the activity. |
ExternalId
The GUID of the visitor who performed the activity. |
DeploymentId
The ID of the email deployment for an email activity. |
SmtpErrorCode
The SMTP status code for the email bounceback. |
SmtpStatusCode
The SMTP response code for the email bounceback. |
Type
The asset’s type in Eloqua. |
activity_email_clickthrough
Replication Method : |
Key-based Incremental |
Replication Key |
updatedAt |
Primary Key |
id |
API endpoint : |
The activity_email_clickthrough
table contains info about EmailClickthrough
contact activities.
Note: This table is replicated using the Eloqua Bulk API.
id
The email clickthrough activity ID. |
updatedAt
The Unix timestamp for the date and time the activity was last updated. |
ActivityDate
The date the activity was performed expressed in 10 digit integer Unix time. |
ActivityId
The unique identifier of the activity per activity type. |
ActivityType
The type of the activity. This value will be |
AssetId
The ID of the associated asset. Reference: |
AssetName
The name of the associated asset. |
AssetType
The type of the associated asset. |
CampaignId
The ID of the campaign associated with the activity. Reference:
|
ContactId
The ID of the contact associated with the activity. Reference: |
EmailAddress
The email address of the contact who performed the activity. |
EmailClickedThruLink
The link clicked through for an activity. |
EmailRecipientId
The ID of the recipient associated with the activity. |
EmailSendType
The type of email send for an email activity. Possible values include:
|
EmailWebLink
The link for viewing the email in a web browser window for an email activity. |
ExternalId
The GUID of the visitor who performed the activity. |
DeploymentId
The ID of the email deployment for an email activity. |
IpAddress
The IP address of the visitor who performed the activity. |
SubjectLine
The subject line for an email activity. |
Type
The asset’s type in Eloqua. |
VisitorId
The ID of the visitor who performed the activity. Reference: |
VisitorExternalId
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 : |
The activity_email_open
table contains info about EmailOpen
contact activities.
Note: This table is replicated using the Eloqua Bulk API.
id
The activity ID. |
updatedAt
The Unix timestamp for the date and time the activity was last updated. |
ActivityDate
The date the activity was performed expressed in 10 digit integer Unix time. |
ActivityType
The type of the activity. This value will be |
AssetId
The ID of the associated asset. Reference: |
AssetName
The name of the associated asset. |
AssetType
The type of the associated asset. |
CampaignId
The ID of the campaign associated with the activity. Reference:
|
ContactId
The ID of the contact associated with the activity. Reference: |
EmailAddress
The email address of the contact who performed the activity. |
EmailRecipientId
The ID of the recipient associated with the activity. |
EmailWebLink
The link for viewing the email in a web browser window for an email activity. |
ExternalId
The GUID of the visitor who performed the activity. |
DeploymentId
The ID of the email deployment for an email activity. |
IpAddress
The IP address of the visitor who performed the activity. |
Type
The asset’s type in Eloqua. |
VisitorId
The ID of the visitor who performed the activity. Reference: |
VisitorExternalId
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 : |
The activity_email_send
table contains info about EmailSend
contact activities.
Note: This table is replicated using the Eloqua Bulk API.
id
The activity ID. |
updatedAt
The Unix timestamp for the date and time the activity was last updated. |
ActivityDate
The date the activity was performed expressed in 10 digit integer Unix time. |
ActivityId
The unique identifier of the activity per activity type. |
ActivityType
The type of the activity. This value will be |
AssetId
The ID of the associated asset. Reference: |
AssetName
The name of the associated asset. |
AssetType
The type of the associated asset. |
CampaignId
The ID of the campaign associated with the activity. Reference:
|
ContactId
The ID of the contact associated with the activity. Reference: |
EmailAddress
The email address of the contact who performed the activity. |
EmailRecipientId
The ID of the recipient associated with the activity. |
EmailSendType
The type of email send for an email activity. Possible values include:
|
EmailWebLink
The link for viewing the email in a web browser window for an email activity. |
ExternalId
The GUID of the visitor who performed the activity. |
DeploymentId
The ID of the email deployment for an email activity. |
SubjectLine
The subject line for an email activity. |
Type
The asset’s type in Eloqua. |
activity_form_submit
Replication Method : |
Key-based Incremental |
Replication Key |
updatedAt |
Primary Key |
id |
API endpoint : |
The activity_form_submit
table contains info about FormSubmit
contact activities.
Note: This table is replicated using the Eloqua Bulk API.
id
The activity ID. |
updatedAt
The Unix timestamp for the date and time the activity was last updated. |
ActivityDate
The date the activity was performed expressed in 10 digit integer Unix time. |
ActivityType
The type of the activity. This value will be |
AssetId
The ID of the associated asset. Reference: |
AssetName
The name of the associated asset. |
AssetType
The type of the associated asset. |
CampaignId
The ID of the campaign associated with the activity. Reference:
|
ContactId
The ID of the contact associated with the activity. Reference: |
ExternalId
The GUID of the visitor who performed the activity. |
RawData
The raw data submitted with a |
Type
The asset’s type in Eloqua. |
VisitorId
The ID of the visitor who performed the activity. Reference: |
VisitorExternalId
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 : |
The activity_page_view
table contains info about PageView
contact activities.
Note: This table is replicated using the Eloqua Bulk API.
id
The activity ID. |
updatedAt
The Unix timestamp for the date and time the activity was last updated. |
ActivityDate
The date the activity was performed expressed in 10 digit integer Unix time. |
ActivityId
The unique identifier of the activity per activity type. |
ActivityType
The type of the activity. This value will be |
AssetId
The ID of the associated asset. Reference: |
AssetName
The name of the associated asset. |
AssetType
The type of the associated asset. |
CampaignId
The ID of the campaign associated with the activity. Reference:
|
ContactId
The ID of the contact associated with the activity. Reference: |
ExternalId
The GUID of the visitor who performed the activity. |
IpAddress
The IP address of the visitor who performed the activity. |
Type
The asset’s type in Eloqua. |
Url
The URL viewed with a |
VisitorId
The ID of the visitor who performed the activity. Reference: |
VisitorExternalId
The GUID of the visitor who performed the activity. |
WebVisitId
The ID of the WebVisit associated with a |
activity_subscribe
Replication Method : |
Key-based Incremental |
Replication Key |
updatedAt |
Primary Key |
id |
API endpoint : |
The activity_subscribe
table contains info about Subscribe
contact activities.
Note: This table is replicated using the Eloqua Bulk API.
id
The activity ID. |
updatedAt
The Unix timestamp for the date and time the activity was last updated. |
ActivityDate
The date the activity was performed expressed in 10 digit integer Unix time. |
ActivityId
The unique identifier of the activity per activity type. |
ActivityType
The type of the activity. This value will be |
AssetId
The ID of the associated asset. Reference: |
AssetName
The name of the associated asset. |
AssetType
The type of the associated asset. |
CampaignId
The ID of the campaign associated with the activity. Reference:
|
ContactId
The ID of the contact associated with the activity. Reference: |
EmailAddress
The email address of the contact who performed the activity. |
EmailRecipientId
The recipient ID associated with the activity. |
ExternalId
The GUID of the visitor who performed the activity. |
Type
The asset’s type in Eloqua. |
activity_unsubscribe
Replication Method : |
Key-based Incremental |
Replication Key |
updatedAt |
Primary Key |
id |
API endpoint : |
The activity_unsubscribe
table contains info about Unsubscribe
contact activities.
Note: This table is replicated using the Eloqua Bulk API.
id
The activity ID. |
updatedAt
The Unix timestamp for the date and time the activity was last updated. |
ActivityDate
The date the activity was performed expressed in 10 digit integer Unix time. |
ActivityId
The unique identifier of the activity per activity type. |
ActivityType
The type of the activity. This value will be |
AssetId
The ID of the associated asset. Reference: |
AssetName
The name of the associated asset. |
AssetType
The type of the associated asset. |
CampaignId
The ID of the campaign associated with the activity. Reference:
|
ContactId
The ID of the contact associated with the activity. Reference: |
EmailAddress
The email address of the contact who performed the activity. |
EmailRecipientId
The recipient ID associated with the activity. |
ExternalId
The GUID of the visitor who performed the activity. |
Type
The asset’s type in Eloqua. |
activity_web_visit
Replication Method : |
Key-based Incremental |
Replication Key |
updatedAt |
Primary Key |
id |
API endpoint : |
The activity_web_visit
table contains info about WebVisit
contact activities.
Note: This table is replicated using the Eloqua Bulk API.
id
The activity ID. |
updatedAt
The Unix timestamp for the date and time the activity was last updated. |
ActivityDate
The date the activity was performed expressed in 10 digit integer Unix time. |
ActivityType
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 named |
AssetId
The ID of the associated asset. Reference: |
AssetType
The type of the associated asset. |
ContactId
The ID of the contact associated with the activity. Reference: |
Type
The asset’s type in Eloqua. |
assets
Replication Method : |
Key-based Incremental |
Replication Key |
updatedAt |
Primary Key |
id |
API endpoint : |
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.
id
The ID of the external asset. Reference: |
|
updatedAt
The Unix timestamp for the date and time the external asset was last updated. |
|
accessedAt
The date and time the external asset was last accessed, expressed in Unix time. |
|
createdAt
The date and time the external asset was created, expressed in Unix time. |
|
createdBy
The login ID of the user who created the external asset. Reference:
|
|
currentStatus
The external asset’s current status. |
|
depth
Level of detail returned by the request. Eloqua APIs can retrieve entities at three different levels of depth: |
|
description
The description of the external asset. |
|
externalAssetTypeId
The ID of the external asset type. |
|
folderId
The ID of the folder that contains the external asset. Reference: |
|
name
The name of the external asset. |
|
permissions
The permissions for the external asset granted to your current instance.
|
|
scheduledFor
The date the external asset is scheduled. |
|
sourceTemplateId
The ID of the template used to create the external asset. |
|
type
The asset’s type in Eloqua. |
|
updatedBy
The ID of the user that last updated the external asset. |
campaigns
Replication Method : |
Key-based Incremental |
Replication Key |
updatedAt |
Primary Key |
id |
API endpoint : |
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.
id
The campaign ID. Reference:
|
|
updatedAt
The Unix timestamp for the date and time the campaign was last updated. |
|
accessedAt
The date and time the campaign was last accessed, expressed in Unix time. |
|
actualCost
The campaign’s actual cost. |
|
badgeId
The badge ID of the campaign. |
|
budgetedCost
The campaign’s projected cost. |
|
campaignCategory
Defines whether a campaign is simple or multi-step. Possible values are:
|
|
campaignType
The campaign’s type. |
|
clrEndDate
The end date of the clr. |
|
createdAt
The date and time the campaign was created, expressed in Unix time. |
|
createdBy
The ID of the user who created the campaign. Reference:
|
|
crmId
The ID of the customer relationship management application. |
|
currentStatus
The campaign’s current status. Possible values are:
|
|
depth
Level of detail returned by the request. Eloqua APIs can retrieve entities at three different levels of depth: |
|
description
The description of the campaign. |
|
endAt
The date and time the campaign will end. |
|
firstActivation
The date and time the campaign was originally activated. |
|
folderId
The ID of the folder containing the campaign. Reference: |
|
isEmailMarketingCampaign
Indicates whether the campaign is an email marketing campaign. |
|
isIncludedInROI
Indicates whether the campaign is included in return on investment. |
|
isMemberAllowedReEntry
Indicates whether members are allowed to re-enter the campaign. |
|
isReadOnly
Indicates whether the campaign is read only. |
|
isSyncedWithCRM
Indicates whether the campaign is synced with a customer relationship management application. |
|
memberCount
The amount of members in the campaign. |
|
name
The name of the campaign. |
|
permissions
The permissions for the campaign granted to your current instance.
|
|
product
The campaign’s product value. |
|
region
The campaign’s region value. |
|
runAsUserId
The ID of the user to activate the campaign. Reference:
|
|
scheduledFor
The date the campaign is scheduled. |
|
sourceTemplateId
The ID of the template used to create the asset. |
|
startAt
The date time for which the campaign will activate. |
|
type
The asset’s type in Eloqua. |
|
updatedBy
The ID of the user that last updated the campaign. |
contacts
Replication Method : |
Key-based Incremental |
Replication Key |
UpdatedAt |
Primary Key |
Id |
API endpoint : |
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.
Id
The contact ID. Reference: |
UpdatedAt
The Unix timestamp for the date and time the contact was last updated. |
AccountName
|
ContactIDExt
|
CreatedAt
The date and time the contact was created, expressed in Unix time. |
EmailFormat
|
IsBounceBack
|
IsSubscribed
|
Custom Fields
Custom fields associated with contacts in your Eloqua account. |
Custom Objects
Replication Method : |
Key-based Incremental |
Replication Key |
UpdatedAt |
Primary Key |
id |
API endpoint : |
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.
id
The custom object ID. |
UpdatedAt
The Unix timestamp for the date and time the record was last updated. |
CreatedAt
The date and time the record was created, expressed in Unix time. |
DataCardIDExt
|
Custom Fields
The fields associated with the custom object in your Eloqua account. |
emails
Replication Method : |
Key-based Incremental |
Replication Key |
updatedAt |
Primary Key |
id |
API endpoint : |
The emails
table contains details about the emails sent from your Eloqua account.
Note: This table is replicated using the Eloqua Application REST API.
id
The email ID. Reference: |
||||||||||||||||||||||||||||||||||
updatedAt
The Unix timestamp for the date and time the email was last updated. |
||||||||||||||||||||||||||||||||||
accessedAt
The date and time the email was last accessed, expressed in Unix time. |
||||||||||||||||||||||||||||||||||
archive
|
||||||||||||||||||||||||||||||||||
bounceBackEmail
The email address which is notified if the email is undeliverable. |
||||||||||||||||||||||||||||||||||
createdAt
The date and time the email was created, expressed in Unix time. |
||||||||||||||||||||||||||||||||||
createdBy
The ID of the user who created the email. Reference:
|
||||||||||||||||||||||||||||||||||
currentStatus
The asset’s current status. |
||||||||||||||||||||||||||||||||||
depth
Level of detail returned by the request. Eloqua APIs can retrieve entities at three different levels of depth: |
||||||||||||||||||||||||||||||||||
description
The description of the email. |
||||||||||||||||||||||||||||||||||
dynamicContents
A list of associated dynamic content.
|
||||||||||||||||||||||||||||||||||
emailFooterId
The ID of the email footer. Reference: |
||||||||||||||||||||||||||||||||||
emailGroupId
The ID of the email group. |
||||||||||||||||||||||||||||||||||
emailHeaderId
The ID of the email header. Reference: |
||||||||||||||||||||||||||||||||||
encodingId
The ID of the encoding used. |
||||||||||||||||||||||||||||||||||
fieldMerges
A list of associated field merges.
|
||||||||||||||||||||||||||||||||||
files
A list of imported files.
|
||||||||||||||||||||||||||||||||||
forms
A list of associated form assets.
|
||||||||||||||||||||||||||||||||||
htmlContent
Details about the HTML content in the email.
|
||||||||||||||||||||||||||||||||||
hyperlinks
A list of hyperlinks contained within the email.
|
||||||||||||||||||||||||||||||||||
images
A list of associated Image assets.
|
||||||||||||||||||||||||||||||||||
isContentProtected
Indicates whether the asset’s content is protected. |
||||||||||||||||||||||||||||||||||
isPlainTextEditable
Indicates whether the asset’s text is editable. |
||||||||||||||||||||||||||||||||||
isPrivate
|
||||||||||||||||||||||||||||||||||
isTracked
Indicates whether Eloqua will track the asset. |
||||||||||||||||||||||||||||||||||
landingPages
A list of associated landing page assets. |
||||||||||||||||||||||||||||||||||
layout
The email’s main layout. |
||||||||||||||||||||||||||||||||||
name
The name of the email. |
||||||||||||||||||||||||||||||||||
permissions
The permissions for the email granted to your current instance. |
||||||||||||||||||||||||||||||||||
plainText
The email’s content in plain text. |
||||||||||||||||||||||||||||||||||
renderMode
|
||||||||||||||||||||||||||||||||||
replyToEmail
The email address targeted when recipients click ‘reply’. |
||||||||||||||||||||||||||||||||||
replyToName
The sender name recipients of the email will see. |
||||||||||||||||||||||||||||||||||
sendPlainTextOnly
Indicates whether the sent email is plain text only. |
||||||||||||||||||||||||||||||||||
senderEmail
The address the email will appear to be sent from. |
||||||||||||||||||||||||||||||||||
senderName
The sender name recipients of the email will see. |
||||||||||||||||||||||||||||||||||
sourceTemplateId
The ID of the template used to create the asset. |
||||||||||||||||||||||||||||||||||
style
The email’s main layout style. |
||||||||||||||||||||||||||||||||||
subject
The email’s subject line text. |
||||||||||||||||||||||||||||||||||
type
The asset’s type in Eloqua. |
||||||||||||||||||||||||||||||||||
updatedBy
The ID of the user that last updated the email. Reference:
|
||||||||||||||||||||||||||||||||||
virtualMTAId
|
email_groups
Replication Method : |
Key-based Incremental |
Replication Key |
updatedAt |
Primary Key |
id |
API endpoint : |
The email_groups
table contains details about the email groups in your Eloqua account.
Note: This table is replicated using the Eloqua Application REST API.
Replication Method : |
Key-based Incremental |
Replication Key |
updatedAt |
Primary Key |
id |
API endpoint : |
The forms
table contains info about the forms in your Eloqua account.
Note: This table is replicated using the Eloqua Application REST API.
id
The form ID. Reference: |
|||||||||||||||||||
updatedAt
The Unix timestamp for the date and time the form was last updated. |
|||||||||||||||||||
accessedAt
The date and time the form was last accessed, expressed in Unix time. |
|||||||||||||||||||
createdAt
The date and time the form was created, expressed in Unix time. |
|||||||||||||||||||
createdBy
The ID of the user who created the form. Reference:
|
|||||||||||||||||||
currentStatus
The form’s current status. For example: |
|||||||||||||||||||
customCSS
|
|||||||||||||||||||
defaultKeyFieldMapping
|
|||||||||||||||||||
depth
Level of detail returned by the request. Eloqua APIs can retrieve entities at three different levels of depth: |
|||||||||||||||||||
description
The description of the form. |
|||||||||||||||||||
elements
A list of elements associated with the form.
|
|||||||||||||||||||
emailAddressFormFieldId
The form element’s field instructions. Field instructions are optional instructions that help users fill in fields. |
|||||||||||||||||||
folderId
Reference: |
|||||||||||||||||||
html
The asset’s raw HTML content. |
|||||||||||||||||||
htmlName
The asset’s raw HTML name. |
|||||||||||||||||||
name
The name of the form. |
|||||||||||||||||||
permissions
The permissions for the form granted to your current instance. |
|||||||||||||||||||
processingSteps
A list of the form’s processing steps.
|
|||||||||||||||||||
processingType
A list of the form’s processing types. For example: |
|||||||||||||||||||
size
|
|||||||||||||||||||
style
The asset’s main layout style. |
|||||||||||||||||||
submitFailedLandingPageId
The landing page ID of the failed submit. |
|||||||||||||||||||
type
The asset’s type in Eloqua. |
|||||||||||||||||||
updatedBy
The ID of the user that last updated the form. Reference:
|
visitors
Replication Method : |
Key-based Incremental |
Replication Key |
V_LastVisitDateAndTime |
Primary Key |
id |
API endpoint : |
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.
id
The visitor ID. Reference: |
V_LastVisitDateAndTime
|
V_Browser_Type
|
V_CityFromIP
|
V_CompanyDNSName
|
V_CompanyNameFromIP1
|
V_CountryFromIP
|
V_CountryName
|
V_Current_Total_Pages
|
V_Current_Visit_Length
|
V_FirstPageInVisit
|
V_FirstVisitDateAndTime
|
V_HostName
|