How to use WEBSERVICE and FILTERXML calc functions?


I’m using LibreOffice (x64) and I would like to make a live import of a remote XML file. The URL is:

I have written this formula, but calc import only the firs row.


Is it normal? How to import all the output of the XPath query?

In gdrive sheet it works with:


Thank you very much


There is a bug report about this.

m.a.riosv give an example to get an array.


Thank you. I have added my comment to the issue

And I have reopened again the bug, because the function only return the first value when there are several.

Thank you very much m.a.riosv


Entered as array and calling every row, seems a workaround:

A3: ={FILTERXML(WEBSERVICE("");"//main/DATA_RECORD["&ROW()-3&"]")}