Object reference not set to instance of object with JSON Array

[erommel (Eric Rommel)]

Check out the following topic on JSON parsing

4. RPA Challenge - Json Parsing

Like I said, there’s no error It’s just that the whole file is not a strict JSON, but a JSON array in itself - if you use Deserialize JSON Array activity instead, it’ll work. Solution attached - Linq and SelectToken variants. Sidenote - for better view if it’s correct change the phone numbers in the file so they’re not all identical. Main.xaml (9.5 KB)

Or the following StackOverflow on JSONPath

Is there a JSON equivalent of XQuery/XPath?