topic Re: Qlik Sense Desktop Rest connector with Zendesk in Integration, Extension & APIs

Qlik Sense Desktop Rest connector with Zendesk

Mon, 16 Jan 2017 11:36:44 GMT

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

URL: https://[company].zendesk.com/api/v2/users.json
Timeout: 30
Method: GET

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}

}

Re: Qlik Sense Desktop Rest connector with Zendesk

rittermd — Tue, 17 Jan 2017 16:22:17 GMT

Does ZenDesk limit it to 100?

Re: Qlik Sense Desktop Rest connector with Zendesk

Tue, 17 Jan 2017 16:25:37 GMT

Yes, Zendesk limit it to 100 per page.

Re: Qlik Sense Desktop Rest connector with Zendesk

Thu, 26 Jan 2017 10:51:09 GMT

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

Re: Qlik Sense Desktop Rest connector with Zendesk

Anonymous — Fri, 07 Apr 2017 15:33:04 GMT

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)");

Re: Qlik Sense Desktop Rest connector with Zendesk

Anonymous — Fri, 07 Apr 2017 15:35:58 GMT

Another option is using

- Pagination type: Next URL

- Field is: root/next_page

Re: Qlik Sense Desktop Rest connector with Zendesk

Anonymous — Tue, 19 Sep 2017 14:23:17 GMT

With "root/next_page" it worked fine for me

Re: Qlik Sense Desktop Rest connector with Zendesk

hsorhaug — Fri, 11 Jan 2019 11:17:47 GMT

Hi,

If you or someone else got an example of your solution (something similiar) it would be great if you could share en extract of this? been trying both custom and "Next Url" types of pagination, but having problem to get more results than 100 (get pagination to work).

Br,

Henrik