Eloqua - How to get started with Oracle Eloqua in Qlik Application Automation

[Ionut_Dumitrascu]

This article gives an overview of the available blocks in the Oracle Eloqua connector in Qlik Application Automation. It will also go over a basic example of creating a custom object record within your account.

Eloqua is a software as a service (SaaS) platform for marketing automation offered by Oracle that aims to help B2B marketers and organizations manage marketing campaigns and sales lead generation.

This connector consists of:

• list and get support for custom object structure;
• CRUD support for custom object records.
• List/Get/Create support for accounts and contacts

To authenticate, you must provide your client ID and client secret on the Eloqua login page. You can find the client ID and client secret on the Security page in the Platform Settings tab. You must be an Administrator to access this tab. Also, please ensure that the OAuth Callback URL on your app is set to https://connector.qlikcloud.com/callback. For more information, please check this article.

Let's now go over a basic example of how to create a custom object record and link it to an existing contact using the Oracle Eloqua connector:

1. Create an automation.
2. From the left menu, click the Oracle Eloqua connector.
   
3. Use the Search for blocks input to search for the Get Custom Object block. Using this block, you can get the IDs of the fields you want to fill in when you create your custom object record.
4. Drag the Get Custom Object block to the automation canvas and link it to the Start block.
5. On the right side of the screen, click on the id input field, and use the do lookup functionality to select the type of object you want to create.
6. Run the automation. In the output of this block, you will find information about the selected custom field, along with a list of fields that contains the IDs.
7. Unlink the Get Custom Object block from the start block. Use the Search for blocks input to search for the Create Custom Object Record block. Drag the Create Custom Object Record block to the automation canvas and link it to the Start block.
   
8. On the right side of the screen, use the do lookup functionality to select the type of object you want to create. In the field values input, use a 'list' type variable together with an object variable to build the structure. The IDs of the fields you want to add are found in the output of the Get Custom Object block. Here is an example of this structure:

   [{ "id": "150", "value": "12345" }, { "id": "151", "value": "54321" }, { "id": "152", "value": "abc" }]​

   Notice that we are using the ID of the fields to add values to and not the names.
   
   Fill in the Contact ID input field with an id of an existing contact. Use the List contacts block to get the contact IDs.
9. Run the automation. This will create a new custom field record linked to a contact in your Oracle Eloqua account.

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.