Skip to end of banner
Go to start of banner

Eloqua Query Activities

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 16 Next »

In this article

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.

  • Expected input: The typical input for this Snap would be documents containing Eloqua contact IDs, such as the output of the Eloqua Read Snap for the Contacts type.

  • Expected output: One output document per contact ID, containing the contact ID and a list of zero or more activities for that contact.

Snap Type

The Eloqua Query Activities Snap is a Read-type Snap.

Prerequisites

None.

Support for Ultra Pipelines

Works in Ultra Task Pipelines.

Limitations and Known Issues

None.

Snap Views

Type

Format

Number of Views

Examples of Upstream and Downstream Snaps

Description

Input 

Document

  • Min: 1

  • Max: 1

JSON Generator

The Snap invokes the Eloqua endpoint for the given object type once for each input document, using the document as the content sent to the endpoint. Check the Eloqua API documentation to understand the required and supported fields specific to the object type. Note that the Eloqua documentation is not very complete/accurate in this respect.

Output

Document

 

  • Min: 1

  • Max: 1

Mapper

 

The Snap produces one document in the view for each successful call to the Eloqua endpoint.

Error

Error handling is a generic way to handle errors without losing data or failing the Snap execution. You can handle the errors that the Snap might encounter while running the Pipeline by choosing one of the following options from the When errors occur list under the Views tab:

  • Stop Pipeline Execution: Stops the current pipeline execution when the Snap encounters an error.

  • Discard Error Data and Continue: Ignores the error, discards that record, and continues with the remaining records.

  • Route Error Data to Error View: Routes the error data to an error view without stopping the Snap execution.

Learn more about Error handling in Pipelines.

Snap Settings

Snap type:

Read

Description:

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.

  • Expected input: The typical input for this Snap would be documents containing Eloqua contact IDs, such as the output of the Eloqua Read Snap for the Contacts type.

  • Expected output: One output document per contact ID, containing the contact ID and a list of zero or more activities for that contact.

Prerequisites:

[None]

Support and limitations:

Works in Ultra Task Pipelines.

Account: 

This Snap uses account references created on the Accounts page of SnapLogic Manager to handle access to this endpoint. See Eloqua Account for more information.

Views:


InputThis Snap has at most one document input view.
OutputThis Snap has exactly one document output view.
ErrorThis Snap has at most one document error view and produces zero or more documents in the view.


Settings

Label


Required. The name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your pipeline.

Contact ID


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

Example:
Default value:

Activity Type

Required. The type of activity you wish to retrieve for the specified contact.  One of:

  • emailOpen

  • emailSend

  • emailClickThrough

  • emailSubscribe

  • emailUnsubscribe

  • formSubmit

  • webVisit

  • campaignMembership

Start Date/Time

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 a DateTime. See http://www.unixtimestamp.com/.

Examples:

  • 1341343693

  • Date.now().minusDays(30)

  • Date.parse("2015-12-25T12:00:00+00:00")

End Date/Time

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

Count

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

Page lookup error: page "Anaplan Read" not found.

If you're experiencing issues please see our Troubleshooting Guide.

Page lookup error: page "Anaplan Read" not found.

If you're experiencing issues please see our Troubleshooting Guide.


Examples


Sample input:


[
  {
    "id": "4156"
  },
  {
    "id": "4157"
  },
  {
    "id": "4158"
  }
]


Sample output:


[
  {
    "contactId" : "4156",
    "activities" : [
      {
        "type" : "Activity",
        "activityDate" : "1403589324",
        "activityType" : "emailSubscribe",
        "asset" : "0",
        "assetType" : "email",
        "contact" : "4156",
        "details" : [ ],
        "id" : "130345"
      },
      {
        "type" : "Activity",
        "activityDate" : "1341343693",
        "activityType" : "emailSubscribe",
        "asset" : "0",
        "assetType" : "email",
        "contact" : "4156",
        "details" : [ ],
        "id" : "2947"
      }
    ]
  },
  {
    "contactId" : "4157",
    "activities" : [ ]
  },
  {
    "contactId" : "4158",
    "activities" : [
      {
        "type" : "Activity",
        "activityDate" : "1341343693",
        "activityType" : "emailSubscribe",
        "asset" : "0",
        "assetType" : "email",
        "contact" : "4158",
        "details" : [ ],
        "id" : "2948"
      }
    ]
  }
]





 Click to view/expand
