How to pass parameters dynamically in rest connector in Qlik sense

[#1]

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

[shraddha_g]

I ma not so sure about JSON.

But refer Connection REST Post with request body | Qlik Community

[#3]

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;

[shraddha_g]

Great!

[#5]

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

[shraddha_g]

Sorry, Not so aware of Mashups

[pawwy1415]

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.

[Vishal01]

How do I pass 2 parameters