If you need a JSON file to update your SQL Server you could do what you already wrote. That way you can sync data using JSON files between the two. You could also use services like Zapier or similar I would guess to populate and handle the JSON file outputs.