---
title: "Retrieve a table"
method: GET
path: "/commerce/{connection_id}/table/{id}"
tags: ["commerce", "table"]
---

# Retrieve a table

`GET /commerce/{connection_id}/table/{id}`

## Request

- Base URL: `https://api.unified.to`
- URL: `https://api.unified.to/commerce/{connection_id}/table/{id}`
- Auth: API key in header `authorization`
- TypeScript: <https://skmtc.dev/unified/apis/unified-to-api/docs/commerce/:connection_id/table/:id/get.ts> (a function with typed inputs; its response is checked against the schema)

Retrieves a single CommerceTable by its `id`. Obtain `id` values from the corresponding list endpoint. Use `fields` to return only the fields you need.

## Path parameters

- `connection_id` string, required
- `id` string, required

## Query parameters

- `fields` string[]
- `raw` string

## Response `200`

Successful

- CommerceTable
  - `id` string
  - `created_at` string, date-time: (ISO-8601 / YYYY-MM-DDTHH:MM:SSZ format)
  - `updated_at` string, date-time: (ISO-8601 / YYYY-MM-DDTHH:MM:SSZ format)
  - `name` string: display label of the table, e.g. "Table 1" or "Patio 4"
  - `number` string: human-facing table number shown on the POS (string, as some systems use alphanumeric labels)
  - `description` string
  - `is_active` boolean
  - `capacity` number: number of seats/guests the table is set up for
  - `location_id` string: reference to a commerce_location (the restaurant/site) (reference to CommerceLocation)
  - `floorplan_name` string: floorplan, section or dining area the table belongs to
  - `floorplan_identifier` string: the provider's identifier of that floorplan/section
  - `layout` PropertyCommerceTableLayout: position and shape of the table on its floorplan
    - `x` number: horizontal position on the floorplan, in the provider's floorplan units
    - `y` number: vertical position on the floorplan, in the provider's floorplan units
    - `width` number
    - `height` number
    - `rotation` number: degrees
    - `shape` 'ROUND' | 'SQUARE' | 'RECTANGLE' | 'OVAL' | 'OTHER'
  - `status` 'AVAILABLE' | 'OCCUPIED' | 'RESERVED' | 'INACTIVE' | 'OTHER': current occupancy
  - `guest_count` number: number of guests currently seated
  - `occupied_at` string, date-time: when the current party was seated (earliest open order) (ISO-8601 / YYYY-MM-DDTHH:MM:SSZ format)
  - `salesorder_ids` string[]: open orders/checks currently on the table; references accounting_salesorder
  - `metadata` CommerceMetadata[]
    - `id` string: The ID of the custom field definition (from the metadata/metadata endpoint).
    - `value` union: The field's value, typed by `format`: DATE as ISO-8601 (`YYYY-MM-DD`, or `YYYY-MM-DDTHH:MM:SSZ` for date-times); NUMBER, PRICE and CURRENCY as a number; BOOLEAN and YES_NO as true/false; MULTIPLE_SELECT as an array of option values; otherwise a string.
      - object
      - string
      - number
      - boolean
      - union[]
        - union
          - object
          - string
          - number
          - boolean
    - `namespace` string
    - `format` 'TEXT' | 'NUMBER' | 'DATE' | 'BOOLEAN' | 'FILE' | 'TEXTAREA' | 'SINGLE_SELECT' | 'MULTIPLE_SELECT' | 'MEASUREMENT' | 'PRICE' | 'YES_NO' | 'CURRENCY' | 'URL': The data type of the custom field, which determines how `value` is formatted.
    - `extra_data` union
      - object
      - string
      - number
      - boolean
      - union[]
        - union
          - object
          - string
          - number
          - boolean
    - `slug` string: The integration's API name (key) of an existing custom field. List valid slugs for this object with the metadata/metadata endpoint; unknown slugs are rejected by the integration.
    - `description` string
    - `is_required` boolean
  - `raw` object

## Changes

- **2026-11-07** `1425f51a6fa3`: 1 info
  - endpoint added

[Operation history](https://skmtc.dev/unified/apis/unified-to-api/changes/commerce/:connection_id/table/:id/get.md)

---

[API](https://skmtc.dev/unified/apis/unified-to-api.md) - [All operations](https://skmtc.dev/unified/apis/unified-to-api/llms.txt) - [OpenAPI document](https://skmtc.dev/unified/apis/unified-to-api/revisions/266f05d14af8?raw)