Forum Discussion
I wanted to Store Rest API Response as A JSON in the SQL Database Table
I am using Copy Activity in Azure Data Factory in which I am using REST API for getting the Response from the API I am getting an array contain multiple dictionaries. I wanted to Store the Response a...
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
Hi Shayan12378
Thank you for reaching out to the Microsoft Fabric Forum Community.
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.