---
title: "List all Calculated Fields"
method: GET
path: "/1/derived_columns/{datasetSlug}"
tags: ["Calculated Fields"]
---

# List all Calculated Fields

`GET /1/derived_columns/{datasetSlug}`

Get all the Calculated Fields (also called Derived Columns) in a dataset or environment. With the `?alias=X` query parameter, can return a single Calculated Field by its `alias`.

## Query parameters

- `alias` string

## Response `200`

When listing all columns, an array of CalculatedField objects will be returned. When using `key_name`, will return a single CalculatedField object if found.

- union
  - CalculatedField[]
    - `id` string, required — Unique identifier (ID), returned in response bodies.
    - `alias` string, required — The human-readable name of the Calculated Field (also called Derived Column), as it will be referenced when building queries.
    - `expression` string, required — The expression to evaluate to construct this Calculated Field's value. (Calculated Field is also called Derived Column.) Refer to the [Calculated Field Reference](https://docs.honeycomb.io/reference/derived-column-formula/).
    - `description` string — A human-readable description for the Calculated Field that displays in the UI.
    - `created_at` string, required — ISO8601 formatted time when the field was created.
    - `updated_at` string, required — ISO8601 formatted time when the field was updated.
  - CalculatedField
    - `id` string, required — Unique identifier (ID), returned in response bodies.
    - `alias` string, required — The human-readable name of the Calculated Field (also called Derived Column), as it will be referenced when building queries.
    - `expression` string, required — The expression to evaluate to construct this Calculated Field's value. (Calculated Field is also called Derived Column.) Refer to the [Calculated Field Reference](https://docs.honeycomb.io/reference/derived-column-formula/).
    - `description` string — A human-readable description for the Calculated Field that displays in the UI.
    - `created_at` string, required — ISO8601 formatted time when the field was created.
    - `updated_at` string, required — ISO8601 formatted time when the field was updated.

## Other responses

- `400` — The provided request body was invalid.
- `401` — Unauthorized
- `404` — Not Found
- `429` — Rate Limit Exceeded

---

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