OK, here it is 🙂
Props to Joe Carr for this https://www.thedataschool.co.uk/joe-carr/webscraping-through-alteryx-as-if-you-are-logged-in it was the information that I needed to make the entire thing work.
My initial reaction was like everyone else here - web scraping a table ... EASY ..... uh, NOT so easy with this one. Load the URL in a browser, load the same URL in Alteryx and the data is not there. Change the header in Alteryx to make it look like it's a browser - STILL no data.
Then I read Joe's article. OK, I didn't read Joe's article I saw the image about the Network tab in the Inspect tools - BINGO! ... Back to Chrome, do the same thing and there's 6 API looking calls (so they probably match the 6 tabs on the webpage).
Easy - ok, write the workflow, call the 6 APIs, check the results and it's perfect. BUT leave it a few hours and it's not - comparing the data from browser to Alteryx and it used to be perfect and now it's not. The only thing I did was re-run the workflow.
I looked at the API URLs again and saw some numbers on the end (1628744311727&_=1628744311728) .... hmmm ... 2 big numbers, ending in 27 and then 28 .... vague memories of epoch times !
So I found this https://www.epochconverter.com/ and you can see the epoch time NOW, and enter your own time to convert.
OK, so the API is sending a to & from in epoch milliseconds !!! better still, in UTC time.
EASY !!!! .... get the current UTC time in epoch, convert to milliseconds (you might not have to convert, I didn't bother testing), modify the API URL for the times and the data matches - always !!
The API actually gives you a huge amount of fields (check the Select just after the Cross Tab) but I've only kept the fields that you need for each tab.
Hopefully it works for you, let me know if you have any questions or need help.