Fetch a single row by `:id`

GET

/api/v1/socrata/{portal}/row/{dataset_id}/{row_id}

Last modified:2026-05-10 09:22:39

Maintainer:Not configured

OperationId:socrata_portal_row_dataset_id_row_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.

Request

Authorization

API Key

Add parameter in header

x-api-key

Example:

x-api-key: ********************

Path Params

Header Params

Request Code Samples

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

Responses

🟢200

application/json

Single row keyed by SoQL field names.

Bodyapplication/json

Example

{
    "data": {
        "portal": "nyc",
        "domain": "data.cityofnewyork.us",
        "dataset_id": "erm2-nwe9",
        "row_id": "string",
        "row": {
            "property1": "string",
            "property2": "string"
        }
    },
    "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": "string",
        "fallback_used": true,
        "fallback_chain": [
            "string"
        ],
        "cached": true
    }
}

🟠401

🟠422

🟠429

🔴503

Modified at 2026-05-10 09:22:39

Dataset column schema

Catalog of 30 available World Bank macro indicators