Create Excel-List of layers out of GetCapabilities-Document

Question

I would like to create an Excel list from our GetCapabilities document, where all our wms services are listed.
Some of our services are grouped together and I don't want to list these group layers, just the lowest level of layers.
The list should include name, title, abstract and metadata link (xlink:href).
I have searched the community for examples, and although there are many questions about XML, I have not been able to apply these solutions to my problem and thus create a list.
I probably have to use the XQueryExtractor to find the desired layer elements, but I am not able to insert the XQuery expression (Layer[child::CRS]).

URL: https://map.geo.sz.ch/mapserv_proxy?SERVICE=WMS&REQUEST=GetCapabilities&lang=de

Any help will be appreciated!

Thanks in advance
Vera

Page 1 / 1

I was able to achieve it using an XML fragmenter and to break it down to a feature per layer.

I had to go two layers deep as there seems to be only one layer at the top level, with (i’m assuming) the layers you want under that.

The attached is in 2023.1 (had to zip it as the platform doesn’t seem to like me uploading an FMW @mark2atsafe)

Reply

hkingsbury · Accepted Answer

​I was able to achieve it using an XML fragmenter and to break it down to a feature per layer.I had to go two layers deep as there seems to be only one layer at the top level, with (i’m assuming) the layers you want under that.The attached is in 2023.1 (had to zip it as the platform doesn’t seem to like me uploading an FMW @mark2atsafe)​

Reply

Community Stats

Sign up

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Scanning file for viruses.

This file cannot be downloaded