---
title: "Run a report with input"
method: POST
path: "/v1/Reports/{id}/results"
tags: ["Reports"]
---

# Run a report with input

`POST /v1/Reports/{id}/results`

Run a report that requires user input.

## Path parameters

- `id` integer, required

## Request body

- RevAppModelsReportsResultsInput
  - `format` 'JSON' | 'CSV' | 'XML', required — Indicates how data is structured in results.
  - `clear_cache` boolean — Forces query directly from database.
  - `prompts` RevAppModelsReportsReportPrompt[] — List of prompts requesting input from executing user.
    - `prompt_id` integer — Primary identifier for this prompt.
    - `column` string — Name of the SQL table column to query.
    - `value` string — Value you want to compare with column.
    - `operator` string — Relationship between column and value that qualifies as a match.

## Response `200`

OK

- RevAppModelsReportsResultsOutput
  - `data` string — Row output of report after execution.

## Other responses

- `400` — BadRequest
- `500` — InternalServerError

---

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