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

Thirty_Noodles

New Member
Joined
Jan 14, 2025
Messages
6
Office Version
  1. 2024
Platform
  1. Windows
This is a similar post to that solved in this thread:


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.

1739780846865.png


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

Thanks for the help,

Noodles
 
in PQ advanced editor use the following
Power Query:
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"

1739790812226.png
 
Upvote 0
Solution
Kerryx, you are a superstar! This is exactly what I needed!

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

Noodles.
 
Upvote 0

Forum statistics

Threads
1,226,771
Messages
6,192,918
Members
453,766
Latest member
Gskier

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top