---
title: "Overwrites an existing data table from an imported file."
method: PUT
path: "/api/v2/DataTables/{dataTableId}/Import"
tags: ["DataTables"]
---

# Overwrites an existing data table from an imported file.

`PUT /api/v2/DataTables/{dataTableId}/Import`

## 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/v2/DataTables/{dataTableId}/Import`
- Auth: HTTP bearer
- TypeScript: <https://skmtc.dev/slopesoftware/apis/akur8-life-api/docs/api/v2/DataTables/:dataTableId/Import/put.ts> (a function with typed inputs; its response is checked against the schema)

Overwrites the contents of an existing data table using the specified file. Library and Production models cannot be updated using this endpoint. The excel sheet name field is required for excel files and the delimiter field, which defaults to a comma if not set, is required for non-excel files. The limit for the number of rows is 25,000 for data tables that aren't file only.

## Path parameters

- `dataTableId` integer, required

## Request body

- OverwriteDataTableRequestV2: Request model for overwriting an existing data table from a file.
  - `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
  - `isFileOnly` boolean: Is File Only?
  - `indexes` DataTableIndexV2[], nullable: Optional list of indexes to update index read methods.
    - `columnName` string, nullable, required
    - `indexReadMethod` 'ExactMatch' | 'RangeLowerBound'

## Response `200`

Data table overwritten successfully

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

## Other responses

- `201`: Created
- `400`: Invalid request parameters or Library/Production model
- `401`: Unauthorized
- `403`: Forbidden - insufficient permissions
- `404`: Data table 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)