Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
twanqlik
Creator
Creator

API Rest Connection with Eloqua

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!

2 Replies
felipedl
Partner
Partner

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:

REST API for Oracle Eloqua Marketing Cloud Service - All REST Endpoints

And how to connect it with Qlik here:

https://help.qlik.com/en-us/connectors/Subsystems/REST_connector_help/Content/1.0/Introduction/REST-...

For the OAuth part of Eloqua, see the following:

REST CONNECTOR locate the Authorization token

Hope it helps.

Felipe.

amir_vit
Contributor
Contributor

Did it work for you?

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