07-15-2022 06:30 AM
I noticed that Workato offers a build-in functionality to connect to Excel. However, this features includes a connection to oneDrive, Sharepoint or Google Drive. This is not what I want to achieve...
I want to read an Excel file from an on-premises system. Does anyone has an idea to solve my problem? Or will a new feature request be the answer?
07-15-2022 02:14 PM
Avenue Franklin Roosevelt, 104 Bte 11, 1332 Rixensart - Belgium
This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission.
07-15-2022 03:11 PM
08-08-2022 05:37 AM
I was not able to test it yet, due to my yearly holiday period. I will try it as soon as possible.
Based on your answer, my expectations are high!
08-08-2022 01:04 PM
I'm trying to use the trigger 'On Prem Files - new file in folder' but it is not working on my end. Did you change anything in the JS action?
Error message: Line input evaluation error in js_eval. Error calculating input for field 'file_content': undefined method `encode_base64' for #<Workato::Types::InputStreamProxy:0x00007fa13e422818>.
08-09-2022 08:05 AM
Just a quick FYI for everyone in the community: above solution is working. BUT it is necessary to add the method '.to_s' when using On-Prem Files.
An additional point: when the Excel has some filters applied or calculated fields, this will become an issue: filters are getting discarded for example.
Found my solution over here: https://app.workato.com/recipes/1396791