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] + '
}'