Copy Activity - JSON Mapping

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).