The user can override connection paramters such as queryt URL, Parameters, Headers and Body using WITH CONNECTION command in the Select statement.
Environment:
Qlik REST Connector
The format is:
<select_stmt> WITH CONNECTION (<connection_item> {,<connection_item>})
connection_item = URL "new url" | QUERY "param name" "param value" | HTTPHEADER "header name" "header value" | BODY "request body text"
Example:
Set vURL="https://jsonplaceholder.typicode.com/comments";
Set vHeader="customer1";
Set vParam="?postId=1";
RestConnectorMasterTable:
SQL SELECT
"userId",
"id",
"title",
"body",
"postId",
"name",
"email"
FROM JSON (wrap on) "root"
WITH CONNECTION(
Url "$(vURL)$(vParam)",
QUERY "postId" "2",
QUERY "postId" "3",
HTTPHEADER "Cust-Header" "$(vHeader)"
);