Update from xlsx or csv

POST https://{server}/api/v2.1/workspace/{workspace_id}/synchronous-import/update-table-via-excel-csv/

This API call allows you to update a SeaTable database table by uploading an Excel (xlsx) or CSV file. The uploaded file contains rows with data that should be either matched against existing rows in the table for updates or inserted as new rows if no match is found.
Matching is performed based on the columns specified in the selected_columns parameter. For each row in the uploaded file, the system checks whether there are existing rows where the values in these selected columns match exactly. If a match is found, the existing row is updated with the new data from the file. If no match exists, the row is added as a new entry.

📘

Example of the selected_columns parameter

• If one column is specified (e.g., Name), the update process finds rows where the value in that column matches the corresponding value in the file. Those rows will be updated; unmatched rows result in new rows being created.
• If multiple columns are specified (e.g., Name,Age), all these columns must match exactly for a row to be considered a match and updated.
• Rows not matching on all selected columns are treated as new and will be added to the table.