Can I query against the saas users members?

[dwighttrumbower]

I have a need to show a persons name in an email report. I'm wondering if I can merge my sql data with user's sales territory and email with the tenant user list and grab their name? 

Currently I would have to add a column in the table that stores the email and territory and include name for recipients name. I would prefer not to maintain the name in multiple places.

Thanks

[WeLoveQlik]

https://yourtenant.us.qlikcloud.com/api/v1/users

This is the qlik API you want to use.

Create a REST connection using that URL and you should be able to pull all user information for all users with access to the tenant

[dwighttrumbower]

Now I after figure out how to to get Rest connection to work. I've tried all authentication schemas and the SAML login. Test connection always fails.

[WeLoveQlik · Accepted solution]

To create this rest connection.

First, Go to the Admin Screen, on the left hand side Scroll to API Keys, and click Generate New. You might need to grant yourself the permissions to do so under the Manage user > Permissions section.

Its not a default option, so 

1. Create New
2. Give it a Name
3. Click Features and Actions
4. Click Developer
5. Change Manage API Keys Dropdown to Allowed
6. Confirm
7. Go back to All Users
8. Find yourself, Click the 3 dots on the right, Manage Roles
9. Add the newly Created Role

Then, when creating the rest connection, you just need to enter

URL: https://yourtenant.us.qlikcloud.com/api/v1/users

Then scroll down to Query Headers

Name: Authorization Value: Bearer TheLongAPIKeyStringYouCreatedAbove

Then Scroll to Pagination Type

Change Dropdown to Next URL

"Next URL' path: links/next/href

[dwighttrumbower]

So you don't put anything in the Authentication Schema?

[WeLoveQlik]

Anonymous

[WeLoveQlik]

can you screenshot the rest connection screen with the information you are entering?

[dwighttrumbower]

I got it. Entering in wrong fields.