Sorry just jumping in here without fully reading the topic, but even if you don’t use SQL 2016 or above with JSON support, another way you could access JSON data is in a script, you have access to JSON.parse() and you could load the relevant field in using sql.Query() or another SQL function. Read more here…