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

[joseanmarsol]

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:

1. "eurofxref-daily.xml"
2. "eurofxref-hist-90d.xml"
3. "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:

[davo44]

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.

[spaceman1205]

Hello @joseanmarsol 

I have the same problem and unfortunately no solution.

Are there any solutions?

Best regards

[joseanmarsol]

@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?

[Anonymous]

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.

[joseanmarsol]

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