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