Skip to main content
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Rest Connector set up for dynamic data filter

Hi Members,

 Need help on this issue.

I am using REST connector to fetch data, and below is the query URL.

In the URL, using static date value, how to use this as dynamic date, e.g. last month start and end date for time_stamp column.

REST URL: TOP 1000 application_name as 'Application Name',AVG(IF(availability_status,>,0,1,0))*100 as 'Application Availability',AVG(dResponseTime/1000) as 'Response Time' from trans_t where time_stamp>=20201101 and time_stamp<20201130 and customer_name='Default Client'

Response type: using as XML (Auto Detect, JSON is failing if select)

Can any one help me on this.

Qlik Sense 

Labels (2)
0 Replies