I’m using a stored procedure to query SQL database tables and the result is a JSON string. I would like to store the string in an Azure storage blob but can’t seem to figure out how to just store the SProc result value.

The stored blob data has the following… I just want the JSON value (red arrow part):

I can’t seem to determine how to specify just the .value from the result set. The preview data only includes the value.

I’m also trying to use values in a for each loop to specify the name of the blob.