Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
anilmahanty
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: https://DNS.domain.com/topaz/gdeopenapi/GdeOpenApi?method=getData&user=username&password=password&qu... 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