I try to xml retrieve the official ECB currency rates.
CHF, AUD works. All other currencies fail: why ?
Thanks for any help,
Ola
This works: = Xml.Tables(Web.Contents("http://www.ecb.europa.eu/stats/exchange/eurofxref/html/chf.xml"))
I get a nice table with currency rates
This fails: = Xml.Tables(Web.Contents("http://www.ecb.europa.eu/stats/exchange/eurofxref/html/usd.xml"))
Error message:
DataFormat.Error: Xml processing failed; either the input is invalid or it is not supported. (Internal error: The 'link' start tag on line 2 position 8 does not match the end tag of 'head'. Line 3, position 9.)
Details:
Binary
CHF, AUD works. All other currencies fail: why ?
Thanks for any help,
Ola
This works: = Xml.Tables(Web.Contents("http://www.ecb.europa.eu/stats/exchange/eurofxref/html/chf.xml"))
I get a nice table with currency rates
This fails: = Xml.Tables(Web.Contents("http://www.ecb.europa.eu/stats/exchange/eurofxref/html/usd.xml"))
Error message:
DataFormat.Error: Xml processing failed; either the input is invalid or it is not supported. (Internal error: The 'link' start tag on line 2 position 8 does not match the end tag of 'head'. Line 3, position 9.)
Details:
Binary