How to transfer "Set Variable" activity output into Json file using "Copy Data" activity or any oth

Hello everyone! I hope this video has helped solve your questions and issues. This video is shared because a solution has been found for the question/problem. I create videos for questions that have solutions. If you have any other issues, feel free to reach out to me on Instagram: https://www.instagram.com/ky.emrah

Below, you can find the text related to the question/problem. In the video, the question will be presented first, followed by the answers. If the video moves too fast, feel free to pause and review the answers. If you need more detailed information, you can find the necessary sources and links at the bottom of this description. I hope this video has been helpful, and even if it doesn't directly solve your problem, it will guide you to the source of the solution. I'd appreciate it if you like the video and subscribe to my channel!How to transfer "Set Variable" activity output into Json file using "Copy Data" activity or any other options?

I have tried "Copy Data" activity to copy data from Set Variable output into a JSON file, but it's not working. Please check below the steps I have tried:
Set Variable Activity: Here the variable type is Array which contains this data below:
Set Variable Activity:
{
"name": "OrderList",
"value": [
{
"id": 3,
"portfolioId": 92,
"createDate": "2023-10-17T14:17:35.45Z",
"externalId": null,
"quantity": 10,
"type": {
"name": "Buy"
}
},
{
"id": 4,
"portfolioId": 120,
"createDate": "2024-08-27T05:32:50.546Z",
"externalId": null,
"type": {
"name": "Buy"
}
}
]
}

{
"name": "OrderList",
"value": [
{
"id": 3,
"portfolioId": 92,
"createDate": "2023-10-17T14:17:35.45Z",
"externalId": null,
"quantity": 10,
"type": {
"name": "Buy"
}
},
{
"id": 4,
"portfolioId": 120,
"createDate": "2024-08-27T05:32:50.546Z",
"externalId": null,
"type": {
"name": "Buy"
}
}
]
}
Copy Data Activity - Source: I have taken an empty JSON dataset and added an Additional Column
Copy Data Activity - Source:
Sink: I have taken an dummy JSON to sink which contains empty "OrderList"
Sink:
Mapping: Import schemas couldn't maapped automatically, that's why I have added the additional column manually
Mapping:
After doing all of this I am getting below error:

Failed to convert the value in 'value' property to 'System.String' type

Failed to convert the value in 'value' property to 'System.String' type
Can anyone suggest what I have missed. Thanks in advance.
Tags: azure,azure-data-factory,etl,azure-data-lakeSource of the question:
https://stackoverflow.com/questions/78997901

Question and source license information:
https://meta.stackexchange.com/help/licensing
https://stackoverflow.com/

Видео How to transfer "Set Variable" activity output into Json file using "Copy Data" activity or any oth канала Emrah KAYA