Get specific values form json file

[Mathkar_kunal]

Hello,

i need to split below json and need to get values of defects
check below json
{

“testExecutionKey”: “P000110-15004”,
“tests”: [
{
“status”: “PASS-PARTIALLY”,
“testKey”: “P000110-6436”,
“start”: “2023-11-22T09:43:48+01:00”,
“executedBy”: “abc”,
“defects”: [
“P000110-15008”,
“P000110-15008.1”
],
“evidences”: ,
“steps”: [
{
“status”: “PASS”,
“defects”: ,
“evidences”:
},
{
“status”: “EXECUTING”,
“defects”: [
“attachment1/P000110-14943”,
“attachment2/P000110-14944”
],
“evidences”:
}
],
“assignee”: “abc”,
“testEnvironments”: ,
“iterations”: ,
“comment”: “null”
}
]
}

i need values under defects which are
“P000110-15008”,
“P000110-15008.1”

and values under second defect which is in steps
“attachment1/P000110-14943”,
“attachment2/P000110-14944”

let me now how can i achieve this
one json file contains multiple testKey’s which is under “testExecutionKey” but one json contains only one testExecutionKey
above is for one test key

[Krishna_Raj]

@Mathkar_kunal

How to get specific values form json

Hi, Can you try the following sample? [image] Sample Sample20240125-6.zip (3.8 KB) Regards,

check above thread

[Mathkar_kunal]

here values in array splitting with comma.
will it get values one by one in array?

[supriya117 (Supriya Allada)]

Hi @Mathkar_kunal

Deserialize JSON: JSONString → jsonObject

defectsArray = jsonObject("tests")(0)("defects").ToString
stepsArray = jsonObject("tests")(0)("steps").ToArray
secondDefectsArray = stepsArray(1)("defects").ToString

[pravallikapaluri]

Hi @Mathkar_kunal

jsonObject("tests")(0)("defects").ToString

jsonObject("tests")(0)("steps")(1)("defects").ToString

Hope it helps!!

[vrdabberu (Varunraj Dabberu)]

Hi @Mathkar_kunal

Try the below syntaxes:

defectsValues= String.Join(vbCrLf,JObject("tests")(0)("defects").ToObject(Of JArray).Select(Function(x) x.ToString()).ToArray())

secondDefectsValues= String.Join(vbcrlf,JObject("tests")(0)("steps")(1)("defects").ToObject(Of JArray).Select(Function(x) x.ToString()).ToArray())

Regards

[ppr (Peter Preuss)]

one of many options which can also be adapted

[Mathkar_kunal]

thanks can u tell how to extract defect from ollowing

{
“status”: “EXECUTING”,
“defects”: [
“P000110-14943”,
“P000110-149434”
],
“evidences”:
}

need below values
“P000110-14943”,
“P000110-149434”

[Nawazish_Ahmad]

Hi @Mathkar_kunal

1. Deserialize JSON - Output as JObj
2. Use Assign Activity with Variable ArrDefects - String(Of Array)

And use below expression

ArrDefects = If(JObj.SelectToken(“tests[0].defects”) IsNot Nothing, JObj.SelectToken(“tests[0].defects”).ToObject(Of String()), Nothing)

Hope it will helps you
Cheers!!

[pravallikapaluri]

@Mathkar_kunal

{
“status”: “EXECUTING”,
“defects”: [
“P000110-14943”,
“P000110-149434”
],
“evidences”:
}

@Mathkar_kunal

Jsonout("defects").ToString