General Web Connector
Get data from any URL
De Qlik General Web Connector can retrieve data, for example JSON or XML data, from any URL and with this you can easily connect directly and in a structured way to many web services. The connector is designed with a global approach so that it can connect to many different APIs. You must comply with the terms of use of the specific API you want to connect.
De Qlik General Web Connector is part of Qlik Web Connectors - a comprehensive suite of preconfigured connectors for major social media and web-based data sources.
Since this connector is a generic connector, you can define the following parameters:
- Make GET, POST, PUT or DELETE requests to any URL.
- Read files directly from your local machine.
- Automatically convert JSON data to XML data.
- Requests to make SOAP web services.
- Require a URL to be encoded to prevent sensitive parameters from spreading in your Qlik load script.
- Set a cookie to be sent with a request.
- Set custom http headers.
- Set a minimum time between requests.
- Specify optional basic authentication privileges.
- It is possible to connect to an OAuth2 based API with the Qlik GeneralWebConnector.
To do this, you must be able to generate an access token from the OAuth2 service. For example, you can
send the access token as a header or URL parameter. - Minimize the requests to the API by allowing the response to be stored up to
a certain amount of time, for example when the results rarely change. - Configure the content type of the request.
- Configure the user agent of the request.
- Make a large volume request on parallel threads using the parallel function. This works on the
tables XXXXToTable. - Store a response from an API, or an http request, directly on the local file system. For example, you can download images and then load binary into your Qlikview of
Qlik Sense application. - You can access the headers returned from the response through the ResponseMetaData table.
- Set a request timeout, that is, increase or decrease the default value of 180000 ms or 3 minutes.
- Configure a recurrence for the request in case of failure after a specified number of milliseconds.
The data that is returned can be entered directly Qlikview of Qlik Sense can be streamed as XML, using Qliknative XML parsing functionality.
Alternatively, there are tables in the connector that try to convert the data into QVX tables.