I am trying to insert .JSON file data into Azure SQL Database using GitHub Actions. Looking for an sql query how we can insert the JSON file data into Azure SQL Database
I am trying to insert .JSON file data into Azure SQL Database using GitHub Actions. Looking for an sql query how we can insert the JSON file data into Azure SQL Database
Thanks for using Microsoft Q&A !!
As per my limited knowledge on GitHub Actions, I do not think there is a way to load the content of JSON file to a SQL database however you can explore options of reading the file content using Read-file-Action and pass the data to SQL procedure as a variable and then write insert code at SQL end. I also suggest you to post your question to GitHub Actions Support Community for a better solution from community experts.
Thanks
Saurabh
10 people are following this question.