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

leonaschaaf — Wed, 16 Sep 2015 14:08:08 GMT

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-tickets) it 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?

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

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