how to import data periodically from external spread sheet to custom table ?

[KM SN]

I have external spread sheet from where I need to import data to custom table for every week.

how to proceed it? if it is through scheduled jobs let me know how to  achieve it??

[Sagar Pagar · Accepted solution]

Hi @KM SN,

You need to configure the below steps -

1. Create Import sets table. This will be used as import table to store data from external spreadsheet.

2. Create Data Source and Transform maps for getting data of external spreadsheet to import table.

3. Create a scheduled import job. This scheduled import job will execute at required time to insert/update data in the Custom table.

Thanks,

Sagar Pagar