This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi,
I am pulling API data. I have a copy activity with the source as REST and sink as JSON to store in ADLS. The link service test for the REST is successful. Also I'm able to "preview data" on source in Copy activity But during the debug run following error throws up-
ErrorCode=HttpFileFailedToRead,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failed to read data from http server. Check the error from http server：The remote server returned an error: (403) Forbidden.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Net.WebException,Message=The remote server returned an error: (403) Forbidden.,Source=System,'
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 20%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Can you please provide more information regarding the restAPI response, is it Json structured? do we have a code for the request (200 or success)?
It is Json Structured, I am testing it with a simple API https://catfact.ninja/fact . I am using Rest API as source and want to dump the JSON results in CSV format. I tested it in postman it is working fine, even in the web activity I am getting respone but in Copy activity I am getting the error.
remove the headers, you dont need them for this specific API
@Sally Dabbah Do we need some additional permissions when we are writing the data from Rest API to a container that is behind a firewall ? I can copy data easily to container without firewall but the data it fails writing to firewall container with same error ErrorCode=HttpFileFailedToRead,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failed to read data from http server. Check the error from http server：The remote server returned an error: (403) Forbidden.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Net.WebException,Message=The remote server returned an error: (403) Forbidden.,Source=System,'
Sally Dabbah Thanks for your answer, the container is behind firewall therefore it is causing the issue
Hello Dubey, Can you please provide more information regarding the response that you get from your restAPI, is it a Json structured or CSV?
i think you should change your source and sink configuration in the Copy activity.
Here is a simple POC that i did:
added a Copy activity to a pipeline.
in Source:
Source Dataset: i added only the catfact URL.
Sink:
A Json in ADLS account
Sink Dataset:
so the sink dataset is a Json file linked to my ADLS account.
Output in ADLS:
a Json file containing the result from the API.
I tried the above, still getting the same error
Can you please send a screenshot for source and sink and the error so i can take a look?