# Find IDs

> Part of the NocoDB documentation (APIs). Index of all pages: https://nocodb.com/llms.txt. Any docs page is available as Markdown by adding `.md` to its URL.

URL: https://nocodb.com/docs/apis/ids
Last updated: 2026-10-21

Find the workspace, base, table, view, field, record, user and data source IDs that NocoDB REST API endpoints need, and the prefix of each ID.

Most NocoDB API endpoints take IDs in the path, for example `/api/v3/data/{baseId}/{tableId}/records`. Before you make API calls, find and copy the IDs that your endpoints need. This page tells you where to find each ID. In the NocoDB app, a base is called a project.

| ID                                | Starts with      | Where to find it                                                         |
| --------------------------------- | ---------------- | ------------------------------------------------------------------------ |
| [Workspace ID](#workspace-id)     | `w`              | URL bar, workspace switcher, **Settings** > **General** > **Appearance** |
| [Base ID](#base-id)               | `p`              | URL, base context menu                                                   |
| [Table ID](#table-id)             | `m`              | URL, table context menu                                                  |
| [View ID](#view-id)               | `v`              | URL, view context menu, view toolbar                                     |
| [Field ID](#field-id)             | `c`              | URL, field context menu, `Tools` > `Manage fields`                       |
| [Record ID](#record-id)           | A number, from 1 | **ID** field, URL of an expanded record                                  |
| [User ID](#user-id)               | `u`              | **Workspace Members** or **Project Members** page                        |
| [Data Source ID](#data-source-id) |                  | Data source context menu, Data Source settings page                      |

## Workspace ID

**Workspace ID** is a unique alphanumeric identifier for your workspace in NocoDB. It starts with `w` (for *workspace*). It shows in the URL bar when you open a project in the workspace.

You can also find it in the workspace switcher, at the top of the workspace sidebar. Click the ID to copy it to your clipboard.

<img alt="Workspace ID" src={__img0} placeholder="blur" />

The Workspace ID also shows in **Settings** > **General** > **Appearance**.

<img alt="Workspace ID" src={__img1} placeholder="blur" />

## Base ID

Metadata APIs and administrative operations need the **Base ID**. It is a unique identifier for one database (or base) in your workspace.

The Base ID is an alphanumeric identifier that starts with `p` (for *project*). It shows in the URL when you open a table or the base settings. You can also find it in the base context menu in the left sidebar. To open this menu, click the chevron next to the base name. Click the ID to copy it to your clipboard.

<img alt="Base ID" src={__img2} placeholder="blur" />

## Table ID

**Table ID** is the identifier that you use most. All data API calls need it. It is a unique identifier for one table in your project.

The Table ID is an alphanumeric string that starts with `m` (for *model*). When you open a table, it shows in the URL, immediately after the Base ID. You can also find it in the table context menu in the left sidebar. To open this menu, click the three dots next to the table name. Click the ID to copy it to your clipboard.

<img alt="Table ID" src={__img3} placeholder="blur" />

## View ID

Use the **View ID** for API operations on a view, for example to get records from one view. It is a unique identifier for one view in a table.

The View ID is an alphanumeric string that starts with `v` (for *view*). It shows in the URL when a view is open. You can also find it in the view context menu in the left sidebar. To open this menu, click the three dots next to the view name. Click the ID to copy it to your clipboard.

<img alt="View ID" src={__img4} placeholder="blur" />

You can also get the View ID from the view toolbar > more actions (3 dots) menu.

<img alt="View ID" src={__img5} placeholder="blur" />

## Field ID

Use the **Field ID** for API operations on a field, for example to update field properties. It is a unique identifier for one column in a table.

The Field ID is an alphanumeric string that starts with `c` (for *column*). It shows in the URL when you view or edit the settings of a field. You can also find it in the field context menu in the field header bar. To open this menu, click the chevron next to the field name. Click the ID to copy it to your clipboard.

<img alt="Field ID" src={__img6} placeholder="blur" />

You can also get the Field ID from `Tools` > `Manage fields`.

<img alt="Field ID in the Manage fields tool" src={__img7} placeholder="blur" />

## Record ID

Use the **Record ID** for API operations on a record, for example to get or update one record. It is a unique identifier for one row in a table.

By default, the Record ID is a number that starts at 1. The **ID** field shows the Record ID. To show the **ID** field, do these steps:

1. In the toolbar, open the **Fields** menu.
2. Enable **Show System Fields**.

<img alt="Record ID" src={__img8} placeholder="blur" />

You can also find it in the URL when you open a record (expanded record view).

<img alt="Record ID" src={__img9} placeholder="blur" />

You can also use the Record ID in formulas. In the formula editor, select **ID** from the list of available fields, or use the `RECORD_ID()` function.

<img alt="Record ID" src={__img10} placeholder="blur" />

## User ID

Use the **User ID** for API operations on a user, for example to get user details. It is a unique identifier for one user in your workspace or organization.

The User ID is an alphanumeric string that starts with `u` (for *user*). To find it, open the **Workspace Members** page or the **Project Members** page. Then click the three dots menu next to the name of the user. Click the ID to copy it to your clipboard.

<img alt="User ID" src={__img11} placeholder="blur" />

<img alt="User ID" src={__img12} placeholder="blur" />

## Data Source ID

For external data sources that are connected to NocoDB (for example Postgres or MySQL), data API operations also need the **Data Source ID**.

The Data Source ID is a unique alphanumeric string for the connected data source. To find it, click the three dots next to the data source name in the left sidebar. The context menu opens. Click the ID to copy it to your clipboard.

<img alt="Data Source ID" src={__img13} placeholder="blur" />

You can also find it on the Data Source settings page.

<img alt="Data Source ID" src={__img14} placeholder="blur" />

---

## Related pages

- [NocoDB API Quickstart](https://nocodb.com/docs/apis.md): Make your first NocoDB REST API request: create an API token, find your project and table IDs, then list the records of a table with the v3 Data API.
- [Authentication](https://nocodb.com/docs/apis/authentication.md): Authenticate NocoDB REST API requests with an API token, sent in the xc-token header or as a Bearer token, and explore endpoints in the Swagger UI.
- [Filtering](https://nocodb.com/docs/apis/filtering.md): Filter NocoDB REST API results with the where query parameter: comparison operators, date sub-operators, logical operators and the quoted v3 syntax.
- [Query Parameters](https://nocodb.com/docs/apis/query-parameters.md): Query parameters of NocoDB REST API list requests: where, limit, offset, sort, fields and shuffle, with their aliases, defaults and example values.
- [Pagination](https://nocodb.com/docs/apis/pagination.md): Page through NocoDB REST API results: follow the next and prev URLs of v3 record lists, and use limit, offset and pageInfo for the base list.
- [Errors and Rate Limits](https://nocodb.com/docs/apis/errors.md): NocoDB REST API errors and rate limits: the JSON error body, what each HTTP status code means, request IDs, and how to handle a 429 response.
- [Upload Files](https://nocodb.com/docs/apis/upload-files.md): Upload local files to a NocoDB Attachment field with the REST API: code samples in JavaScript, Bash, TypeScript, Python, Ruby and Java, for one file or a batch.
- [Delete Records by ID](https://nocodb.com/docs/apis/delete-records.md): Delete NocoDB records, or unlink linked records, by sending the record ids in a records query parameter when a client or proxy removes the DELETE body.