---
title: "Create a new transformation"
method: POST
path: "/organizations/{orgId}/integrationtransformations"
tags: ["IntegrationTransformations"]
---

# Create a new transformation

`POST /organizations/{orgId}/integrationtransformations`

## Request

- Base URL: `https://api.m3ter.com`
- URL: `https://api.m3ter.com/organizations/{orgId}/integrationtransformations`
- Auth: OAuth 2
  - Authorization code: `https://m3ter.auth.us-east-1.amazoncognito.com/oauth2/authorize`, token URL `https://m3ter.auth.us-east-1.amazoncognito.com/oauth2/token`
  - Client credentials, token URL `/oauth/token`
- TypeScript: <https://skmtc.dev/m3ter-com/apis/m3ter-api/docs/organizations/:orgId/integrationtransformations/post.ts> (a function with typed inputs; its response is checked against the schema)

Create a new transformation

## Path parameters

- `orgId` string, required

## Request body

- IntegrationTransformationRequest
  - `version` integer: The version number of the entity: - **Create entity:** Not valid for initial insertion of new entity - *do not use for Create*. On initial Create, version is set at 1 and listed in the response. - **Update Entity:** On Update, version is required and must match the existing version because a check is performed to ensure sequential versioning is preserved. Version is incremented by 1 and listed in the response.
  - `name` string, required
  - `description` string, required
  - `sourceSystem` string, required
  - `destinationSystem` string, required
  - `sourceTable` string, required
  - `destinationTable` string, required
  - `transformations` AbstractLookupRequest[], required
    - `destinationField` string, required
    - `type` 'CALCULATION' | 'STATIC' | 'LOOKUP', required

## Response `200`

Return the IntegrationTransformation

- IntegrationTransformationResponse: Response containing a IntegrationRun entity
  - `id` string, required: The UUID of the entity.
  - `version` integer: The version number: - **Create:** On initial Create to insert a new entity, the version is set at 1 in the response. - **Update:** On successful Update, the version is incremented by 1 in the response.
  - `dtCreated` string, date-time: The DateTime when this item was created *(in ISO-8601 format)*.
  - `dtLastModified` string, date-time: The DateTime when this item was last modified *(in ISO-8601 format)*.
  - `createdBy` string: The ID of the user who created this item.
  - `lastModifiedBy` string: The ID of the user who last modified this item.
  - `name` string
  - `description` string
  - `sourceSystem` string
  - `destinationSystem` string
  - `sourceTable` string
  - `destinationTable` string
  - `transformations` AbstractLookupResponse[]
    - `destinationField` string, required
    - `type` 'CALCULATION' | 'STATIC' | 'LOOKUP', required

## Other responses

- `4XX`: Error message
- `5XX`: Error message

## Changes

- **2026-10-16** `85c514abc692`: 1 info
  - endpoint added

[Operation history](https://skmtc.dev/m3ter-com/apis/m3ter-api/changes/organizations/:orgId/integrationtransformations/post.md)

---

[API](https://skmtc.dev/m3ter-com/apis/m3ter-api.md) - [All operations](https://skmtc.dev/m3ter-com/apis/m3ter-api/llms.txt) - [OpenAPI document](https://skmtc.dev/m3ter-com/apis/m3ter-api/revisions/85c514abc692?raw)