Hello there! In Azure Data Factory, I am trying to send a GET request to an API, by using a copy activity (thus trying to receive data). I've made a REST Linked Service where I define the correct Base URL and put the Authentication Type to Anonymous. Furthermore; I uploaded a .pfx certificate into my Key Vault. This Key Vault is also linked to my Azure Data Factory. When I first tried to Preview the data in a copy activity, ADF gave me a 'Forbidden error', telling me I was not authorized. After this I tried adding an Auth header in the REST linked service, using the Authorization as Name and using the Certificate from my Key Vault as value. This also does not seem to work. When I try to Test the connection with the Auth header, it gives me an error with: Object must implement IConvertible . Does anyone have a solution to this problem or has experience with certificates and authorization in ADF? Thanks in advance!

Hello @Sander Schmeitz | VANDAAG , Thanks for the question and using MS Q&A platform. As we understand the ask here is how to use certificate to authenticate a get call , please do let us know if its not accurate. I just the checked that the UI and I see that we do have an option for client certificate. I suggest you to please try that let us know how it goes. Thanks Himanshu Please accept as "Yes" if the answer provided is useful , so that you can help others in the community looking for remediation for similar issues.

Using a Certificate as authorization in a GET API call

Accepted answer

HimanshuSinha-msft 19,381 Reputation points Microsoft Employee

2023-02-07T22:09:59+00:00

Hello @Sander Schmeitz | VANDAAG , Thanks for the question and using MS Q&A platform.
As we understand the ask here is how to use certificate to authenticate a get call , please do let us know if its not accurate.

I just the checked that the UI and I see that we do have an option for client certificate. I suggest you to please try that let us know how it goes.

Thanks
Himanshu
Please accept as "Yes" if the answer provided is useful , so that you can help others in the community looking for remediation for similar issues.
Please sign in to rate this answer.
Sander Schmeitz | VANDAAG 20 Reputation points

2023-02-08T14:51:07.7+00:00

Dear @HimanshuSinha-msft ,

Thanks for answering my question!

If I apply the settings to your instructions accordinly, I get the Connection Succesful message! We're one step closer now! Though, when we're trying to retrieve data with a Copy Activity in Azure Data Factory, we get a new error:
Http request failed with client error, status code 403 Forbidden, please check your activity settings. If you configured a baseUrl that includes path, please make sure it ends with '/'. Request URL: <URL that ends with />. The remote server returned an error: (403) Forbidden.

I masked the request URL but trust me, it ends with a '/'.

As additional information: My source dataset is HTTP with the JSON file format. The relative URL in the dataset properties is correct (according to the API-host).

How can I solve this issue?

Thanks in advance!

HimanshuSinha-msft 19,381 Reputation points Microsoft Employee

2023-02-15T05:23:01.13+00:00

Hello @Sander Schmeitz | VANDAAG ,

I do trust you and I am happy that at least you have got through the initial error. I am not sure that as to how are you setting the url in the source side, as you will have to build the complete url by adding the later part of the url in the source side.
This is what I suggest, please use curl / postman and test the API call and once you have done that it will be easy to clone that in the configuration.

Thanks
Himanshu

HimanshuSinha-msft 19,381 Reputation points Microsoft Employee

2023-02-17T19:38:12.7866667+00:00

Hello @Sander Schmeitz | VANDAAG , We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help . Thanks Himanshu

HimanshuSinha-msft 19,381 Reputation points Microsoft Employee

2023-02-22T19:57:41.1533333+00:00

Hello @Sander Schmeitz | VANDAAG ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others .\n If you have any question relating to the current thread, please do let us know and we will try out best to help you.\n In case if you have any other question on a different issue, we request you to open a new thread .

Thanks Himanshu

Sander Schmeitz | VANDAAG 20 Reputation points

2023-02-27T10:15:43.47+00:00

Hello @HimanshuSinha-msft ,

Sorry for my late response! The issues in Azure have all been resolved! Thank you very much for your intial help! :)

Best regards,

Sander
Sign in to comment

Using a Certificate as authorization in a GET API call

0 additional answers