Brilliant. Absolutely brilliant! Thank you so much, I'm new to working with JSON in SQL and just couldn't find the right technique. I was able to write a c# assembly...
It seems like my issue is with the extra set of brackets around the json text. However, this is a multiple row JSON string. So my FULL JSON looks like...