Connectors
Connectors
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.
Customer Support CommunityOtherwise, this sounds like a job for Workbench
Customer Support CommunityIf 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.
Customer Support Community**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.
Customer Support CommunityOtherwise, this sounds like a job for Workbench
Customer Support CommunityIf 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.
Customer Support Community**If this answer solved your problem be sure to like it and accept it as a solution!
4
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3K Transform
- 114 SQL DataFlows
- 654 Datasets
- 2.2K Magic ETL
- 4.1K Visualize
- 2.5K Charting
- 803 Beast Mode
- 79 App Studio
- 44 Variables
- 758 Automate
- 188 Apps
- 480 APIs & Domo Developer
- 73 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 408 Distribute
- 119 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 141 Manage
- 137 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive