Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Filtering data through Qlik Rest API Connector

Hi I am connecting to a table and because the table contains too many rows, I just want part of data, such as CustomerType='student', I tried Query Parameter and Query Header with Name=CustomerType and Value=student, and it returns same result as I don't pur any condition. The result returns several records for each type, what setting makes it to do so? And how do I get Student data only? Thanks!

Tags (1)
4 Replies
Highlighted
Employee
Employee

Re: Filtering data through Qlik Rest API Connector

<BUMP> - is there someone in the community that can assist?

Regards,

Mike T

Qlik

Regards,
Mike Tarallo
Qlik
Highlighted
Employee
Employee

Re: Filtering data through Qlik Rest API Connector

Hi Jessica, I moved it to the New to QlikView section to get some more visibility.

Regards,
Mike Tarallo
Qlik
Highlighted
Partner
Partner

Re: Filtering data through Qlik Rest API Connector

Hi everyone,

I faced with use of $filter parameter as well. It's strange that everything works via browsers (Chrome, IE, FF, Edge) but does not work via QV.

In my URL I have the following parameter string: <URI>?filter=Code eq '643'.

When I add the parameters to the REST Connection dialog (either into URL or Query parameters) and test connection, the "Operation is not allowed in WHERE" error appears.

I found that IIS logs contains the following:

1. for queries sent from browsers -> $filter=Code%20eq%20%27643%27

2. for queries sent from QV -> %24filter=Code+eq+'643'

I.e. QV or REST Connector replaces some symbols in such a way the service throws an error (400 or 500).

Does anyone have any assumption what can I do with this?

Thanking you in advance.

Best regards,

Maxim

Highlighted
Creator III
Creator III

Re: Filtering data through Qlik Rest API Connector

Hi Maxi,

Did you find any solution? We had same issue and we can't extract full load daily and want to extract only last 1 week record based on some conditions.