Somerville 311 Service Requests logo

Somerville 311 Service Requests

Overview

This is a public Socrata Open Data API endpoint — no authentication is required to read data.

Setup guide

Optional: Get an app token for higher limits

To raise throttling limits, you can register for a free Socrata app token:

  1. Visit https://data.somervillema.gov/profile/app_tokens
  2. Sign in or create a free account
  3. Register a new app token
  4. Copy the token that is generated

If you provide an app token, it is sent as the X-App-Token header. This is optional — basic ingestion works without a token.

Add it to Ingest

In the Ingest UI under Connectors → Somerville 311 Service Requests, you can leave the credential blank (no authentication required). If you have an optional app token, paste it in the provided field.

Mind the limits

The connector is configured to make up to 2 requests per second. HTTP 429, 500, 502, 503, and 504 responses are retried automatically. The API uses SoQL query parameters ($limit, $offset, $where, $order, $select) to filter and page through the dataset.

Supported streams

1 endpoint are available out of the box. Each endpoint syncs into its own Iceberg table in Snowflake.

EndpointDescriptionReference
list_service_requests
list_service_requests
–

Authentication

Auth type
None

Performance & limits

Rate limit
2 requests per second (unauthenticated)
Automatic backoff
Ingest throttles requests to the published rate limit and retries with exponential backoff on transient errors. You don't need to handle 429s, retries, or pagination yourself.

Resources