Looping through Json file


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)

Refer this
DerializeJSON.xaml (5.7 KB)

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?

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.