---
title: "List reporting metadata"
method: GET
path: "/apilist"
tags: ["API"]
---

# List reporting metadata

`GET /apilist`

## Request

- Base URL: `https://api3.mountain.com`
- URL: `https://api3.mountain.com/apilist`
- Auth: none declared
- TypeScript: <https://skmtc.dev/mountain/apis/mntn-ai-ops-reporting-api/docs/apilist/get.ts> (a function with typed inputs; its response is checked against the schema)

Returns tables, columns and help text available to the advertiser (same `key` and `format` query parameters as **GET /apidata**). 
 The response shape depends on `format`: `json` returns a structured JSON object, while `csv`, `excel`, and `human` return tabular text/binary representations of the same metadata. 
 There is **no** `filter` query parameter on this route; call **`/apidata`** to apply **`filter`**. Use **`/apilist`** first to discover column identifiers for `data`, `sum`, and `filter`.

## Query parameters

- `key` string, required
- `format` 'human' | 'json' | 'csv' | 'excel'

## Response `200`

Metadata payload in the requested format

- ListMetadataResponse: Response containing available tables and columns metadata
  - `tables` object[]: List of available tables
    - `name` string: Table name
    - `friendly` string: User-friendly table name
    - `help` string: Table description
    - `columns` object[]: List of columns in this table
      - `name` string: Column name
      - `friendly` string: User-friendly column name
      - `help` string: Column description
      - `format` string: Data format type
      - `icon` string: Icon type for UI
      - `table` string: Parent table name
      - `fully_qualified_name` string: Full column path

## Other responses

- `400`: Invalid request parameters
- `401`: Unauthorized
- `403`: Forbidden
- `404`: Not Found
- `413`: Payload Too Large — the query exceeds server memory limits. Use the asynchronous /batch endpoint for large requests.
- `500`: An unexpected error occurred while processing the request
- `504`: Gateway Timeout — the query exceeded the synchronous request time limit.

---

[API](https://skmtc.dev/mountain/apis/mntn-ai-ops-reporting-api.md) - [All operations](https://skmtc.dev/mountain/apis/mntn-ai-ops-reporting-api/llms.txt) - [OpenAPI document](https://skmtc.dev/mountain/apis/mntn-ai-ops-reporting-api/revisions/826e4445c45e?raw)