SoQL row query

GET

/api/v1/socrata/{portal}/rows/{dataset_id}

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

Maintainer:Not configured

OperationId:socrata_portal_rows_dataset_id

Row-level query on a dataset via /resource/{dataset_id}.json. Each supported SoQL parameter maps to a $-prefixed query string arg upstream: $select, $where, $order, $limit, $offset, $q, $group, $having. Column names with spaces or special characters should be wrapped in backticks in SoQL expressions. SoQL string literals use single quotes; escape internal apostrophes by doubling ('O''Brien'). Upstream caps $limit at 50,000 rows per call; Sugra enforces the same bound and defaults to 1,000.

Request

Authorization

API Key

Add parameter in header

x-api-key

Example:

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

Path Params

Query Params

Header Params

Request Code Samples

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

curl --location '/api/v1/socrata/nyc/rows/erm2-nwe9?select=created_date%2C%20complaint_type&where=&order=created_date%20DESC&limit=100&offset=0&q=&group=&having=' \
--header 'x-api-key: <api-key>'

Responses

🟢200

application/json

Row list for the SoQL query, with echoed paging parameters.

Bodyapplication/json

Example

{
    "data": {
        "portal": "nyc",
        "domain": "data.cityofnewyork.us",
        "dataset_id": "erm2-nwe9",
        "count": 0,
        "limit": 0,
        "offset": 0,
        "rows": [
            {
                "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 view metadata

Cross-portal federated catalog search