Automate DOMO pulling an Excel File
Hi,
I have several excel files that I upload to domo manually every week. I was wondering what would be the easiest way to have DOMO grab and update the file automatically. This would be my first time doing this so if you could provide the steps that would be super beneficial.
Best Answers
-
Is the file name, format, tab name, etc… remaining the same and just the data changing? If so, the files could be stored in OneDrive and you could use the OneDrive for Business connector in Domo.
Otherwise, this sounds like a job for Workbench
If I solved your problem, please select "yes" above
1 -
@ColinHaze You could use Workbench if the file is stored locally on your network. I believe you need to have admin rights to be able to download Workbench. If you use SharePoint you could also use that to automatically get the files. You may also be able to use some scripting with the Java CLI to do this as well. I think there is also an excel plug in where you can have a file directly connected to Domo and you can just click upload.
**If this answer solved your problem be sure to like it and accept it as a solution!
4
Answers
-
Is the file name, format, tab name, etc… remaining the same and just the data changing? If so, the files could be stored in OneDrive and you could use the OneDrive for Business connector in Domo.
Otherwise, this sounds like a job for Workbench
If I solved your problem, please select "yes" above
1 -
ColemenWilson I just read about that one but we dont really use one drive. I was thinking either the Excel SFPT connector or workbench. Im not quite sure what the difference is.
0 -
@ColinHaze You could use Workbench if the file is stored locally on your network. I believe you need to have admin rights to be able to download Workbench. If you use SharePoint you could also use that to automatically get the files. You may also be able to use some scripting with the Java CLI to do this as well. I think there is also an excel plug in where you can have a file directly connected to Domo and you can just click upload.
**If this answer solved your problem be sure to like it and accept it as a solution!
4
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 605 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 696 Beast Mode
- 43 App Studio
- 39 Variables
- 659 Automate
- 170 Apps
- 442 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 388 Distribute
- 111 Domo Everywhere
- 271 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 9 Domo University
- 31 Product Releases
- Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive