DBT Capital

DBT Capital Files API

File operations

GitHub OpenAPI

Operations 5

POST /files/excel/presign Generate an Excel file from a given set of columns and rows #
POST /files/excel/file Generate an Excel file from a given set of columns and rows #
POST /files Prepare upload #
POST /files/{id}/content Put file contents for upload #
GET /files/{id} Get metadata for a file #

Specifications

⚙
OpenAPI
https://artifacts.apis.io/dbt-se/openapi/dbt-se-files-api-openapi.yml

Schemas & Data

📊
JSONSchema
https://artifacts.apis.io/dbt-se/json-schema/dbt-se-health-checks-resolved-status-response-body-schema.json
📊
JSONSchema
https://artifacts.apis.io/dbt-se/json-schema/dbt-se-collateral-valuation-response-body-schema.json
📊
JSONSchema
https://artifacts.apis.io/dbt-se/json-schema/dbt-se-portfolio-organization-schema.json
📊
JSONSchema
https://artifacts.apis.io/dbt-se/json-schema/dbt-se-base-summation-account-plan-adjustment-request-body-schema.json
📊
JSONSchema
https://artifacts.apis.io/dbt-se/json-schema/dbt-se-organization-schema.json
📊
JSONSchema
https://artifacts.apis.io/dbt-se/json-schema/dbt-se-get-lgdpotential-response-body-schema.json

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.
All 92 tools →

Call it yourself

curl for this page
This API 
curl "https://apis.io/api/v1/apis/dbt-se:dbt-se-files-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.

GitHub Google LinkedIn

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

OpenAPI Specification

dbt-se-files-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  title: DBT Capital Files API
  version: 1.0.0
  description: File operations
servers:
- url: https://api.p.dbt.se
  description: Current environment
tags:
- name: Files
  description: File operations
paths:
  /files/excel/presign:
    post:
      tags:
      - Files
      summary: Generate an Excel file from a given set of columns and rows
      x-source-file: js/node/hono/api/src/files/routers/excel.ts
      security:
      - JWT Bearer: []
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/GetExcelRequestBody'
      responses:
        '200':
          description: Presigned URL to the Excel file
          content:
            application/json:
              schema:
                type: object
                properties:
                  url:
                    type: string
                    format: uri
                required:
                - url
        '400':
          description: Client error!
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/GetExcelErrorBody'
        '404':
          description: Not found
      operationId: postFilesExcelPresign
      x-operation-id-source: derived
  /files/excel/file:
    post:
      tags:
      - Files
      summary: Generate an Excel file from a given set of columns and rows
      x-source-file: js/node/hono/api/src/files/routers/excel.ts
      security:
      - JWT Bearer: []
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/GetExcelRequestBody'
      responses:
        '200':
          description: The Excel file
          content:
            application/vnd.openxmlformats-officedocument.spreadsheetml.sheet:
              schema:
                $ref: '#/components/schemas/ExcelFile'
        '400':
          description: Client error!
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/GetExcelErrorBody'
        '404':
          description: Not found
      operationId: postFilesExcelFile
      x-operation-id-source: derived
  /files:
    post:
      tags:
      - Files
      summary: Prepare upload
      x-source-file: js/node/hono/api/src/files/routers/index.ts
      security:
      - JWT Bearer: []
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/PutUploadRequestBody'
      responses:
        '200':
          description: Upload
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/UploadResponseBody'
        '403':
          description: Forbidden
          content:
            application/json:
              schema:
                type: object
                properties:
                  code:
                    type: string
                    enum:
                    - forbidden
                  message:
                    type: string
                required:
                - code
                - message
        '404':
          description: Not found
      operationId: postFiles
      x-operation-id-source: derived
  /files/{id}/content:
    post:
      tags:
      - Files
      summary: Put file contents for upload
      x-source-file: js/node/hono/api/src/files/routers/index.ts
      security:
      - JWT Bearer: []
      parameters:
      - schema:
          type: string
          description: ID of the upload
        required: true
        description: ID of the upload
        name: id
        in: path
      - schema:
          type: string
        required: true
        name: content-length
        in: header
      requestBody:
        content:
          application/octet-stream:
            schema:
              type: string
              format: binary
      responses:
        '200':
          description: Upload
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/UploadResponseBody'
        '400':
          description: Client error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/PutContentErrorResponseBody'
        '404':
          description: Not found
      operationId: postFilesByIdContent
      x-operation-id-source: derived
  /files/{id}:
    get:
      tags:
      - Files
      summary: Get metadata for a file
      x-source-file: js/node/hono/api/src/files/routers/index.ts
      security:
      - JWT Bearer: []
      parameters:
      - schema:
          type: string
          description: ID of the upload
        required: true
        description: ID of the upload
        name: id
        in: path
      responses:
        '200':
          description: Upload
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/UploadResponseBody'
        '404':
          description: Client error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/GetUploadErrorResponseBody'
      operationId: getFilesById
      x-operation-id-source: derived
