Fabric Data Days Monthly is back. Join us on March 26th for two expert-led sessions on 1) Getting Started with Fabric IQ and 2) Mapping & Spacial Analytics in Fabric. Register now
Hi,
I have an Azure Data Factory (AF) instance that I am using to create a Pipeline to ingest external (cloud based) 3rd party data into my Azure SQL Server database. I am a novice with ADF and have only used it to ingest some external SQL data into my SQL database - it did work.
The external source I'm attempting to extract from uses an OAuth 2.0 API and an API is something I've not used before.
Using Postman (never used this software before this attempt), I have passed the external source's base_url, client_id, and client_secret, and in return successfully received an access token. This tells me that the base_url, client_id, and client_secret values I passed are correct and accepted by the target source/application.
Feeling encourage to implement the same values into ADF, I first created a Linked Service which a successful test connection is returned - see below. This Linked Service uses the same values the Postman entry which granted an access token.
I then created a Pipeline with a Web activity object within it. The General and User Properties don't have any configuration, only the Settings tab does which shown below.
I execute the Web object and it returns with a failure - see below.
The error states the endpoint refused the request (for an access token). Is this accurate as I was able to receive an access token via Postman when using the same credentials? I don't understand why via Postman I can received an access token but via ADF it errors. I'm wondering if I've completed the ADF parts incorrectly, or if there is more needed just to received an access token, or if it's something else?
Are you able to advise what's taking place here?
Thanks.
Solved! Go to Solution.
Hi!
This forum focuses only on Fabric Data Factory topics.
For Azure Data Factory inquiries, please post them in the official Azure Data Factory community forum:
Azure Data Factory | Microsoft Community Hub
I'd also highly encourage you to try Fabric Data Factory:
Hi!
This forum focuses only on Fabric Data Factory topics.
For Azure Data Factory inquiries, please post them in the official Azure Data Factory community forum:
Azure Data Factory | Microsoft Community Hub
I'd also highly encourage you to try Fabric Data Factory: