where condition IN REST API JSON Script

[aatish12345]

Hi all,

I am loading data from APIs using REST connector.

Now in order to implement incremental load, I need to load only new data based on latest date using where condition on JSON Script that got generated by default when I added data from table.

I am getting issue while using where condition in SQL JSON Code.

Can you please help me if there is a way of doing it, or any other alternative for it.

Aatish

[Andreas_Giesbrecht]

Hi Aatish12345,

Thank you for reaching out.

Did you already try and test using the WITH CONNECTION() ?

Here are some example links:

https://community.qlik.com/t5/Qlik-Design-Blog/REST-connector-Using-WITH-CONNECTION/ba-p/1523257

https://community.qlik.com/t5/Connectivity-Data-Prep/Where-statement-in-Qlik-Rest-Connector-Incremen...

Best regards

Qlik Support

[aatish12345]

Dear Andreas, thanks for the reply.

I am already using With connection for some other query parameters. 

And in where condition I want to use greater than or equal to symbol, which is not working in With connection keyword ...it only check based on equal to condition.

In one of the link you shared there also >= is used and I tried it in With connection at my end but it was not working...

Aatish

[Andreas_Giesbrecht]

Hi Aatish,

Thank you for your reply.

Are you able to verify if the REST API you are trying to reload from does allow any kind of filtering? Is is possible to filter via a third party API testing tool like POSTMAN?

Best regards

Qlik Support