Error on source dataset with REST Connetor in Azure Synapse pipeline

Question

question

namwam-6150 asked May 8, '22 KranthiPakala-MSFT edited May 9, '22

Error on source dataset with REST Connetor in Azure Synapse pipeline

I am using Copy and transform data from and to a REST endpoint by using Azure Data Factory to load a file from my Box.com account to an Azure Data Lake Gen2 (ADLSGen2) container. I'm using Synapse pipeline whith source as the REST connector where I've identified the Base URL in step3 of the tutorial to be https://api.box.com/2.0/files/:file_id/content where file_id is the id of my file stored in Box.com (ref: here).

When I run the pipeline, I get the following error. Question: What I may be doing wrong and how can the issue be resolved?

 "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": []

azure-data-factory azure-synapse-analytics

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 1 · 2022-05-09T21:12:24.36Z

KranthiPakala-MSFT answered May 9, '22

Hello @namwam-6150,

Thanks for the question and using MS Q&A platform.

From the error code HTTP 401 it seems like the authorization is not valid, and the request operation fails. Could you please make sure your linked service is configured with correct values and a valid Bearer token is passed through Authorization.

Another thing I would like to double check is your Base URL used in the Linked service. Please use https://api.box.com/ as your base URL in your linked service and Use the Relative URL in your dataset and see if that helps to resolve the issue. Here is a reference thread where a similar issue arises due to misconfiguration of the Base URL in the connector. - https://docs.microsoft.com/en-us/answers/questions/794319/index.html

Since the error code complains about authorization, I would recommend giving a try using other tools like POSTMAN to see if you were able to establish a successful connection. And if it works with POSTMAN, please make sure to use similar configurations in ADF REST connector.

Another thing to check is the Bearer Access token passed in the Authorization. Please validate if a correct access token is passed while making the REST call.

Please refer to this troubleshooting guide related to this error message and see if it helps - Error code: RestSourceCallFailed

Hope these inputs help. Please keep us posted how it goes.

Thank you.

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
Want a reminder to come back and check responses? Here is how to subscribe to a notification
If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

image.png (61.5 KiB)

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

question