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)
As a little bit of extra fun I uploaded it and it passes, a fun fact is you don't need to have the JSON fields in the correct order for the creation to be successful!
This challenge comes at a convenient time after I've been using the Server API Tool quite a lot lately. I've built this payload quite a few times to automate user creation :)
Enjoyed this one! Took a little while to get everything exact, but I managed to get there in the end.
Not sure if I have oversimplified this but just did it in one formula.
That was a tonne of fun!!!
Loads of "gotchas" in there if you're trying to get the EXACT answer 😎.
Tried to make it dynamic so it builds payloads for multiple users aswell.
Time Taken: 38 mins
Got to the answer in the above portion of the workflow and then tried playing around with the JSON Build Tool to gain some practice with the tool.
