Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
OData Source with API Key
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(224.00000000000003, 77%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
Ryan Abbey
1,186
Reputation points
I have set up an OData linked service and added an Auth Header with API Key, testing the connection comes back successful (PS Is it not possible to parameterise anything within OData??)
I have set up an OData dataset using the above linked service and when clicking "Preview Data", I get data back
However, when I attempt to run the pipeline, I get
actual status code: Unauthorized, response is : {\"fault\":{\"faultstring\":\"Invalid ApiKey\",\"detail\":{\"errorcode\":\"oauth.v2.InvalidApiKey\"}}
Now since the API Key is defined in the linked service, why am I getting the error? How do I get it to recognise the API key that has been entered in the linked service?
Azure Synapse Analytics
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
{count} votes
-
Ryan Abbey 1,186 Reputation points
2021-10-31T19:58:29.713+00:00 I see the following as part of the error message
Failed to get metadata of odata service, please check if service url and credential is correct and your application has permission to the resource
Which makes me wonder if the "Preview" does not attempt this part of the process and that's why it works and then the metadata query does not provide the API Key and that's why it fails...
Sign in to comment
Sign in to answer