Data Loader means the process of the bulk Import or Export of the data. Use it to Insert, Update, Delete, or Export PWR Apps records. (When importing data, Data Loader reads, extracts, and loads data from comma-separated values (CSV) files or from a database connection)
There are two types of execution i.e sync or async
Sync: Use to the import or export of records up to 10000
Async: Use to import or export of records greater than 10000
Import
In import, you can perform four sub-operations i.e insert, update, upsert, delete
Insert:
By using the insert operation you can add new records to an object
You have to specify the object name, operation, execution, and type of file that you are going to use to insert records
Depending upon the no. of records you can use execution type as sync or async
Update:
By using the update operation you can modify the records of an object
For update records, you have to provide the ID of the record that you want to update
Upsert:
By using the upsert operation you can update as well as insert records at a time
The records with id will get updated and other than these records will be inserted
Delete:
By using the delete operation you can delete records of an object
To delete records you have to provide an ID of the records that you want to delete
Export
By using the export operation you can export records of an object
You have to provide the file type in which you want to export data