Discussion board where members can get started with Qlik Sense.
I'm using a REST connection to get my data. But I create for each end point a new connection.
See the picture below:My first connection is to https://test.webshop.nl/api/data/v4.1/customerMy second connection is to https://test.webshop.nl/api/data/v4.1/addressMy third connection is to https://test.webshop.nl/api/data/v4.1/shipto
Is there a possibility to use a variable, something like https://test.webshop.nl/api/data/v4.1/$(V_connnection)Or is there a smarter solution.
Please let me know.Wouter
Go to Solution.
Once you have connected to the API,
You could something like this -
Let V_Connection = 'Customer';
Let vURL = '<a href="https://test.webshop.nl/api/data/v4.1/" target="_blank">https://test.webshop.nl/api/data/v4.1/</a>' & V_Connection;
FROM JSON (wrap on) "root"
WITH CONNECTION(Url "$(vURL)");
DROP TABLE RestConnectorMasterTable;
If it is what you are looking for, please consider marking it as resolved.
Yes it works for me.Sometimes it's easier to create the connection in QlikView and load the data. Copy the of the script code to your Sense Solution. You can use the end of the connection part of the code for the variable V_Connection.