---
title: "Changes to Execute a prepared query"
method: POST
path: "/v3/{ledgerName}/prepared-queries/{queryName}/execute"
---

# Changes to Execute a prepared query

`POST /v3/{ledgerName}/prepared-queries/{queryName}/execute`

> Every recorded change to this operation, newest first.

## Timeline

Changed in 21 of 119 revisions.

- **2026-11-03** `f5e817eca038`: 1 info
- **2026-10-19** `2a7ea687c691`: 2 breaking, 4 warning, 1 info
- **2026-10-09** `0ed18e459f51`: 12 breaking, 12 info
- **2026-10-08** `3da23d327316`: 2 info
- **2026-10-08** `b3ee1959d86a`: 1 info
- **2026-10-08** `21be46727a2f`: 1 info
- **2026-10-07** `8de1b9405d3e`: 11 info
- **2026-10-06** `6413bb242a30`: 1 warning
- **2026-10-06** `6e5e3a66e734`: 1 info
- **2026-10-05** `6413bb242a30`: 2 info
- **2026-10-05** `8eea2fde18da`: 1 warning
- **2026-09-30** `b747efd5cd77`: 1 info
- **2026-09-29** `6ff73ac9a6bd`: 1 breaking
- **2026-09-11** `4d2bf2f4e2e5`: 2 breaking
- **2026-09-10** `838326dbf099`: 3 info
- **2026-09-09** `5b22631dac29`: 1 warning
- **2026-09-01** `4d28c76b4328`: 1 info
- **2026-08-28** `fe945da1b75d`: 1 breaking
- **2026-08-25** `1d95db787640`: 1 info
- **2026-08-13** `812efd1474d2`: 3 info
- **2026-07-20** `cf34a2749985`: 1 info

## Changes

- **2026-11-03** `f5e817eca038`: 1 info
  - api operation id `executePreparedQuery` removed and replaced with `v3ExecutePreparedQuery`
- **2026-10-19** `2a7ea687c691`: 2 breaking, 4 warning, 1 info
  - for the `query` request parameter `pageSize`, default value `100` was added
  - the `pageSize` request property format changed from `int32` to `uint32`
  - for the `query` request parameter `pageSize`, the max was set to `4294967295.00`
  - for the `query` request parameter `pageSize`, the min was set to `0.00`
  - the `pageSize` request property's max was set to `4294967295.00`
  - the `pageSize` request property's min was set to `0.00`
  - the `pageSize` request property default value `100` was added
- **2026-10-09** `0ed18e459f51`: 12 breaking, 12 info
  - response property `aggregateResult/groups/items/volumes/items/balance` list-of-types was widened by adding types `integer` to media type `application/json` of response `200`
  - response property `aggregateResult/groups/items/volumes/items/input` list-of-types was widened by adding types `integer` to media type `application/json` of response `200`
  - response property `aggregateResult/groups/items/volumes/items/output` list-of-types was widened by adding types `integer` to media type `application/json` of response `200`
  - response property `aggregateResult/volumes/items/balance` list-of-types was widened by adding types `integer` to media type `application/json` of response `200`
  - response property `aggregateResult/volumes/items/input` list-of-types was widened by adding types `integer` to media type `application/json` of response `200`
  - response property `aggregateResult/volumes/items/output` list-of-types was widened by adding types `integer` to media type `application/json` of response `200`
  - response property `cursor/accountData/items/volumes/items/volumes/balance` list-of-types was widened by adding types `integer` to media type `application/json` of response `200`
  - response property `cursor/accountData/items/volumes/items/volumes/input` list-of-types was widened by adding types `integer` to media type `application/json` of response `200`
  - response property `cursor/accountData/items/volumes/items/volumes/output` list-of-types was widened by adding types `integer` to media type `application/json` of response `200`
  - response property `cursor/transactionData/items/postCommitVolumes/additionalProperties/items/input` list-of-types was widened by adding types `integer` to media type `application/json` of response `200`
  - response property `cursor/transactionData/items/postCommitVolumes/additionalProperties/items/output` list-of-types was widened by adding types `integer` to media type `application/json` of response `200`
  - response property `cursor/transactionData/items/postings/items/amount` list-of-types was widened by adding types `string` to media type `application/json` of response `200`
  - added the new optional `header` request parameter `Formance-Bigint-As-String`
  - the `aggregateResult/groups/items/volumes/items/balance` response's property pattern `^(0|-?[1-9][0-9]*)$` was removed for the status `200`
  - the `aggregateResult/groups/items/volumes/items/input` response's property pattern `^(0|[1-9][0-9]*)$` was removed for the status `200`
  - the `aggregateResult/groups/items/volumes/items/output` response's property pattern `^(0|[1-9][0-9]*)$` was removed for the status `200`
  - the `aggregateResult/volumes/items/balance` response's property pattern `^(0|-?[1-9][0-9]*)$` was removed for the status `200`
  - the `aggregateResult/volumes/items/input` response's property pattern `^(0|[1-9][0-9]*)$` was removed for the status `200`
  - the `aggregateResult/volumes/items/output` response's property pattern `^(0|[1-9][0-9]*)$` was removed for the status `200`
  - the `cursor/accountData/items/volumes/items/volumes/balance` response's property pattern `^(0|-?[1-9][0-9]*)$` was removed for the status `200`
  - the `cursor/accountData/items/volumes/items/volumes/input` response's property pattern `^(0|[1-9][0-9]*)$` was removed for the status `200`
  - the `cursor/accountData/items/volumes/items/volumes/output` response's property pattern `^(0|[1-9][0-9]*)$` was removed for the status `200`
  - the `cursor/transactionData/items/postCommitVolumes/additionalProperties/items/input` response's property pattern `^(0|[1-9][0-9]*)$` was removed for the status `200`
  - the `cursor/transactionData/items/postCommitVolumes/additionalProperties/items/output` response's property pattern `^(0|[1-9][0-9]*)$` was removed for the status `200`
