โ02-12-2021 03:42 PM
Hey Everyone! I'm new to Workato and wanted to see if anyone has solved for the ability to split larger Excel workbooks into singular CSV's to use the utility Workato CSV Parser action? Or if anyone has some pro tips on tackling large excel workbooks, I'm all ears!!
โ02-12-2021 07:16 PM
A few weeks ago, the product hour showed how to use the new javascript action to do something like this. Maybe go watch the recording and see what they did? Otherwise, we've done something like this with a script on OPA and then brought the necessary data back into the recipe from there.
โ02-12-2021 08:20 PM
Thanks Amy!
Christopher Anderson here's a link to the product hour that walks through an example of this with the JavaScript connector. Take a look after the 19 minute mark
โ02-12-2021 08:03 PM
Hello Christopher,
Because Office365 and MS Excel donโt have great APIs, it can be tricky to work with them in Workato.
Here are some ideas (and things weโve seen done):
Regards,
โ02-16-2021 08:38 PM
Thanks Ben, will be digging into this this week and let you know what I find!