Azure Data Factory relative url is not reconizing special character ('?') in relative url

Question

Hi there,

I am trying to pull data through the Azure Data Factory REST API call service where I have an absolute URL and relative URL. Absolute URL for actual page link and relative URL to get some filtered information from the same page

Absolute URL: "https//www.abc.com/shop/"
Relative URL: "class_b?syspram=2000"

In the above scenario the relative URL part after '?' is not getting recognized in the call not sure why but if I use the below absolute URL it works as expected and '?' is also getting recognized:

Absolute URL: "https//www.abc.com/shop/class_b?syspram=2000"

Kindly suggest a solution or in case I am missing anything.

Regards
Vipul Choudhary

Answer 1

Hello @Choudhary, Vipul ,
Thanks for the ask and also using the Microsoft Q&A.

I looked into the url you shared i am sure that they are not REST API . If you are using a a REST connector in your pipeline its expects a JSON in the response , which it parses . In the above example its not returing a JSON . Please read more here on this .

So to me it does not look to be anything to do with "?" . In case if you can share the error it will be more clear . If you are getting a big HTML ( which I am getting ) , that means the request is going through .

Let me know if you have further query .

Thanks Himanshu
Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

Answer 2

i also have a similar problem when url contains id . character

url:"https://id.kiotviet.vn/connect/token"

it's a valid url i cant get that data when doing in data factory use web activity to query