Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jood_ahmad
Creator II
Creator II

REST Connection Query Parameters Issue

Dears, 

I have a question regarding using the rest connection and how to use the query parameter. 

I have connected to the main table by specifying the query headers and I get the response with data with JSON format and everything is fine, but when I try to connect to the details tables that have data I have to add the query parameters Name & Value like:

1st parameter.     Name: Date_Col     Value: 2019-01-01

2nd parameter.   Name: ID_Col.         Value:  _12342 

I got connect successfully but the file format that I receive is CSV file with no data or structure.

so the question is there format to have it in the query parameter to get JSON file structure and data. 

Anyone can help with that, please? 

@fosuzuki  @ArturoMuñoz 

thanks. 

Labels (5)
1 Solution

Accepted Solutions
jood_ahmad
Creator II
Creator II
Author

Dears I find the solution, 

I don't know why this is happening but when I use the filter in the Query Parameters the filter are not working fine and I'm not able to get a successful connection with my API but when i add the filter in the URL after the table name with the API format i got connected and finally i get the data.

Https:///[your URL]/[Table]?filters[coloumn 1]=xxxxxxxx&filters[coloumn 2]=xxxxxxx

View solution in original post

1 Reply
jood_ahmad
Creator II
Creator II
Author

Dears I find the solution, 

I don't know why this is happening but when I use the filter in the Query Parameters the filter are not working fine and I'm not able to get a successful connection with my API but when i add the filter in the URL after the table name with the API format i got connected and finally i get the data.

Https:///[your URL]/[Table]?filters[coloumn 1]=xxxxxxxx&filters[coloumn 2]=xxxxxxx