---
title: "DataSet Column Search by ID"
method: GET
path: "/dataset/{id}/column/{colId}"
tags: ["dataset"]
---

# DataSet Column Search by ID

`GET /dataset/{id}/column/{colId}`

Get the DataSet column object specified by the provided datasetId and columnId

## Path parameters

- `datasetId` integer, required
- `datasetColumnId` integer, required

## Response `200`

successful operation

- DataSetColumn — Class DataSetColumn
  - `dataSetColumnId` integer — The ID of this DataSetColumn
  - `dataSetId` integer — The ID of the DataSet that this Column belongs to
  - `heading` string — The Column Heading
  - `dataTypeId` integer — The ID of the DataType for this Column
  - `dataSetColumnTypeId` integer — The ID of the ColumnType for this Column
  - `listContent` string — Comma separated list of valid content for drop down columns
  - `columnOrder` integer — The order this column should be displayed
  - `formula` string — A MySQL formula for this column
  - `dataType` string — The data type for this Column
  - `remoteField` string — The data field of the remote DataSet as a JSON-String
  - `showFilter` string — Does this column show a filter on the data entry page?
  - `showSort` string — Does this column allow a sorting on the data entry page?
  - `dataSetColumnType` string — The column type for this Column
  - `tooltip` string — Help text that should be displayed when entering data for this Column.
  - `isRequired` integer — Flag indicating whether value must be provided for this Column.
  - `dateFormat` string — Date format of dates in the source for remote DataSet.

---

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