08-22-2023 06:32 AM
Hello All,
Do you know if it's possible to download un excel file, like a referential of cost center or hiring sources, into a data table in workato ? Don't want to enter each row manually....
Thanks in advance
Solved! Go to Solution.
08-22-2023 06:49 AM
Hi @MItoiz, Yes, that possible and a typical automation task, which might be even belong to a bigger end-2-end process.
For that use-case you would use our Excel connector which comes with a number of actions and one if "Get rows". This returns you a list of rows which you can pass on to other applications, such as a database.
In case you would like to add it to the data table (https://docs.workato.com/table-storage/data-tables.html), which is part of Workato Workflow Apps, you can use one of the actions: Create, Update or Upsert record of the Table Storage connector: https://www.workato.com/integrations/workato_db_table
Hope this helps,
Chris
08-22-2023 06:49 AM
Hi @MItoiz, Yes, that possible and a typical automation task, which might be even belong to a bigger end-2-end process.
For that use-case you would use our Excel connector which comes with a number of actions and one if "Get rows". This returns you a list of rows which you can pass on to other applications, such as a database.
In case you would like to add it to the data table (https://docs.workato.com/table-storage/data-tables.html), which is part of Workato Workflow Apps, you can use one of the actions: Create, Update or Upsert record of the Table Storage connector: https://www.workato.com/integrations/workato_db_table
Hope this helps,
Chris
08-22-2023 07:26 AM
Thanks !