Pulling data from web XML

Questions
,
1

Describe the issue/error/question

Trying to pull data from an online xml file which is pulled via rss feed (Weather alerts)
From here it goes to a discord bot that spits it out (a bit of a mess so didn’t include that bit)

An example of the XML file is here; XML file

Ideally what I am wanting to do, is pull bits of information out of the XML, such as

<event>wind</event>
<responseType>Monitor</responseType>
<urgency>Immediate</urgency>
<parameter>
      <valueName>ColourCode</valueName>
      <value>Yellow</value>
<onset>2022-08-18T09:00:00+12:00</onset>
<expires>2022-08-19T05:00:00+12:00</expires>
<areaDesc>Taranaki about and south of the Mountain, Whanganui and Taihape</areaDesc>

From here I would be able to push it to discord… However getting that information out I am finding quite a struggle so need a hand getting there.

Information on your n8n setup

  • n8n version: 0.190.0
  • Database you’re using (default: SQLite): SQLite
  • Running n8n with the execution process [own(default), main]: Own
  • Running n8n via [Docker, npm, n8n.cloud, desktop app]: Unraid, docker
2

Hi @FlippinTurt, have you tried out the XML node? It can parse XML and should help with the job:

image
image1907×887 124 KB

Here’s a slightly modified version of your workflow including the XML node to illustrate this:

Hope this helps! Let me know if you have any questions :slight_smile:

2 Likes