How to read "status" value from below json?

{“transactionId”:“pqrstuvwxy”,“invokingUser”:“Digital People”,“timestamp”:“2021-12-06T07:57:22.836Z”,“data”:[{“created_by”:“Digital People”,“created_date”:“2021-12-01T11:20:30.000Z”,“modified_by”:“abc”,“modified_date”:“2021-12-01T11:20:30.000Z”,“ir_id”:“INC12345623”,“config_item”:“PQ RST”,“status”:“Assigned”]}


  1. Write this Json text into notepad file.

  2. And then use Read Text File activity to read the text from notepad file and it will give output as String. Let’s say stringJson.

  3. And then use Deserialize Json activity and pass above stringJson to it and it will give output as Json Object. Let’s say jsonObject.

  4. And then use below expression to get status.


Let me know if you need more details


There was an issue with the JSON you have mentioned

make sure you copied all the tags

you can also check the JSON is in correct format by copying the json result to a text file and paste the result in Best JSON Viewer and JSON Beautifier Online and click beautify, IF there are errors in JSON result then you can to see

After the correct JSON you can follow steps mentioned by @lakshman


Hi It’s giving below error
please help

as mentioned by others, the JSON has to be corrected:
checked with:

data property has a JArray value, which is to handle within the retrieval statement:
Line2: is retrieving the status from first data JArray item - (0) Access

It is recommended to grab the value with the help of Value function as we can control the returned datatype:
myJObject("data")(0)("status").Value(Of String)

In case of more items are present within the JArray we can pass the items to a for each by:
myJObject("data").Values(Of JObject)

1 Like

Thank you so much
slight_smile: myJObject(“data”)(0)(“status”).Value(Of String)
This worked

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.