I want to export my dataset as chunk of excel/csv file

user094816

I have a dataset in domo and I want to export the it in to chunks of excel/CSV file and each file having 5 lakhs rows. I found this link on domo developer. Can some one guide me how to proceed with this? I have Python 3.7.1 installed on my system and also having Anaconda distribution to work with Python if needed.

https://developer.domo.com/docs/dataset/import-and-export-data#Export%20Data

PS: I am very new in DOMO and exporting that data manually that took whole day to export chunks of file using DOMO UI.

Thanks in advance.

Kulchandra

GrantSmith

Hi @user094816 

You can't directly export the data in chunks from the Domo API, only the entire dataset. There are some sample Python files they provide to show how to accomplish this: https://github.com/domoinc/domo-python-sdk/blob/master/examples/dataset.py shows how to connect to Domo and export a dataset. I'd recommend you start with that example file.

 

Once you have the data exported to a CSV you could then utilize some looping, other package or even another tool to split your file into smaller chunks.

user094816

Is it possible to export whole dataset (millions or rows) in single CSV file with this solution?

GrantSmith

Yes, there isn't a limitation on the number of records a CSV can store or that would be exported from the API to my knowledge. You'll just have a very large file.