If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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
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.
View solution in original post
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.
I am new to Qlik so please pardon if my question is silly.
I am trying to achieve something similar but when I insert the URL it shows error. Could you please let me know how can I proceed further?
Also, do we need to change the REST connection URL to match the same ?