0 Replies Latest reply: Sep 16, 2015 10:08 AM by Leona Schaaf RSS

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

    Leona Schaaf

      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?