How to use the split() function in an action that processes a JSON object

Question

I have a JSON object that contains a property named "Born At" the property contains city, state as data. I am trying to use the split() function in an action to return just the city and not the state. I am not able to figure out how to do so. I've tried split((body.Born At but I'm not sure what the complete syntax is. can't seem to figure out the entire syntax for manipulating data in the body of the JSON object.

Thanks for any help provided!

Answer 1

The exact syntax depends on how your data is structured. Assuming your JSON looks like this:

{
  "Born At": "New York, NY"
}

you should be able to use the following expression:

split(triggerBody()?['Born At'], ',')[0]

---

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin