topic Re: where condition IN REST API JSON Script in Connectivity & Data Prep

where condition IN REST API JSON Script

aatish12345 — Fri, 01 Apr 2022 07:21:53 GMT

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

Re: where condition IN REST API JSON Script

Andreas_Giesbrecht — Fri, 01 Apr 2022 10:58:54 GMT

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-Incremental-Load/td-p/1341093

Best regards

Qlik Support

Re: where condition IN REST API JSON Script

aatish12345 — Sun, 03 Apr 2022 05:37:57 GMT

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

Re: where condition IN REST API JSON Script

Andreas_Giesbrecht — Tue, 05 Apr 2022 07:42:42 GMT

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