# SeaTable integration

> No-code database platform: read, query and edit bases, tables, rows, columns, views, links, comments and file attachments through the base API.

- Authentication: apiKey

## Tools (69)

- **Add Rows into Big Data Backend**: Insert rows directly into the big data backend.
- **Add Single/Multiple Select Options**: Once you have created a single/multiple select column, use this request to add options for it.
- **Append Columns**: Use this request to append multiple columns to your table at once.
- **Append Row(s)**: Append multiple rows to a table.
- **Auto Links**: Automatically create link relationships.
- **Auto Link task**: Query the status of auto add links task.
- **Create Row Comment**: Create a comment for a certain row.
- **Create Row Link(s)**: Creates multiple links between one column and many others (1:n relation).
- **Create Snapshot**: Creates a snapshot for the current base.
- **Create Table**: Creates a new table in a base.
- **Create View**: Create a new view in the current table.
- **Delete a Base Asset**: Delete a base's attachment.
- **Delete a Base Asset in Custom Folder**: Delete a base's attachment in custom folder.
- **Delete Base Notifications**: Delete all the notifications in the current base irrevocably.
- **Delete Column**: Delete a column with its name or `key`.
- **Delete Comment**: Delete a certain comment by its ID.
- **Delete Row Link(s)**: Deletes one or multiple links between two rows.
- **Delete Row(s)**: Deletes one or multiple rows from the table, identified by its row id no matter if the row is stored in big data or normal backend.
- **Delete Single/Multiple Select Options**: Use this request to remove single select or multiple select options that you don't need any more.
- **Delete Table**: Delete an existing table identified by its name.
- **Delete View**: Delete a view by its name.
- **Duplicate Table**: Duplicate an existing table in your base with or without the existing data in it.
- **Get Base Access Token (Exchange API Token)**: Exchange the base API token for a short-lived base access token plus the base UUID, required by every /api-gateway call.
- **Get Base Activity Log**: Get the activities log in a base.
- **Get Base Big Data Operations**: Get the operation logs of big data in a base.
- **Get Comment**: Get the details of a certain comment with its ID.
- **Get Download Link (Custom Folder)**: Get a temporary download link for a file in a custom folder.
- **Get File Download Link**: Get the file download link of a base's attachment.
- **Get File Metadata (Custom Folder)**: Get metadata (name, size, last update) of a file in a custom folder.
- **Get Files from Folder (Custom Folder)**: List files and subdirectories in a custom folder of a base.
- **Get Metadata**: Get the complete metadata of a base with all tables, columns and views and settings.
- **Get Number of Comments**: Get the number of comments for all rows.
- **Get Row**: Get the values of one row with all columns and values, according to the row id provided.
- **Get Row Comments Count**: Get the number of comments in a certain row.
- **Get SeaTable Server Info**: Use this anonymous call to retrieve the current SeaTable server version information.
- **Get Upload Link**: Generate an upload link, including the parent- and the relative path.
- **Get Upload Link (Custom Folder)**: Get a temporary upload link for uploading files to a custom folder.
- **Get View**: Get the detailed settings of a view by its name.
- **Insert Column**: Create a new column.
- **List Base Notifications**: List all the notifications, read or unread, in a base.
- **List Collaborators**: List all collaborators of a base with name, email address and avatar.
- **List Columns**: List all the visible columns in a certain view in a table.
- **List Comments within Days**: List all the comments in a base within a given number of days before today.
- **List Row Activities**: List all the activities done to a certain row with the row's `row_id`.
- **List Row Comments**: List all the comments in a certain row.
- **List Row Links**: When you have a "Link to other records" column in your table and you have created some links to the current or another table, you can use this request to query each row's linked records' IDs and display values.
- **List Rows**: Returns a list of rows contained in a table (or in a view if provided).
- **List Views**: List all the views and their settings in a table.
- **Lock Rows**: Locks one or more rows.
- **Mark Base Notifications as seen**: Use this request to mark all the notifications as read.
- **Mark Notification Read/Unread**: Mark a specific notification as read or unread.
- **Move Rows to Big Data Backend**: Select a view to move its rows to the big data backend.
- **Move Rows to Normal Backend**: Moves the selected rows from the big data backend to the normal backend.
- **Ping API Gateway**: Check the status of the API gateway.
- **Ping dtable-db Server**: Check the status of the dtable-db server.
- **Ping dtable Server**: Check the status of the dtable-server.
- **Ping Server**: Check the server status.
- **Query SeaTable with SQL**: This is the **recommended endpoint** for reading and modifying data in SeaTable.
- **Rename Table**: Rename a table by providing its original `table_name` and the desired `new_table_name`.
- **Restore Big Data Operations**: Restore the operations by `op_id` of big data operation logs in a base.
- **Send Toast Notification**: Send a toast notification
- **Unlock Rows**: Use this API request to unlock one or more locked rows.
- **Update Column**: Allows various changes of the column: name, column_type, freeze/unfreeze, resize, etc...
- **Update Column Cascade Settings**: After you have added at least two single select columns and have added relevant options, you can start to set the cascade relationships between these single select columns.
- **Update Row Link(s)**: Updates the link(s) between one column and many others (1:n relation).
- **Update Row(s)**: Change the values in one or multiple existing row(s) by defining the new values for necessary columns in the row object.
- **Update Single/Multiple Select Options**: Use this request to update existing single/multiple select options by changing their name and/or color.
- **Update View**: Change the settings of a current view by its name.
- **Upload File (or Image)**: Upload a file or an image as an attachment to a base.

Connect SeaTable in General Input: https://www.generalinput.com/apps/seatable