Home

Webservice #Value Error

%3CLINGO-SUB%20id%3D%22lingo-sub-863207%22%20slang%3D%22en-US%22%3EWebservice%20%23Value%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-863207%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20anyone%20help%20me%20figure%20out%20why%20this%20webservice%20call%20isn't%20working%3F%20I%20know%20it's%20my%20XML%20filter%2C%20but%20I%20just%20don't%20know%20why.%20I%20see%20the%20result%20I%20want%20is%20there%2C%20I%20just%20can't%20get%20it%20into%20the%20cell!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20the%20WEBSERVICE%20result%20in%20my%20column%20labeled%20XML%20(result%20I%20want%20is%20bold%20and%20underlined)%3A%3C%2FP%3E%3CTABLE%20border%3D%220%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%3E%7B%22success%22%3Atrue%2C%22terms%22%3A%22https%3A%5C%2F%5C%2Fcurrencylayer.com%5C%2Fterms%22%2C%22privacy%22%3A%22https%3A%5C%2F%5C%2Fcurrencylayer.com%5C%2Fprivacy%22%2C%22query%22%3A%7B%22from%22%3A%22USD%22%2C%22to%22%3A%22CAD%22%2C%22amount%22%3A7500%7D%2C%22info%22%3A%7B%22timestamp%22%3A1564703999%2C%22quote%22%3A1.321435%7D%2C%22historical%22%3Atrue%2C%22date%22%3A%222019-08-01%22%2C%22result%22%3A%3CU%3E%3CSTRONG%3E9910.7625%3C%2FSTRONG%3E%3C%2FU%3E%7D%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3EHere's%20my%20XML%20formula%3A%3C%2FP%3E%3CP%3E%3DFILTERXML(%5B%40XML%5D%2C%22%2F%2Finfo%2F%40result%22)%3C%2FP%3E%3CP%3EWhich%20results%20in%20the%20%23VALUE%20error%20in%20the%20cell.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20is%20appreciated!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-863207%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
rarmont
Frequent Visitor

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!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies