I have a JSON response body that contains an id within a web request that I previously called for . I'm attempting to use the substring between to fetch the ID, but it's unsuccessful at finding it. The substring I'm using is
I'm trying to extract the number 357636
FindID:
{{webhookResponse.body.substringBetween("id=", ",")}}
The JSON response was
{queryType=flat, queryResultType=workItem, asOf=2024-10-04T19:26:34.07Z, columns=[{referenceName=System.Id, name=ID, url=https://abc.com/123/_apis/wit/fields/System.Id}, {referenceName=System.Title, name=Title, url=https://abc.com/123/_apis/wit/fields/System.Title}], workItems=[{id=357636, url=https://abc.com/123/2049fc05-e304-4422-b2be-d7c00d1f17d5/_apis/wit/workItems/357636}]}