Power Query | Extract data from different tab on webpage with same URL

[Thirty_Noodles]

This is a similar post to that solved in this thread:

Extract data from xml web page

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...

www.mrexcel.com

However I didn't want to repost in a solved thread, hence this new one (similar, but with a slight difference I believe).

Issue:
I'm trying to extract data from the table that appears after clicking the "7 day view" link, however the URL (ADMIRALTY EasyTide) remains unchanged and I cannot work out the correct way to do this via Power Query.

Basically, I was hoping to get something like this in my Excel worbook.

I'm sure this is simple, but unfortunately I haven't mastered Power Query yet, so apologies if so.

Thanks for the help,

Noodles

 

[Kerryx]

in PQ advanced editor use the following

let
    Source = Json.Document(Web.Contents("https://easytide.admiralty.co.uk/Home/GetPredictionData?stationId=0116")),
    tidalEventList = Source[tidalEventList],
    #"Converted to Table" = Table.FromList(tidalEventList, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"eventType", "dateTime", "height", "isApproximateTime", "isApproximateHeight", "date"}, {"Column1.eventType", "Column1.dateTime", "Column1.height", "Column1.isApproximateTime", "Column1.isApproximateHeight", "Column1.date"})
in
    #"Expanded Column1"

 

[Thirty_Noodles]

Kerryx, you are a superstar! This is exactly what I needed!

Thanks so much for all your help and the swift response.

Noodles.