Extract data from xml web page

[Thirty_Noodles]

Hello all,

So I thought that this should be relatively straightforward, but unfortunately I appear to be stuck. I've had a quick search through existing posts on this forum, yet no joy either... I'll say from the start that my knowledge of PowerQuery or data extraction is quite limited, so apologies for anything that should be obvious.

Issue 1:
In a nutshell, I'm trying to use a web query to extract data from this website:

Notices to Mariners

Essential up to date information and advice to those supporting navigation and commercial shipping in the Port of London.

pla.co.uk

The query works fine, however there are multiple pages of table data that I need, yet the URL remains identical regardless of which page you're on, so I can't seem to grab the data from the subsequent pages.

Issue 2:
I've tried to work out a way to resolve this, but I then realised there is however a separate page on this website that contains all the data I need, which could be easier... However, this is in a .xml format, so when I try to extract the data it doesn't seem to work (I'd be happy simply with the full list of text)

https://ntm.pla.co.uk/rss/notices_to_mariners.xml

Question:
Is there an easy way to extract all the text on the .xml page, or if this won't work, a way to get the data from the other pages in the original issue if that's easier?

Just thought I'd ask rather than drive myself nuts on something that I thought should be simple enough.

Thanks in advance.

Noodles.

 

[JGordon11]

let
    Source = Xml.Tables(Web.Contents("https://ntm.pla.co.uk/rss/notices_to_mariners.xml")),
    channel = Source{0}[channel],
    item = channel{0}[item]
in
    item

 

[Thirty_Noodles]

Thanks JGordon11 for your swift reply.

This is exactly what I needed and works perfectly! Brilliant!

Noodles.