I wrote Bourne shell and both of you assumed bash. Horrid state of affairs in today’s IT. All hail Linux hegemony!
And AWK, if it’s not easily parsable with the language specifically designed for parsing data, something is wrong with that data.
If you want to deal with JSON, I'd recommend jq as an easy manipulation tool.