Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Dynamic variable in QVsource request URL for ticket id (zendesk)

I need data from Zendesk. I get data from Zendesk through their API. At the moment I need the Zendesk tickets so I generated a request URL with QVSource. There are a lot of tickets so I created a loop since I can request a maximum of 100 tickets in one request. But with this it gets every ticket individually in one request.

In the documentation of Zendesk at "show multiple tickets" https://developer.zendesk.com/rest_api/docs/core/tickets#getting-tickets (https://developer.zendesk.com/rest_api/docs/core/tickets#getting-ticketsit says you can insert id’s comma separated to get more than one id in one request.

I could just enter the values 1 till 100 comma separated but I'm looking for an easier way. In Qlikview you can create dynamic variables for start date and end date. So I'm wondering if there’s a way to create a dynamic variable for ticket id so I can say ticket id 1 (min ticket id) till ticket id 100 (max ticket id) . Hope this makes sense

Anybody who know if this is possible and how I can do this?