Skip to main content
Solved

Action Flows/'Microsoft 365 Excel, Search Workbooks' module

  • June 24, 2024
  • 1 reply
  • 23 views

shane.proct
Level 4
Forum|alt.badge.img

I see where I can have the module look for a file in my OneDrive, or a Teams/Sharepoint location. How do I route the module to a network drive?

Best answer by mateusz.dudek14

Hi,

 

I'm affraid that may be much harder, as OneDrive and Teams/Sharepoint locations are hosted in cloud environment, and network drives probably only accesible by VPN and not shared publicly. I would consider to either:

A) Relocate the files (easiest solution) - you can map onedrive as a network drive

B) Asking colleagues to synch network drive with one drive, and then try to get the files from network drive

C) Write custom python code to connect to it with code to proxy through comapny FPV to acces it, and pushing the data into Celonis data pool via ML workbench (not adviced)

 

You can maybe also set a SFTP server which would be publicly available with good security measures that would fetch that files on daily basis, and then you could acces them from celonis. More info:

SFTP (Action Flow) (celonis.com)

 

Best Regards,

Mateusz Dudek

1 reply

mateusz.dudek14
Level 11
Forum|alt.badge.img+11
  • Level 11
  • 102 replies
  • Answer
  • June 26, 2024

Hi,

 

I'm affraid that may be much harder, as OneDrive and Teams/Sharepoint locations are hosted in cloud environment, and network drives probably only accesible by VPN and not shared publicly. I would consider to either:

A) Relocate the files (easiest solution) - you can map onedrive as a network drive

B) Asking colleagues to synch network drive with one drive, and then try to get the files from network drive

C) Write custom python code to connect to it with code to proxy through comapny FPV to acces it, and pushing the data into Celonis data pool via ML workbench (not adviced)

 

You can maybe also set a SFTP server which would be publicly available with good security measures that would fetch that files on daily basis, and then you could acces them from celonis. More info:

SFTP (Action Flow) (celonis.com)

 

Best Regards,

Mateusz Dudek