ctlsurf Datastore API
The datastore API from ctlsurf — 7 operation(s) for datastore.
Work with this as data
Every API here is available over the APIs.io API and to AI agents over MCP.
MCP server
One button, every client — Claude, Cursor, VS Code and the rest.
https://apis.io/mcp
Tools for apis
7 MCP tools reach this
find_apisBrowse and filter every API in the catalog.get_api_artifactsOne API's artifacts, grouped by type.get_openapiThe primary OpenAPI for this API.find_similar_apisAPIs that look like this one.apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.resolveTurn a domain, URL or GitHub org into the provider it belongs to.find_cohortsEvery scored population of providers in the catalog.
Call it yourself
curl for this page
This API
curl "https://apis.io/api/v1/apis/ctlsurf-com:ctlsurf-com-datastore-api"
All apis
curl "https://apis.io/api/v1/apis?limit=25"Calls without X-API-Key need no key. Calls with it need a paid plan — get a key.
Get an API key
Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.
A second provider on the same verified email joins the account you already have.
OpenAPI Specification
openapi: 3.2.0
info:
title: Ctlsurf Com Datastore API
version: 0.1.0
description: 'Operations tagged datastore across 2 of this provider''s published API definitions: ctlsurf-com-openapi.json, ctlsurf-com-openapi.yml. Each path carries the servers of the definition it was published in.'
servers:
- url: https://app.ctlsurf.com
description: ctlsurf application host (documented MCP endpoint https://app.ctlsurf.com/api/mcp; spec served at /openapi.json)
tags:
- name: Datastore
paths:
/api/datastore/{block_id}/schema:
get:
tags:
- Datastore
summary: Get Schema
description: Get the column schema for a datastore block.
operationId: get_schema_api_datastore__block_id__schema_get
security:
- HTTPBearer: []
parameters:
- name: block_id
in: path
required: true
schema:
type: string
format: uuid
title: Block Id
responses:
'200':
description: Successful Response
content:
application/json:
schema: {}
'422':
description: Validation Error
content:
application/json:
schema:
$ref: '#/components/schemas/HTTPValidationError'
put:
tags:
- Datastore
summary: Update Schema
description: Update the column schema for a datastore block.
operationId: update_schema_api_datastore__block_id__schema_put
security:
- HTTPBearer: []
parameters:
- name: block_id
in: path
required: true
schema:
type: string
format: uuid
title: Block Id
requestBody:
required: true
content:
application/json:
schema:
type: object
additionalProperties: true
title: Body
responses:
'200':
description: Successful Response
content:
application/json:
schema: {}
'422':
description: Validation Error
content:
application/json:
schema:
$ref: '#/components/schemas/HTTPValidationError'
/api/datastore/{block_id}/rows:
post:
tags:
- Datastore
summary: Add Row
description: Add a row to a datastore block.
operationId: add_row_api_datastore__block_id__rows_post
security:
- HTTPBearer: []
parameters:
- name: block_id
in: path
required: true
schema:
type: string
format: uuid
title: Block Id
requestBody:
required: true
content:
application/json:
schema:
type: object
additionalProperties: true
title: Body
responses:
'200':
description: Successful Response
content:
application/json:
schema: {}
'422':
description: Validation Error
content:
application/json:
schema:
$ref: '#/components/schemas/HTTPValidationError'
get:
tags:
- Datastore
summary: Query Rows
description: Query rows from a datastore block with optional filtering, sorting, and pagination.
operationId: query_rows_api_datastore__block_id__rows_get
security:
- HTTPBearer: []
parameters:
- name: block_id
in: path
required: true
schema:
type: string
format: uuid
title: Block Id
- name: where
in: query
required: false
schema:
anyOf:
- type: string
- type: 'null'
description: 'JSON-encoded filter object, e.g. {"Status": "scouted"} or {"Score": {"$gt": 50}}'
title: Where
description: 'JSON-encoded filter object, e.g. {"Status": "scouted"} or {"Score": {"$gt": 50}}'
- name: order_by
in: query
required: false
schema:
anyOf:
- type: string
- type: 'null'
description: Column name to sort by
title: Order By
description: Column name to sort by
- name: order
in: query
required: false
schema:
anyOf:
- type: string
- type: 'null'
description: 'Sort direction: asc or desc'
default: asc
title: Order
description: 'Sort direction: asc or desc'
- name: limit
in: query
required: false
schema:
type: integer
maximum: 1000
minimum: 1
default: 100
title: Limit
- name: offset
in: query
required: false
schema:
type: integer
minimum: 0
default: 0
title: Offset
- name: select
in: query
required: false
schema:
anyOf:
- type: string
- type: 'null'
description: Comma-separated column names to return
title: Select
description: Comma-separated column names to return
responses:
'200':
description: Successful Response
content:
application/json:
schema: {}
'422':
description: Validation Error
content:
application/json:
schema:
$ref: '#/components/schemas/HTTPValidationError'
patch:
tags:
- Datastore
summary: Update Rows
description: 'Bulk-update rows matching a filter. Body: {where: {...}, data: {Column: value, ...}}.
Only the provided fields are merged into each matched row (like update_row). An empty/omitted
`where` matches all rows in the datastore.'
operationId: update_rows_api_datastore__block_id__rows_patch
security:
- HTTPBearer: []
parameters:
- name: block_id
in: path
required: true
schema:
type: string
format: uuid
title: Block Id
requestBody:
required: true
content:
application/json:
schema:
type: object
additionalProperties: true
title: Body
responses:
'200':
description: Successful Response
content:
application/json:
schema: {}
'422':
description: Validation Error
content:
application/json:
schema:
$ref: '#/components/schemas/HTTPValidationError'
/api/datastore/{block_id}/rows/{row_id}:
put:
tags:
- Datastore
summary: Update Row
description: Update a row in a datastore block. Merges provided data with existing.
operationId: update_row_api_datastore__block_id__rows__row_id__put
security:
- HTTPBearer: []
parameters:
- name: block_id
in: path
required: true
schema:
type: string
format: uuid
title: Block Id
- name: row_id
in: path
required: true
schema:
type: string
format: uuid
title: Row Id
requestBody:
required: true
content:
application/json:
schema:
type: object
additionalProperties: true
title: Body
responses:
'200':
description: Successful Response
content:
application/json:
schema: {}
'422':
description: Validation Error
content:
application/json:
schema:
$ref: '#/components/schemas/HTTPValidationError'
delete:
tags:
- Datastore
summary: Delete Row
description: Delete a row from a datastore block.
operationId: delete_row_api_datastore__block_id__rows__row_id__delete
security:
- HTTPBearer: []
parameters:
- name: block_id
in: path
required: true
schema:
type: string
format: uuid
title: Block Id
- name: row_id
in: path
required: true
schema:
type: string
format: uuid
title: Row Id
responses:
'200':
description: Successful Response
content:
application/json:
schema: {}
'422':
description: Validation Error
content:
application/json:
schema:
$ref: '#/components/schemas/HTTPValidationError'
/api/datastore/{block_id}/export:
get:
tags:
- Datastore
summary: Export Rows
description: Every matching row as an Excel workbook, CSV, or tab-separated text (for pasting into Excel).
operationId: export_rows_api_datastore__block_id__export_get
security:
- HTTPBearer: []
parameters:
- name: block_id
in: path
required: true
schema:
type: string
format: uuid
title: Block Id
- name: format
in: query
required: false
schema:
type: string
pattern: ^(xlsx|csv|tsv)$
default: xlsx
title: Format
- name: where
in: query
required: false
schema:
anyOf:
- type: string
- type: 'null'
description: Same JSON filter as GET /rows
title: Where
description: Same JSON filter as GET /rows
- name: order_by
in: query
required: false
schema:
anyOf:
- type: string
- type: 'null'
title: Order By
- name: order
in: query
required: false
schema:
anyOf:
- type: string
- type: 'null'
default: asc
title: Order
responses:
'200':
description: Successful Response
content:
application/json:
schema: {}
'422':
description: Validation Error
content:
application/json:
schema:
$ref: '#/components/schemas/HTTPValidationError'
/api/datastore/{block_id}/ingest-url:
post:
tags:
- Datastore
summary: Create Ingest Url
description: 'Mint a short-lived signed token for a bulk-ingest operation on this datastore.
The caller embeds the token in the ingest URL and curls row data directly to
POST /datastore/ingest, avoiding the token cost of sending rows through MCP.'
operationId: create_ingest_url_api_datastore__block_id__ingest_url_post
security:
- HTTPBearer: []
parameters:
- name: block_id
in: path
required: true
schema:
type: string
format: uuid
title: Block Id
requestBody:
required: true
content:
application/json:
schema:
type: object
additionalProperties: true
title: Body
responses:
'200':
description: Successful Response
content:
application/json:
schema: {}
'422':
description: Validation Error
content:
application/json:
schema:
$ref: '#/components/schemas/HTTPValidationError'
/api/datastore/ingest:
post:
tags:
- Datastore
summary: Ingest
description: 'Bulk-ingest rows via a signed token (see POST /{block_id}/ingest-url).
Body is NDJSON (one JSON object per line) or a JSON array; the operation mode
(insert/upsert/replace/delete) is fixed by the token. For delete, the body is a list of
row ids (or key-column values when the token carries a key_column).
Returns {inserted, updated, deleted, errors:[{line, reason}]}.'
operationId: ingest_api_datastore_ingest_post
security:
- HTTPBearer: []
parameters:
- name: t
in: query
required: false
schema:
anyOf:
- type: string
- type: 'null'
description: Signed datastore ingest token (alternative to Authorization header)
title: T
description: Signed datastore ingest token (alternative to Authorization header)
responses:
'200':
description: Successful Response
content:
application/json:
schema: {}
'422':
description: Validation Error
content:
application/json:
schema:
$ref: '#/components/schemas/HTTPValidationError'
/api/datastore/{block_id}/rows/delete:
post:
tags:
- Datastore
summary: Delete Rows
description: 'Bulk-delete rows by filter or explicit ids. Body: {where: {...}} or {row_ids: [...]}.
Requires one of `where` or `row_ids` (no empty-body "delete everything" footgun).'
operationId: delete_rows_api_datastore__block_id__rows_delete_post
security:
- HTTPBearer: []
parameters:
- name: block_id
in: path
required: true
schema:
type: string
format: uuid
title: Block Id
requestBody:
required: true
content:
application/json:
schema:
type: object
additionalProperties: true
title: Body
responses:
'200':
description: Successful Response
content:
application/json:
schema: {}
'422':
description: Validation Error
content:
application/json:
schema:
$ref: '#/components/schemas/HTTPValidationError'
components:
schemas:
ValidationError:
properties:
loc:
items:
anyOf:
- type: string
- type: integer
type: array
title: Location
msg:
type: string
title: Message
type:
type: string
title: Error Type
type: object
required:
- loc
- msg
- type
title: ValidationError
HTTPValidationError:
properties:
detail:
items:
$ref: '#/components/schemas/ValidationError'
type: array
title: Detail
type: object
title: HTTPValidationError
securitySchemes:
HTTPBearer:
type: http
scheme: bearer
x-refined-from:
- ctlsurf-com-openapi.json
- ctlsurf-com-openapi.yml