question

MangeshPawar-2664 avatar image
0 Votes"
MangeshPawar-2664 asked OuryBa-MSFT commented

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

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

sql-server-generalazure-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.

Taz-3478 avatar image
0 Votes"
Taz-3478 answered MangeshPawar-2664 commented

Hello @MangeshPawar-2664 !

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 -|

· 1
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.

i i need to implement this things into GitHub action pipeline so how we implement into GitHub actions.

0 Votes 0 ·
Yufeishao-msft avatar image
0 Votes"
Yufeishao-msft answered OuryBa-MSFT commented

Hi @MangeshPawar-2664

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.


· 1
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.

Hi @MangeshPawar-2664 Please check @Yufeishao-msft answer and let us know if you have additional queries.

Regards,
Oury

0 Votes 0 ·