---
title: "Execute MI SQL INSERT"
method: POST
path: "/v1/spatial/misql/execute"
tags: ["Advanced Querying - Data Modification"]
---

# Execute MI SQL INSERT

`POST /v1/spatial/misql/execute`

## Request

- Base URL: `https://api.cloud.precisely.com`
- URL: `https://api.cloud.precisely.com/v1/spatial/misql/execute`
- Auth: one of:
  - `bearerAuth` (a scheme the document does not define)
  - `ApiKeyAuth` (a scheme the document does not define)

Executes an MI SQL INSERT statement provided in the request body, with optional bound parameters.

## Headers

- `X-Request-Id` string

## Request body

- MISqlRequest
  - `insert` string
  - `update` string
  - `delete` string
  - `parameters` SqlParameter[]
    - `name` string
    - `value` unknown
    - `crs` object

## Response `201`

INSERT executed successfully

- InsertFeaturesResponse
  - `successfulInserts` integer
  - `insertedKeys` string[]

## Other responses

- `400`: Missing 'insert' field, or invalid SQL/parameters, in the request body
- `401`: Unauthorized: Invalid token
- `403`: Forbidden
- `404`: Table not found
- `429`: Too many requests
- `500`: Internal Server Error
- `503`: Service Unavailable

---

[API](https://skmtc.dev/precisely/apis/feature-api.md) · [All operations](https://skmtc.dev/precisely/apis/feature-api/llms.txt) · [OpenAPI document](https://skmtc.dev/precisely/apis/feature-api/revisions/6dc26f89c0aa?raw)