I'm getting \u0022 error while calling the REST API to generate a token via web activity(Post Method) in ADF. I'm using "content-type": "application/x-www-form-urlencoded". ADF request: This request was working fine 10 days ago with same configuraiton. Please let me understand how to modify the request.

ok, thanks for the info!. To resolve this issue, you can try the following steps: Check the JSON payload to ensure that it is in valid JSON format. You can use an online JSON validator to check the payload. Ensure that all double quotes in the JSON payload are properly escaped. In JSON, double quotes must be escaped with a backslash ("). If the JSON payload is in valid format and all double quotes are properly escaped, then the issue may be with the way the payload is being sent in the request body. You can try encoding the payload using the "application/x-www-form-urlencoded" content type. To encode the payload, you can use the "urlencode" function in ADF. For example, if your payload is stored in a variable called "payload", you can encode it using the following expression in the web activity: @urlencode(variables('payload')) Ensure that the "Content-Type" header in the web activity is set to "application/x-www-form-urlencoded". If you have already tried these steps and are still encountering issues, please provide more details about the JSON payload and the web activity configuration, and I can help you further.

web activity in azure data factory - Rest API - Post method failing with error code \u0022

Anil Kumar Ulchala 0

I'm getting \u0022 error while calling the REST API to generate a token via web activity(Post Method) in ADF. I'm using "content-type": "application/x-www-form-urlencoded".

User's image

ADF request:

User's image

This request was working fine 10 days ago with same configuraiton. Please let me understand how to modify the request.

QuantumCache 20,266 Reputation points

2023-07-11T16:25:58.8766667+00:00

Hello @Anil Kumar Ulchala thanks for posting this question on this forum.

Did you try with any other REST APIs ? is this error consistent ?

Also, please check if the REST API endpoint is correct and accessible.

You can try testing the REST API endpoint using a REST client like Postman to see if it returns the expected response. If the issue persists, please provide more details about the REST API endpoint and the request body you are using so that we can assist you better.

Please comment in the below section, happy to help!
Anil Kumar Ulchala 0 Reputation points

2023-07-11T16:40:06.2433333+00:00

Hello Satish, Thanks for repsonding. I have tried with other API's. For other API's it is working fine for content type "Application/Json". Even the one I mentioned in the post, it is working fine while hitting through postman.
QuantumCache 20,266 Reputation points

2023-07-11T21:46:00.9333333+00:00

Hello @Anil Kumar Ulchala thanks for the quick response,

So you are saying that the POST is failing if we use "content-type": "application/x-www-form-urlencoded". right***?***
Anil Kumar Ulchala 0 Reputation points

2023-07-12T04:58:05.84+00:00
Yeah, the body we are using is

@CONCAT('username=', variables('username'), ';password=', variables('password'))
QuantumCache 20,266 Reputation points

2023-08-01T01:02:52.8966667+00:00

Hello @Anil Kumar Ulchala Just checking if we are still connected on this discussion? Please let us know if you need to add more info so that we better assist you!

1 answer

QuantumCache 20,266 Reputation points

2023-07-12T22:07:36.75+00:00

ok, thanks for the info!.

To resolve this issue, you can try the following steps:

Check the JSON payload to ensure that it is in valid JSON format. You can use an online JSON validator to check the payload.

Ensure that all double quotes in the JSON payload are properly escaped. In JSON, double quotes must be escaped with a backslash (").

If the JSON payload is in valid format and all double quotes are properly escaped, then the issue may be with the way the payload is being sent in the request body. You can try encoding the payload using the "application/x-www-form-urlencoded" content type.

To encode the payload, you can use the "urlencode" function in ADF. For example, if your payload is stored in a variable called "payload", you can encode it using the following expression in the web activity:

@urlencode(variables('payload'))

Ensure that the "Content-Type" header in the web activity is set to "application/x-www-form-urlencoded".

If you have already tried these steps and are still encountering issues, please provide more details about the JSON payload and the web activity configuration, and I can help you further.
Please sign in to rate this answer.
Joffre L. A. Mota (LG lugar de gente) 25 Reputation points

2024-04-09T14:44:59.3633333+00:00

I'm with a similar issue.

I've got the curl below (data into {} were hidden for privacy purposes) that is used through Postman, that returns to me a json body with the bearer token that I'll have to use on other requests.

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

I've created a Web activity into a new Pipeline, added a header like below...

... but no matter what I try to use as body of my request inside of ADF works.

Really need a help here. :-\
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

web activity in azure data factory - Rest API - Post method failing with error code \u0022

1 answer

Your answer