CODEWITHSUNDEEP
jsonazureazure-sql-databaseazure-data-factory
Kunal Sinha
Kunal Sinha

Reputation: 77

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

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

Upvotes: 2

Views: 1042

Answers (1)

Kunal Sinha
Kunal Sinha

Reputation: 77

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

Upvotes: 2

Related Questions