---
title: "Creates or updates a DB2API creator (promotion)"
method: POST
path: "/apiops/projects/{projectName}/db2apis/{db2ApiName}/"
tags: ["DB2API"]
---

# Creates or updates a DB2API creator (promotion)

`POST /apiops/projects/{projectName}/db2apis/{db2ApiName}/`

## Request

- Base URL: `http://167.86.118.166:32080`
- URL: `http://167.86.118.166:32080/apiops/projects/{projectName}/db2apis/{db2ApiName}/`
- Auth: none declared
- TypeScript: <https://skmtc.dev/apinizer/apis/apinizer-management-apis/docs/apiops/projects/:projectName/db2apis/:db2ApiName/post.ts> (a function with typed inputs; its response is checked against the schema)

Creates or updates a DB2API (DbToApi) creator for promotion purposes.

## Path parameters

- `projectName` string, required
- `db2ApiName` string, required

## Request body

- DbToApi
  - `id` string
  - `name` string
  - `description` string
  - `projectId` string
  - `methodDefList` DbToApiMethod[]
    - `id` string
    - `name` string
    - `description` string
    - `httpMethod` 'GET' | 'POST' | 'PUT' | 'HEAD' | 'OPTIONS' | 'DELETE' | 'PATCH' | 'TRACE' | 'ALL' | 'QUERY'
    - `sqlStatement` string
    - `connectionPoolDefId` string
    - `parameterList` DatabaseParameter[]
      - `name` string
      - `description` string
      - `dataType` 'STRING' | 'CLOB' | 'BOOLEAN' | 'INTEGER' | 'LONG' | 'DOUBLE' | 'DATE' | 'DATETIME' | 'REF_CURSOR'
      - `format` string
      - `paramType` 'BODY' | 'PATH' | 'QUERY' | 'HEADER' | 'FORMDATA'
      - `repetitionType` 'SINGLE' | 'MULTIPLE'
      - `paramDirection` 'OUT' | 'IN'
      - `booleanValue` boolean
      - `dateValue` string
      - `doubleValue` number, double
      - `longValue` integer
      - `intValue` integer
      - `stringValue` string
      - `clobValue` string
      - `indexList` integer[]
    - `reqIgnoreNull` boolean
    - `reqIgnoreEmpty` boolean
    - `reqNumbersAsStrings` boolean
    - `queryTimeout` integer
    - `exampleResponse` string
    - `parsed` boolean
    - `operationType` 'SELECT' | 'UPDATE' | 'INSERT' | 'DELETE' | 'PROCEDURE' | 'TRUNCATE' | 'BATCH_INSERT'
    - `databaseType` 'ORACLE' | 'MYSQL' | 'POSTGRES' | 'SQL_SERVER' | 'SYBASE' | 'DB2' | 'APACHE_HIVE' | 'APACHE_IMPALA' | 'MONGODB' | 'TRINO'
    - `environmentSettingsId` string

## Response `200`

successful operation!

- ApiOpsResponseSuccess
  - `status` 'SUCCESS' | 'FAILURE'
  - `resultMessage` string
  - `resultList` string[]
  - `resultCount` integer
  - `deploymentResult` DeploymentResult
    - `envName` string
    - `podName` string
    - `podIp` string
    - `success` boolean
    - `detail` string
    - `responseTime` integer
    - `detailList` unknown[]
      - unknown
    - `firstFromApiResultList` unknown
  - `unresolvedReferences` string[]
  - `advisories` ApiOpsAdvisoryDTO[]
    - `level` string
    - `key` string
    - `params` object

## Other responses

- `401`: not authorized for this operation!
- `500`: internal error!

## Changes

- **2026-08-11** `9ae232e55479`: 1 info
  - endpoint added

[Operation history](https://skmtc.dev/apinizer/apis/apinizer-management-apis/changes/apiops/projects/:projectName/db2apis/:db2ApiName/post.md)

---

[API](https://skmtc.dev/apinizer/apis/apinizer-management-apis.md) - [All operations](https://skmtc.dev/apinizer/apis/apinizer-management-apis/llms.txt) - [OpenAPI document](https://skmtc.dev/apinizer/apis/apinizer-management-apis/revisions/e083046b24cd?raw)