How to insert json file data into local sql database using github actions

Mangesh Pawar 1 Reputation point
2021-09-16T08:25:53.75+00:00

i need to insert json file data into artifacts i want to upload this data into local SQL database using GitHub actions

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,117 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Tasadduq Burney 8,391 Reputation points MVP
    2021-09-16T09:22:16.637+00:00

    Hello @Mangesh Pawar !

    Hope you are having a great day!

    This article describes how to import JSON files into SQL Server.You can go thhrough it and let me know if you have more questions! I will be glad to help you out

    https://github.com/MicrosoftDocs/sql-docs/blob/live/docs/relational-databases/json/import-json-documents-into-sql-server.md

    __

    |- Please don't forget to "Upvote" and "Accept as answer" if the reply is helpful -|


  2. YufeiShao-msft 7,076 Reputation points
    2021-09-17T03:10:42.463+00:00

    Hi @Mangesh Pawar

    with my limited knowledge of GitHub actions, I think there may not be a way to achieve what you want, perhaps you should explore other ways to achieve your aims, I recommend you can go to the GitHub Actions Support Community for help.
    Like reading the file content, then passing the data as variables to SQL and writing the insert code at code at SQL end.