Fetch a single row by `:id`

Single row fetch from /resource/{dataset_id}.json?:id={row_id}. Uses the Socrata :id system column, which is present on every dataset. For datasets that expose a natural primary key (e.g. unique_key on NYC 311), query via the /rows/{dataset_id} endpoint with a $where filter instead.

portalstring required

Portal slug (e.g. nyc).

dataset_idstring required

Socrata 4-4 hex dataset identifier.

row_idstring required

Row identifier from the upstream :id system column.

Response

Single row keyed by SoQL field names.

Example response

{
  "data": {
    "portal": "nyc",
    "domain": "data.cityofnewyork.us",
    "dataset_id": "erm2-nwe9"
  },
  "meta": {
    "endpoint": "/api/v1/fred/us/cpi",
    "data_time": "2026-04-16T14:30:00Z",
    "response_time": "2026-04-16T14:30:12Z",
    "provider": "Sugra API v1.0.1",
    "source": "sugra_crypto",
    "attribution": "Short interest and Reg SHO daily short volume data is owned by and sourced from FINRA (Financial Industry Regulatory Authority).",
    "fallback_chain": [
      "sugra_crypto",
      "sugra_finance"
    ]
  }
}

v5

Fetch a single row by `:id`

Path parameters

Response

Example response