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

user094816
user094816 Member
in APIs & Domo Developer

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

  • GrantSmith
    GrantSmith Coach

    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!**
  • user094816
    user094816 Member

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

  • GrantSmith
    GrantSmith Coach

    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!**
This discussion has been closed.

Categories