- **2026-10-08** `3da23d327316`: 2 info
  - added the media type `text/plain` for the response with the status `401`
  - added the media type `text/plain` for the response with the status `403`
- **2026-10-08** `b3ee1959d86a`: 1 info
  - added the new optional `header` request parameter `X-Consistency`
- **2026-10-08** `21be46727a2f`: 1 info
  - added the optional property `cursor/previous` to the response with the `200` status
- **2026-10-07** `8de1b9405d3e`: 11 info
  - the `aggregateResult/groups/items/volumes/items/balance` response's property pattern `^(0|-?[1-9][0-9]*)$` was added for the status `200`
  - the `aggregateResult/groups/items/volumes/items/input` response's property pattern `^(0|[1-9][0-9]*)$` was added for the status `200`
  - the `aggregateResult/groups/items/volumes/items/output` response's property pattern `^(0|[1-9][0-9]*)$` was added for the status `200`
  - the `aggregateResult/volumes/items/balance` response's property pattern `^(0|-?[1-9][0-9]*)$` was added for the status `200`
  - the `aggregateResult/volumes/items/input` response's property pattern `^(0|[1-9][0-9]*)$` was added for the status `200`
  - the `aggregateResult/volumes/items/output` response's property pattern `^(0|[1-9][0-9]*)$` was added for the status `200`
  - the `cursor/accountData/items/volumes/items/volumes/balance` response's property pattern `^(0|-?[1-9][0-9]*)$` was added for the status `200`
  - the `cursor/accountData/items/volumes/items/volumes/input` response's property pattern `^(0|[1-9][0-9]*)$` was added for the status `200`
  - the `cursor/accountData/items/volumes/items/volumes/output` response's property pattern `^(0|[1-9][0-9]*)$` was added for the status `200`
  - the `cursor/transactionData/items/postCommitVolumes/additionalProperties/items/input` response's property pattern `^(0|[1-9][0-9]*)$` was added for the status `200`
  - the `cursor/transactionData/items/postCommitVolumes/additionalProperties/items/output` response's property pattern `^(0|[1-9][0-9]*)$` was added for the status `200`
- **2026-10-06** `6413bb242a30`: 1 warning
  - removed the optional property `cursor/previous` from the response with the `200` status
- **2026-10-06** `6e5e3a66e734`: 1 info
  - added the optional property `cursor/previous` to the response with the `200` status
- **2026-10-05** `6413bb242a30`: 2 info
  - added the new optional `query` request parameter `reverse`
  - added the new optional request property `reverse`
- **2026-10-05** `8eea2fde18da`: 1 warning
  - removed the optional property `cursor/previous` from the response with the `200` status
- **2026-09-30** `b747efd5cd77`: 1 info
  - endpoint added
- **2026-09-29** `6ff73ac9a6bd`: 1 breaking
  - api path removed without deprecation
- **2026-09-11** `4d2bf2f4e2e5`: 2 breaking
  - the `cursor/accountData/items/metadata/additionalProperties/oneOf[subschema #2]/` response's property format changed from `int64` to no format for status `200`
  - the `cursor/transactionData/items/metadata/additionalProperties/oneOf[subschema #2]/` response's property format changed from `int64` to no format for status `200`
- **2026-09-10** `838326dbf099`: 3 info
  - added the optional property `cursor/logData/items/payload` to the response with the `200` status
  - added the optional property `cursor/logData/items/responseSignature` to the response with the `200` status
  - added the optional property `cursor/logData/items/sequence` to the response with the `200` status
- **2026-09-09** `5b22631dac29`: 1 warning
  - removed the request property `minLogSequence`
- **2026-09-01** `4d28c76b4328`: 1 info
  - endpoint added
- **2026-08-28** `fe945da1b75d`: 1 breaking
  - api path removed without deprecation
- **2026-08-25** `1d95db787640`: 1 info
  - added the new optional `header` request parameter `X-Query-Profile`
- **2026-08-13** `812efd1474d2`: 3 info
  - the response property `cursor/transactionData/items/metadata` became required for the status `200`
  - the response property `cursor/transactionData/items/postings` became required for the status `200`
  - the response property `cursor/transactionData/items/reverted` became required for the status `200`
- **2026-07-20** `cf34a2749985`: 1 info
  - endpoint added

---

[Operation](https://skmtc.dev/formancehq/apis/ledger-api/docs/v3/:ledgerName/prepared-queries/:queryName/execute/post.md) - [API](https://skmtc.dev/formancehq/apis/ledger-api.md) - [Page](https://skmtc.dev/formancehq/apis/ledger-api/changes/v3/:ledgerName/prepared-queries/:queryName/execute/post)
