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
We use a data loader for the import or export of the records in the PWRapps
There are two main operations performed in data loader i.e import and export
You can use the execution type as sync or async
Sync: It is used for the import or export of records up to 10000
Async: It is used for the 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 format of the 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 on which you have provided the ID that records will update 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 format of the file in which you want to export data