Release Snap Pack VersionDateType  Updates
May 2024main26341 StableUpdated and certified against the current SnapLogic Platform release.
February 2024main25112 StableUpdated and certified against the current SnapLogic Platform release.
November 2023main23721 StableUpdated and certified against the current SnapLogic Platform release.

August 2023

main22460

 

Stable

Updated and certified against the current SnapLogic Platform release.

May 2023main21015 StableUpgraded with the latest SnapLogic Platform release.
February 2023main19844 StableUpgraded with the latest SnapLogic Platform release.
November 2022main18944 Stable

The Eloqua Snaps now include the Pass through checkbox, which enables the Snap to pass the input document to the output view under the key original.

August 2022430patches17270 Latest

The Custom Object Metadata ID field in the Eloqua Create Snap allows you to specify an ID for creating custom object data. This conditional field appears only when you select Custom Object Data as the Core object type.

August 2022main17386 StableUpgraded with the latest SnapLogic Platform release.
4.29main15993 StableUpgraded with the latest SnapLogic Platform release.
4.28main14627 StableUpgraded with the latest SnapLogic Platform release.

4.27

main12833

 

Stable

Upgraded with the latest SnapLogic Platform release.
4.26main11181 StableUpgraded with the latest SnapLogic Platform release.
4.25main9554
 
StableUpgraded with the latest SnapLogic Platform release.
4.24main8556
StableUpgraded with the latest SnapLogic Platform release.
4.23main7430
 
StableUpgraded with the latest SnapLogic Platform release.
4.22main6403
 
StableUpgraded with the latest SnapLogic Platform release.
4.21snapsmrc542

 

StableUpgraded with the latest SnapLogic Platform release.
4.20snapsmrc535
 
StableUpgraded with the latest SnapLogic Platform release.
4.19snaprsmrc528
 
StableUpgraded with the latest SnapLogic Platform release.
4.18snapsmrc523
 
StableUpgraded with the latest SnapLogic Platform release.
4.17ALL7402
 
Latest

Pushed automatic rebuild of the latest version of each Snap Pack to SnapLogic UAT and Elastic servers.

4.17snapsmrc515
 
Latest

Added the Snap Execution field to all Standard-mode Snaps. In some Snaps, this field replaces the existing Execute during preview check box.

4.16snapsmrc508
 
StableUpgraded with the latest SnapLogic Platform release.
4.15snapsmrc500
 
StableUpgraded with the latest SnapLogic Platform release.
4.14snapsmrc490
 
StableUpgraded with the latest SnapLogic Platform release.
4.13

snapsmrc486

 
StableUpgraded with the latest SnapLogic Platform release.
4.12

snapsmrc480

 
StableUpgraded with the latest SnapLogic Platform release.
4.11snapsmrc465
 
StableUpgraded with the latest SnapLogic Platform release.
4.10

snapsmrc414

 
StableUpgraded with the latest SnapLogic Platform release.
4.9snapsmrc405
 
StableUpgraded with the latest SnapLogic Platform release.
4.8

snapsmrc398

 
StableUpgraded with the latest SnapLogic Platform release.
4.7

snapsmrc382

 
StableUpgraded with the latest SnapLogic Platform release.
4.6snapsmrc362
 
StableUpgraded with the latest SnapLogic Platform release.
4.5.1

snapsmrc344

 
LatestUpgraded with the latest SnapLogic Platform release.
4.5

snapsmrc344

 StableUpgraded with the latest SnapLogic Platform release.
4.4.1N/A LatestUpgraded with the latest SnapLogic Platform release.
4.4N/A StableUpgraded with the latest SnapLogic Platform release.
4.3.2N/A Latest
  • NEW! Create, Delete, Query Activities, and Update Snaps added.
  • Added core object types to support all remaining REST 1.0 and 2.0 endpoints in Read and Query Snaps.
  • Read Snap now supports expressions for Search setting and an input view.
  • Resolved an issue with Eloqua Snaps not correctly obtaining the base URL from the login id endpoint.
  • Resolved an issue with Eloqua Snaps not handling Additional Parameters correctly.
  • Resolved an issue with Eloqua Read settings listing core object types that aren't applicable for this Snap and will always fail.
  • Resolved an issue with Eloqua Read and Query Snap not able read or query External Asset object type.
  • Resolved an exception with Eloqua Query when Activities returns no content.
  • Resolved an exception with Eloqua Query when Activities returns content.
  • Resolved an issue with Eloqua Read returning duplicate items when Count was greater than 1000.

  • No labels