Share via

REST API in ADF

Rose Mary Job 5 Reputation points
2023-04-22T15:45:12.11+00:00

I am trying to copy data from a rest API to Blob storage. I created a lnked service to the REST API service and it is showed as successful.I am connecting using username and password.To my surprise evenif I am not giving right username the linked service is successsful. But when I try to preview data from source dataset it is erroring out . Regards, R

Azure Data Factory
Azure Data Factory

An Azure service for ingesting, preparing, and transforming data at scale.

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator
    2023-04-25T21:45:45.7866667+00:00

    Hello Rose Mary Job, Welcome to the MS Q&A platform.

    Can you provide more details about the error you are seeing when previewing the data from the source dataset?

    It's possible that the linked service connection test is successful because it's only checking the connectivity to the REST API service, not the authentication. When you try to preview data from the source dataset, the authentication process takes place, and if the username or password is incorrect, it will result in an error.

    Also, have you verified that the credentials you use to connect to the REST API service are correct and have sufficient permissions to access the data you are trying to copy to Blob storage?

    It seems like the error you are seeing is related to authentication/authorization issues with the REST API service.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.