How to parse json with specified key value using SIL

[MeterSphere Demo]

Below is the sample of the JSON. I want to get the id and workspaceId with the given value of jirakey using SIL. 

In this given JSON, how to get id and workspaceId with "jirakey=MD" ?

--------------------------------------------------

{
"success": true,
"message": null,
"data": [
{
"id": "AAAAAAAAAAAAAAA",
"workspaceId": "BBBBBBBBBBBBBBBB",
"name": "name01",
"description": null,
"jiraKey": "MD",
"platform": "Jira",
"workspaceName": "workspace1"
},
{
"id": "CCCCCCCCCCCCCCCCCC",
"workspaceId": "dddddddddddddddd",
"name": "name02",
"description": "mydescription",
"jiraKey": null,
"platform": "Local",
"workspaceName": "workspace2"
}
]
}

---------------------------------------------------

In JMeter, there's way as following:

$.data[?(@.jiraKey=="MD")].id
$.data[?(@.jiraKey=="MD")].workspaceId

How about in SIL? 

[Andrea Pannitti]

Hi @MeterSphere Demo

you should use fromJson to get the json like an object and then you should get the property like it showed in this documentation page.

[Ingo Bultschnieder]

I would love to see the document page, but how do i get access to cprime confluence?

[Andrea Pannitti]

Hi @MeterSphere Demo,

Just a thing about your json: there is an issue due to the comma near "workspace1" and near "workspace2".
I recommend you to use a Json validator like: JSONLint.

[MeterSphere Demo]

Thank you @Andrea Pannitti for pointing it out. I corrected the json. 

This was because I removed part of the content in the original json. 

[MeterSphere Demo]

removing the wrong comments