Azure Data Factory数据流：将逐行JSON转为单个复杂JSON文档

算力阿峰

2026-6-25

ADF Data Flow 转换JSON适配HubSpot格式问题

我正在用Azure Data Factory (ADF) 的Data Flow处理数据湖里的JSON文档，要把结构转换成HubSpot能加载的格式。现在遇到个问题：输出始终是逐行的JSON文档，而不是我需要的单个包含数组的复杂JSON结构。目前我是用Derive Column来定义目标结构的。

源JSON格式

{"Id":"1000000000003919138","Version":0,"ContactKey":"148101","IsIndividual":true,"Name":"Margerie Bouvier Simpson","FirstName":"Margerie","LastName":"Simpson","MiddleName":"Bouvier","EmailAddresses":"","OtherAddresses":"","PhoneNumbers":"","Roles":122,"FaxNumbers":"","WebSites":"","RecordDate":"2024-04-12T18:34:07.019505+00:00"}
{"Id":"1000000000003919134","Version":0,"ContactKey":"148100","IsIndividual":true,"Name":"Homer J Simpson","FirstName":"Homer","LastName":"Simpson","MiddleName":"J","EmailAddresses":"","OtherAddresses":"","PhoneNumbers":"","Roles":122,"FaxNumbers":"","WebSites":"","RecordDate":"2024-04-12T18:34:07.007973+00:00"}

目标输出格式

{
    "inputs": [
        {
            "properties": {
                "email": "fdsfds@fdsfds.com",
                "firstname": "Brenda",
                "lastname": "Wooster",
                "phone": "(123) 1232332",
                "company": "",
                "website": ""
            }
        },
        {
            "properties": {
                "email": "",
                "firstname": "James",
                "lastname": "Kline",
                "phone": "",
                "company": "",
                "website": ""
            }
        }
    ]
}