Forum Discussion

joseanmarsol's avatar
joseanmarsol
New Member
2 years ago

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

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: 

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:

 

 

 

 

 

pipelines

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      joseanmarsol
      New Member
      2 years ago

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

       



  • joseanmarsol's avatar
    joseanmarsol
    New Member
    2 years ago

    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?

  • davo44's avatar
    davo44
    New Member
    1 year ago

    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.