---
title: "Generates dynamic SQL based on the provided query request."
method: POST
path: "/qe/v{version}/Queries/dynamic-sql"
tags: ["Query Engine"]
---

# Generates dynamic SQL based on the provided query request.

`POST /qe/v{version}/Queries/dynamic-sql`

## 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

- string

## 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)