
Hi Community members,
A solution to last week’s challenge can be found here.
This challenge was submitted by Valentina Radchanka (@The_Rad_Valentina). Thank you, Valentina, for this interesting challenge!
Alteryx Server is a great platform that allows developers to share and automate workflows with business users. To access workflows on Server, business users typically need permission to interact with the Gallery, which is a central hub for running and managing workflows.
By default, when a user navigates to the Gallery for the first time, they are automatically assigned a Default role. This allows them to run publicly available workflows, such as an Access Request Form.
Here is how the Access Request process works:
- A user submits the Access Request Form, specifying their email and preferences for:
- Workflow scheduling (whether they can schedule jobs)
- Creating collections (whether they can organize workflows into collections)
- API access (whether they need programmatic access to workflows)
- The request goes through an approval process to ensure that only authorized users receive the requested permissions.
- Once approved, another workflow is triggered to automate access changes, eliminating the need for manual intervention by the Server Administrator (Curator).
This challenge includes two datasets:
- Server user data Text Input: Information about users in Server.
- Single user request data Text Input: Information submitted by a single user via the Access Request Form.
Your task is to generate a “payload” (a structured JSON-like data format) that the Alteryx Server API can use to grant the appropriate access permissions to the user. Your final output should look like this:

Hint: The Formula tool is your best friend! 😁
Need a refresher? Review the following lesson in Academy to gear up: Diving Into Expressions
Ready to take on this challenge? Good luck!
The Academy Team
Source:
Server API Tool ( https://marketplace.alteryx.com/en-US/apps/418052/server-api-tool)