nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Text functions not working on JSON Object or variable

Steve Kohrs_goudsf

I'm trying to parse a Web Response which is a JSON object. I saw several suggestions to use text functions to extract substrings from the response. However, it doesn't appear to work as described. The output is just blank. I've also tried creating a variable to force it to text, but the output is still blank.

tempWebResponse = {{webResponse.body.results}}
UserId = {{#debug}}{{tempWebReponse.substring(8, 15)}}{{/}}

Audit Log:

Action details:
["10099"]

Send web request
Successfully published web request

Log action
Log
tempWebResponse: {users={1220280={id=1220280, first_name=Steve,...}

Create variable
Debug message

Log action
Log
UserID:

Accepted answers

Steve Kohrs_goudsf

I think I just had a typo above. Today, I'm able to use the text functions to extract substrings from the JSON object.

All comments

Jehan Bhathena

Hi @Steve Kohrs ,

Assuming this is your webresponse :

{users={1220280={id=1220280, first_name=Steve,...}

You should be able to access the users id using this:

{{webResponse.body.1220280.id}}

Steve Kohrs_goudsf

The object name, 1220280, is a dynamic value.

Steve Kohrs_goudsf

I think I just had a typo above. Today, I'm able to use the text functions to extract substrings from the JSON object.

Jehan Bhathena

Glad to know it works now. :-)

Perhaps you can share the solution here, and mark this thread as the Accepted answer, it might help another member from the community reach the solution quicker.

Steve Kohrs_goudsf

Here's the working example:

Create variable:
usersWebResponse = {{webResponse.body.results.users}}

Create variable:
userId = {{usersWebResponse.substringBetween("{","=")}}

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud

automation