Socrata Public Data

Connects to Socrata portals to access, search, and retrieve public datasets from various government and organizational sources.

Custom Streaming + One-shot

Fetch records from a Socrata/SODA dataset.

What you can ask Delphi

“Which Socrata datasets are available for city crime statistics in New York?”
“Retrieve the latest 100 records from the Chicago building permits dataset.”
“What are the average daily temperature readings from the San Francisco open weather data for the last month?”
“Can I set up a recurring feed to monitor new restaurant inspection scores from the Boston Socrata portal?”

Authentication ▾

Ingestion ▾

Mode: Streaming + One-shot

Tools exposed (3) ▾

socrata/get_records

Fetch records from a Socrata/SODA dataset.

socrata/search_datasets

Search Socrata portals for public datasets before creating a connector.

schedule_socrata_records

Create or update a recurring Socrata public-data connector.

Inputs ▾

Name	Type	Required	Description
dashboardId	string	no	Target dashboard/initiative ID. Omit to use the current dashboard.
domain	string	yes	Socrata portal domain, e.g. data.cdc.gov.
datasetId	string	yes	Dataset identifier, e.g. swc5-untb.
soql	string	no	Optional SoQL query string. Example: select countyname,data_value where stateabbr='NY'.
limit	number	no	Max rows to fetch. Default 100.
offset	number	no	Offset for one-shot pagination. Default 0.
rowIdentifierField	string	no	Field path to a stable unique identifier for deduplication and deduplication keys.
description	string	no	Human-readable description shown in the connector UI.
filter_paths	string[]	no	Optional glob paths to reduce the response.

Name	Type	Required	Description
query	string	yes	Dataset search query.
domains	string[]	no	Optional portal domains to scope the search, e.g. ['data.cdc.gov'].
limit	number	no	Maximum number of results to return. Default 10.
offset	number	no	Pagination offset. Default 0.
filter_paths	string[]	no	Optional glob paths to reduce the response.

Name	Type	Required	Description
dashboardId	string	no	Target dashboard/initiative ID. Omit to use the current dashboard.
domain	string	yes	Socrata portal domain, e.g. data.cdc.gov.
datasetId	string	yes	Dataset identifier, e.g. swc5-untb.
soql	string	no	Optional SoQL query string. Example: select countyname,data_value where stateabbr='NY'.
limit	number	no	Max rows to fetch. Default 100.
offset	number	no	Offset for one-shot pagination. Default 0.
rowIdentifierField	string	no	Field path to a stable unique identifier for deduplication and deduplication keys.
description	string	no	Human-readable description shown in the connector UI.
filter_paths	string[]	no	Optional glob paths to reduce the response.
polling_frequency	string	yes	How often to poll the dataset.
connectorId	string	no	If provided, updates the existing connector.