Eloqua Query Activities

Overview

This Snap is used to retrieve the activities associated with one or more Eloqua contact asset.  It invokes the Eloqua REST API 1.0 "Read (list)" endpoint for Activities.


Eloqua Query Activities Overview

Snap views

Type Description Examples of upstream and downstream Snaps
Input A document containing the contact ID and time range for querying activity data.
Output A document containing the activity data (email opens, clicks, web visits, etc.) for the specified contact.
Learn more about Error handling.

Snap settings

Legend:
  • Expression icon (): Allows using JavaScript syntax to access SnapLogic Expressions to set field values dynamically (if enabled). If disabled, you can provide a static value. Learn more.
  • SnapGPT (): Generates SnapLogic Expressions based on natural language using SnapGPT. Learn more.
  • Suggestion icon (): Populates a list of values dynamically based on your Snap configuration. You can select only one attribute at a time using the icon. Type into the field if it supports a comma-separated list of values.
  • Upload : Uploads files. Learn more.
Learn more about the icons in the Snap settings dialog.
Field/Field set Type Description
Label

String

Required. Specify a unique name for the Snap. Modify this to be more appropriate, especially if more than one of the same Snaps is in the pipeline.

Default value: Eloqua Query Activities

Example: Query Email Opens
Contact ID

String/Expression

Required. ID of the Eloqua contact associated with the activities of interest, or an expression which evaluates to a contact ID.

Default value: None

Example: ABC876
Activity Type

Dropdown list

Required. The type of activity to retrieve for the specified contact. Options: emailOpen, emailSend, emailClickThrough, emailSubscribe, emailUnsubscribe, formSubmit, webVisit, campaignMembership.

Default value: emailOpen

Example: emailSend
Start Date/Time

String/Expression

Required. Start of the time range for activities to retrieve. This should be a 10-digit Unix timestamp, or an expression that evaluates to a timestamp or DateTime.

Default value: None

Example: Date.now().minusDays(30)
End Date/Time

String/Expression

Required. End of the time range for activities to retrieve.

Default value: None

Example: Date.now().minusDays(30)
Count

Integer

Maximum number of activities to retrieve for each contact. This is not a limit on the number of documents to output, which is always equal to the number of input documents (or 1 if there are no input documents).

Default value: None

Example: 5
Pass through

Checkbox

Select this checkbox to enable the Snap to pass the input document to the output view under the key original.

Default value: Deselected
Snap execution

Dropdown list

 Choose one of the three modes in which the Snap executes.
Available options are:
  • Validate & Execute. Performs limited execution of the Snap and generates a data preview during pipeline validation. Subsequently, performs full execution of the Snap (unlimited records) during pipeline runtime.
  • Execute only. Performs full execution of the Snap during pipeline execution without generating preview data.
  • Disabled. Disables the Snap and all Snaps that are downstream from it.

Default value: Execute only

Example: Validate & Execute