Create JSON from Fields

I am attempting to build a workflow that will take customer phone numbers from our PSA (HaloPSA) and POST them to the Zoom API. This workflow gives some sample content and what I started playing with before realizing it won’t work. Essentially, I need it to handle situations where one or two of the three fields could be null. The important fields here from the initial content is name, email, phonenumber, mobilenumber and mobilenumber2.

To provide as much info as possible, here is how the Zoom API requires the JSON to be formatted, using the first result of the sample workflow above. I’m obviously not married to using Set here. Just whatever get’s me the output I need below. As always, thanks in advance!

{
  "email": "[email protected]",
  "name": "John Smith",
  "phone_numbers": [
    "+14035557777",
    "+14035554321"
  ]
}

@MutedJam provided the solution via Discord. Thanks Tom!

2 Likes

Glad to hear this worked, thanks so much for confirming!

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.