Copy Activity - JSON Mapping

Sample Pipeline JSON

{
  "name": "FlattenJsonToCsv",
  "properties": {
    "activities": [
      {
        "name": "CopyFromJsonToCsv",
        "type": "Copy",
        "dependsOn": [],
        "policy": {
          "timeout": "7.00:00:00",
          "retry": 0,
          "retryIntervalInSeconds": 30,
          "secureOutput": false,
          "secureInput": false
        },
        "typeProperties": {
          "source": {
            "type": "JsonSource",
            "storeSettings": {
              "type": "AzureBlobStorageReadSettings"
            },
            "formatSettings": {
              "type": "JsonReadSettings"
            },
            "collectionReference": "$.data"
          },
          "sink": {
            "type": "DelimitedTextSink",
            "storeSettings": {
              "type": "AzureBlobStorageWriteSettings"
            },
            "formatSettings": {
              "type": "DelimitedTextWriteSettings",
              "columnDelimiter": ",",
              "quoteAllText": true
            }
          },
          "enableStaging": false,
          "translator": {
            "type": "TabularTranslator",
            "mappings": [
              {
                "source": {
                  "path": "$.status"
                },
                "sink": {
                  "name": "status"
                }
              },
              {
                "source": {
                  "path": "$.requestTime"
                },
                "sink": {
                  "name": "requestTime"
                }
              },
              {
                "source": {
                  "path": "@item()"
                },
                "sink": {
                  "name": "Data"
                }
              }
            ]
          }
        },
        "inputs": [
          {
            "referenceName": "JsonSourceDataset",
            "type": "DatasetReference"
          }
        ],
        "outputs": [
          {
            "referenceName": "CsvSinkDataset",
            "type": "DatasetReference"
          }
        ]
      }
    ]
  }
}

1. Set Up Source Dataset (JSON)
•    Dataset type: JSON
•    File pattern: Single JSON file
•    Import Schema: No
•    JSON Path: Leave blank (or just point to $.data if needed to preview array)
2. Enable Unroll Feature in Source
In the Copy Activity > Source tab:
•    Collection reference: $.data
•    This tells ADF to "flatten" the array items and treat each item as a row.
3. Configure Mappings
Go to Mapping tab in the Copy Activity. You’ll map:
Source Path        Target Column
$.status            status
$.requestTime        requestTime
@item()        Data

@item() refers to each element inside the data array being unrolled.
________________________________________
4. Output Format (CSV)
•    Sink type: Delimited Text (CSV)
•    Make sure the sink has columns: status, requestTime, Data
•    Choose appropriate column delimiter (e.g., comma)
•    If you want to format the date, you may post-process with Data Flow or Logic App (ADF Copy Activity doesn’t support date formatting directly).