---
title: "Get custom data row by ID"
method: GET
path: "/api/v1/organization/custom-data/row"
tags: ["Custom Data"]
---

# Get custom data row by ID

`GET /api/v1/organization/custom-data/row`

Retrieve a single custom data table row by its identifier, within the
authenticated organization.

Organization-scoped tokens have full access. For user-scoped tokens the row
is returned only if the user's role has view access to the table and the row.

## Query parameters

- `tableName` string, required
- `id` integer, required

## Response `200`

The custom data table row.

- CustomDataRow — A single row of a custom data table.
  - `id` integer, required — Unique identifier of the row within its table.
  - `orgId` integer, required — Identifier of the organization the row belongs to.
  - `values` CustomDataColumnValue[], required — Column values of the row, one entry per table column, in the same order as the columns are defined in the table.
    - union — A single column value of a custom data table row. The concrete schema depends on the `type` discriminator property, which reflects the type of the column the value belongs to. Every value also carries the `columnName` it corresponds to.
      - object — Value of a decimal (double) column.
        - `type` 'double', required — Value type discriminator.
        - `columnName` string, required — Name of the column this value belongs to.
        - `value` number, double, required — The decimal value.
        - `decimalsFormat` 'NO_FRACTION' | 'FRACTION_1' | 'FRACTION_2' | 'FRACTION_3' | 'FRACTION_4' | 'FRACTION_5' | 'FILL_1' | 'FILL_2' | 'FILL_3' | 'FILL_4' | 'FILL_5' — Decimal format used for displaying a numeric value in the dashboard and reports.
        - `unit` 'None' | 'KilometerPerHour' | 'MillimeterPerHour' | 'InchesPerHour' | 'CubicMetresPerHour' | 'MilePerHour' | 'MilePerHour2' | 'GramPerSquareMeter' | 'MilliLitterPerSquareMeter' | 'LitterPerSquareMeter' | 'PoundPerSquareInch' | 'PoundPerSquareInch2' | 'PoundPerCubicYard' | 'OuncePerCubicYard' | 'PoundPerCubicFoot' | 'VolumeFlow' | 'CubicCentimetersPerMinute' | 'SignalStrength' | 'DegreeDays' | 'Millimeter' | 'Centimeter' | 'Meter' | 'Kilometer' | 'KiloBytes' | 'MegaBytes' | 'GigaBytes' | 'Feet' | 'SquareFeet' | 'Inch' | 'Foot' | 'Yard' | 'Mile' | 'Milligram' | 'Gram' | 'Kilogram' | 'Ton' | 'Liter' | 'Milliliter' | 'Ounce' | 'Pint' | 'Gallon' | 'Pound' | 'Stone' | 'Quarter' | 'Hundredweight' | 'Celsius' | 'Fahrenheit' | 'Kelvin' | 'Percentage' | 'Degrees' | 'RPM' | 'Step' | 'Year' | 'Month' | 'Week' | 'Day' | 'Hour' | 'Minute' | 'Second' | 'Volt' | 'Ampere' | 'MilliAmpere' | 'MicroAmpere' | 'Ohm' | 'Hertz' | 'Watts' | 'Farad' | 'Siemen' | 'Henry' | 'MicrogramPerCubicMeter' | 'PartsPerMillion' | 'PartsPerBillion' | 'KiloWatts' | 'HectoPascal' | 'Pascal' | 'Lux' | 'Pressure' | 'PressureInBars' | 'AirQualityIndex' | 'KiloWattHour' | 'MilliSecond' | 'MilliSec' | 'MeterPerSecond' | 'MilliGramPerCubicMeter' | 'KiloPascal' | 'CubicMeter' | 'CubicYard' | 'CubicFeetPerMinute' | 'SquareMeter' | 'LitersPerSecond' | 'WattHour' | 'MilliWatt' | 'pH' | 'AmpereHour' | 'MilliAmpereHour' — DataStream units
      - object — Value of an integer column.
        - `type` 'integer', required — Value type discriminator.
        - `columnName` string, required — Name of the column this value belongs to.
        - `value` integer, required — The integer value.
        - `unit` 'None' | 'KilometerPerHour' | 'MillimeterPerHour' | 'InchesPerHour' | 'CubicMetresPerHour' | 'MilePerHour' | 'MilePerHour2' | 'GramPerSquareMeter' | 'MilliLitterPerSquareMeter' | 'LitterPerSquareMeter' | 'PoundPerSquareInch' | 'PoundPerSquareInch2' | 'PoundPerCubicYard' | 'OuncePerCubicYard' | 'PoundPerCubicFoot' | 'VolumeFlow' | 'CubicCentimetersPerMinute' | 'SignalStrength' | 'DegreeDays' | 'Millimeter' | 'Centimeter' | 'Meter' | 'Kilometer' | 'KiloBytes' | 'MegaBytes' | 'GigaBytes' | 'Feet' | 'SquareFeet' | 'Inch' | 'Foot' | 'Yard' | 'Mile' | 'Milligram' | 'Gram' | 'Kilogram' | 'Ton' | 'Liter' | 'Milliliter' | 'Ounce' | 'Pint' | 'Gallon' | 'Pound' | 'Stone' | 'Quarter' | 'Hundredweight' | 'Celsius' | 'Fahrenheit' | 'Kelvin' | 'Percentage' | 'Degrees' | 'RPM' | 'Step' | 'Year' | 'Month' | 'Week' | 'Day' | 'Hour' | 'Minute' | 'Second' | 'Volt' | 'Ampere' | 'MilliAmpere' | 'MicroAmpere' | 'Ohm' | 'Hertz' | 'Watts' | 'Farad' | 'Siemen' | 'Henry' | 'MicrogramPerCubicMeter' | 'PartsPerMillion' | 'PartsPerBillion' | 'KiloWatts' | 'HectoPascal' | 'Pascal' | 'Lux' | 'Pressure' | 'PressureInBars' | 'AirQualityIndex' | 'KiloWattHour' | 'MilliSecond' | 'MilliSec' | 'MeterPerSecond' | 'MilliGramPerCubicMeter' | 'KiloPascal' | 'CubicMeter' | 'CubicYard' | 'CubicFeetPerMinute' | 'SquareMeter' | 'LitersPerSecond' | 'WattHour' | 'MilliWatt' | 'pH' | 'AmpereHour' | 'MilliAmpereHour' — DataStream units
      - object — Value of a list column, holding an ordered collection of nested column values.
        - `type` 'list', required — Value type discriminator.
        - `columnName` string, required — Name of the column this value belongs to.
        - `value` CustomDataColumnValue[], required — The list items, each being a nested column value.
      - object — Represents an empty (unset) column value.
        - `type` 'null', required — Value type discriminator.
        - `columnName` string, required — Name of the column this value belongs to.
      - object — Value of a text column.
        - `type` 'text', required — Value type discriminator.
        - `columnName` string, required — Name of the column this value belongs to.
        - `value` string, nullable — The text value. May be `null` when the cell is empty.
      - object — Value of a column that references a device.
        - `type` 'device_reference', required — Value type discriminator.
        - `columnName` string, required — Name of the column this value belongs to.
        - `deviceId` integer, required — Identifier of the referenced device. May be `null` when no device is referenced.
        - `deviceOrgId` integer, nullable — Identifier of the organization the referenced device belongs to.
        - `deviceName` string, nullable — Name of the referenced device.
      - object — Value of an enum column.
        - `type` 'enum', required — Value type discriminator.
        - `columnName` string, required — Name of the column this value belongs to.
        - `value` integer, required — The numeric enum value, mapped to a display name in the column configuration.
        - `valueDisplayName` string, nullable — Human-readable display name mapped to the numeric value.
      - object — Computed value of a formula column.
        - `type` 'formula', required — Value type discriminator.
        - `columnName` string, required — Name of the column this value belongs to.
        - `value` number, double, required — The computed decimal value of the formula.
        - `decimalsFormat` 'NO_FRACTION' | 'FRACTION_1' | 'FRACTION_2' | 'FRACTION_3' | 'FRACTION_4' | 'FRACTION_5' | 'FILL_1' | 'FILL_2' | 'FILL_3' | 'FILL_4' | 'FILL_5' — Decimal format used for displaying a numeric value in the dashboard and reports.
        - `unit` 'None' | 'KilometerPerHour' | 'MillimeterPerHour' | 'InchesPerHour' | 'CubicMetresPerHour' | 'MilePerHour' | 'MilePerHour2' | 'GramPerSquareMeter' | 'MilliLitterPerSquareMeter' | 'LitterPerSquareMeter' | 'PoundPerSquareInch' | 'PoundPerSquareInch2' | 'PoundPerCubicYard' | 'OuncePerCubicYard' | 'PoundPerCubicFoot' | 'VolumeFlow' | 'CubicCentimetersPerMinute' | 'SignalStrength' | 'DegreeDays' | 'Millimeter' | 'Centimeter' | 'Meter' | 'Kilometer' | 'KiloBytes' | 'MegaBytes' | 'GigaBytes' | 'Feet' | 'SquareFeet' | 'Inch' | 'Foot' | 'Yard' | 'Mile' | 'Milligram' | 'Gram' | 'Kilogram' | 'Ton' | 'Liter' | 'Milliliter' | 'Ounce' | 'Pint' | 'Gallon' | 'Pound' | 'Stone' | 'Quarter' | 'Hundredweight' | 'Celsius' | 'Fahrenheit' | 'Kelvin' | 'Percentage' | 'Degrees' | 'RPM' | 'Step' | 'Year' | 'Month' | 'Week' | 'Day' | 'Hour' | 'Minute' | 'Second' | 'Volt' | 'Ampere' | 'MilliAmpere' | 'MicroAmpere' | 'Ohm' | 'Hertz' | 'Watts' | 'Farad' | 'Siemen' | 'Henry' | 'MicrogramPerCubicMeter' | 'PartsPerMillion' | 'PartsPerBillion' | 'KiloWatts' | 'HectoPascal' | 'Pascal' | 'Lux' | 'Pressure' | 'PressureInBars' | 'AirQualityIndex' | 'KiloWattHour' | 'MilliSecond' | 'MilliSec' | 'MeterPerSecond' | 'MilliGramPerCubicMeter' | 'KiloPascal' | 'CubicMeter' | 'CubicYard' | 'CubicFeetPerMinute' | 'SquareMeter' | 'LitersPerSecond' | 'WattHour' | 'MilliWatt' | 'pH' | 'AmpereHour' | 'MilliAmpereHour' — DataStream units
      - object — Value of a system column that stores when the row was created.
        - `type` 'created_at', required — Value type discriminator.
        - `columnName` string, required — Name of the column this value belongs to.
        - `value` integer, required — Timestamp (Unix epoch milliseconds) when the row was created.
      - object — Value of a system column that stores when the row was last modified.
        - `type` 'modified_at', required — Value type discriminator.
        - `columnName` string, required — Name of the column this value belongs to.
        - `value` integer, required — Timestamp (Unix epoch milliseconds) when the row was last modified.
      - object — Value of a system column that stores the user who created the row.
        - `type` 'created_by', required — Value type discriminator.
        - `columnName` string, required — Name of the column this value belongs to.
        - `userId` integer, required — Identifier of the user who created the row.
        - `userName` string, nullable — Name of the user who created the row.
        - `userEmail` string, nullable — Email of the user who created the row.
      - object — Value of a reference column that points to a row in another custom data table.
        - `type` 'reference', required — Value type discriminator.
        - `columnName` string, required — Name of the column this value belongs to.
        - `rowId` integer, required — Identifier of the referenced row. May be `null` when no row is referenced.
        - `row` CustomDataRow — recursive
        - `tableName` string, nullable, required — Name of the table the referenced row belongs to.
        - `displayColumn` string, nullable — Name of the column used to display the referenced row.
      - object — Value of a date column, represented as separate day, month and year fields.
        - `type` 'date', required — Value type discriminator.
        - `columnName` string, required — Name of the column this value belongs to.
        - `day` integer, required — Day of month (1-31).
        - `month` integer, required — Month of year (1-12).
        - `year` integer, required — Four-digit year.
      - object — Placeholder returned instead of the actual value when the authenticated user does not have access to the underlying data of the column.
        - `type` 'no_access', required — Value type discriminator.
        - `columnName` string, required — Name of the column this value belongs to.
      - object — Computed value of an aggregation column (e.g. sum, average over referenced rows).
        - `type` 'aggregation', required — Value type discriminator.
        - `columnName` string, required — Name of the column this value belongs to.
        - `value` number, double, required — The computed aggregated decimal value.
        - `decimalsFormat` 'NO_FRACTION' | 'FRACTION_1' | 'FRACTION_2' | 'FRACTION_3' | 'FRACTION_4' | 'FRACTION_5' | 'FILL_1' | 'FILL_2' | 'FILL_3' | 'FILL_4' | 'FILL_5' — Decimal format used for displaying a numeric value in the dashboard and reports.
        - `unit` 'None' | 'KilometerPerHour' | 'MillimeterPerHour' | 'InchesPerHour' | 'CubicMetresPerHour' | 'MilePerHour' | 'MilePerHour2' | 'GramPerSquareMeter' | 'MilliLitterPerSquareMeter' | 'LitterPerSquareMeter' | 'PoundPerSquareInch' | 'PoundPerSquareInch2' | 'PoundPerCubicYard' | 'OuncePerCubicYard' | 'PoundPerCubicFoot' | 'VolumeFlow' | 'CubicCentimetersPerMinute' | 'SignalStrength' | 'DegreeDays' | 'Millimeter' | 'Centimeter' | 'Meter' | 'Kilometer' | 'KiloBytes' | 'MegaBytes' | 'GigaBytes' | 'Feet' | 'SquareFeet' | 'Inch' | 'Foot' | 'Yard' | 'Mile' | 'Milligram' | 'Gram' | 'Kilogram' | 'Ton' | 'Liter' | 'Milliliter' | 'Ounce' | 'Pint' | 'Gallon' | 'Pound' | 'Stone' | 'Quarter' | 'Hundredweight' | 'Celsius' | 'Fahrenheit' | 'Kelvin' | 'Percentage' | 'Degrees' | 'RPM' | 'Step' | 'Year' | 'Month' | 'Week' | 'Day' | 'Hour' | 'Minute' | 'Second' | 'Volt' | 'Ampere' | 'MilliAmpere' | 'MicroAmpere' | 'Ohm' | 'Hertz' | 'Watts' | 'Farad' | 'Siemen' | 'Henry' | 'MicrogramPerCubicMeter' | 'PartsPerMillion' | 'PartsPerBillion' | 'KiloWatts' | 'HectoPascal' | 'Pascal' | 'Lux' | 'Pressure' | 'PressureInBars' | 'AirQualityIndex' | 'KiloWattHour' | 'MilliSecond' | 'MilliSec' | 'MeterPerSecond' | 'MilliGramPerCubicMeter' | 'KiloPascal' | 'CubicMeter' | 'CubicYard' | 'CubicFeetPerMinute' | 'SquareMeter' | 'LitersPerSecond' | 'WattHour' | 'MilliWatt' | 'pH' | 'AmpereHour' | 'MilliAmpereHour' — DataStream units
      - object — Value of a system column that stores the organization a row belongs to.
        - `type` 'row_organization', required — Value type discriminator.
        - `columnName` string, required — Name of the column this value belongs to.
        - `orgId` integer, required — Identifier of the organization the row belongs to.
        - `orgName` string, nullable — Name of the organization the row belongs to.
      - object — Value of a column that references a device data snapshot.
        - `type` 'device_data_snapshot_reference', required — Value type discriminator.
        - `columnName` string, required — Name of the column this value belongs to.
        - `snapshotId` integer, required — Identifier of the referenced snapshot.
        - `startedAt` integer, required — Timestamp (Unix epoch milliseconds) when the snapshot started.
        - `finishedAt` integer, required — Timestamp (Unix epoch milliseconds) when the snapshot finished.
        - `deviceId` integer, required — Identifier of the device the snapshot belongs to.
        - `deviceName` string, nullable — Name of the device the snapshot belongs to.
      - object — Value of a boolean column.
        - `type` 'boolean', required — Value type discriminator.
        - `columnName` string, required — Name of the column this value belongs to.
        - `value` boolean, required — The boolean value.
      - object — Value of a date-time column.
        - `type` 'date_time', required — Value type discriminator.
        - `columnName` string, required — Name of the column this value belongs to.
        - `value` integer, required — Timestamp (Unix epoch milliseconds).
  - `canEdit` boolean, required — Whether the authenticated user is allowed to edit this row.
  - `canDelete` boolean, required — Whether the authenticated user is allowed to delete this row.
  - `modifiedAt` integer, required — Timestamp (Unix epoch milliseconds) of the last row modification.

## Other responses

- `400` — Bad request
- `403` — Forbidden. The authenticated user has no access to the table or the row.
- `404` — Table or row not found.
- `429` — Too many requests
- `500` — Internal server error

---

[API](https://skmtc.dev/blynk/apis/blynk-platform-api.md) · [All operations](https://skmtc.dev/blynk/apis/blynk-platform-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/blynk/blynk-platform-api/revisions/d8640cc48a13/schema)