Getting error on trying to call a REST API on Data Factory

Through Postman, I'm able to request a token using the following curl request - some info were hidden for security purposes.

curl --location 'https://hidden/Token' \
--header 'Content-Type: application/x-www-form-urlencoded' \
--data-urlencode 'grant_type=client_credentials' \
--data-urlencode 'client_id=hidden' \
--data-urlencode 'client_secret=hidden'

On Data Factory, I've tried both Web and Copy Data Activity, but got the same result.

I'm using the following header configuration.

User's image

But I'm unable to get the successful result that I get on Postman.

Postman result:

User's image

Data Factory result (I'm 100% sure that the client is valid, since I'm copying it from Postman instead of typing):

User's image Let me know what more evidences I may share.

NIKHILANETHIKUNTA 1,585 Reputation points Microsoft Vendor

2024-09-04T05:40:07.5766667+00:00
@Joffre L. A. Mota (LG lugar de gente)
Thank you for the question and using Microsoft Q&A platform.
The error message you’re seeing, “invalid_client,” typically occurs when the client secret provided is either invalid or expired. Here are some steps we can take to address this:

Verify the Client Secret:

Double-check that you’re using the correct client secret value. Although you've mentioned that you're copying the client ID and secret from Postman, it's possible that there's a subtle difference in the way they're being sent in the Data Factory request. Verify that the client ID and secret are being sent exactly as they are in the Postman request.

Also, make sure that the client secret is not expired.

Check for Key Vault Usage:

Are you using any Azure Key Vault to manage secrets? If so, ensure that the secret you’re using is correctly stored and retrieved from the Key Vault.

Sometimes, misconfigurations related to Key Vault access can cause authentication issues.

Hope this helps. Please let us know if you have any further questions.
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Souza, Esther 0 Reputation points

2024-09-05T17:58:24.7533333+00:00

Hello, we are facing a similar issue and the problem was because the adf adds a header calls expect = 100-continue...
NIKHILANETHIKUNTA 1,585 Reputation points Microsoft Vendor

2024-09-09T09:54:09.48+00:00

@Joffre L. A. Mota (LG lugar de gente)
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 with more details and we will try to help.
Joffre L. A. Mota (LG lugar de gente) 0 Reputation points

2024-09-09T10:34:52.83+00:00

Hello! I did respond, but for some reason, my answer was deleted "due to a violation of our Code of Conduct".

Anyway... I'm 100% sure that my properties values are correct, since I'm copying them from Postman (where I successfully get the token).

I'm still not able to get it through Data Factory. Here is the last attempt as a Web Activity, also returning "invalid_client" for some reason.
Souza, Esther 0 Reputation points

2024-09-09T16:10:40.55+00:00

Did you check if the expect=100-continue is appearing in your request?
NIKHILANETHIKUNTA 1,585 Reputation points Microsoft Vendor

2024-09-10T16:13:52.25+00:00

@Joffre L. A. Mota (LG lugar de gente)
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 with more details and we will try to help.

Share via

Getting error on trying to call a REST API on Data Factory

Your answer