---
title: "Executes the generated SQL and returns the data."
method: POST
path: "/qe/v{version}/Queries/get-data"
tags: ["Query Engine"]
---

# Executes the generated SQL and returns the data.

`POST /qe/v{version}/Queries/get-data`

## Path parameters

- `version` string, required

## Headers

- `company-id` string, required

## Request body

- QueryEngineContractsModelsDtoDynamicQueryRequest
  - `userId` integer
  - `workflowEntityId` integer
  - `primaryKey` string, nullable
  - `fields` QueryEngineContractsModelsDtoQueryField[], nullable
    - `fieldName` string, nullable
    - `displayName` string, nullable
    - `format` string, nullable
    - `culture` string, nullable
    - `aggregation` string, nullable
  - `filters` QueryEngineContractsModelsDtoQueryFilter[], nullable
    - `fieldName` string, nullable
    - `operator` string, nullable
    - `value` unknown
    - `logicalOperator` string, nullable
  - `sortBy` QueryEngineContractsModelsDtoQuerySort[], nullable
    - `fieldName` string, nullable
    - `direction` string, nullable
  - `groupBy` QueryEngineContractsModelsDtoQueryGroupBy[], nullable
    - `fieldName` string, nullable
  - `pagination` QueryEngineContractsModelsDtoQueryPagination
    - `pageNumber` integer
    - `pageSize` integer

## Response `200`

Success

- QueryEngineContractsModelsDtoDynamicQueryResult
  - `isValid` boolean
  - `errors` string[], nullable
  - `warnings` string[], nullable
  - `info` string[], nullable
  - `message` string, nullable
  - `data` object[], nullable

## Other responses

- `400` — Bad Request

---

[API](https://skmtc.net/bilflo/apis/bilflo-api.md) · [All operations](https://skmtc.net/bilflo/apis/bilflo-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/bilflo/bilflo-api/revisions/bcdbca776df0/schema)