Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Insert square (Box) brackets to a string for a JSON build string

franciscoruizrise
7 - Meteor

Hello everyone,

 

I'm creating a workflow to send a JSON string into an API (https://help.getharvest.com/api-v2/users-api/users/users/).

Normally the string will look like this:

 

{"email":"test@test.com","roles":"ACM","has_access_to_all_future_projects":"False","is_contractor":"False","first_name":"test","last_name":"haus"}


The issue is that one of the fields, roles, the value need to be like this: "roles":["ACM"]

 

I'm trying to dynamically add the [ ] in the value for the roles field but haven't been able to do it.

Do you have any recommendation to accomplish this? Attach is a sample of the workflow.

 

Regards,

Francisco.

1 REPLY 1
binuacs
20 - Arcturus

@franciscoruizrise Not sure the below update works for you or not

binuacs_0-1684957696037.png

 

Labels