This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
There isn't a already existing macro for paging through web site results since each of them implements the pagination differently.
Since the data all available in the first response, it's just a question of parsing it out of the returned HTML
The top container gets the response, finds the table and marks the header and body sections using a couple of Multi-row tools. The middle one parses the header info and cross tabs the results to put it all on one row. The last one uses a couple of Multi-row tools to tag each row and the columns within each row. After the final Cross tab, the header and data rows are unioned together and the Dynamic Rename takes the column names from the header row.
Here's the start of the data
and the end showing the most recent data for June 6th
You'll notice that I left the task of replacing the URL encoded characters in the column names for you.