Hi Guys,
I am working on a task which is to query the salesforce objects by using the REST API and load into the blob storage from the ADF, this needs to be done for 40 objects in the for each loop, I am able dynamically pass the object/table names and querying the data in the copy activity, however I am getting data in the json format and I need to convert it into csv format dynamically in the copy activity,
Below is the sample json for one table, format will be same for other tables also but the columns will be changed.
[
{
"totalSize": 1,
"done": true,
"records": [
{
"attributes": {
"type": "Account",
"url": "/services/data/v52.0/sobjects/Account/0013O00000g7EmSQAU"
},
"Id": "0013O00000g7EmSQAU",
"IsDeleted": false,
"MasterRecordId": null,
"Name": "eon1623321508143 nach1623321508143",
"Type": "Prospect",
"RecordTypeId": "0120Y000000aOWBQA2",
}
]
}
]
if we can just provide the collection reference in the copy activity with out any mapping will it work?, i have tried already by giving $records, but it's not worked, if there is a simple solution for this please suggest.

