Eloqua Query Activities
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 |
| JSON Generator | This Snap has one document input view. |
Output | Document  |
| Mapper  | This Snap has exactly one document output view. |
Error | This Snap has at most one document error view and produces zero or more documents in the view. 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:
Learn more about Error handling in Pipelines. |
Snap Settings
Field Name | Field Type | Field Dependency | Description |
---|---|---|---|
Label Default Value: Eloqua Query Activities Example: Create Accounts | String | N/A | 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 Example: | String | N/A | Required. ID of the Eloqua contact associated with the activities of interest, or an expression which evaluates to a contact ID. |
Activity Type | Dropdown List | N/A | Required. The type of activity you wish to retrieve for the specified contact. Â One of:
|
Start Date/Time | String | N/A | 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 Unix Time Stamp - Epoch Converter . Examples:
|
End Date/Time | String | N/A | Required. End of the time range for activities to retrieve. |
Count | String | N/A | 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). |
Pass through Default Value: Deselected | Checkbox | N/A | Select this checkbox to enable the Snap to pass the input document to the output view under the key  |
Snap Execution  | Dropdown list | N/A |  Select one of the three modes in which the Snap executes. Available options are:
 |
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"
}
]
}
]
Snap Pack History
Have feedback? Email documentation@snaplogic.com | Ask a question in the SnapLogic Community
© 2017-2024 SnapLogic, Inc.