Use of variables in rest connection.

[woutermak]

Hi,

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/customer
My second connection is to https://test.webshop.nl/api/data/v4.1/address
My 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

[ChiragPradhan · Accepted solution]

Hi,

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;

Trace $(vURL);

RestConnectorMasterTable:
SQL SELECT 
	'
    '
    '
    '
FROM JSON (wrap on) "root"
WITH CONNECTION(Url "$(vURL)");
;

[root]:
LOAD
	'
	"
    "
    "
    "
    '
RESIDENT RestConnectorMasterTable;


DROP TABLE RestConnectorMasterTable;

If it is what you are looking for, please consider marking it as resolved.

Regards,

Chirag

[woutermak]

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.

Wouter

[msuvarna]

Hi,

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 ?