Socrata
Query, upsert, replace, delete, and poll rows in Socrata open-data portal datasets through SODA/SoQL.
Tools
| Name | Description |
|---|---|
query_rowsQuery a Socrata dataset with SODA/SoQL select, where, order, limit, offset, and full-text parameters. | Query a Socrata dataset with SODA/SoQL select, where, order, limit, offset, and full-text parameters. |
get_recordGet one Socrata row by row identifier. | Get one Socrata row by row identifier. |
upsert_rowsCreate or update rows in a Socrata dataset by posting an array of row objects. | Create or update rows in a Socrata dataset by posting an array of row objects. |
replace_recordReplace one Socrata row by row identifier. | Replace one Socrata row by row identifier. |
delete_recordDelete one Socrata row by row identifier. | Delete one Socrata row by row identifier. |
Triggers
| Name | Description |
|---|---|
changed_rowsPoll a Socrata dataset for rows whose :updated_at system field is newer than the last poll. | Poll a Socrata dataset for rows whose :updated_at system field is newer than the last poll. |
Quick Start
import { WeavzClient } from '@weavz-io/sdk'
const weavz = new WeavzClient({ apiKey: 'wvz_...' })
const result = await weavz.actions.execute('socrata', 'query_rows', {
workspaceId: '550e8400-e29b-41d4-a716-446655440000',
integrationAlias: 'socrata',
input: { /* ... */ },
})Related Integrations
Frequently Asked Questions
How do I connect Socrata to my app?
Use Weavz Hosted Connect for Custom authentication. Install the SDK, create a connection through the connect portal or API, then execute tools programmatically.
What tools does Socrata support?
Socrata supports 5 tools including Query Rows, Get Record, Upsert Rows, Replace Record, Delete Record.
Can I use Socrata with AI agents?
Yes. Add Socrata to an MCP server in Tool Mode or Code Mode. Code Mode provides 3 meta-tools with on-demand API discovery so agents can compose stateful workflows without loading every action schema up front.
Can Socrata be used in stateful agent workflows?
Yes. Agents can combine Socrata tools with Filesystem, State KV, Human Gates, input partials, and other workspace integrations while keeping execution scoped to the selected workspace or end user.
What authentication does Socrata use?
Socrata uses Custom. Weavz stores credentials securely and uses them for authorized action execution.
How much does the Socrata integration cost?
The Socrata integration is included on all Weavz plans including the free tier with 20,000 actions per month. No credit card required.
What triggers does Socrata support?
Socrata supports 1 triggers including Changed Rows.
Connect Socrata in minutes
Get 20,000 free action executions every month. No credit card required.