---
title: "Generates custom mi report user defined"
method: POST
path: "/v1.0/mireports/user-defined/generate-custom"
tags: ["Mi Reports User defined"]
---

# Generates custom mi report user defined

`POST /v1.0/mireports/user-defined/generate-custom`

## Request body

- CustomMiReportQuery — The custom sql query
  - `sqlQuery` string, required

## Response `200`

OK

- MiReportUserDefinedResult
  - `columnNames` string[]
  - `results` object[]

## Other responses

- `400` — Bad Request Error Code | Description MIREPORT1000 | Invalid MI Report type
- `500` — Internal Server Error

---

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