Domo Python SDK
I have been using the Python SDK to send csv data to Domo via API using the data_import_from_file
and have done so successfully. However, I also need to send xlsx files to Domo, but have not been able to successfully do so using the same method. Is the method capable of sending xlsx data using this method?
Best Answer
-
data_import_from_file only supports CSV files. If your data in a structure other than a non-tabular format? How does the format break?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Answers
-
I would use Domo Workbench. It's easy to setup and you can schedule it.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
You can utilize python packages such as pandas to read the excel file and convert it to a csv and then upload it to Domo that way.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
@GrantSmith Is it not possible to send and xlsx file using this method. I require the file to stay as in xlsx format.
0 -
You can keep the format as xlsx I’m just recommending making a copy of the xlsx as a csv and uploading that copy
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
I have been working with a xslx file and converting it to csv makes my data unreadable and breaks its format. That is why I need to upload directly as a xlsx file and am asking if the
data_import_from_file
is capable of that or does it only upload csv files?0 -
Try using work bench if you can. Most of the other connectors have much lower file size limits.
1 -
data_import_from_file only supports CSV files. If your data in a structure other than a non-tabular format? How does the format break?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive