While copying data from API using Azure Data Factory to Azure SQL, I'm only getting first row in table. The API response is Nested JSON

Question

While copying data from API using Azure Data Factory to Azure SQL, I'm only getting first row in table. The API response is Nested JSON. I've mapped source and sink as well. enter image description here

Data factory only can get the fist row of the nested josn, because we only can choose one collection in the mapping. — Leon Yue

Kunal Sinha Kunal Sinha · Accepted Answer · 2020-09-25T11:21:34

0

votes

Issue resolved by enabling the Collection reference in mapping option in copy activity.

While copying data from API using Azure Data Factory to Azure SQL, I'm only getting first row in table. The API response is Nested JSON

1 Answers