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.

All 92 tools →

Call it yourself

curl for this page

This API

curl "https://apis.io/api/v1/apis/mammoth-io:mammoth-io-publish-to-db-api"

All apis

curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

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.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

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