To do that, I used SQL Server's OpenJson function that I discussed in an earlier post but addressing specific real-world JSON object as my example: Declare @json NVarChar ... is to convert a JSON ...

For example, if a hacker inserts non-JSON code into a string ... Everything inside the curly braces is part of the object. Objects can contain multiple name and value pairs. Each name is followed by a ...

All good so far! Now my issue comes when dealing with appending objects to my file. Because I need valid JSON I can't just add the single item to the existing text file because that isn't valid.