Get value from JSON data

Help Studio
, , , ,
1

Hi team ,

This is my json -

[{“WD_ExceptionID”:“WD-0003”,“WD_ExceptionMessage”:“Company Address is not matching with workday custom report”},{“WD_ExceptionID”:“WD-0003”,“WD_ExceptionMessage”:“Supplier Address is not matching with workday custom report”}]

I just want to obtain all the “WD_ExceptionMessage” in different lines.
How to achieve this after deserializing?

Regards,
G

2

we deserialize to a JArray:
grafik

can loop over it by:
grafik

or using LINQ:

grafik
grafik819×269 72.3 KB 

arrExtractResult =
yourJArrayVar.SelectTokens("$..WD_ExceptionMessage").Select(Function (x) x.Value(Of String)).ToArray

bringing this array to flatten string with Linebreaks we can do:
String.Join(Environment.NewLine, arrExtractResult)

3

Hello @gokul1904

You need to use like

item.SelectToken(“WD_ExceptionMessage”) inside the for each

image
image716×533 13.6 KB

Regards
Sudharsan

4

Kindly note: we do have two methods

SelectTokens <-s - retrieval all founds

And SelectToken ← without s - retrieve first found

5

Hi @gokul1904 ,

Could also try with an Alternate, direct convert to Datatable :

DT = Newtonsoft.Json.JsonConvert.DeserializeObject(Of Datatable)(strJson)

Here, strJson is the Json data (JArray) that you have in string format.

image