Forum Discussion
I wanted to Store Rest API Response as A JSON in the SQL Database Table
Hi Shayan12378 ,
Consider this example, I have my json like this format and i want to store orders entire json into one of my column in my sql db table.
under mapping section of ADF, click on import schemas, select "Map complex values as string" and then if you see orders json come as array and then select column name to store. Exclude other columns
sometime it takes time to refresh the arrays properly
You can also check this link for reference https://sarnendude.com/azure-data-factory-copy-activity-how-to-save-json-data-as-string-in-azure-synapse-analytics-sql-pool/
Regards,
Srisakthi
It is help me to store a part of my response. Like you are saving the Order part from the whole response but I wanted to save whole response in a Single Column
Hi Shayan12378 ,
I have tried with data flow as well but no luck. Other option is store the API response in json file(ADLS) and use OPENROWSET BULK
Also you can raise support ticket with Microsoft , may be they can give direction on achieving this scenario.
Regards,
Srisakthi
Sure
Hi Shayan12378
Thank you for reaching out to the Microsoft Fabric Forum Community.
Srisakthi Thanks for the inputs.
Shayan12378 As suggested by Super User, have you raised a support ticket? If so, please share your details here. If not, please raise one here. Create a Fabric and Power BI Support Ticket - Power BI | Microsoft Learn.
If you have any other issues, please reach community.
Thanks.
