Forum Discussion
Solved
Copy Activity: JSON Array Mapping
Hello, I query an API using the Copy Activity in Data Pipelines. The JSON returned has the following schema - I struggle to get the mapping right to import all rows to a table in a Fabric Dat...
Can you check whether using explicit mapping like below can work, details refer to Schema and data type mapping in copy activity - Azure Data Factory & Azure Synapse | Microsoft Learn?
The Advanced Editor and Collection Reference features do not exist in Microsoft Fabric Data Factory. They do exist in Azure Data Factory. I'm running into the same problem where essentially my json data cannot be mapped properly because the activity is not able to recognize the array data type in Fabric Data Factory like it can in Azure Data Factory.