How to extract Full user from all workspaces?

Question

Hello Community,

I’m trying to extract a complete list of users across all workspaces, including workspace name, user/email, role, and access type. I already have the data in a JSON file exported via an Alteryx REST API call, but I’m struggling to consolidate and convert it into a readable format (table/CSV/report).

Is there an official or recommended API/admin endpoint for this, and what’s the best way to flatten and normalize the JSON (one row per user per workspace)? Any examples or best practices would be appreciated.

Thanks

Amit

alexnajm · Accepted Answer

How about the JSON Parse Tool? Once it parses out you can work on it from there!