M3m3ter-com
IntegrationTransformations

Create a new transformation

Changed on

Create a new transformation

post/organizations/{orgId}/integrationtransformations

Request

Path parameters

orgIdstring required

UUID of the organization

Request body

versioninteger

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.
namestring required
descriptionstring required
sourceSystemstring required
destinationSystemstring required
sourceTablestring required
destinationTablestring required

Example request

{
  "name": "m3ter Bill to Netsuite Invoice",
  "description": "Transforms a m3ter Bill into a Netsuite Invoice",
  "sourceSystem": "m3ter",
  "destinationSystem": "Netsuite",
  "sourceTable": "Bill",
  "destinationTable": "customrecord_invoice",
  "transformations": [
    {
      "destinationField": "m3terId",
      "type": "LOOKUP",
      "sourceField": "id"
    }
  ]
}

Response

Return the IntegrationTransformation

idstring required

The UUID of the entity.

versioninteger

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.
dtCreatedstring date-time

The DateTime when this item was created (in ISO-8601 format).

dtLastModifiedstring date-time

The DateTime when this item was last modified (in ISO-8601 format).

createdBystring

The ID of the user who created this item.

lastModifiedBystring

The ID of the user who last modified this item.

namestring
descriptionstring
sourceSystemstring
destinationSystemstring
sourceTablestring
destinationTablestring

Example response

{
  "name": "m3ter Bill to Netsuite Invoice",
  "description": "Transforms a m3ter Bill into a Netsuite Invoice",
  "sourceSystem": "m3ter",
  "destinationSystem": "Netsuite",
  "sourceTable": "Bill",
  "destinationTable": "customrecord_invoice",
  "transformations": [
    {
      "destinationField": "m3terId",
      "type": "LOOKUP",
      "sourceField": "id"
    }
  ]
}

Changes