View API response in copy activity

Hi nkailasamurthy ,

Below are my thoughts.

Firstly, to view the JSON response from a copy activity in Microsoft Fabric, you can follow these steps:

1. Ensure that debugging is enabled for your pipeline. This will allow you to see detailed logs and outputs.

2. Execute your pipeline with the copy activity.

3. After the pipeline run, go to the Monitor tab in the Data Factory. Here, you can see the run history of your pipeline.

3. Click on the specific copy activity within the pipeline run. You should see detailed logs and outputs, including the JSON response if the activity was successful.

Secondly, best Approach for Parsing and Loading JSON to Lakehouse, you can follow theses steps:

1. Web Activity: Use a web activity to make the API call and capture the JSON response.
2. Store JSON in Lakehouse: Save the JSON response to a file in your lakehouse.
3. Copy Activity: Use a copy activity to read the JSON file from the lakehouse and load it into your table.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.