Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have set a variable in qlik sense . i have to pass this variable as query parameters in get method.
I tried to pass this variable . but getting @value .Its not retrieving data from service. But when I pass hardcoded value ,
then getting result . Can anyone help me
I ma not so sure about JSON.
But refer Connection REST Post with request body | Qlik Community
Now its working get method
I made changes in the below query and gave Id as name in query parameter.thank u so much for your reply
LIB CONNECT TO 'Rest';
Let Id='10' ;
RestConnectorMasterTable:
SQL SELECT
"CategoryName",
"Name",
"Price",
"ProductId"
FROM JSON (wrap on) "root" WITH CONNECTION (QUERY "Id" "$(Id)");
[root]:
LOAD [CategoryName] AS [CategoryName],
[Name] AS [Name],
[Price] AS [Price],
[ProductId] AS [ProductId]
RESIDENT RestConnectorMasterTable;
Great!
Hai Shraddha,
I have one Issue is mashup. Are you aware of below issue.
I have placed a horizontal UI tab menu in mashup . There are two tabs in this menu.First tab shows data in tables. Second tab shows a graph. First time when the page is loaded first tab table will be filled.
But when click on second tab graph is not showing.But when I press F12 or F11 , graph will be shown.Can anyone help me. Why graph is not displayed when clicking tab
Sorry, Not so aware of Mashups
Hi @shraddha_g
I am looking for the solution to filter the data from rest connector.
I have a query like below
SQL SELECT
"id" as "id",
"name" as "name_u1"
FROM JSON (wrap on) "root" PK "__PK_root";
From name field I have to filter only Approved Data i.e., name= 'Approved'.
Could you please help me to write the condition on API. I have tried query Parameters but no luck.
Thanks in advance.
How do I pass 2 parameters