'=' getting converted to '%3D' in external call dataflow

Question

'=' getting converted to '%3D' in external call dataflow

Jaganath Kumar 110

Hi Team, I am attempting to make an external API call using dataflow. I dynamically pass the value from the input file to the REST endpoint URL. However, when passing the value, '=' is being converted to '%3D'. The configuration settings are as follows. Actual URL

Uri: https://testapi.com:443/RestApi/resources/11.11.11.01/customer?q=customerNumber=234567

From ADF data preview output:

Uri: https://testapi.com:443/RestApi/resources/11.11.11.01/customer?q=customerNumber%3D234567

Method: GET Headers: content-type: application/json | accept: application/json | Authorization: ****** Body: User's image

User's image

Appreciate your help Thanks,

Harishga 6,005 Reputation points Microsoft External Staff

2024-02-23T12:07:09.64+00:00

@Jaganath Kumar
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.
Jaganath Kumar 110 Reputation points

2024-02-26T03:29:00.32+00:00

@Harishga Thank you for your input. I complete understand the functionality. However, I get 415:unsupported media error from the external call. Can you guide how do i resolve this? Appreciate your help, Thanks

Answer accepted by question author

0 additional answers

Your answer

Harishga 6,005 Reputation points Microsoft External Staff

2024-02-23T12:07:09.64+00:00

@Jaganath Kumar
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.
Jaganath Kumar 110 Reputation points

2024-02-26T03:29:00.32+00:00

@Harishga Thank you for your input. I complete understand the functionality. However, I get 415:unsupported media error from the external call. Can you guide how do i resolve this? Appreciate your help, Thanks

Answer 1

Harishga 6,005 Microsoft External Staff

Hi @Jaganath Kumar
Welcome to Microsoft Q&A platform and thanks for posting your question here.

The reason why '=' is being converted to '%3D' in your external API call using data flow is because '=' is a reserved character in URLs and needs to be URL encoded. When a URL is encoded, special characters are replaced with a percent sign (%) followed by a two-digit hexadecimal code. In this case, '=' is being replaced with '%3D'.

In your case, the value of the query parameter is "customer Number=234567". To correctly encode this value, the equals sign needs to be replaced with '%3D'. This is why you are seeing the encoded value of "customerNumber%3D234567" in the ADF data preview output.

This behavior is expected and is done to ensure that the URL is correctly interpreted by the server.

Reference
https://learn.microsoft.com/en-us/azure/architecture/best-practices/api-design#urls

I hope this information helps you. Let me know if you have any further questions or concerns.

Jaganath Kumar 110 Reputation points

2024-02-26T03:32:11.1266667+00:00

@Harishga Thank you for your input. I completely understand the functionality. However, I get 415:Unsupported media error after i run the external call. Can you guide me how to resolve this problem? Appreciate your help, Thanks
Harishga 6,005 Reputation points Microsoft External Staff

2024-02-26T10:05:38.69+00:00

@Jaganath Kumar
It looks like you're getting a 415 error code when making an external API call using dataflow. This error occurs when the server is unable to process the request payload due to an unsupported media type.

To resolve this issue, you can check the Content-Type header in your request and make sure that it matches the expected media type for the API you are calling. You can also verify that the payload you are sending is in the correct format by referring to the API documentation.

Reference
https://learn.microsoft.com/en-us/azure/architecture/best-practices/api-design#error-handling

I hope this helps! Let me know if you have any further questions.
Jaganath Kumar 110 Reputation points

2024-02-27T05:15:54.4566667+00:00

Ok, Thanks Harishga.
Harishga 6,005 Reputation points Microsoft External Staff

2024-02-27T05:29:48.8433333+00:00

Jaganath Kumar Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Share via

'=' getting converted to '%3D' in external call dataflow

0 additional answers

Your answer