Automate Download Item as CSV

[Am4dor]

Hi Team.

On a daily basis I need to download the file created with the  "Download items as CSV..." functionallity , is there a way to automotize this process?
Any help would be appreciated.
Thanks.
Regards.

[Pablo_Childe]

From workspace report-lets cant be auto scheduled just entire workspace.

Could you copy this one report-let and then email schedule it?

If this doesn't help only other option is setup Data warehouse then try ftp.

GLTU

[Am4dor]

Thanks in advance for the answer, I tried this option but in the generated file some info is not shown since in the workspace it only shows the first 400 rows of data and the data I have its for about 2k-3k rows, will try with Data Warehouse, thanks.

[Jennifer_Dungan]

I assume you are using this feature because you want to download more than 400 rows of data (the max that can be "shown" at a time in the Workspace)?

How complex is your Workspace? Would Data Warehouse be a better option? This will provide CSV files on a schedule, but of course, segments would apply to all the data.

Or, you could use Report Builder to retrieve data directly into Excel in the formatting, this also has a scheduler option.

[Am4dor]

Thanks in advance for the answer, yes, the info I'm trying to download its for about 2k-3k items,
I will try with the two options you mention, but I believe Report Builder should work better for me since I only need some specific data, not all of it, thanks.

[Jennifer_Dungan]

If that doesn't work, you can still sometimes use a segment on your data warehouse export to limit to the specifics... but again, it applies to all columns.. if you have segment A on one column, and segment B on another this won't really work.... 

If you don't have access to Report Builder, you may also be able to use the Analytics API to call in the data directly to your system.. but you might need a developer to help on that one (or many you can handle it yourself)

[yuhuisg · Accepted solution]

Data Warehouse would really be your best choice. The other way is programmatically with the Analytics API, but I don't think you need to go down that route yet.