Workspaces are built using API 2.0.. if you can create a report there that does what you need, you can actually get a copy of the API calls to use "as-is" or manipulate to your desired need.
First, enable debugging on your Workspace:
Now, you will see a new icon on your tables:
Click on this, and you will be presented with options for the Freeform Table or the Sparkline (you will want the table):
Now, when you click on that, you will be presented with timestamps of API runs, when you choose any of these, a page will open up showing you the API request (in multiple formats) that was run to retrieve data:
You can copy that request and use it as needed....
But can I ask what the final use of the data will be? Would a scheduled project (in CSV format) work? Or a Scheduled Report Builder report?
There are many ways to get the data, ones that might be less effort than the API....