Sep 19 2019 06:42 AM
Can anyone help me figure out why this webservice call isn't working? I know it's my XML filter, but I just don't know why. I see the result I want is there, I just can't get it into the cell!
Here's the WEBSERVICE result in my column labeled XML (result I want is bold and underlined):
{"success":true,"terms":"https:\/\/currencylayer.com\/terms","privacy":"https:\/\/currencylayer.com\/privacy","query":{"from":"USD","to":"CAD","amount":7500},"info":{"timestamp":1564703999,"quote":1.321435},"historical":true,"date":"2019-08-01","result":9910.7625} |
Here's my XML formula:
=FILTERXML([@XML],"//info/@result")
Which results in the #VALUE error in the cell.
Any help is appreciated!