Qlik Sense Desktop Rest connector with Zendesk

[#1]

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}

}

[rittermd]

Does ZenDesk limit it to 100?

[#3]

Yes, Zendesk limit it to 100 per page.

[#4]

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

[Anonymous]

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

[Anonymous]

Another option is using 

- Pagination type: Next URL

- Field is: root/next_page

[Anonymous]

With "root/next_page" it worked fine for me

[hsorhaug]

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