JSON Query wildcard

Help Activities
, ,
5

@SorenB

Perfect, also have a look at this variation as mentioned on:

myLKDict | Dictionary(Of String, String) =

(From jt In myJOBject.SelectTokens("..[?(@.identifier == 'ElementUpload')].values")
From pr In jt.Value(Of JObject).Properties()
Where pr.Name.toUpper().StartsWith("DOCUMENT-")
Select r=pr).ToDictionary(Function (x) x.Name, Function (x) x.Value.Value(Of String))

An image showing a coding console with JSON-like string data and dictionary declarations in C#, including identifiers and document values. (Captioned by AI)
An image showing a coding console with JSON-like string data and dictionary declarations in C#, including identifiers and document values. (Captioned by AI)478×435 32.9 KB

So we avoid doing the same retrieval job twice (result check and result retrieval)

And also the negative / empty result test:

The image shows a debugging session displaying a JSON-like object structure with identifiers and attachments, highlighted numbers for attachment keys, alongside the inspection of a dictionary and a Boolean check result. (Captioned by AI)
The image shows a debugging session displaying a JSON-like object structure with identifiers and attachments, highlighted numbers for attachment keys, alongside the inspection of a dictionary and a Boolean check result. (Captioned by AI)298×448 29.1 KB

for sure we can also go for variations

1 Like