API Rest Connection with Eloqua - Qlik Community

twanqlik · ‎2017-10-20

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 · ‎2017-10-20

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 · ‎2017-12-18

Did it work for you?

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