List reports
list_reportsList the online reports (Excel reports users run in Azquo) the current user can see, across every database in the business. Read-only, no parameters. Use it to find a report's id or name before get_report_data, read_workbook or delete_report. For the reports, setup sheets and import templates of one database use list_database_sheets instead.
Who sees what: an administrator sees every report in the business; a developer sees the reports on databases they own; a user whose role has the Reports menu item sees every report in the business too (marked readOnly: true when the role may only see Reports - they run, but do not save); other users see the reports on their menus.
Returns an array of reports: id, reportName (with " uploaded by " appended), database (the one it runs against; empty for reports usable with any database, "No database" when unlinked), filename, category, explanation, dateCreated and author. A report linked to several databases appears once for each. To SHOW the person a report, call open_in_browser with its id and database: its one-use link opens the report already signed in as this same user, with their choices. Do not give the person any other address for a report - a plain one makes them sign in again, and they may land as another login of theirs, whose saved choices differ. Then the reports of the shared azquo_library databases (overlaid read-only, as list_databases shows them), marked library: true and readOnly: true - run them with get_report_data on the database shown, or show them with open_in_browser, which opens them read-only (no Save, executes do not run). A library database whose name this business also holds is left out: the business's own copy wins. With none visible, a single placeholder with id 0 and reportName "No reports found" is returned. Not paginated.
Tool call template
This tool declares no required parameters. Add optional parameters from the input schema as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {},
"name": "list_reports"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| business | No | Optional. The business this call is for, by name, e.g. "azquo" - it then runs there whatever business the session is in. Worth giving on writes when you work in more than one business: a new MCP session starts in the login's own business. list_businesses shows the names. |