Looping through Json file

[Cormac (Cormac White)]

Hello,

I am trying to loop through a Json file (attached) and find all of the “IsMissing”: false, values under the value “FieldName”: “Items”,

Would anyone know the best way to do this?Untitled.txt (320.4 KB)

[Karuna (Karuna Devanagavi)]

@Cormac
Refer this
DerializeJSON.xaml (5.7 KB)

[Cormac (Cormac White)]

Thanks @Karuna.

But if I just wanted to find the value for missing items underneath the field name ‘Items’ which is the last field name your code runs through - do you know how I would just loop through that object?

[Adrian_Star (Adrian Starukiewicz)]

Hi,
Deserialized JSON iterate in For Each:

For each item in jsonInput.Item("ResultsDocument").Item("Fields") (TypeArgument: Newtonsoft.Json.Linq.JObject)

Add data row in ArrayRow: {item.Item("IsMissing").ToString}

Then you can work on DT. For eq. filter DT.