Download More than 400+

[skatofiabah]

Hi,

Is there a way to download more than 400 rows from a workspace table?

[Jennifer_Dungan]

Yes, you can actually download up to 50,000 rows of data by right clicking on the dimension, and selecting "Download items as CSV"

This will not include any breakdown data, so if you need that, this won't help you.

[skatofiabah]

Hi @Jennifer_Dungan,

What about the Download selection as CSV? Will that download breakdowns and download all rows of data/all data? Or is there no true way to do that in workspace freeform table?

[Jennifer_Dungan]

I believe that "Download selection" is based on what you actually have selected in the Workspace...

So if you have the totals row selected, only that will be returned... if you have 7 rows selected in the table, those 7 rows will be returned...

So unfortunately, that would then limit you back to what you can see in the UI, which is limited to 400...

Now, if you do need breakdowns, there isn't going to be an easy way to do this... I think the option left to you is to use the API... but unfortunately, the way API 2.0 works, you have to make a call for each breakdown separately...

So if you have 1000 rows, and each of those is broken down once each, I think you have to make 1000 requests for each of those breakdowns, then another request for the "top level"... so 1001 requests in all...

[MandyGeorge]

As Jen said "download item as (item)" is your best way to get up to 50k rows directly from your table.

If you do need more than that, you can use data warehouse. It doesn't let you download the table directly, you essentially have to recreate the table in a data warehouse request. But there isn't a limit to the number of rows that it can pull.

[skatofiabah]

Hi @MandyGeorge,

How do you create a data warehouse request and is that different from FTP file send or request? If so, how are they different?

cc @Jennifer_Dungan