How to parse json output into SQL Server in python

Treesa George 21 Reputation points

I have a python script where the json output is stored in "data". I need to store that output in SQL Server wherein each time when i run the python script the data shout automatically be saved in SQL server.172369-capture.png

Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. Treesa George 21 Reputation points

    Hi @GeethaThatipatri-MSFT sorry for late reply. The solution that you advised did not work. Instead I converted it to a list and later used dataframe 174246-capture.pngthrough which I could insert it into database.
    Below is the steps.

    Thanks for your help and follow up. Appreciate it.