Forum Discussion
Problem with FILTERXML
Hello Guys! I have a problem with the FILTERXML function. (please note that my code is in German) I'm trying to get the current follower amount of our companies social media channels with the...
Hi Timo
you should pass the xml data to the FILTERXML function.
If you get a xml data through an API, then you need the WEBDIENST (or WEBSERVICE function).
so:
=XMLFILTERN(WEBDIENST("[your url]");"[your xpath]")
You find the information about the WEBDIENST function hier:
https://support.microsoft.com/de-de/office/webdienst-funktion-0546a35a-ecc6-4739-aed7-c0b7ce1562c4
If the xml data is too big, then you might get an error message "#WERT"...