Trying to parse JSON and match specific values out

[Gilad Waldman]

Hello, I have a field that is populated with multiple platform versions :

{ "Browser": ["1.2.3", "1.23.0"], "Extension": ["1.8.6p"], "Protect": ["1.98.4p", "1.98.4p", "1.98.4p"], "SSH": ["1.87.0"] }

Am trying to build an automation rule that parse the text and brake it into different fields like this:

Browser ->  ["1.2.3", "1.23.0"]

Extension -> ["1.8.6p"]

I first tried to use this smart value : {{ issue.customfield_10582.asJson."Browser"}}

but i get nothing, so was trying to use asJsonObject but still can match.

any ideas?

[Bill Sheboy]

Hi @Gilad Waldman 

Please try using the function jsonStringToObject() to convert the plain text to JSON which can access the elements with dot-notation:

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-text-fields/#jsonStringToObject--

Kind regards,
Bill

[Marc - Devoteam]

Hi @Gilad Waldman 

You will have to use smart values, based on text options.

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-text-fields/ 

Then create a variable and use the smart value: {{issue.customfield_10582.substringBetween("[","]")}}

Then log this as well and see what you get as result.

With an edit action set the field based on the variable.

[Gilad Waldman]

Wondering why... this should JSON should be easier to extract data from.

[Marc - Devoteam]

Hi @Gilad Waldman 

Then you need to set the options as an array.

{{issue.customfield_10582.asJsonStringArray}}

See https://support.atlassian.com/cloud-automation/docs/jira-smart-values-json-functions/ 

[Gilad Waldman]

familiar with the documentation, thanks. its just keeps returning empty value

[Gilad Waldman]

for example, if i use 

asJsonObject: {{issue.customfield_10582.asJsonObject("Browser")}}

I'm expecting to get the values ["1.2.3", "1.23.0"] but instead im getting: 

{ "Browser": "{\"Browser\": [\"1.2.3\", \"1.23.0\"],\"Extension\": [\"1.8.6p\"],\"Protect\": [\"1.98.4p\", \"1.98.4p\", \"1.98.4p\",\"1.1.1\"],\"SSH\": [\"1.87.0\"]} " }

[Marc - Devoteam]

Hi @Gilad Waldman 

What do you get on using {{issue.customfield_10582.asJsonStringArray}}

What you expect is not right, as the values you are trying to fetch in a single field, so you get everything.

You will 1st need to get the values in an array and from the array use the values you want to place in the respective fields.

[Gilad Waldman]

Ok that helps, im just not sure why it doesnt allow me to break it into an array

When I'm using asJsonStringArray Im not getting back any value

Only if I'm trying to use asJsonObject as seen above 

[Marc - Devoteam]

Hi @Gilad Waldman 

As mentioned before the information you have is text, so you need to split this content, you can use the text smart value options for this.

See this form post on why setting text as as json object is hard and iratic.

https://community.atlassian.com/forums/Jira-questions/Parsing-a-text-field-with-a-JSON-object/qaq-p/2260884 

[Yash Smith]

Can you please explain in detail?

[Gilad Waldman]

explain what exactly?