---
title: "Run Ad-hoc Query"
method: POST
path: "/print-mail/v1/reports/samples"
tags: ["Reports"]
---

# Run Ad-hoc Query

`POST /print-mail/v1/reports/samples`

Run an ad-hoc SQL query against your data lake and get a sample of the results.
This is useful for quickly testing queries without saving them as a report.
The query execution time and result size are limited.

## Request body

- AdHocReportSampleCreate — Base properties for creating a report sample.
  - `params` string[] — Optional parameters to bind to the SQL query (e.g., for placeholders like ? or $1).
  - `limit` integer — Maximum number of rows to return in the sample.

## Response `201`

A sample of the query results.

- ReportSample — Represents the result of a report sample query.
  - `id` string, required — Unique identifier for the sample query result.
  - `report` string, nullable, required — The ID of the report this sample was generated from, or null for ad-hoc samples.
  - `records` ReportRecord[], required — The actual data records returned by the sample query.

## Other responses

- `400` — A sample of the query results.
- `401` — A sample of the query results.
- `404` — A sample of the query results.
- `422` — A sample of the query results.
- `429` — A sample of the query results.
- `500` — A sample of the query results.

---

[API](https://skmtc.net/postgrid/apis/postgrid-print-mail-api.md) · [All operations](https://skmtc.net/postgrid/apis/postgrid-print-mail-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/postgrid/postgrid-print-mail-api/versions/6bb9d268c5d1/schema)