FAQ: I want to create or update a target record by reading a CSV file in a batch process
## Answer
Use the "「Import API Record」".
---
## Overview
If you want to load a CSV file in batch processing and create or update the target records, use the "「Import API Record」".
As an example, insert the column loaded from the CSV file in the table below into the column in Pleasanter. If the value of id (ClassA) already exists in Pleasanter, it will be overwritten and updated. In order to check the ID, the "「Search Type」" of ClassA must be set to an exact match. Save the CSV data to be imported in the same folder as the script file.
|CSV column|Pleasanter column|
|:--:|:--:|
|name|Title|
|id|ClassA|
|mail|ClassE|
## Operation Procedure
1. Open Pleasanter and create a table
1. Open "[Manage Table](/en/manual/table-management)" and enable ClassA and ClassE in the "「Editor」" tab.
1. Open the "「Filter」" tab, select ClassA, click the advanced settings button, change "「Search Type」" to an exact match, and then click the Change button.
1. Click the Update button.
1. Use the Back button to return to the list screen.
1. Create an API key in "API Settings" from the user menu and copy the key.
1. Note the site ID of the target table.
1. Copy the example CSV file below and save the file as data.csv.
1. Copy the sample code below and save the file as import.ps1.
1. Modify line 8 of import.ps1 to match the character code of the CSV file.
1. Change the site ID and API key on lines 1 and 2 of import.ps1 and save it.
1. Execute import.ps1.
### Create a CSV file (data.csv)
````
id,name,mail
1,user1,user1@example.com
2,user2,user2@example.com
3,user3,user3@example.com
4,user4,user4@example.com
5,user5,user5@example.com
6,user6,user6@example.com
7,user7,user7@example.com
8,user8,user8@example.com
9,user9,user9@example.com
10,user10,user10@example.com
````
## Sample Code
##### PowerShell
````
$url = 'http://localhost/api/items/xxxsiteidxxx/import'
$apiKey = 'xxxAPIKeyxxx'
$filePath = "./data.csv"
$form = @{
parameters = ConvertTo-Json @{
ApiVersion = 1.1;
ApiKey = $apiKey;
Encoding = "UTF-8";
UpdatableImport = $true;
Key = "ClassA";
};
file = Get-Item -Path $filePath;
}
Invoke-WebRequest -Uri $url -Method Post -Form $form
````
## Related Information
<div id="ManualList"><ul><li><a href="/en/manual/table-management">Manage Table</a><span>12.09.2025 up</span></li></ul></article></div><input id="SearchTextHidden" type="hidden" value="" />
