topic Re: Can I query against the saas users members? in Data Movement & Streaming

Can I query against the saas users members?

dwighttrumbower — Fri, 20 Mar 2026 13:26:34 GMT

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

Re: Can I query against the saas users members?

WeLoveQlik — Fri, 20 Mar 2026 14:39:50 GMT

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

Re: Can I query against the saas users members?

dwighttrumbower — Fri, 20 Mar 2026 18:37:14 GMT

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.

Re: Can I query against the saas users members?

WeLoveQlik — Fri, 20 Mar 2026 18:50:01 GMT

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

Create New
Give it a Name
Click Features and Actions
Click Developer
Change Manage API Keys Dropdown to Allowed
Confirm
Go back to All Users
Find yourself, Click the 3 dots on the right, Manage Roles
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

Re: Can I query against the saas users members?

dwighttrumbower — Fri, 20 Mar 2026 19:37:39 GMT

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

Re: Can I query against the saas users members?

WeLoveQlik — Fri, 20 Mar 2026 20:31:08 GMT

Anonymous

Re: Can I query against the saas users members?

WeLoveQlik — Mon, 23 Mar 2026 00:24:01 GMT

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

Re: Can I query against the saas users members?

dwighttrumbower — Mon, 23 Mar 2026 00:41:25 GMT

I got it. Entering in wrong fields.