topic Re: Syntax to change URLs and Query Parameters using WITH CONNECTION in App Development

Syntax to change URLs and Query Parameters using WITH CONNECTION

Fri, 03 Feb 2017 19:36:55 GMT

I have a column of URLs, in Excel: I want to load all of them.

And I may allow user to change URL query parameters via the same Excel.

I don't want to create separate Qlik Sense REST Data connections for each.

Can I use the "WITH CONNECTION"? I'm sure I can.

WITH CONNECTION keyword

The REST Connector supports the WITH CONNECTION keyword, which can be used to override URLs, query parameters and query headers in a connection. The POST body can also be overridden when the POST method has been selected for the connection. WITH CONNECTION allows you to alter some parts of a connection rather than create a separate connection.

I can find two examples:

Modifying the URL:

WITH CONNECTION(Url "http://rd-xxx-win8.rdfund.hypertek.com:1337");

Modifying the Query parameters:

WITH CONNECTION(QUERY "startAt" "$(startAt)");

But I can't see where this "WITH CONNECTION" syntax is described -- does anyone have a link? Like in Backus-Naur form which Qlik help uses for other syntaxes.

Re: Syntax to change URLs and Query Parameters using WITH CONNECTION

Anonymous — Sun, 19 Mar 2017 22:38:46 GMT

‌Hi Nathaniel,

the the correct syntax is

WITH CONNECTION (

URL "new URL" ,

QUERY "param name" "param value",

HEADER "header name" "header value",

BODY "request body text"

)

The answer from Petter in the full context.

Re: With Connection statement - What are all the parameters possible?

Re: Syntax to change URLs and Query Parameters using WITH CONNECTION

Mon, 20 Mar 2017 16:50:47 GMT

Thank you, maybe your answer is the best source of syntax;

I'll wait before accepting your answer as I was hoping for a more definitive/authoritative source/documentation.

Re: Syntax to change URLs and Query Parameters using WITH CONNECTION

Anonymous — Mon, 20 Mar 2017 17:07:37 GMT

Unfortunately there is no more information on the web currently nor on the help.

You may log a ticket in order for Qlik to update their help.

Re: Syntax to change URLs and Query Parameters using WITH CONNECTION

Anonymous — Tue, 24 Oct 2017 12:43:09 GMT

Note HEADER should be HTTPHEADER (at least in QSE 3.2 and above)

Re: Syntax to change URLs and Query Parameters using WITH CONNECTION

slondono — Wed, 15 Nov 2017 04:01:20 GMT

I have an issue too.

It fails when i use WITH CONNECTION. I think the problem is the Header but im not sure what is exaclty the problem.

Hope you can help me

Re: Syntax to change URLs and Query Parameters using WITH CONNECTION

bjendrick — Wed, 15 Nov 2017 16:56:07 GMT

Qlik Sense 3.1 SR4

I've had to fight through this over the last week... our URL required 2 query parameters, both "start_date" and "end_date". In order to get that to work successfully, I had to set values in the initial REST connection setup, allow it to verify, and save the connection. Then in code, I had to do the following:

FROM CSV (header off, delimiter "|", quote """") "CSV_source"

WITH CONNECTION (

QUERY "start_date" "$(vCurrentStartDate)",

QUERY "end_date" "$(vCurrentEndDate)"

);

I'm sure there's someone out there that could use this with their connections. Good luck!