Query to insert data into Azure SQL Database from JSON files which is located in GITHub Repository using GITHUB Actions

Question

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

Answer 1

Hi @Pulipati Vedanth ,

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