Relevance statement that can verify the content of JSON file

Content Authoring
1

Hi everyone,

I'm looking for a relevance statement that can verify the content of a specific JSON configuration file on a Windows application. Specifically, I need to determine if the file contains a key named buildNumber and if the associated value meets or exceeds a specified version threshold.
The relevance should return either true or false based on this condition.

Any ideas or suggestions would be greatly appreciated!

Thank you.

2

@S2S here is an idea and inspiration to get started on your effort. Using the following example JSON file located in a C:\Temp directory:

{
  "name": "ExampleSoftware",
  "id": "f47ac10b-58cc-4372-a567-0e02b2c3d479",
  "description": "A brief description of the software's purpose.",
  "buildNumber": "1.5.0"
}

Here is some suggestions:

Q: values of keys "buildNumber" of jsons of files "C:\Temp\config.json"
A: 1.5.0
T: 1.011 ms
I: plural json value

Q: exists files "C:\Temp\config.json" whose (exists json of it AND (exists value of key "buildNumber" of json of it AND value of key "buildNumber" of json of it as string as version >= "1.2.3.4"))
A: True
T: 0.780 ms
I: singular boolean

Q: exists files "C:\Temp\config.json" whose (exists json of it AND (exists value of key "buildNumber" of json of it AND value of key "buildNumber" of json of it as string as version < "1.4"))
A: False
T: 0.385 ms
I: singular boolean
3 Likes
3

@gus Your example was very helpful. Thank you so much!