Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to pass parameters dynamically in rest connector in Qlik sense

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

16 Replies
shraddha_g
Partner - Master III
Partner - Master III

I ma not so sure about JSON.

But refer Connection REST Post with request body | Qlik Community

Not applicable
Author

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
Partner - Master III
Partner - Master III

Great!

Not applicable
Author

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
Partner - Master III
Partner - Master III

Sorry, Not so aware of Mashups

pawwy1415
Creator III
Creator III

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
Contributor
Contributor

How do I pass 2 parameters