cancel
Showing results for 
Search instead for 
Did you mean: 

Loading data in data tables from external sources

MItoiz
Deputy Chef II
Deputy Chef II

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

1 ACCEPTED SOLUTION

chris-wiechmann
Workato employee
Workato employee

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

View solution in original post

2 REPLIES 2

chris-wiechmann
Workato employee
Workato employee

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

MItoiz
Deputy Chef II
Deputy Chef II

Thanks !