We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

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

MadYX
8 - Asteroid

New tools for me! I've never played with the json tools! great fun

Erin
11 - Bolide

Ooooh I've been meaning to set something like this up for my company's server. Just the right motivation I needed....

 

I tried to solve this two ways.......QUICK QUESTION FOR JSON PEEPS (in the spoiler) - 

Spoiler
474.pngI tried to use JSON Build which I'm not a JSON girly - so would this work if it doesn't have new lines in the output? I'm guessing I should have separated the "Value" fields by their type instead of fixing the Bool Values after the fact? Since I was lazy and read them all in as string?
Now you see why I'm not yet a JSON peep!  

 

olga_strubbe
11 - Bolide

Thank you, Valentina @The_Rad_Valentina  for a real-life challenge. This can definitely save time and effort in automating the input from the user to their permissions on the server. 

In writing my string logic, I got a bit overwhelmed with too much punctuation, so want to say thank you to @Bobbyt23 for sharing his solution on that!

Spoiler
2025-04-28_14-02-13.png
mmontgomery
11 - Bolide
11 - Bolide

c474

Spoiler
c474.png
lwolfie
11 - Bolide

I'm getting better at API's.

Noah-Waite
6 - Meteoroid

There's definitely a cleaner way to achieve this, but I at least wanted to create a solution that could also account for multiple users within a single request.

England-1
6 - Meteoroid
Spoiler
This one was tricky, loads of nuances, I believe I caught them all! Prefer to preform the payload construction in a single formula tool, not ideal but preferred in this case. :)
Screenshot 2025-04-28 162018.jpg  
binuacs
21 - Polaris
Spoiler
image.png
AaronSmatta
8 - Asteroid

Very tedious 

alineruizcampos
8 - Asteroid
Spoiler
Screenshot 2025-04-29 113555.png