Skip to main content
Product Release Webinar: Qlik Insider airing December 6! REGISTER TODAY!
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

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" ( 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?

0 Replies