How can I process an xml feed, filter it and output it as a new xml feed?

valve90210 · 14 Oct 2019 at 13:51

I'm trying to work out if it's possible to integrate an xml feed from one of our systems (a calendar system) at work with another system (a digital signage system) to display the info from the xml feed.

I've got it basically working however I have an issue in that really I need to be able to filter the original xml feed so the digital signage only displays information which matches certain categories (which is a data field within the info from the xml feed).

The digital signage software allows me to format the xml feed so I can choose what information is displayed for each event in the calendar but I can't filter it.

I also can't change the original xml feed to output only the information that matches the categories which I want to display.

My current thinking is whether there is a way I could have something process the original xml feed, select the entries that match the categories I want, then re output that as an xml file which I can use in the digital signage software?

If that's not possible, can anyone think of any other potential solutions?

PaulStat · 14 Oct 2019 at 15:13

Lookup XPath

Spyhop · 14 Oct 2019 at 17:15

"XSLT is a language for transforming XML documents into other XML documents"

https://en.wikipedia.org/wiki/XSLT

Washout · 15 Oct 2019 at 12:13

Probably easier ways of doing it with gui toolsets but if could probably be fairly easily done in powershell.

Spooter · 16 Oct 2019 at 10:38

Easy with powershell.

Hades · 16 Oct 2019 at 13:55

Loads of ways of doing it. I would probably use Python.

valve90210 · 16 Oct 2019 at 15:23

Thanks for the suggestions.

Are any of these options something which can run continuously as the signage will update each day.

Washout · 17 Oct 2019 at 12:08

If you use Python or PowerShell there'd be loads of ways of getting something to run the script periodically. Windows Task scheduler or cron jobs in unixy world.

Here's a starter for how to read in an xml and do some basic stuff in PS:
https://www.business.com/articles/powershell-read-xml-files/

Get v5 installed on your desktop if it's not already there.