How to read key_value from the json array

Help
, ,
3

@sandeep_deshpande - So this is Json contain a Json array.

So You have use this hierarchy only Let’s say I want **rate ** of the marketValues so these are the steps:

  1. Read the text.
  2. DEserialize the JSON using Deserialize Json Object activity and type argument will be Newtonsoft.Json.LinqJObject result of this activity will be Res
  3. Then use Res(“marketValues”).ToString and save it in variable var1.
  4. Then Use Deserialize Json Array activity with Type Argument and pass the var1 in input and say the output of this activity will be Res2
  5. Then use For Each loop with Newtonsoft.Json.LinqJObject and pass the Res2 in For Each.
  6. In for Each use Write line activity and pass item(“rate”).ToString.

It will print all the rate in console.
Now it’s on you how you want to use it.

Best!!
Anmol

3 Likes