This important step enables you to create the setup of your REST connector and to import your AT Internet data into Qlik.
You will then be able to load a REST URL (in XML or JSON format) which you can obtain directly in the Data Query application within AT Internet’s Analytics Suite.
Create a query in Data Query
Build your query in Data Query and select the API REST URL relating to your dataset.
To be able to import data into Qlik, it’s mandatory to have the Data Explorer option enabled, which will give me access to the Data Query application.
Go into Data Query:
Create a new template, or use an existing template:
Import data from AT Internet’s API into Qlik
Select the URL created at the bottom of your dataset, in JSON, HTML or XML format.
Only paste the beginning of your URL, up until GET DATA: https://apirest.atinternet-solutions.com/data/v2/json/getData
Paste this Data Query URL into the URL section of the setup window.
Then, you must login in order to access your data. Enter your AT Internet login and password.
Now, specify the different parameters that make up this API URL by detailing out each “Query parameter” one by one.
The URL obtained in Data Query offers the following parameters:
Carefully transfer these parameters over into the different fields below:
To save your data connection, be sure to verify that your connection has been successfully tested.
When you get back to the editor mode, resize the window to make appear the OK button which will allows you to validate and import the data source.
Once the connection is registered, you have to reload the data by clicking in the Menu File > Reload data.