Forum Discussion
Sarmistha1245
Mar 22, 2024Copper Contributor
JSON Lines from API Response in ADF Pipeline
How to read API response in JSON Lines through Azure Data Factory Activity? Currently the RESTful API is sending dataset in JSON Array format which will be changed to JSON Lines. Can you please sugge...
Kidd_Ip
Jun 05, 2025MVP
Take this:
Using Copy Activity
1. Set the dataset type to JSON in your source dataset.
2. Configure the format settings in the Copy Activity:
- Use JsonReadSettings in the formatSettings section.
- Ensure filePattern is set to setOfObjects, which supports JSON Lines.
3. Map the schema properly to extract individual records.