How do you make a list of all the "items" i got in an XML file (from the web)?

Hello. I got an xml file from this address: Radio Galileo
that returns all the news of this local radio station, and i wish to extract "title", "link", "enclosure url" (or "media:content url") from each "item" in the xml file.

I can download the file, but have no success in parsing it. Nor with list pairs nor with dictionary.
And if i decode it with the web1 functionalities for xml file i lost the <> and all the outoput text became a mess...

RadioGalileo.aia (184.6 KB)

Hello Federico

Hmm - problem is, the file has no consistency. Some items have 'enclosure url' and a 'media:content url' for example.

		<title>Anche l’umbria al campionato quarta categoria figc salute mentale</title>
		<pubDate>Wed, 05 Oct 2022 10:17:57 +0000</pubDate>
		<dc:creator>Redazione Galileo</dc:creator>
				<category><![CDATA[AttualitĂ ]]></category>

		<guid isPermaLink="false"></guid>
		<description><![CDATA[Il debutto ufficiale in campo è fissato per il 15 ottobre a Pontedera, ma indipendentemente dalla partita, hanno già raggiunto un grande risultato: portare sul campo di calcio ragazzi e ragazze umbri con disabilità mentale per disputare un torneo nazionale. L’iniziativa è dell’Asd Ellera Calcio che con il contributo della Comunità di Capodarco di Perugia&#8230;]]></description>
	<enclosure url="" length="1089560" type="image/jpg" />
<media:content xmlns:media="" url="" width="3590" height="2970" medium="image" type="image/jpeg">
	<media:copyright>Radio Galileo</media:copyright>

To code your own parser, the Text functions are required but I think they lack a few tools needed in this case. If anyone can think of a way to process the file successfully, it would be @ABG. Abraham is very good at making the impossible possible.

Also, the data does not really lend itself to a list format, would possibly work better as a Table (use version 4):

It might be easier to parse that result though:

This with an extension, it's not finished, you need to remove ", \u201,...

borrar_xml.aia (877.6 KB)

This is the long way around...

xmltest.aia (4.2 KB)

Here's my take, with a general purpose multi-column shredder. no extensions or Javascript...
initialize global responsecontent to

shred_rss.aia (5.7 KB)


this seems a goot starting point.
Experimenting a bit.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.