Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #474: Create an API Payload for Alteryx Server User Updates

AYXAcademy
Alteryx
Alteryx

Full Width - WC banner.svg

 

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:

 

  1. 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)
  2. The request goes through an approval process to ensure that only authorized users receive the requested permissions.
  3. 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:

 

AYXAcademy_0-1745850755712.png

 

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

 

Download Start File

 

Source:
Server API Tool ( https://marketplace.alteryx.com/en-US/apps/418052/server-api-tool)

DylanBell
9 - Comet
Spoiler
 
Screenshot 2025-04-28 161612.png

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!

Screenshot 2025-04-28 164505.png

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 :)


Bulien
Pilsner
11 - Bolide

Enjoyed this one! Took a little while to get everything exact, but I managed to get there in the end.

Spoiler
474.png

Bobbyt23
12 - Quasar

Not sure if I have oversimplified this but just did it in one formula.

Spoiler
Had to change the Boolean to string in the join tool too.

image.pngimage.png
BS_THE_ANALYST
14 - Magnetar
14 - Magnetar

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.

 

Spoiler
Workflow
Screenshot 2025-04-28 164117.png
Time Taken: 38 mins

 

All the best,
BS

LinkedIN

Bulien
Kilbyflow_Designer
8 - Asteroid

Done!

 

Spoiler
Challenge 474.jpg

TurboToad
11 - Bolide

Done this exercise a few times before!

 

Spoiler
image.png
BransonJamesFarley
8 - Asteroid
Spoiler
C474.png

 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. 

Flo_P
9 - Comet
Spoiler
Could not really be bothered to go through the fields so we'll assume the API accepts it all - fun challenge!
image.png
balajilolla2
10 - Fireball
Spoiler
Solution Attached

Screenshot 2025-04-28 092738.png