---
title: "Execute a stored query"
method: POST
path: "/v1/capacitydb/stored_query/{id}/execute"
tags: ["CapacityDB"]
---

# Execute a stored query

`POST /v1/capacitydb/stored_query/{id}/execute`

## Request

- Base URL: `https://api.capacity.com` (the document declares no server; this is the origin it was published from)
- URL: `https://api.capacity.com/v1/capacitydb/stored_query/{id}/execute`
- Auth: one of:
  - API key in header `x-capacity-id`
  - HTTP bearer

Execute a stored query

## Path parameters

- `id` string, required

## Request body

- object
  - `parameters` object: Parameters to pass to the stored query

## Response `200`

The result of the query

- object
  - `body` object: Json body data in the request
  - `parameters` object: Query parameters in the request
  - `result` object
    - `database_id` string
    - `error` string
    - `query_id` string
    - `rowcount` integer
    - `rows` object[]

## Other responses

- `400`: Bad Request
- `404`: The requested resource could not be found
- `500`: Internal server error

---

[API](https://skmtc.dev/capacity/apis/capacity-api-docs.md) - [All operations](https://skmtc.dev/capacity/apis/capacity-api-docs/llms.txt) - [OpenAPI document](https://skmtc.dev/capacity/apis/capacity-api-docs/revisions/74c85bb61004?raw)