ADF Mapping Issue (NOT Mapping Data Flows) - (another urgent issue)

Mike Kiser 1,531 Reputation points

Hello! @Nasreen Akter @MartinJaffer-MSFT @HimanshuSinha-msft

We have a major issue in QA Testing before we can go live; we have the following in a json data file that I am using the COPY to copy the data into a SQL Server Table. Please see the following: It was just noticed that the ADF is copying only the first item in the array below and that is all to the first row in the DB Table (see screenshot below). How can I map in ADF (we DON"T have Mapping Data Flows in the Govt Cloud yet) the following so that I can copy all 3 of these phone number types into the DB Table?

"contactInformation": {
"phoneNumbers": [
"isPrimary": true,
"type": "Business",
"phoneNumber": "215/483-1234"
"isPrimary": false,
"type": "Business Cellular",
"phoneNumber": "541/281-6984"
"isPrimary": false,
"type": "Home",
"phoneNumber": "979-256-9666"


Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
7,188 questions
0 comments No comments
{count} votes

Accepted answer
  1. Nasreen Akter 10,656 Reputation points

    Hi @Mike Kiser ,

    There is an option in the CopyActivity --> Collection reference. Please select phoneNumbers [] array on the dropdown. Hope this will work for you! Thanks! :)


2 additional answers

Sort by: Most helpful
  1. Ma01 76 Reputation points

    It depends on how you are parsing Json data in source data set of your pipeline. For above json data , please try with source data set query as below and then map to SQL Server table as target data set.

    from c
    JOIN ci IN c.contactInformation.phoneNumbers


    0 comments No comments

  2. Ma01 76 Reputation points

    If Json is from storage account, Map the collection reference in Copy Activity.