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 sy...
Can you please provide more information how you are trying to refresh your token? On my side I have implemented the following:refresh_on: [401] (whatever code the API is returning when authentication is failing)
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 i...
Thierry,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_conte...
Thierry,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!
Thierry, Most of our accounts are connected to Office 365. FYI: I found a usefull product hour post: https://www.workato.com/product-hub/javascript-connector-the-freedom-to-transform-your-way/Recipe URL: https://app.workato.com/recipes/1381928-simple...
