Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
jood_ahmad
Contributor 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. 

1 Solution

Accepted Solutions
jood_ahmad
Contributor II

Re: REST Connection Query Parameters Issue

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

1 Reply
jood_ahmad
Contributor II

Re: REST Connection Query Parameters Issue

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