topic API Rest Connection with Eloqua in Connectivity & Data Prep

API Rest Connection with Eloqua

twanqlik — Fri, 02 Apr 2021 08:07:20 GMT

I'm trying to create an API Rest connection with Eloqua, but i'm not really successful in that.

It's not clear for me where i can define the Eloqua instance, i assume it is before my login name?

Hence: Instance/Login

Further, from what i have understood i should follow this order to extract data from Eloqua:

Create Structure (Post)

Sync Structure (Post)

Validate Sync (Get)

Exraction (Get)

I'm still at the first step, i tried to make a test connection but i'm receiving an error about ' field; name, constract --> must be a string value..

I expect that the error has something to do with my Request body?

{

%3name%3: %3Contact Export%3,

%3fields%3: {%3EmailAddress%3: %3{{Contact.Field(C_EmailAddress)}}%3}}

Any help is appreciated!

felipedl — Fri, 20 Oct 2017 16:52:53 GMT

Hi Twan,

From what I've researched on Eloqua, it's a simple REST API, just needing to authentica with it to extract the data.

The API can be found here:

And how to connect it with Qlik here:

For the OAuth part of Eloqua, see the following:

Hope it helps.

Felipe.

amir_vit — Mon, 18 Dec 2017 13:46:05 GMT

Did it work for you?

I've started to investigate it and i want to make sure its working...