LINQ to extract field from Json Array

Help Studio
,
1

Hi,

I need your help. How can I create a LINQ query to loop through the entire JSON Array and extract the ID = “6789” from:

[
{
“ID”: “12345”,
“NAME”: “Juan Porras”,
“SCHEDULE START”: “12:00 PM”,
“SCHEDULE END”: “09:00 PM”
},
{
“ID”: “6789”,
“NAME”: “Michael J”,
“SCHEDULE START”: “03:00 PM”,
“SCHEDULE END”: “12:00 AM”
}
]

I’ll need something like: ID = {your_linq}

Is that possible?

Juan P.

2

parse the JSON into a JArray - out: myJArray

Assign Activity:
arrValues | DataType: String Array =
myJArray.Values(Of JObject).Select(Function (x) x("ID").Value(Of String)).toArray

3

UPD1 - Visualizations:
grafik
out: myJArray

grafik

4

Ah, awesome! Thank you

5

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