components:
  schemas:
    PutUploadRequestBody:
      type: object
      properties:
        name:
          type: string
        size:
          type: integer
          minimum: 0
        contentType:
          type: string
        tags:
          type: array
          items:
            type: string
      required:
      - name
      - size
      - contentType
    PutContentErrorResponseBody:
      type: object
      properties:
        code:
          type: string
          enum:
          - fileNotFound
          - contentLengthHeaderMismatch
          - missingContentLengthHeader
          - fileIdNotFound
          - alreadyUpdated
        message:
          type: string
      required:
      - code
      - message
    UploadedByResponseBody:
      oneOf:
      - type: object
        properties:
          type:
            type: string
            enum:
            - system
          value:
            type: 'null'
        required:
        - type
        - value
      - type: object
        properties:
          type:
            type: string
            enum:
            - ssn
          value:
            type: string
          physicalPersonId:
            type: string
            format: uuid
        required:
        - type
        - value
        - physicalPersonId
      - type: object
        properties:
          type:
            type: string
            enum:
            - dbt-staff-member-id
          value:
            type: string
        required:
        - type
        - value
      - type: object
        properties:
          type:
            type: string
            enum:
            - consent
          value:
            type: string
        required:
        - type
        - value
    GetExcelErrorBody:
      type: object
      properties:
        code:
          type: string
          enum:
          - column_misconfigured
          - row_formats_misconfigured
        message:
          type: string
      required:
      - code
      - message
    UploadResponseBody:
      oneOf:
      - type: object
        properties:
          id:
            type: string
          name:
            type: string
          size:
            type: integer
            minimum: 0
          contentType:
            type: string
          tags:
            type: array
            items:
              type: string
          uploadedBy:
            $ref: '#/components/schemas/UploadedByResponseBody'
          uploaded:
            type: boolean
            enum:
            - true
          md5Hash:
            type: string
        required:
        - id
        - name
        - size
        - contentType
        - uploadedBy
        - uploaded
        - md5Hash
      - type: object
        properties:
          id:
            type: string
          name:
            type: string
          size:
            type: integer
            minimum: 0
          contentType:
            type: string
          tags:
            type: array
            items:
              type: string
          uploadedBy:
            $ref: '#/components/schemas/UploadedByResponseBody'
          uploaded:
            type: boolean
            enum:
            - false
        required:
        - id
        - name
        - size
        - contentType
        - uploadedBy
        - uploaded
    GetUploadErrorResponseBody:
      type: object
      properties:
        code:
          type: string
          enum:
          - fileNotFound
        message:
          type: string
      required:
      - code
      - message
    ExcelFile:
      type: string
      format: binary
    GetExcelRequestBody:
      type: object
      properties:
        columns:
          type: array
          items:
            type: string
        rows:
          type: array
          items:
            type: array
            items:
              anyOf:
              - type: object
                properties:
                  dateString:
                    type: string
                  day:
                    type: number
                  monthIndex:
                    type: number
                  timeZone:
                    type: string
                  type:
                    type: string
                    enum:
                    - date
                  year:
                    type: number
                required:
                - dateString
                - day
                - monthIndex
                - timeZone
                - type
                - year
              - type: object
                properties:
                  format:
                    type: object
                    properties:
                      maximumFractionDigits:
                        type: number
                        minimum: 0
                      minimumFractionDigits:
                        type: number
                        minimum: 0
                  number:
                    type: number
                  type:
                    type: string
                    enum:
                    - number
                required:
                - number
                - type
              - type: object
                properties:
                  string:
                    type: string
                  type:
                    type: string
                    enum:
                    - string
                required:
                - string
                - type
              - type: object
                properties:
                  amount:
                    type: string
                  currency:
                    type: string
                  format:
                    type: object
                    properties:
                      notation:
                        type: string
                        enum:
                        - scientific
                        - engineering
                        - compact
                      roundingPriority:
                        type: string
                        enum:
                        - morePrecision
                        - lessPrecision
                  numericAmount:
                    type: number
                  type:
                    type: string
                    enum:
                    - currency
                required:
                - amount
                - currency
                - numericAmount
                - type
              - type: object
                properties:
                  format:
                    type: object
                    properties:
                      maximumFractionDigits:
                        type: number
                        minimum: 0
                      maximumIntegerDigits:
                        type: number
                        minimum: 0
                      minimumFractionDigits:
                        type: number
                        minimum: 0
                      minimumIntegerDigits:
                        type: number
                        minimum: 0
                  percentageAsFraction:
                    type: number
                  type:
                    type: string
                    enum:
                    - percent
                required:
                - percentageAsFraction
                - type
              - type: string
              - type: number
              - type: 'null'
        rowFormats:
          type: array
          items:
            type: object
            properties:
              fill:
                type:
                - string
                - 'null'
                enum:
                - positive
                - negative
                - null
              outlineLevel:
                type: integer
                minimum: 0
                maximum: 7
            required:
            - fill
            - outlineLevel
      required:
      - columns
      - rows
  securitySchemes:
    JWT_Bearer:
      bearerFormat: JWT
      handlers:
      - null
      - null
      scheme: bearer
      type: http
    Cookie:
      handlers:
      - null
      - null
      name: .dbt.accessToken
      scheme: cookie
      type: http