mammoth-io Publish to DB API
The Publish to DB API from mammoth-io — 1 operation(s) for publish to db.
The Publish to DB API from mammoth-io — 1 operation(s) for publish to db.
Every API here is available over the APIs.io API and to AI agents over MCP.
One button, every client — Claude, Cursor, VS Code and the rest.
https://apis.io/mcp
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.curl "https://apis.io/api/v1/apis/mammoth-io:mammoth-io-publish-to-db-api"
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.
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. By signing up you are subscribing to the APIs.io and API Evangelist newsletters — you can unsubscribe from any issue. See our Privacy Policy and Terms.
A second provider on the same verified email joins the account you already have.
openapi: 3.2.0
info:
title: Mammoth Io Publish to DB API
version: 0.1.0
contact:
name: Mammoth Analytics
url: https://mammoth.io
email: support@mammoth.io
description: 'Operations tagged Publish to DB across 2 of this provider''s published API definitions: app.mammoth.io-openapi.json, mammoth-io-openapi.json. Each path carries the servers of the definition it was published in.'
servers:
- url: /api/v2
security:
- bearerAuth: []
- apiKey: []
apiSecret: []
workspaceId: []
tags:
- name: Publish to DB
paths:
/workspaces/{workspace_id}/projects/{project_id}/datasets/{dataset_id}/dataviews/{dataview_id}/publish-to-db:
post:
tags:
- Publish to DB
summary: Publish view to external database
description: Publish view to external database with given data
operationId: CreatePublishToDb
parameters:
- name: workspace_id
in: path
schema:
type: integer
minimum: 1.0
title: Workspace ID
description: Workspace refers to a collection of projects. Workspace ID is unique identifier for workspace.
examples:
- 4
description: Workspace refers to a collection of projects. Workspace ID is unique identifier for workspace.
required: true
deprecated: false
examples:
workspace_id-example-1:
summary: Sample workspace ID
value: 4
- name: project_id
in: path
schema:
type: integer
minimum: 1.0
title: Project ID
description: Project ID of the workspace
examples:
- 4
description: Project ID of the workspace
required: true
deprecated: false
examples:
project_id-example-1:
summary: Sample project ID
value: 4
- name: dataset_id
in: path
schema:
type: integer
minimum: 0.0
title: Dataset ID
description: Id of the dataset
examples:
- 121
description: Id of the dataset
required: true
deprecated: false
examples:
dataset_id-example-1:
summary: Sample dataset ID
value: 121
- name: dataview_id
in: path
schema:
type: integer
minimum: 1.0
title: Dataview ID
description: Dataview ID of the dataset
examples:
- 4
description: Dataview ID of the dataset
required: true
deprecated: false
examples:
dataview_id-example-1:
summary: Sample dataview ID
value: 4
requestBody:
content:
application/json:
schema:
$ref: '#/components/schemas/PublishDataSchema'
required: true
responses:
'202':
description: Publish to DB request accepted
content:
application/json:
schema:
$ref: '#/components/schemas/ObjectJobSchema'
'400':
description: Bad Request
'403':
description: Request forbidden -- authorization will not help
content:
application/json:
schema:
properties:
status_code:
type: integer
detail:
type: string
extra:
additionalProperties: {}
type:
- 'null'
- object
- array
type: object
required:
- detail
- status_code
description: Authorization Exception
examples:
- status_code: 403
detail: Forbidden
extra: {}
'401':
description: Authorization error
deprecated: false
patch:
tags:
- Publish to DB
summary: Update Publish to DB credentials
description: Update Publish to DB credentials data
operationId: UpdatePublishToDb
parameters:
- name: workspace_id
in: path
schema:
type: integer
minimum: 1.0
title: Workspace ID
description: Workspace refers to a collection of projects. Workspace ID is unique identifier for workspace.
examples:
- 4
description: Workspace refers to a collection of projects. Workspace ID is unique identifier for workspace.
required: true
deprecated: false
examples:
workspace_id-example-1:
summary: Sample workspace ID
value: 4
- name: project_id
in: path
schema:
type: integer
minimum: 1.0
title: Project ID
description: Project ID of the workspace
examples:
- 4
description: Project ID of the workspace
required: true
deprecated: false
examples:
project_id-example-1:
summary: Sample project ID
value: 4
- name: dataset_id
in: path
schema:
type: integer
minimum: 0.0
title: Dataset ID
description: Id of the dataset
examples:
- 121
description: Id of the dataset
required: true
deprecated: false
examples:
dataset_id-example-1:
summary: Sample dataset ID
value: 121
- name: dataview_id
in: path
schema:
type: integer
minimum: 1.0
title: Dataview ID
description: Dataview ID of the dataset
examples:
- 4
description: Dataview ID of the dataset
required: true
deprecated: false
examples:
dataview_id-example-1:
summary: Sample dataview ID
value: 4
requestBody:
content:
application/json:
schema:
$ref: '#/components/schemas/PublishToDBPatchRequest'
required: true
responses:
'202':
description: Publish to DB request accepted
content:
application/json:
schema:
$ref: '#/components/schemas/ObjectJobSchema'
'400':
description: Bad Request
'403':
description: Request forbidden -- authorization will not help
content:
application/json:
schema:
properties:
status_code:
type: integer
detail:
type: string
extra:
additionalProperties: {}
type:
- 'null'
- object
- array
type: object
required:
- detail
- status_code
description: Authorization Exception
examples:
- status_code: 403
detail: Forbidden
extra: {}
'401':
description: Authorization error
deprecated: false
servers:
- url: /api/v2
components:
schemas:
OdbcTypes:
type: string
enum:
- postgres
- bigquery
minLength: 1
title: OdbcTypes
description: ODBC Type for the connection
examples:
- summary: Sample ODBC Type
value: postgres
PatchPath:
type: string
enum:
- credentials
title: PatchPath
description: Path
examples:
- value: credentials
ObjectJobSchema:
properties:
status_code:
oneOf:
- type: integer
- type: 'null'
title: Status code
examples:
- value:
status_code: 200
job_id:
oneOf:
- type: integer
- type: 'null'
title: Job id
description: Created job id
failure_reason:
oneOf:
- type: string
- type: 'null'
title: Failure reason
description: Failure reason if status is failure
examples:
- value:
failure_reason: Some reason
type: object
required: []
title: ObjectJobSchema
PublishDataSchema:
properties:
odbc_type:
$ref: '#/components/schemas/OdbcTypes'
target_properties:
$ref: '#/components/schemas/TriggerPropertiesSchema'
type: object
required:
- odbc_type
- target_properties
title: PublishDataSchema
description: Publish detail which needs to be created
examples:
- odbc_type: postgres
target_properties:
table: Transaction_view_1
PublishToDBPatchOp:
properties:
op:
$ref: '#/components/schemas/publish_const_PatchOps'
path:
$ref: '#/components/schemas/PatchPath'
value:
additionalProperties:
$ref: '#/components/schemas/OdbcTypes'
type: object
description: Patch value
examples:
- value:
odbc_type: postgres
type: object
required:
- op
- path
- value
title: PublishToDBPatchOp
publish_const_PatchOps:
type: string
enum:
- replace
title: PatchOps
description: Operation
examples:
- value: replace
PublishToDBPatchRequest:
properties:
patch:
items:
$ref: '#/components/schemas/PublishToDBPatchOp'
type: array
description: List of patch operations
examples:
- value:
- op: replace
path: credentials
value:
odbc_type: postgres
type: object
required:
- patch
title: PublishToDBPatchRequest
description: Subscription detail which needs to be updated
examples:
- patch:
- op: replace
path: credentials
value:
odbc_type: postgres
TriggerPropertiesSchema:
properties:
table:
type: string
minLength: 1
title: Table
description: Table for the connection
examples:
- summary: Sample Table
value: Transactions_view_1
type: object
required:
- table
title: TriggerPropertiesSchema
description: Target properties for the connection
examples:
- summary: Sample Target Properties
value:
table: Transactions_view_2
securitySchemes:
bearerAuth:
type: http
description: 'Primary credential. Authorization: Bearer mm_<token>. The token is issued server-side and shown once at creation.'
scheme: bearer
apiKey:
type: apiKey
description: Deprecated — use bearerAuth.
name: X-API-KEY
in: header
apiSecret:
type: apiKey
description: Deprecated — use bearerAuth.
name: X-API-SECRET
in: header
workspaceId:
type: apiKey
description: Required with X-API-KEY and X-API-SECRET. Deprecated with them — use bearerAuth.
name: X-WORKSPACE-ID
in: header
x-refined-from:
- app.mammoth.io-openapi.json
- mammoth-io-openapi.json