> ## Documentation Index > Fetch the complete documentation index at: https://docs.scispot.com/llms.txt > Use this file to discover all available pages before exploring further. # Update Rows By UUID > Update individual columns on one or more existing rows, identified by each row's `uuid`. Each entry in `rows` supplies the row `uuid` and the column names to change. Only the columns you send are updated. Omitted columns keep their current values, including dates, connections, and references. This works on labsheets that have no ID or ID_BARCODE column. The `uuid` key selects the row. It is not written as a column value, including when the labsheet has a column named `uuid`. Unknown column names are ignored. Use the Get Row Data endpoint to look up row uuids. A row that fails validation is returned with `success` set to `false` and a `message`, and the other rows in the request are still updated. ## OpenAPI ````yaml /api-docs.yaml post /labsheets/update-rows-by-uuid openapi: 3.0.0 info: title: Scispot's API Documentation description: >- ### [Welcome! Feel Free To Visit Scispot.com](https://www.scispot.com) #### Overview This is a documentation listing API calls for the following Scispot applications: 1. Labsheets (LIMS) 2. ELN 3. Manifests (plates, boxes, racks, etc.) 4. Sequences ## [Getting Started](https://labsheets.scispot.io/#getting-started) ### [Create a new API Key in account settings](https://labsheets.scispot.io/) - Go to [Scispot](https://labsheets.scispot.io) - Click on the "Account" button in the navigation bar on the bottom left corner of your screen - Click "Personal Tokens" on the left side of the pop-up modal - Click "Generate New Token" - Name your token, select token access, and click "Generate" - Copy the API Key and save it somewhere safe - this token cannot be retrieved once it is generated - This token will be used as "apiKey" in all API requests version: 1.0.0 servers: - url: https://cloudlab.scispot.io description: Scispot Cloud Lab security: - bearerAuth: [] tags: - name: Scispot API - name: Scispot API - LABSHEETS (LIMS) API description: >- #### Overview The following API calls are for the manipulation of Labsheets data. #### Terminology - **Labsheet** - A labsheet is a table that can be used to store and organize data. Labsheets can be created or manipulated in Scispot via GUI or API. - **Uuid** - Row uuids are unique identifiers for each labsheet row used in request and response bodies. Row uuids can be found using the Get Row Data endpoint and used in other endpoint requests to manipulate specific rows. - **ID** - IDs are user-defined values that can be used to identify rows in a labsheet. Create row IDs in labsheets by adding a column with type "ID" to your labsheet. The Update Row Data By ID Column endpoint uses IDs to update rows in a labsheet. - **Column Data Types** - These are data types set for each column in a labsheet and can be viewed in a labsheet's manage view menu, under the columns tab. - name: Scispot API - ELN API description: >- #### Overview The following API calls are for the manipulation of ELN data. #### Terminology - **Labspace** - "Labspace" is analogous to a directory or workspace. A labspace can contain folders,experiments, protocols and/or documentation pages. Labspaces can be created and manipulated through via GUI or API. - **Folder** - "Folder" is similar to a traditional folder. It allows users to organize their data inside different "Labspaces". - **Protocol** - A protocol is a base object used to store and organize protocol data. It is analogous to a page in a traditional laboratory record. - **Experiment** - An experiment is a base object used to store and organize experiment data and related protocols. It is also analogous to a page in a traditional laboratory record. - **Documentation** - A documentation page is a base object analogous to a simple note-taking page. - name: Scispot API - ELN API - Create - name: Scispot API - ELN API - Update - name: Scispot API - ELN API - Find - name: Scispot API - ELN API - List - name: Scispot API - ELN API - Delete - name: Scispot API - ELN API - Permissions (Super Admin Only) description: >- ### Permissions Endpoint These endpoint allows you to list, add, remove useres from a private folder. #### **Notes**: - The owner of the API token must have Super Admin permissions - These endpoints only work for folders that are already privated - name: Scispot API - MANIFESTS (PLATES, BOXES, RACKS) API description: |- #### Overview The following API calls are for the manipulation of manifest data. #### Terminology - **Manifest** - A visual representation of a well plate. - name: Scispot API - SEQUENCE API description: |- #### Overview The following API calls are for the manipulation of DNA sequence data. - name: Scispot API - FILES API - name: Scispot API - LOCATIONS API - name: Scispot API - LABFLOWS API - name: Scispot API - WEBHOOK API paths: /labsheets/update-rows-by-uuid: post: tags: - Scispot API - LABSHEETS (LIMS) API summary: Update Rows By UUID description: >- Update individual columns on one or more existing rows, identified by each row's `uuid`. Each entry in `rows` supplies the row `uuid` and the column names to change. Only the columns you send are updated. Omitted columns keep their current values, including dates, connections, and references. This works on labsheets that have no ID or ID_BARCODE column. The `uuid` key selects the row. It is not written as a column value, including when the labsheet has a column named `uuid`. Unknown column names are ignored. Use the Get Row Data endpoint to look up row uuids. A row that fails validation is returned with `success` set to `false` and a `message`, and the other rows in the request are still updated. parameters: [] requestBody: content: application/json: schema: type: object properties: labsheet: type: string description: The name of the labsheet whose rows will be updated. rows: type: array description: >- The list of rows to update. Each entry targets one existing row by its uuid and supplies the columns to change. items: type: object properties: uuid: type: string description: >- The uuid of the row to update. This key selects the row and is not written as a column value. Row uuids can be retrieved using the Get Row Data endpoint. required: - uuid additionalProperties: description: >- The new value for a column, keyed by the column name. Include only the columns you want to change. type: string required: - labsheet - rows additionalProperties: true example: labsheet: Sample Manager rows: - uuid: Sample Status: Completed Sample Quantity: '.002' - uuid: Sample Status: Invalid Input Sample Quantity: '.002' required: true responses: '200': description: OK headers: Content-Type: schema: type: string example: application/json content: application/json: schema: type: array items: type: object properties: uuid: type: string success: type: string message: type: string additionalProperties: true example: - uuid: success: 'true' - uuid: success: 'false' message: the option Invalid Input is invalid '401': description: Invalid Authentication Token content: application/json: schema: type: object properties: success: type: boolean example: false message: type: string additionalProperties: true example: success: false message: Invalid Authentication Token '403': description: Missing Authentication Token content: application/json: schema: type: object properties: success: type: boolean example: false message: type: string additionalProperties: true example: success: false message: Missing Authentication Token '404': description: Not found content: application/json: schema: type: object properties: success: type: boolean example: false message: type: string additionalProperties: true example: success: false message: Not found '422': description: Validation error content: application/json: schema: type: object properties: success: type: boolean example: false message: type: string additionalProperties: true example: success: false message: Validation error '500': description: Operation failed content: application/json: schema: type: object properties: success: type: boolean example: false message: type: string additionalProperties: true example: success: false message: Operation failed components: securitySchemes: bearerAuth: type: http scheme: bearer bearerFormat: UUID description: Personal access token from Scispot Account → Personal Tokens ```` This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.