Using Download File Endpoint in REST Connector in Azure Data Factory or Synapse pipeline

I'm following this tutorial Copy and transform data from and to a REST endpoint by using Azure Data Factory to load a text file from my Box.com account to my Azure Data Lake storage using REST Api connector of Azure Data Factory pipeline.

In step 3 of this section of the tutorial, I enter `Base URL` to be `https://api.box.com/2.0/files/:file_id/content (where file_id is the id of my file in Box.com). But when I run the pipeline, I get the following error:

Question: What could be a cause of this error and how can we fix it?

"errorCode": "2200",
     "message": "Failure happened on 'Source' side. ErrorCode=RestSourceCallFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The HttpStatusCode 401 indicates failure.\nRequest URL: https://api.box.com/2.0/files/:984786751561/content\nResponse payload:,Source=Microsoft.DataTransfer.ClientLibrary,'",
     "failureType": "UserError",
     "target": "Copy data1",
     "details": []

Chris Dascalos

May 10, 2022 21:57

Hey Saf Kaify,

What is your current method of authentication with the Box API?

It looks like Box is attempting to standardize on a 401 error being a user authentication error.

[https://developer.box.com/guides/api-calls/permissions-and-errors/common-errors/]

Also, are you using a Custom Box application to do this? Any additional information will help the community better understand the environment in which you are operating so we can lead you down the right path.

Additionally, if you can perform testing using a client like Postman this will help us break down where the error could be coming from to ensure we are able to replicate it in multiple places.

Hopefully this helps and happy coding!

Comments