Factset · Capability

Factset OFDB API — Database

Factset OFDB API — Database. 30 operations. Lead operation: Database. Self-contained Naftiko capability covering one Factset business surface.

Run with Naftiko FactsetDatabase

What You Can Do

POST
Createdatabase — Creates a 2d or 3d database(OFDB). Users will note that not every field requires all the parameters listed in the schema. Please review FactSet data types on the OA for further guidance.
/v1/database
GET
Getresourcedatabase — Returns the end results of a long running request. The full URL is normally provided for you in the Location header of a finished long running response.
/v1/database/jobs/{id}
GET
Getstatus — Returns the current status of a long running request. The full URL is normally provided for you in the Location header of a long running response.
/v1/database/jobs/{id}/status
GET
Getdata — Returns the data in the database(OFDB, OMS_OFDB, ECONOFDB) for the mentioned Symbol or Date. Atleast one parameter(Symbol/Date) is required. For a range of dates symbol parameter is mandatory.
/v1/database/{path}
GET
Getaudit — Returns a list of the most recent "modificationTimes" in long datetime format
/v1/database/{path}/audit
GET
Getresourceaudit — Returns the end results of a long running request. The full URL is normally provided for you in the Location header of a finished long running response.
/v1/database/{path}/audit/jobs/{id}
GET
Getdates — Returns all the dates in the database(OFDB, OMS_OFDB, ECONOFDB)
/v1/database/{path}/dates
POST
Adddates — Creates a new date with single/multiple symbols for a 3d database(OFDB).
/v1/database/{path}/dates
PUT
Updatedates — Updates existing dates for single/multiple symbols or adds a new date/symbol within a date if not present in 3d database(OFDB).
/v1/database/{path}/dates
GET
Getresourcedates — Returns the end results of a long running request. The full URL is normally provided for you in the Location header of a finished long running response.
/v1/database/{path}/dates/jobs/{id}
PUT
Updatedate — Updates an existing date field value for single/multiple symbols or adds a new date/symbol within a date if not present in 3d database(OFDB).
/v1/database/{path}/dates/{date}
DELETE
Deletedate — Deletes all data specific to the date in 3d database(OFDB). This includes all the symbols related to that date
/v1/database/{path}/dates/{date}
GET
Getresourcedate — Returns the end results of a long running request. The full URL is normally provided for you in the Location header of a finished long running response.
/v1/database/{path}/dates/{date}/jobs/{id}
DELETE
Deletedatefromsymbol — Deletes data specific to the symbol and date from a 3d database(OFDB).
/v1/database/{path}/dates/{date}/symbols/{symbol}
DELETE
Getresourcedatefromsymbol — Deletes data specific to the symbol and date from a 3d database(OFDB).
/v1/database/{path}/dates/{date}/symbols/{symbol}/jobs/{id}
POST
Deletebulkitems — Allows users to delete various combinations of symbols, dates, and fields from the desired OFDB
/v1/database/{path}/delete
GET
Getresourcebulkdelete — Returns the end results of a long running request. The full URL is normally provided for you in the Location header of a finished long running response.
/v1/database/{path}/delete/jobs/{id}
GET
Getfields — Returns all the fields in the database(OFDB, OMS_OFDB, ECONOFDB)
/v1/database/{path}/fields
POST
Addfields — Allows users to add fields to existing OFDBs
/v1/database/{path}/fields
GET
Getresourcefields — Returns the end results of a long running request. The full URL is normally provided for you in the Location header of a finished long running response.
/v1/database/{path}/fields/jobs/{id}
GET
Getresourcedata — Returns the end results of a long running request. The full URL is normally provided for you in the Location header of a finished long running response.
/v1/database/{path}/jobs/{id}
GET
Getstats — Returns a summary of OFDB metadata and data points
/v1/database/{path}/stats
GET
Getresourcestats — Returns the end results of a long running request. The full URL is normally provided for you in the Location header of a finished long running response.
/v1/database/{path}/stats/jobs/{id}
GET
Getsymbols — Returns all the symbols in the database(OFDB, OMS_OFDB, ECONOFDB)
/v1/database/{path}/symbols
POST
Addsymbols — Creates a new symbol with single/multiple dates for 3d database(OFDB). Creates a symbol for 2d database(OFDB)
/v1/database/{path}/symbols
PUT
Updatesymbols — Updates existing symbols for single/multiple dates or adds a new symbol/date within a symbol if not present in 3d database(OFDB). Updates an existing symbol field value or adds a new symbol if not present in the 2d database(OFDB)
/v1/database/{path}/symbols
GET
Getresourcesymbols — Returns the end results of a long running request. The full URL is normally provided for you in the Location header of a finished long running response.
/v1/database/{path}/symbols/jobs/{id}
PUT
Updatesymbol — Updates an existing symbol field value for single/multiple dates or adds a new symbol/date within a symbol if not present in 3d database(OFDB). Updates an existing symbol field value or adds a new symbol if not present in the 2d database(OF
/v1/database/{path}/symbols/{symbol}
DELETE
Deletesymbol — Deletes all data specific to the symbol in both 2d and 3d database(OFDB). This includes all the dates related to that symbols in 3d database(OFDB)
/v1/database/{path}/symbols/{symbol}
GET
Getresourcesymbol — Returns the end results of a long running request. The full URL is normally provided for you in the Location header of a finished long running response.
/v1/database/{path}/symbols/{symbol}/jobs/{id}

MCP Tools

creates-2d-3d-database-ofdb-users

Creates a 2d or 3d database(OFDB). Users will note that not every field requires all the parameters listed in the schema. Please review FactSet data types on the OA for further guidance.

returns-end-results-long-running

Returns the end results of a long running request. The full URL is normally provided for you in the Location header of a finished long running response.

read-only idempotent
returns-current-status-long-running

Returns the current status of a long running request. The full URL is normally provided for you in the Location header of a long running response.

read-only idempotent
returns-data-database-ofdb-oms-ofdb

Returns the data in the database(OFDB, OMS_OFDB, ECONOFDB) for the mentioned Symbol or Date. Atleast one parameter(Symbol/Date) is required. For a range of dates symbol parameter is mandatory.

read-only idempotent
returns-list-most-recent-modificationtimes

Returns a list of the most recent "modificationTimes" in long datetime format

read-only idempotent
returns-end-results-long-running-2

Returns the end results of a long running request. The full URL is normally provided for you in the Location header of a finished long running response.

read-only idempotent
returns-all-dates-database-ofdb-oms

Returns all the dates in the database(OFDB, OMS_OFDB, ECONOFDB)

read-only idempotent
creates-new-date-single-multiple

Creates a new date with single/multiple symbols for a 3d database(OFDB).

updates-existing-dates-single-multiple

Updates existing dates for single/multiple symbols or adds a new date/symbol within a date if not present in 3d database(OFDB).

idempotent
returns-end-results-long-running-3

Returns the end results of a long running request. The full URL is normally provided for you in the Location header of a finished long running response.

read-only idempotent
updates-existing-date-field-value

Updates an existing date field value for single/multiple symbols or adds a new date/symbol within a date if not present in 3d database(OFDB).

idempotent
deletes-all-data-specific-date

Deletes all data specific to the date in 3d database(OFDB). This includes all the symbols related to that date

idempotent
returns-end-results-long-running-4

Returns the end results of a long running request. The full URL is normally provided for you in the Location header of a finished long running response.

read-only idempotent
deletes-data-specific-symbol-and

Deletes data specific to the symbol and date from a 3d database(OFDB).

idempotent
deletes-data-specific-symbol-and-2

Deletes data specific to the symbol and date from a 3d database(OFDB).

idempotent
allows-users-delete-various-combinations

Allows users to delete various combinations of symbols, dates, and fields from the desired OFDB

returns-end-results-long-running-5

Returns the end results of a long running request. The full URL is normally provided for you in the Location header of a finished long running response.

read-only idempotent
returns-all-fields-database-ofdb-oms

Returns all the fields in the database(OFDB, OMS_OFDB, ECONOFDB)

read-only idempotent
allows-users-add-fields-existing

Allows users to add fields to existing OFDBs

returns-end-results-long-running-6

Returns the end results of a long running request. The full URL is normally provided for you in the Location header of a finished long running response.

read-only idempotent
returns-end-results-long-running-7

Returns the end results of a long running request. The full URL is normally provided for you in the Location header of a finished long running response.

read-only idempotent
returns-summary-ofdb-metadata-and

Returns a summary of OFDB metadata and data points

read-only idempotent
returns-end-results-long-running-8

Returns the end results of a long running request. The full URL is normally provided for you in the Location header of a finished long running response.

read-only idempotent
returns-all-symbols-database-ofdb-oms

Returns all the symbols in the database(OFDB, OMS_OFDB, ECONOFDB)

read-only idempotent
creates-new-symbol-single-multiple

Creates a new symbol with single/multiple dates for 3d database(OFDB). Creates a symbol for 2d database(OFDB)

updates-existing-symbols-single-multiple

Updates existing symbols for single/multiple dates or adds a new symbol/date within a symbol if not present in 3d database(OFDB). Updates an existing symbol field value or adds a new symbol if not present in the 2d database(OFDB)

idempotent
returns-end-results-long-running-9

Returns the end results of a long running request. The full URL is normally provided for you in the Location header of a finished long running response.

read-only idempotent
updates-existing-symbol-field-value

Updates an existing symbol field value for single/multiple dates or adds a new symbol/date within a symbol if not present in 3d database(OFDB). Updates an existing symbol field value or adds a new symbol if not present in the 2d database(OF

idempotent
deletes-all-data-specific-symbol

Deletes all data specific to the symbol in both 2d and 3d database(OFDB). This includes all the dates related to that symbols in 3d database(OFDB)

idempotent
returns-end-results-long-running-10

Returns the end results of a long running request. The full URL is normally provided for you in the Location header of a finished long running response.

read-only idempotent

Capability Spec

ofdb-database.yaml Raw ↑
naftiko: 1.0.0-alpha2
info:
  label: Factset OFDB API — Database
  description: 'Factset OFDB API — Database. 30 operations. Lead operation: Database. Self-contained Naftiko capability covering
    one Factset business surface.'
  tags:
  - Factset
  - Database
  created: '2026-05-19'
  modified: '2026-05-19'
binds:
- namespace: env
  keys:
    FACTSET_API_KEY: FACTSET_API_KEY
capability:
  consumes:
  - type: http
    namespace: ofdb-database
    baseUri: https://api.factset.com/analytics/ofdb/v2
    description: Factset OFDB API — Database business capability. Self-contained, no shared references.
    resources:
    - name: database
      path: /database
      operations:
      - name: createdatabase
        method: POST
        description: Creates a 2d or 3d database(OFDB). Users will note that not every field requires all the parameters listed
          in the schema. Please review FactSet data types on the OA for further guidance.
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: body
          in: body
          type: object
          description: Request body (JSON).
          required: false
    - name: database-jobs-id
      path: /database/jobs/{id}
      operations:
      - name: getresourcedatabase
        method: GET
        description: Returns the end results of a long running request. The full URL is normally provided for you in the Location
          header of a finished long running response.
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: database-jobs-id-status
      path: /database/jobs/{id}/status
      operations:
      - name: getstatus
        method: GET
        description: Returns the current status of a long running request. The full URL is normally provided for you in the
          Location header of a long running response.
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: database-path
      path: /database/{path}
      operations:
      - name: getdata
        method: GET
        description: Returns the data in the database(OFDB, OMS_OFDB, ECONOFDB) for the mentioned Symbol or Date. Atleast
          one parameter(Symbol/Date) is required. For a range of dates symbol parameter is mandatory.
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: symbol
          in: query
          type: string
          description: Returns data for the symbol mentioned. e.g:sym1
        - name: date
          in: query
          type: string
          description: Return data for the specific date or range of dates mentioned.e.g:[date1,date2]
        - name: filterFields
          in: query
          type: string
          description: 'Can specify the fields on which you want to perform field filter operations e.g: ["PRICE","SECTOR"]'
        - name: filterOps
          in: query
          type: string
          description: 'Can specify the field filter operations which you want to perform e.g: ["LT", "GTEQ", "CT"]'
        - name: filterValues
          in: query
          type: string
          description: 'Can specify the field filter values of the field filter operations e.g: [100, 20, "AB"]'
        - name: filterDatesOps
          in: query
          type: string
          description: 'Can specify the date filter operations which you want to perform e.g: ["LT", "GTEQ"].'
        - name: filterDatesValues
          in: query
          type: string
          description: 'Can specify the date filter values of the date filter operations e.g: [20200505, 20200303]'
        - name: filterSymbolsOps
          in: query
          type: string
          description: 'Can specify the symbol filter operations which you want to perform e.g: ["CT", "SW"].'
        - name: filterSymbolsValues
          in: query
          type: string
          description: 'Can specify the symbol filter values of the date filter operations e.g: ["ab", "xy"]'
        - name: sortFieldName
          in: query
          type: string
          description: 'Can specify the name of field with respect to which user wants to sort data '
        - name: sortFieldOrder
          in: query
          type: string
          description: 'Can specify the order in which user wants to sort data with respect to sortFieldName query parameter '
    - name: database-path-audit
      path: /database/{path}/audit
      operations:
      - name: getaudit
        method: GET
        description: Returns a list of the most recent "modificationTimes" in long datetime format
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: database-path-audit-jobs-id
      path: /database/{path}/audit/jobs/{id}
      operations:
      - name: getresourceaudit
        method: GET
        description: Returns the end results of a long running request. The full URL is normally provided for you in the Location
          header of a finished long running response.
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: database-path-dates
      path: /database/{path}/dates
      operations:
      - name: getdates
        method: GET
        description: Returns all the dates in the database(OFDB, OMS_OFDB, ECONOFDB)
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: between
          in: query
          type: string
          description: Returns list of dates which are between [start,end], dates should be in the respective order of start
            and end
        - name: equals
          in: query
          type: string
          description: Returns the date which matches given date
        - name: before
          in: query
          type: string
          description: Returns list of dates which are before mentioned date
        - name: after
          in: query
          type: string
          description: Returns list of dates which are after mentioned date
        - name: orderBy
          in: query
          type: string
          description: Returns dates in the mentioned sorted order, should provide asc or desc
      - name: adddates
        method: POST
        description: Creates a new date with single/multiple symbols for a 3d database(OFDB).
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: body
          in: body
          type: object
          description: Request body (JSON).
          required: true
      - name: updatedates
        method: PUT
        description: Updates existing dates for single/multiple symbols or adds a new date/symbol within a date if not present
          in 3d database(OFDB).
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: body
          in: body
          type: object
          description: Request body (JSON).
          required: true
    - name: database-path-dates-jobs-id
      path: /database/{path}/dates/jobs/{id}
      operations:
      - name: getresourcedates
        method: GET
        description: Returns the end results of a long running request. The full URL is normally provided for you in the Location
          header of a finished long running response.
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: database-path-dates-date
      path: /database/{path}/dates/{date}
      operations:
      - name: updatedate
        method: PUT
        description: Updates an existing date field value for single/multiple symbols or adds a new date/symbol within a date
          if not present in 3d database(OFDB).
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: body
          in: body
          type: object
          description: Request body (JSON).
          required: true
      - name: deletedate
        method: DELETE
        description: Deletes all data specific to the date in 3d database(OFDB). This includes all the symbols related to
          that date
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: database-path-dates-date-jobs-id
      path: /database/{path}/dates/{date}/jobs/{id}
      operations:
      - name: getresourcedate
        method: GET
        description: Returns the end results of a long running request. The full URL is normally provided for you in the Location
          header of a finished long running response.
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: database-path-dates-date-symbols-symbol
      path: /database/{path}/dates/{date}/symbols/{symbol}
      operations:
      - name: deletedatefromsymbol
        method: DELETE
        description: Deletes data specific to the symbol and date from a 3d database(OFDB).
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: database-path-dates-date-symbols-symbol-jobs-id
      path: /database/{path}/dates/{date}/symbols/{symbol}/jobs/{id}
      operations:
      - name: getresourcedatefromsymbol
        method: DELETE
        description: Deletes data specific to the symbol and date from a 3d database(OFDB).
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: database-path-delete
      path: /database/{path}/delete
      operations:
      - name: deletebulkitems
        method: POST
        description: Allows users to delete various combinations of symbols, dates, and fields from the desired OFDB
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: body
          in: body
          type: object
          description: Request body (JSON).
          required: false
    - name: database-path-delete-jobs-id
      path: /database/{path}/delete/jobs/{id}
      operations:
      - name: getresourcebulkdelete
        method: GET
        description: Returns the end results of a long running request. The full URL is normally provided for you in the Location
          header of a finished long running response.
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: database-path-fields
      path: /database/{path}/fields
      operations:
      - name: getfields
        method: GET
        description: Returns all the fields in the database(OFDB, OMS_OFDB, ECONOFDB)
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
      - name: addfields
        method: POST
        description: Allows users to add fields to existing OFDBs
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: body
          in: body
          type: object
          description: Request body (JSON).
          required: true
    - name: database-path-fields-jobs-id
      path: /database/{path}/fields/jobs/{id}
      operations:
      - name: getresourcefields
        method: GET
        description: Returns the end results of a long running request. The full URL is normally provided for you in the Location
          header of a finished long running response.
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: database-path-jobs-id
      path: /database/{path}/jobs/{id}
      operations:
      - name: getresourcedata
        method: GET
        description: Returns the end results of a long running request. The full URL is normally provided for you in the Location
          header of a finished long running response.
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: database-path-stats
      path: /database/{path}/stats
      operations:
      - name: getstats
        method: GET
        description: Returns a summary of OFDB metadata and data points
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: database-path-stats-jobs-id
      path: /database/{path}/stats/jobs/{id}
      operations:
      - name: getresourcestats
        method: GET
        description: Returns the end results of a long running request. The full URL is normally provided for you in the Location
          header of a finished long running response.
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: database-path-symbols
      path: /database/{path}/symbols
      operations:
      - name: getsymbols
        method: GET
        description: Returns all the symbols in the database(OFDB, OMS_OFDB, ECONOFDB)
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: startsWith
          in: query
          type: string
          description: Returns list of symbols which starts with mentioned string
        - name: endsWith
          in: query
          type: string
          description: Returns list of symbols which ends with mentioned string
        - name: contains
          in: query
          type: string
          description: Returns list of symbols which contains mentioned string
        - name: equals
          in: query
          type: string
          description: Returns symbol which matches mentioned string
        - name: orderBy
          in: query
          type: string
          description: Returns symbols in the mentioned sorted order, should provide asc or desc
      - name: addsymbols
        method: POST
        description: Creates a new symbol with single/multiple dates for 3d database(OFDB). Creates a symbol for 2d database(OFDB)
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: body
          in: body
          type: object
          description: Request body (JSON).
          required: true
      - name: updatesymbols
        method: PUT
        description: Updates existing symbols for single/multiple dates or adds a new symbol/date within a symbol if not present
          in 3d database(OFDB). Updates an existing symbol field value or adds a new symbol if not present in the 2d database(OFDB)
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: body
          in: body
          type: object
          description: Request body (JSON).
          required: true
    - name: database-path-symbols-jobs-id
      path: /database/{path}/symbols/jobs/{id}
      operations:
      - name: getresourcesymbols
        method: GET
        description: Returns the end results of a long running request. The full URL is normally provided for you in the Location
          header of a finished long running response.
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: database-path-symbols-symbol
      path: /database/{path}/symbols/{symbol}
      operations:
      - name: updatesymbol
        method: PUT
        description: Updates an existing symbol field value for single/multiple dates or adds a new symbol/date within a symbol
          if not present in 3d database(OFDB). Updates an existing symbol field value or adds a new symbol if not present
          in the 2d database(OF
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: body
          in: body
          type: object
          description: Request body (JSON).
          required: true
      - name: deletesymbol
        method: DELETE
        description: Deletes all data specific to the symbol in both 2d and 3d database(OFDB). This includes all the dates
          related to that symbols in 3d database(OFDB)
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: database-path-symbols-symbol-jobs-id
      path: /database/{path}/symbols/{symbol}/jobs/{id}
      operations:
      - name: getresourcesymbol
        method: GET
        description: Returns the end results of a long running request. The full URL is normally provided for you in the Location
          header of a finished long running response.
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    authentication:
      type: bearer
      token: '{{env.FACTSET_API_KEY}}'
  exposes:
  - type: rest
    namespace: ofdb-database-rest
    port: 8080
    description: REST adapter for Factset OFDB API — Database. One Spectral-compliant resource per consumed operation, prefixed
      with /v1.
    resources:
    - path: /v1/database
      name: database
      description: REST surface for database.
      operations:
      - method: POST
        name: createdatabase
        description: Creates a 2d or 3d database(OFDB). Users will note that not every field requires all the parameters listed
          in the schema. Please review FactSet data types on the OA for further guidance.
        call: ofdb-database.createdatabase
        with:
          body: rest.body
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/jobs/{id}
      name: database-jobs-id
      description: REST surface for database-jobs-id.
      operations:
      - method: GET
        name: getresourcedatabase
        description: Returns the end results of a long running request. The full URL is normally provided for you in the Location
          header of a finished long running response.
        call: ofdb-database.getresourcedatabase
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/jobs/{id}/status
      name: database-jobs-id-status
      description: REST surface for database-jobs-id-status.
      operations:
      - method: GET
        name: getstatus
        description: Returns the current status of a long running request. The full URL is normally provided for you in the
          Location header of a long running response.
        call: ofdb-database.getstatus
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/{path}
      name: database-path
      description: REST surface for database-path.
      operations:
      - method: GET
        name: getdata
        description: Returns the data in the database(OFDB, OMS_OFDB, ECONOFDB) for the mentioned Symbol or Date. Atleast
          one parameter(Symbol/Date) is required. For a range of dates symbol parameter is mandatory.
        call: ofdb-database.getdata
        with:
          symbol: rest.symbol
          date: rest.date
          filterFields: rest.filterFields
          filterOps: rest.filterOps
          filterValues: rest.filterValues
          filterDatesOps: rest.filterDatesOps
          filterDatesValues: rest.filterDatesValues
          filterSymbolsOps: rest.filterSymbolsOps
          filterSymbolsValues: rest.filterSymbolsValues
          sortFieldName: rest.sortFieldName
          sortFieldOrder: rest.sortFieldOrder
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/{path}/audit
      name: database-path-audit
      description: REST surface for database-path-audit.
      operations:
      - method: GET
        name: getaudit
        description: Returns a list of the most recent "modificationTimes" in long datetime format
        call: ofdb-database.getaudit
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/{path}/audit/jobs/{id}
      name: database-path-audit-jobs-id
      description: REST surface for database-path-audit-jobs-id.
      operations:
      - method: GET
        name: getresourceaudit
        description: Returns the end results of a long running request. The full URL is normally provided for you in the Location
          header of a finished long running response.
        call: ofdb-database.getresourceaudit
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/{path}/dates
      name: database-path-dates
      description: REST surface for database-path-dates.
      operations:
      - method: GET
        name: getdates
        description: Returns all the dates in the database(OFDB, OMS_OFDB, ECONOFDB)
        call: ofdb-database.getdates
        with:
          between: rest.between
          equals: rest.equals
          before: rest.before
          after: rest.after
          orderBy: rest.orderBy
        outputParameters:
        - type: object
          mapping: $.
      - method: POST
        name: adddates
        description: Creates a new date with single/multiple symbols for a 3d database(OFDB).
        call: ofdb-database.adddates
        with:
          body: rest.body
        outputParameters:
        - type: object
          mapping: $.
      - method: PUT
        name: updatedates
        description: Updates existing dates for single/multiple symbols or adds a new date/symbol within a date if not present
          in 3d database(OFDB).
        call: ofdb-database.updatedates
        with:
          body: rest.body
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/{path}/dates/jobs/{id}
      name: database-path-dates-jobs-id
      description: REST surface for database-path-dates-jobs-id.
      operations:
      - method: GET
        name: getresourcedates
        description: Returns the end results of a long running request. The full URL is normally provided for you in the Location
          header of a finished long running response.
        call: ofdb-database.getresourcedates
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/{path}/dates/{date}
      name: database-path-dates-date
      description: REST surface for database-path-dates-date.
      operations:
      - method: PUT
        name: updatedate
        description: Updates an existing date field value for single/multiple symbols or adds a new date/symbol within a date
          if not present in 3d database(OFDB).
        call: ofdb-database.updatedate
        with:
          body: rest.body
        outputParameters:
        - type: object
          mapping: $.
      - method: DELETE
        name: deletedate
        description: Deletes all data specific to the date in 3d database(OFDB). This includes all the symbols related to
          that date
        call: ofdb-database.deletedate
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/{path}/dates/{date}/jobs/{id}
      name: database-path-dates-date-jobs-id
      description: REST surface for database-path-dates-date-jobs-id.
      operations:
      - method: GET
        name: getresourcedate
        description: Returns the end results of a long running request. The full URL is normally provided for you in the Location
          header of a finished long running response.
        call: ofdb-database.getresourcedate
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/{path}/dates/{date}/symbols/{symbol}
      name: database-path-dates-date-symbols-symbol
      description: REST surface for database-path-dates-date-symbols-symbol.
      operations:
      - method: DELETE
        name: deletedatefromsymbol
        description: Deletes data specific to the symbol and date from a 3d database(OFDB).
        call: ofdb-database.deletedatefromsymbol
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/{path}/dates/{date}/symbols/{symbol}/jobs/{id}
      name: database-path-dates-date-symbols-symbol-jobs-id
      description: REST surface for database-path-dates-date-symbols-symbol-jobs-id.
      operations:
      - method: DELETE
        name: getresourcedatefromsymbol
        description: Deletes data specific to the symbol and date from a 3d database(OFDB).
        call: ofdb-database.getresourcedatefromsymbol
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/{path}/delete
      name: database-path-delete
      description: REST surface for database-path-delete.
      operations:
      - method: POST
        name: deletebulkitems
        description: Allows users to delete various combinations of symbols, dates, and fields from the desired OFDB
        call: ofdb-database.deletebulkitems
        with:
          body: rest.body
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/{path}/delete/jobs/{id}
      name: database-path-delete-jobs-id
      description: REST surface for database-path-delete-jobs-id.
      operations:
      - method: GET
        name: getresourcebulkdelete
        description: Returns the end results of a long running request. The full URL is normally provided for you in the Location
          header of a finished long running response.
        call: ofdb-database.getresourcebulkdelete
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/{path}/fields
      name: database-path-fields
      description: REST surface for database-path-fields.
      operations:
      - method: GET
        name: getfields
        description: Returns all the fields in the database(OFDB, OMS_OFDB, ECONOFDB)
        call: ofdb-database.getfields
        outputParameters:
        - type: object
          mapping: $.
      - method: POST
        name: addfields
        description: Allows users to add fields to existing OFDBs
        call: ofdb-database.addfields
        with:
          body: rest.body
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/{path}/fields/jobs/{id}
      name: database-path-fields-jobs-id
      description: REST surface for database-path-fields-jobs-id.
      operations:
      - method: GET
        name: getresourcefields
        description: Returns the end results of a long running request. The full URL is normally provided for you in the Location
          header of a finished long running response.
        call: ofdb-database.getresourcefields
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/{path}/jobs/{id}
      name: database-path-jobs-id
      description: REST surface for database-path-jobs-id.
      operations:
      - method: GET
        name: getresourcedata
        description: Returns the end results of a long running request. The full URL is normally provided for you in the Location
          header of a finished long running response.
        call: ofdb-database.getresourcedata
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/{path}/stats
      name: database-path-stats
      description: REST surface for database-path-stats.
      operations:
      - method: GET
        name: getstats
        description: Returns a summary of OFDB metadata and data points
        call: ofdb-database.getstats
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/{path}/stats/jobs/{id}
      name: database-path-stats-jobs-id
      description: REST surface for database-path-stats-jobs-id.
      operations:
      - method: GET
        name: getresourcestats
        description: Returns the end results of a long running request. The full URL is normally provided for you in the Location
          header of a finished long running response.
        call: ofdb-database.getresourcestats
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/{path}/symbols
      name: database-path-symbols
      description: REST surface for database-path-symbols.
      operations:
      - method: GET
        name: getsymbols
        description: Returns all the symbols in the database(OFDB, OMS_OFDB, ECONOFDB)
        call: ofdb-database.getsymbols
        with:
          startsWith: rest.startsWith
          endsWith: rest.endsWith
          contains: rest.contains
          equals: rest.equals
          orderBy: rest.orderBy
        outputParameters:
        - type: object
          mapping: $.
      - method: POST
        name: addsymbols
        description: Creates a new symbol with single/multiple dates for 3d database(OFDB). Creates a symbol for 2d database(OFDB)
        call: ofdb-database.addsymbols
        with:
          body: rest.body
        outputParameters:
        - type: object
          mapping: $.
      - method: PUT
        name: updatesymbols
        description: Updates existing symbols for single/multiple dates or adds a new symbol/date within a symbol if not present
          in 3d database(OFDB). Updates an existing symbol field value or adds a new symbol if not present in the 2d database(OFDB)
        call: ofdb-database.updatesymbols
        with:
          body: rest.body
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/{path}/symbols/jobs/{id}
      name: database-path-symbols-jobs-id
      description: REST surface for database-path-symbols-jobs-id.
      operations:
      - method: GET
        name: getresourcesymbols
        description: Returns the end results of a long running request. The full URL is normally provided for you in the Location
          header of a finished long running response.
        call: ofdb-database.getresourcesymbols
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/{path}/symbols/{symbol}
      name: database-path-symbols-symbol
      description: REST surface for database-path-symbols-symbol.
      operations:
      - method: PUT
        name: updatesymbol
        description: Updates an existing symbol field value for single/multiple dates or adds a new symbol/date within a symbol
          if not present in 3d database(OFDB). Updates an existing symbol field value or adds a new symbol if not present
          in the 2d database(OF
        call: ofdb-database.updatesymbol
        with:
          body: rest.body
        outputParameters:
        - type: object
          mapping: $.
      - method: DELETE
        name: deletesymbol
        description: Deletes all data specific to the symbol in both 2d and 3d database(OFDB). This includes all the dates
          related to that symbols in 3d database(OFDB)
        call: ofdb-database.deletesymbol
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/database/{path}/symbols/{symbol}/jobs/{id}
      name: database-path-symbols-symbol-jobs-id
      description: REST surface for database-path-symbols-symbol-jobs-id.
      operations:
      - method: GET
        name: getresourcesymbol
        description: Returns the end results of a long running request. The full URL is normally provided for you in the Location
          header of a finished long running response.
        call: ofdb-database.getresourcesymbol
        outputParameters:
        - type: object
          mapping: $.
  - type: mcp
    namespace: ofdb-database-mcp
    port: 9090
    transport: http
    description: MCP adapter for Factset OFDB API — Database. One tool per consumed operation, routed inline through this
      capability's consumes block

# --- truncated at 32 KB (44 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/factset/refs/heads/main/capabilities/ofdb-database.yaml