topic Re: Filtering data through Qlik Rest API Connector in QlikView

Filtering data through Qlik Rest API Connector

Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Filtering data through Qlik Rest API Connector

Michael_Tarallo — Mon, 27 Jun 2016 16:00:46 GMT

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

Regards,

Mike T

Qlik

Re: Filtering data through Qlik Rest API Connector

Michael_Tarallo — Mon, 27 Jun 2016 16:01:32 GMT

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

Re: Filtering data through Qlik Rest API Connector

maksim_senin — Mon, 11 Jul 2016 08:14:07 GMT

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

Re: Filtering data through Qlik Rest API Connector

pawwy1415 — Mon, 02 Sep 2019 21:04:00 GMT

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.