---
title: "Update a data table using an existing file."
method: PATCH
path: "/api/v1/DataTables"
tags: ["DataTables"]
---

# Update a data table using an existing file.

`PATCH /api/v1/DataTables`

## Request

- Base URL: `https://api.slopesoftware.com` (the document declares no server; this is the origin it was published from)
- URL: `https://api.slopesoftware.com/api/v1/DataTables`
- Auth: HTTP bearer
- TypeScript: <https://skmtc.dev/slopesoftware/apis/akur8-life-api/docs/api/v1/DataTables/patch.ts> (a function with typed inputs; its response is checked against the schema)

This endpoint has the same limitations mentioned in the create data table POST endpoint. <br/>In addition, be aware that a successful request might cause the table to be versioned, thus returning a new data table id that represents the versioned table. <br/>A table will be versioned if it's been used in a projection since the last time it was modified.

## Request body

- UpdateDataTableRequestV1
  - `fileId` integer, nullable: File ID
  - `filePath` string, nullable: File Path
  - `fileVersion` integer, nullable: File Version
  - `delimiter` string, nullable: Delimiter
  - `excelSheetName` string, nullable: Excel Sheet Name
  - `dataTableId` integer, nullable: Date Table ID
  - `tableStructureId` integer, nullable: Table Structure ID
  - `name` string, nullable: Date Table Name
  - `isFileOnly` boolean: Is File Only?
  - `indexes` DataTableIndexV1[], nullable
    - `columnName` string, nullable, required
    - `indexReadMethod` 'ExactMatch' | 'RangeLowerBound'

## Response `200`

OK

- CreateOrUpdateDataTableResponseV1
  - `id` integer
  - `name` string, nullable
  - `tableStructureId` integer
  - `tableStructureName` string, nullable
  - `isFileOnly` boolean
  - `version` integer
  - `isLatestVersion` boolean

## Other responses

- `201`: Created
- `400`: Bad Request
- `401`: Unauthorized
- `403`: Not Allowed To Access
- `404`: Not Found
- `429`: Too Many Requests

---

[API](https://skmtc.dev/slopesoftware/apis/akur8-life-api.md) - [All operations](https://skmtc.dev/slopesoftware/apis/akur8-life-api/llms.txt) - [OpenAPI document](https://skmtc.dev/slopesoftware/apis/akur8-life-api/revisions/9771b2c79880?raw)