Forum Discussion
Shayan12378
5 months agoRegular Visitor
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 as a Raw Format in the SQL Table but In the Mapping I am getting the Individual to be connected with a single Table How Can I store the Response of the API in a Single Row as a JSON Format
Above is attached JSON Prasing I am getting.
@azuredatafactory @copyactivity
10 Replies
- SrisakthiSuper User
Hi Shayan12378 ,
Have you tried enabling the checkbox "Map complex values to string"
Thanks,
Srisakthi
- Shayan12378Regular Visitor
Yes
- SrisakthiSuper User
- ShayanSiddiqueIFrequent Visitor
Could you please explain what to do in mapping