Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
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 (2)
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