Process for using Workbench to read a Sharepoint Excel File
Hi,
I'm trying to set up Workbench to read a sharepoint stored excel file.
While in sharepoint I am generating a link to the file (which is a web https:// link) but after putting this into Workbench as a "local file" it fails to reach the file. Guidance on what I'm missing in Workbench or Sharepoint to get this working would be very much appreciated.
BTW - I am working with my IT department to get the Online Rest connector working (it's requesting Admin rights despite being set up in Azure as per the guide) but this is throwing up other issues right now which is why I am looking at Workbench as a short term solution.
Thanks,
Answers
-
@user065217 if this is a short term fix, why don't you just download the file instead of trying to pass a URL?
also it looks like sharepoint has native functionality for syncing files with a local machine ...
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
I guess I should clarify that short term is currently nearly 4 months with no solution in sight. Maybe I should have said desperate fix. :)
I'd like it to run as independently as possible, while Workbench isn't great it at least runs at the service level which means my "Workbench PC" just needs to be powered rather than logged in.
The files I'm looking to upload are also manually updated themselves which means no fixed times for me to do a daily update. Getting Workbench to update hourly etc is a preferred solution.
I got the impression Workbench supported Sharepoint, if by that they mean, as you mention, to mirror locally then this really should be made more explicit in the docs.
0 -
@user065217 i have no idea if WB can access URL links, i'm just proposing a solution that will work.
WB can be configured to only execute when files are modified. (just search for update, https://knowledge.domo.com/Connect/Connecting_to_Data_Using_Workbench_5/Scheduling_a_Job_in_Workbench_5_(with_new_features))
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
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
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 695 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive