Why on earth would you want to use an SQL SP to play with JSON in C#?
Just install
Json.NET - Newtonsoft[
^] and import the classes directly to your C# code!
If you want to retrieve table values from SQL and return it to the API caller, then fetch it from SQL as normal, convert it into classes and use Json.NET to generate the JSON code by serializing them.