I want to export my dataset as chunk of excel/csv file
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
Comments
-
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.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
Is it possible to export whole dataset (millions or rows) in single CSV file with this solution?
0 -
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.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 544 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 345 Distribute
- 87 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 8 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive