Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

Not applicable

Qlik Sense Desktop Rest connector with Zendesk

I try to use Qlik Sense Desktop (3.1 SR4) Rest connector with Zendesk to get all Zendesk users.

But the pagination does not work, I only get the first 100 users.

Configuration of Rest connector:

Request
Authentication
  • Use Windows authentication: No
  • User Name: *username*
  • Password: ************
  • Force basic authentication: No
  • Use certificate: No
Pagination
  • Pagination type: Next URL
  • Next url field path: next_page

Rest Response

(https://[company].zendesk.com/api/v2/users.json):

{

"users":[100]

,"next_page": "https://[company].zendesk.com/api/v2/users.json?page=2"

,"previous_page":null

,"count":1378}

}

6 Replies
rittermd
Honored Contributor

Re: Qlik Sense Desktop Rest connector with Zendesk

Does ZenDesk limit it to 100?

Not applicable

Re: Qlik Sense Desktop Rest connector with Zendesk

Yes, Zendesk limit it to 100 per page.

Not applicable

Re: Qlik Sense Desktop Rest connector with Zendesk

I've experienced problems with pagination in the 3.1 R4 REST connector, try installing the rest connector off the qlik marketplace and see if it makes it difference.

http://market.qlik.com/rest-connector.html

velthuisf
New Contributor III

Re: Qlik Sense Desktop Rest connector with Zendesk

You can use the custom option and use a loop to walk through the next pages:

Let total = Round(FieldValue('X-Total-Count',1)/100);

Let startAt = 1;

for startAt = 1 to total step

WITH CONNECTION(Url "https://doaj.org/api/v1/search/journals/page=$(startAt)");

velthuisf
New Contributor III

Re: Qlik Sense Desktop Rest connector with Zendesk

Another option is using 

- Pagination type: Next URL

- Field is: root/next_page

mariozoske
New Contributor II

Re: Qlik Sense Desktop Rest connector with Zendesk

With "root/next_page" it worked fine for me