Question

Process Formula String Manipulation

I have the following response body from my call web service process to create a customer:

{"Customer":{"Taxable":true,"BillAddr":{"Id":"118","Line1":"Apartment","City":"Sarajevo","Country":"Maryland","CountrySubDivisionCode":"92","PostalCode":"38701"},"Job":false,"BillWithParent":false,"Balance":0,"BalanceWithJobs":0,"CurrencyRef":{"value":"USD","name":"United States Dollar"},"PreferredDeliveryMethod":"Print","IsProject":false,"domain":"QBO","sparse":false,"Id":"62","SyncToken":"0","MetaData":{"CreateTime":"2025-09-30T00:29:36-07:00","LastUpdatedTime":"2025-09-30T00:29:36-07:00"},"GivenName":"Genie","FullyQualifiedName":"Genie","CompanyName":"Genie","DisplayName":"Genie","PrintOnCheckName":"Genie","Active":true,"PrimaryPhone":{"FreeFormNumber":"(430) 849 0992"},"PrimaryEmailAddr":{"Address":"Genie@rinse.com"},"DefaultTaxCodeRef":{"value":"2"}},"time":"2025-09-30T00:29:36.269-07:00"}

I want to parse out the second id, ""Id":"62"". Is there a way to do this in a process formula or do I need a script task?

Many thanks.

Like 0

Like

0 comments
Show all comments