Loading data in data tables from external sources

[MItoiz]

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

[chris-wiechmann · Accepted solution]

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]

Thanks !