topic Re: Loading data in data tables from external sources in Workato Pros Discussion Board

Loading data in data tables from external sources

MItoiz — Tue, 22 Aug 2023 13:32:45 GMT

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

Re: Loading data in data tables from external sources

chris-wiechmann — Tue, 22 Aug 2023 13:49:08 GMT

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

Re: Loading data in data tables from external sources

MItoiz — Tue, 22 Aug 2023 14:26:10 GMT

Thanks !