Socrata Open Data
Fetch records from a Socrata/SODA dataset.
Custom Streaming + One-shot
Fetch records from a Socrata/SODA dataset.
Technical details
Authentication ▾
Contact us for setup details.
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.
upsert_bento_get_socrata_records
Create or update a recurring Socrata public-data connector.
Inputs ▾
socrata/get_records
| 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 Firestore document IDs. |
| description | string | no | Human-readable description shown in the connector UI. |
| filter_paths | string[] | no | Optional glob paths to reduce the response. |
socrata/search_datasets
| 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. |
upsert_bento_get_socrata_records
| 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 Firestore document IDs. |
| 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. |