REST API Connection through ADF with Auth Error

Amanda Darcangelo 1 Reputation point
2021-09-27T17:32:29.79+00:00

I am working on adding a data source through a rest api in a data factory data flow. The api requires an api key, which I have. I've configured the system with the base url, auth header, and with an anonymous auth type. When testing the connection in the data flow I receive an error from the source service that the api key is missing (even though it has been specified in the authheaders section). When I add the api key to the base url I receive an error that base urls cannot have parameters passed through them in the UI configuration. I've tried this with a few different data services all with the same or similar errors.

Best,
Amanda

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. svijay-MSFT 5,256 Reputation points Microsoft Employee Moderator
    2021-09-28T15:42:38.177+00:00

    Hello @Anonymous ,

    Welcome to the Microsoft Q&A platform.

    You could try the below alternative approach. From my research, this looks like a known issue.

    Remove the API Keys from the AuthHeaders(from the REST ) and provide the API Key headers in the Additional Headers space in the Data Flow under Source Option.

    135981-image.png

    Hope this will help. Please let us know if any further queries.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png 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

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.