Welcome Guest, you are in: Login

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

V2 of the OData Connector is available in QVSource 1.6.0.5 and later and replaces V1 of the Connector.

Please note - this is a breaking change, you will need to regenerate your QlikView or Qlik Sense load script statements using the new connector. Column names in the results should remain unaffected (although some new columns may now appear with the postfix _Feed or _Entry and these can be used to request new tables) however the http:// request to QVSource will change.

Table of Contents [Hide/Show]


OData Sources

The OData Connector opens up a large number of data sets to QlikView and Qlik Sense users, including:
as the service end point.

Please note that this will only work for locally hosted Dynamics installations, however, we do also now have a dedicated Connector to Microsoft Dynamics CRM Online here.

Usage

The connector should allow you to connect to OData services which support either windows or basic authentication (or no authentication).

The first thing you would usually do is find the OData Service URL for the OData you wish to access - in this example we will use:
http://services.odata.org/OData/OData.svc

ListResources

Enter this parameter and you can then use the ListResources table to list the available tables:

Image

Note that there is also a ListResourcesAsXml table should you wish to see the underlying 'raw' OData response and load this directly into QlikView or Qlik Sense.

GetData

You can now select one of the values in the 'Resource' column and enter this as 'OData Resource Path' parameter on the GetData table.

Image

Note again that there is also a GetDateAsXml table should you wish to see the underlying 'raw' OData response and load this directly into QlikView or Qlik Sense.

Note that some of the column names have the postfix _Feed or _Entry. You should be able to use these as new inputs for the 'OData Resource Path' input parameter.

Image

In this example we take:
Products(0)/Categories

And we now get a new related table:

Image

In this way, it would be possible to construct a QlikView or Qlik Sense load script to loop through all of the _Entry or _Feed items for a 'parent' table and construct the related table.

Raw

The raw table allows you to run any request and retrieve the results as XML which can be loaded directly into QlikView or Qlik Sense. A typical use of this might be to view or load the metadata for a service which is usually retrieved by adding $metadata to the end of the service URL. So in this case we would use:
http://services.odata.org/OData/OData.svc/$metadata

Image

Paging

Note that if you are connecting to your own OData server and are getting out of memory exceptions, particularly for requests that return very large data sets you should make sure that paging is enabled for your OData server.

Change Log

1.0.7 - 23/02/16
  • Added optional auth header.
  • Updated auth parameters to be included in the generated load URL by default. If you delete the parameter values from the generated load URL it will fall back to the value stored in settings.
  • Added additional info about request URL to warn log entry in the case of XML needing to be sanitised before loading.

1.0.6 - 05/02/16
  • Connector now attempts to sanitise XML before loading following a bug report where one OData source included invalid content in XML.

1.0.5 - 29/01/16
  • Fix CleanupUrl bug when using file paths.

1.0.4 - 30/11/15
  • Removed optional paging type parameter as it is not being used.

1.0.3 - 18/11/15
  • Added optional paging type parameter that uses OData $skip, $top and $inlinecount to implement paging.

1.0.2 - 20/10/15
  • Updated basic authentication code to handle redirects, sending credentials on first request and challenge-response.
  • Increased default timeout from three minutes to one hour.

1.0.1 - 10/07/15
  • Updated code to set HTTP Basic authentication which did not appear to work in some scenarios.

1.0.0 - 15/04/15
  • Initial release of V2.
  Name Size
- GetData.png 101.97 KB
- Linked Categories.png 89.61 KB
- LisrtResources.png 83.63 KB
- metadata.png 105.62 KB
- _Feed and _Entry.png 106.11 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