question

PulipatiVedanth-8342 avatar image
0 Votes"
PulipatiVedanth-8342 asked SaurabhSharma-msft answered

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

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

azure-sql-database
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

SaurabhSharma-msft avatar image
0 Votes"
SaurabhSharma-msft answered SaurabhSharma-msft commented

Hi @pulipativedanth-8342,

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.