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
