topic Re: Relative URL not working for a http connection in a copy data activity in Pipelines

Relative URL not working for a http connection in a copy data activity

joseanmarsol — Wed, 10 Jul 2024 11:46:13 GMT

Dear all,

when dealing with a simple data copy activity, I am having trouble to use the relative url in a http connection.

I need to get the exchange rates data from the European Central Bank website, which they publish on a daily basis as xml and then put them in a blob storage.

The base url is:

https://www.ecb.europa.eu/stats/eurofxref

Then, they three different endpoints:

"eurofxref-daily.xml"
"eurofxref-hist-90d.xml"
"eurofxref-hist.xml"

In case the first one does not work, I need to get the data from the second one and if that one does not work either, then the third one. Therefore, my idea was to iterate through a parametrized array of the different endpoints, until one is succesfull.

However, I was trying to check the connection just hardcoding the foirst endpoint as relative url, and it is not working:

The surprising part is, if I put the complete url (base + endpoint) in the http connection, it works:

Re: Relative URL not working for a http connection in a copy data activity

Anonymous — Thu, 11 Jul 2024 08:55:30 GMT

Hi joseanmarsol ,

Based on the information you provided in your description, you need to verify that the HTTP connection is set up correctly, to be precise: check that the combination of the base URL and the relative URL is correct. For example, make sure that the base URL ends with a / and that the relative URL does not begin with a /.

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Relative URL not working for a http connection in a copy data activity

joseanmarsol — Thu, 11 Jul 2024 09:34:33 GMT

Anonymous , thanks for trying to help! I checked that and that is not the issue. I tried the combinations, with and without the / in both the base and relative URLs. Could you maybe try to replicate my scenario?

Re: Relative URL not working for a http connection in a copy data activity

joseanmarsol — Thu, 11 Jul 2024 10:31:21 GMT

Besides, per to the info message next to the Relative URL field:

Re: Relative URL not working for a http connection in a copy data activity

spaceman1205 — Wed, 28 Aug 2024 06:15:07 GMT

Hello joseanmarsol

I have the same problem and unfortunately no solution.

Are there any solutions?

Best regards

Re: Relative URL not working for a http connection in a copy data activity

davo44 — Wed, 09 Jul 2025 08:51:01 GMT

I'm having the same problem.

It seems that the Relative URL is overwriting everything after the last / of the Base URL, instead of concatenating it.

Base: https://community.fabric.microsoft.com/4495

+
Relative: hello
=

Current output: https://community.fabric.microsoft.com/hello

I think a more logical outcome would be: https://community.fabric.microsoft.com/4495hello - but it doesn't work.

joseanmarsol I agree with you, that message over the Relative URL is deceptive.