How to use WEBSERVICE and FILTERXML calc functions?

[AndreaBorruso]

Hi,

I’m using LibreOffice 5.1.1.3 (x64) and I would like to make a live import of a remote XML file. The URL is: http://www.comune.palermo.it/xmls/VIS_DATASET_AGENZIE.xml

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

=FILTERXML(WEBSERVICE("http://www.comune.palermo.it/xmls/VIS_DATASET_AGENZIE.xml"),"/main/DATA_RECORD")

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

In gdrive sheet it works with:

=IMPORTXML("http://www.comune.palermo.it/xmls/VIS_DATASET_AGENZIE.xml","/main/DATA_RECORD")

Thank you very much

[PYS]

Hi

There is a bug report about this.

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

Regards

[AndreaBorruso]

Thank you. I have added my comment to the issue https://bugs.documentfoundation.org/show_bug.cgi?id=88257#c7

[mariosv]

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

[AndreaBorruso]

Thank you very much m.a.riosv

[mariosv]

Sample_filterxlmArray.ods

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

A3: ={FILTERXML(WEBSERVICE("http://www.comune.palermo.it/xmls/VIS_DATASET_AGENZIE.xml");"//main/DATA_RECORD["&ROW()-3&"]")}