---
title: "SQL query"
method: POST
path: "/crm/sql"
tags: ["crm"]
---

# SQL query

`POST /crm/sql`

## Request

- Base URL: `https://www.dench.com/api/v1`
- URL: `https://www.dench.com/api/v1/crm/sql`
- Auth: one of:
  - HTTP bearer
  - HTTP bearer

Run CRM SQL-compatible query.

## Request body

- object
  - `objectName` string, required
  - `dsl` object
  - `dslJson` string

## Response `200`

Successful response

- object[]: Entry rows. With dsl.select the rows are flat {_id, ...selectedFields} objects instead.
  - `id` string, required
  - `objectId` string, required
  - `fields` object, required: Field-name -> cell value map.
  - `createdAt` number, required
  - `updatedAt` number, required
  - `updatedBy` string, required
  - `sortOrder` number, required

## Other responses

- `400`: Invalid request
- `401`: Missing or invalid authentication
- `404`: Operation or resource not found
- `500`: Server error

---

[API](https://skmtc.dev/dench/apis/dench-api.md) - [All operations](https://skmtc.dev/dench/apis/dench-api/llms.txt) - [OpenAPI document](https://skmtc.dev/dench/apis/dench-api/revisions/4a145b38f19c?raw)