Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
aatish12345
Creator II
Creator II

where condition IN REST API JSON Script

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

Labels (1)
3 Replies
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
Creator II
Creator II
Author

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