Azure Data Factory pipeline save SQL stored procedure first row result value (JSON string) to blob storage

You can use Stored procedure option inside lookup activity to get the output of the SP.

To load the output result into a blob file in Azure blob storage, you can use a copy activity , point the source to a dummy file having a single column.

Now use additional column option in source setting in copy activity and use the expression @{activity(‘lookup1’).output.value[0]}

Go to mapping tab, and import schema, remove the existing dummy column and only keep the additional column in schema and execute the copy activity