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

SteveY02
8 - Asteroid

Not sure my answer is 100% correct. PS, I can't find the "isCredentialed", Whre is it?

AkimasaKajitani
17 - Castor
17 - Castor

My solution. I will use the JSON Build tool for actual workflow. 

 

Spoiler


image.png

martinson
11 - Bolide

Very cool

Cheers,
martinson

LinkedIN

Bulien
wbasuki
8 - Asteroid

My Solution

Spoiler
Screenshot 2025-04-29 164117.png
RWvanLeeuwen
11 - Bolide

here's my take

Spoiler
474.png
patrick_digan
17 - Castor
17 - Castor
Spoiler
image.png
RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
474.jpg
Kenda
16 - Nebula
16 - Nebula
Spoiler
image.png
jfissel
8 - Asteroid
Spoiler
Challenge_474_jfissel.png
Yoshiro_Fujimori
15 - Aurora
15 - Aurora

I started with Transpose and Summarize, but ended up with Formula Tool,

as the key names do not always match with the input field names.

 

Spoiler
Workflow
workflow.png

Formula Tool

[payload] = 
'{
  "id": ' + [id] + ',
  "firstName": ' + [firstName] + ',
  "lastName": ' + [lastName] + ',
  "email": ' + [email] + ',
  "role": ' + [role] + ',
  "defaultWorkerTag": "",
  "canScheduleJobs": ' + [canSchedule] + ',
  "canPrioritizeJobs": ' + [canSetPriority] + ',
  "canAssignJobs": ' + [canSetWorkerAssignment] + ',
  "canCreateCollections": ' + [canCreateCollections] + ',
  "isApiEnabled": ' + [isApiEnabled] + ',
  "defaultCredentialId": "",
  "isAccountLocked": ' + [accountLocked] + ',
  "isActive": ' + [active] + ',
  "isValidated": ' + [validated] + ',
  "timeZone": ' + [timezone] + ',
  "language": ' + [language] + '
}'