I was close but in all honesty I just couldn't quite get it to work, especially if some rounds were delayed etc.
However, in line with a previous post 'Power Query - PGA Tournament Results' viewtopic.php?t=29093 I managed to solve the problem and as far as I can see it works as per my testing for The Masters last week, even for "live" updates.
Basically it uses a similar process to get the URL for all the Players in the Tournament and then a function is used which gets the relevant round's Scorecard results.
It works by using the URL on the Tournaments worksheet to get a list of all the Golfers who played in the event and then a function is applied to get their scorecards.
Again, if one wants to add more Tournaments and records then follow the comment from the previous post viewtopic.php?t=29093
Should be self-explanatory
Note: this one is a biggie and can take 10-15mins to download all the Scorecards for every Player of every round, so bear with it (even if it is "not responding")
Note: this workbook only contains the results for 2024. I have already done this for other years but because it is 1MB I cannot attach it. So, I'll post other years results after this post.