Get JSON values for a specific name using a Windows batch script

Short answer: you can’t. At least not with a Windows default tools. Is it impossible? No.

1. Windows batch scripts
   The naive method is to parse the text, but I don’t recommend it. It’s slow, inefficient, difficult to scale and not reliable code-wise, not to mention a hell to maintain when you need to update or fix the code.

A proper way is to use a command line tool, unfortunately, I don’t know of any built-in tool that can parse json. However, we can use external tools and integrate them in the windows batch shell. One such utility is ./jq

Pros: ./jq is cross-platform, so if you will need to move to some other OS, it won’t have much of an impact.

Cons: First of all, it’s an external tool, so that means you need to get it from a third party. Secondly, if it’s for work, chances are company security policies won’t let you download exe files or run unknown executables. If it’s for a personal project which you share with others they might be cautious about running an unknown exe that does god-knows-what (from their point of view).

Example: jq-win64.exe -r "."data" | .[] ."ip"" test.json

2. Of course, if you want to align with how Microsoft wants users/admins to automate Windows, you have the option of using PowerShell. It has built-in support for XML and JSON.

Pros: It’s fast, efficient and built-in, not to mention it has support for tons of things.

Cons: If it’s for work, security policies won’t let you download exe files or run PS scripts.

Example: (Get-Content .test.json -Raw | ConvertFrom-Json).data.ip

3. VBScript

Similar to #1. You can use vbsEdit or maybe some repositories on GitHub (such as this one). Note: I haven’t tried either. And similar to #1, I don’t recommend this approach.

Edit:
4. The user Compo also recommends combining 1 and 2 to launch PS from a batch file in a comment.

Example: @%SystemRoot%System32WindowsPowerShellv1.0powershell.exe -NoProfile -Command "(Get-Content '.test.json' -Raw | ConvertFrom-Json).data.ip"