> ## 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. # Fetch List of Labsheet Rows > Pagination constraints: pageSize must be at most 1000, and page multiplied by pageSize must be less than 50000. Violations return HTTP 400 with a plain string message. ## OpenAPI ````yaml /api-docs.yaml get /labsheets/fetch-list-rows 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/fetch-list-rows: get: tags: - Scispot API - LABSHEETS (LIMS) API summary: Fetch List of Labsheet Rows description: >- Pagination constraints: pageSize must be at most 1000, and page multiplied by pageSize must be less than 50000. Violations return HTTP 400 with a plain string message. parameters: - name: labsheet in: query schema: type: string example: Sample Manager description: The name of the selected labsheet required: true - name: pageSize in: query schema: type: string example: 10 description: Number of rows to be fetched (defaults to 5 if not specified) - name: page in: query schema: type: string example: 1 description: >- The page number of rows to be fetched indexed from 1, where a page is a set of rows of size pageSize. (setting pageSize as "10" and page as "2"will fetch rows 11-20) (defaults to 1 if not specified) - name: archiveState in: query schema: type: string example: any description: >- (Optional) Whether to filter out archived or unarchived rows. Possible values: "archived", "unarchived", "any" (defaults to "any" if not provided) responses: '200': description: OK headers: Content-Type: schema: type: string example: application/json content: application/json: schema: type: object properties: headers: type: array items: type: string rows: type: array items: type: array items: type: object total: type: number path: type: string success: type: string message: type: string additionalProperties: true example: headers: - uuid - Sample ID - Sample Name - Sample - Sample Type - Sample Status - Sample Quantity - Sample Units - Test Results - Test Run Sample rows: - - - SMPL000001 - Sample 1 - 1 - DNA - Pending - 0.001 - mg - null - null - - - SMPL000002 - Sample 2 - 2 - DNA - Pending - 0.002 - mg - null - null total: 2 success: 'true' '400': description: Bad request content: application/json: schema: type: object properties: success: type: boolean example: false message: type: string additionalProperties: true example: success: false message: Bad request '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 ````