Welcome Guest, you are in: Login

QVSource: The QlikView & Qlik Sense API Connector (Docs)

We do not currently have a dedicated Eloqua Connector for QlikView, however we have seen successful attempts to access the API using our General JSON/XML/SOAP API Web Connector.

Both the Eloqua REST API and Bulk API support basic authentication meaning that the General JSON/XML/SOAP API Web Connector should be able to connect to them.

What follows are some brief notes on how to get started with the REST API. You would however have to read the Eloqua REST API docs in order to make full use of the API for your particular use case.

Authentication

The first thing to note from this portion of the docs is that the API supports basic authentication where your username is Company Name\User Name and your password is your usual password.

We can go ahead and enter these into the username and password fields of the General Web Connector:

Image

Finding The Correct Endpoint

Next, from this page we can see that the following URL:
https://login.eloqua.com/id

Can be used to establish the 'real' end points where we will make our API requests. So we enter this into QVSource and make a GET request using the JsonToXmlRaw table in QVSource:

Image

It's a little difficult to see the raw response in the current version of QVSource so we simply grab the request URL by clicking the link highlighted:

Image

And then paste this into our web browser's address bar. We should see something like this, verifying that the our credentials have been accepted and that QVSource is connecting successfully to the API:

Image

Extracting Data

Now we have successfully authenticated, we can use the data REST endpoint highlighted above in conjunction with the docs to start getting some data.

Let's start by retrieving a list of contacts. Using the information from above and the docs we can construct the following API query to search for all contacts:
https://secure.eloqua.com/API/REST/2.0/data/contacts?depth=Minimal&search=&page=1&count=100

We are assuming here that leaving the search blank will return all contacts.

Entering this URL into QVSource and once again running the JsonToXmlRaw table confirms that we have data returned.

Image

Once again we can paste the generated URL into a browser for a better preview of the results:

If we scroll down to the very bottom of the page we can also see the total number of results in the system. It should be noted that you would need to construct your QlikView script to loop through all pages of results (if that is what was needed) by making subsequent calls with an updated page parameter in the above URL. This is outside the scope of this tutorial however we do have some sample code for another API here.

Note that we could now in theory go straight to QlikView and simply use the URL grabbed from QVSource above as the path for a 'Web File':

Image

However, having seen the XML we can note that it is essentially a structured table, where each row is a node at:
DATA/elements

So we can select the JsonToTable table in QVSource and enter the above as the XPATH input and we can now retrieve a structured table:

Image

And we can now copy the auto generated QlikView load script for this and paste it directly into our QlikView application:

Image

Next Steps

Hopefully the above has provided a good introduction into how to access data using the QVSource General JSON/XML/SOAP Connector for QlikView.

With a combination of reading the Eloqua REST API docs and perhaps asking questions on their forums it should be possible to access much of the data in their API.

It should also be possible to access the Eloqua Bulk Data API.
  Name Size
- contacts response.png 25.42 KB
- contacts xml.png 41.89 KB
- copy url.png 8.71 KB
- credentials.png 4.65 KB
- end points.png 65.93 KB
- endpoints response.png 61.03 KB
- load script.png 40.03 KB
- total contacts.png 1.75 KB
- web file.png 20.83 KB
- xpath table.png 91.64 KB


(QVSource works with Qlik Sense as well as QlikView - See this page for notes.)
QVSource - The QlikView & Qlik Sense API Connector | © Copyright 2011 - 2016 Industrial CodeBox Ltd