Actions39
- Datastore Create
- Datastore Search
- Datastore Upsert
- Group Activity List
- Group Create
- Group Delete
- Group Member Create
- Group Member Delete
- Group Package Show
- Group Patch
- Group Purge
- Group Show
- Group Update
- Organization Create
- Organization Delete
- Organization List
- Organization Member Create
- Organization Member Delete
- Organization Patch
- Organization Purge
- Organization Show
- Organization Update
- Package Activity List
- Package Create
- Package Delete
- Package List
- Package Patch
- Package Search
- Package Show
- Package Update
- Recently Changed Packages Activity List
- Resource Create
- Resource Patch
- Resource Search
- Resource Show
- Resource Update
- Status Show
- Tag List
- User List
Datastore Upsert
AI-generatedSummary
Insert or update rows in an existing CKAN DataStore table. Choose how duplicate or missing rows are handled, and optionally allow writes to active resources or run the request without committing changes.
Inputs
- CKAN URL (required) — URL of the CKAN instance, such as https://demo.ckan.org.
- Resource Id (required) — Unique ID of the DataStore resource to write to.
- Records (required) — JSON array of row objects to write, for example [{"id":1,"temperature":21.3}].
- Upsert Method — Conflict strategy: insert fails on duplicates, update fails when a row is missing, and upsert inserts or updates. Defaults to upsert.
- Force — Defaults to false. Set true to allow writing to an active, non-draft resource.
- Dry Run — Defaults to false. When enabled, CKAN validates and executes the operation, then rolls back without committing changes.
Output shape
One CKAN response item per input item, containing success and data fields.
The data field contains CKAN's result for the upsert request. Requires CKAN API credentials with a token. If Continue On Fail is enabled, failed inputs produce an error field instead.