Rovo Agent Response String To JSON

[Chance Douglass]

I am trying to treat the response from a Rovo agent as a JSON object and reference it using dot notation.  I have the agent response formatted correctly. Excerpt here:

{ "documentStatus": "PRD In Process", "documentOwners": [], "projectStatus": "", "prfaq": "", "epicTicket": "", "targetRelease": "", "designer": "", "techLead": "", "relatedDocumentation": [], "termsAndDefinitions": ""}

but I am unable to access any of the information outside the entire response.

I have tried using the 'jsonStingToObject()' method both as an entire variable creation and individually in line during the automation.  I can not get any results with the jsonStringToObject call either in dot notation, or for the entire string.

Anyone here had success with either of these methods? Or know of a better one?

[Alex Gallien · Accepted solution]

I came across this while trying to solve the same problem. The workaround that seems to have worked for me is saving {{agentResponse}} as a variable then passing that variable to the jsonStringToObject() function. From there I was able to use dot notation to call other values in the JSON that Rovo returned to me. Hope that helps you too!

[Bill Sheboy]

Hi @Chance Douglass 

Just following up to check if this answered your question.  If so, please consider marking this one as "answered".  That will help others with a similar need find solutions faster.  If not, please let the community know what help you need with the rule changes.

Thanks, and kind regards,
Bill

[Ryan_Buschmeyer]

@Alex Gallien or @Bill Bill 

I'm encountering the same issue.  I am able to successfully pass my {{agentResponse}} into the variable, but I have not been able to successfully pass that data into the jsonStringToObject() function.

My variable is {{agentJSON}}, do I use that as {{agentJSON.jsonStringToObject()}} or {{jsonStringToObject(agentJSON)}}?

Thanks

[Bill Sheboy]

Hi @Ryan_Buschmeyer 

It is the second one you show, {{jsonStringToObject(agentJSON)}} and then reference the attributes needed.  I recommend writing the entire thing to the audit log to confirm it contains what you expected.

And...as this is an older thread / closed question, I recommend creating a new question, perhaps adding a link back to this one for context.  That will ensure more people see it and the conversation focuses on your specific needs.  Thanks!

Kind regards,
Bill

[Ryan_Buschmeyer]

nvm, I found my solution:

First, I passed my agentResponse into a variable as instructed, but then because I have a lot of keys, I passed those all into a lookup table using:  {{jsonStringToObject(<variablename>).<key name>}}

Then I was able to access the lookup table for my needed values.

[Alex Gallien]

@Ryan_Buschmeyer - a lookup table is a great solution! 

If you're looking for an alternative approach, I've found using the .asObject and .asList methods to be more reliable than jsonStringToObject() when working with {{agentResponse}}. See How to Use {{agentResponse}} in Atlassian Automation: Unlocking the Power of AI-Driven Workflows for more info on how to use them!

[Ryan_Buschmeyer]

@Alex Gallien - Thank you so much!  This is very good!

[Ryan_Buschmeyer]

@Bill Sheboy @Alex Gallien @Chance Douglass 

Here is a Loom video showing how we are employing the Rovo response.

https://www.loom.com/share/2df6ba89a18d4069b85c2ddfe6be3e01

[Yanqing Lin]

{{jsonStringToObject(<variablename>).<key name>}} works for me when getting a json array in the automation brach. But asObject and asList do not work in my case. Two steps: 1, creates a variable and assigns agentResponse to it (e.g workItemResponse = agentResponse); 2, retrieves the element (e.g {{jsonStringToObject(workItemResponse).work_items}})  

[Evie Z_]

@Yanqing Lin 

This topic is now closed as the discussion has become outdated. If you have more questions or want to continue the conversation, feel free to start a new topic. For more details on why we close older threads, check out our Rules of engagement - Atlassian Community .

Thank you for your understanding!

[Marc -Devoteam-]

Hi @Chance Douglass 

I'm not sure but are the agent responses JSON, I think they are text.

Do you get results, when using {{agentResponse.documentStatus}} or even simpler {{agentResponse}}

What are the responses?

[Ryan_Buschmeyer]

Marc, in our case, we are telling our Rovo agent to produce its response in a structured JSON format.  We are looking to get specific data that we want inside of keys for formatting and Jira field insertion.

[Evie Z_]

@Ryan_Buschmeyer 

This topic is now closed as the discussion has become outdated. If you have more questions or want to continue the conversation, feel free to start a new topic. For more details on why we close older threads, check out our Rules of engagement - Atlassian Community .
Thank you for your understanding!