How to quickly get the value from a json

Help
1

this is a json
how to quickly get the red marked value?

json
json557Ă—762 25.5 KB

2
  1. Read text file
  2. Deserialize json object - outputVariable - VariableType(Newtonsoft.Json.Linq.Jobject)
  3. outputVariable(“data”)(“ret”)(“word_name”).ToString

Thanks!

1 Like
3

Use deserialize JSON and try to use this in the message box @fightblue

jsonObject.Item(“data”).Item(“ret”) which will give you the array you have in the ret key.

then use deserialize json array and then loop through each object inside and get the value as jsonarrayserialized.Item(“word”)

4

Fine
try with this expression once after deserializing JSON file
lets take like the output variable of Deserializa JSON activity as out_json
–now in a write line activity mention as
out_json(“data”)(“ret”)(3).tostring

this would give you that value
Cheers @fightblue

6 Likes
5

thanks,it is outputVariable(“data”)(“ret”)(0)(“word”).tostring

6 Likes
6

thanks

7

thanks, it is out_json(“data”)(“ret”)(0)(“word”).tostring

8

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