SERTICA

SERTICA Master Data Management API

The MasterDataManagement API from SERTICA — 4 operation(s) for masterdatamanagement.

GitHub OpenAPI

Operations 4

GET /MasterDataManagement/updatedinstances Get updated instances #
POST /MasterDataManagement/duplicatejobs Get duplicate jobs #
POST /MasterDataManagement/initiateupdateunitstask Initiate update units task #
POST /MasterDataManagement/initiatecopyunittask Initiate copy unit task #

Documentation

📖
Documentation
https://support.sertica.com/hc/en-us/articles/28558470734109-SERTICA-Application-Programming-Interface
📖
APIReference
https://docs.sertica.com/api/swagger/index.html
📖
Authentication
https://raw.githubusercontent.com/api-evangelist/sertica/refs/heads/main/authentication/sertica-authentication.yml

Specifications

⚙
OpenAPI
https://raw.githubusercontent.com/api-evangelist/sertica/refs/heads/main/openapi/sertica-masterdatamanagement-api-openapi.yml

Other Resources

🔗
ErrorCatalog
https://raw.githubusercontent.com/api-evangelist/sertica/refs/heads/main/errors/sertica-problem-types.yml
🔗
Conventions
https://raw.githubusercontent.com/api-evangelist/sertica/refs/heads/main/conventions/sertica-conventions.yml
🔗
DataModel
https://raw.githubusercontent.com/api-evangelist/sertica/refs/heads/main/data-model/sertica-data-model.yml
🔗
Webhooks
https://raw.githubusercontent.com/api-evangelist/sertica/refs/heads/main/asyncapi/sertica-webhooks.yml

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/sertica-masterdatamanagement-api"
All apis 
curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

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

sertica-masterdatamanagement-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  title: SERTICA Web Master Data Management API
  description: 'Online API browser for SERTICA Web API.


    Be aware that some endpoints are restricted by license or user rights and may not be available in your environment.


    Each endpoint includes a description of the required license and user rights.'
  version: v1
servers:
- url: /api
tags:
- name: MasterDataManagement
paths:
  /MasterDataManagement/updatedinstances:
    get:
      tags:
      - MasterDataManagement
      operationId: GetUpdatedInstances
      responses:
        '200':
          description: OK
          content:
            text/plain:
              schema:
                type: array
                items:
                  $ref: '#/components/schemas/SerticaWebApi.Models.MasterDataManagementModels.ApiUpdatedPackageUnitInstance'
            application/json:
              schema:
                type: array
                items:
                  $ref: '#/components/schemas/SerticaWebApi.Models.MasterDataManagementModels.ApiUpdatedPackageUnitInstance'
            text/json:
              schema:
                type: array
                items:
                  $ref: '#/components/schemas/SerticaWebApi.Models.MasterDataManagementModels.ApiUpdatedPackageUnitInstance'
        '400':
          description: Bad Request
          content:
            text/plain:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.ValidationResult'
            application/json:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.ValidationResult'
            text/json:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.ValidationResult'
        '401':
          description: If user is unauthorized
        '403':
          description: User must have one of these User Rights</br><table><thead><tr><th>Key</th><th>Right</th></tr></thead><tbody><tr><td style='border-bottom:none;padding-right:5px'>MasterDataManagement_Update</td><td style='border-bottom:none'>Update</td></tr></tbody></table><br/><br/>Customer must have one of these License values set<table><thead><tr><th>Key</th><th>Right</th></tr></thead><tbody><tr><td style='border-bottom:none;padding-right:5px'>MasterDataManagementWeb</td></tr></tbody></table>
        '500':
          description: The api has encountered an unhandled exception. See Sertica logs for details
      security:
      - Bearer: []
      summary: Get updated instances
      x-summary-source: derived
  /MasterDataManagement/duplicatejobs:
    post:
      tags:
      - MasterDataManagement
      operationId: GetDuplicateJobs
      requestBody:
        content:
          application/json-patch+json:
            schema:
              $ref: '#/components/schemas/SerticaWebApi.Models.MasterDataManagementModels.ApiUpdateUnitsArguments'
          application/json:
            schema:
              $ref: '#/components/schemas/SerticaWebApi.Models.MasterDataManagementModels.ApiUpdateUnitsArguments'
          text/json:
            schema:
              $ref: '#/components/schemas/SerticaWebApi.Models.MasterDataManagementModels.ApiUpdateUnitsArguments'
          application/*+json:
            schema:
              $ref: '#/components/schemas/SerticaWebApi.Models.MasterDataManagementModels.ApiUpdateUnitsArguments'
      responses:
        '200':
          description: OK
          content:
            text/plain:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.MasterDataManagementModels.ApiDuplicateJob'
            application/json:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.MasterDataManagementModels.ApiDuplicateJob'
            text/json:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.MasterDataManagementModels.ApiDuplicateJob'
        '400':
          description: Bad Request
          content:
            text/plain:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.ValidationResult'
            application/json:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.ValidationResult'
            text/json:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.ValidationResult'
        '401':
          description: If user is unauthorized
        '403':
          description: User must have one of these User Rights</br><table><thead><tr><th>Key</th><th>Right</th></tr></thead><tbody><tr><td style='border-bottom:none;padding-right:5px'>MasterDataManagement_Update</td><td style='border-bottom:none'>Update</td></tr></tbody></table><br/><br/>Customer must have one of these License values set<table><thead><tr><th>Key</th><th>Right</th></tr></thead><tbody><tr><td style='border-bottom:none;padding-right:5px'>MasterDataManagementWeb</td></tr></tbody></table>
        '500':
          description: The api has encountered an unhandled exception. See Sertica logs for details
      security:
      - Bearer: []
      summary: Get duplicate jobs
      x-summary-source: derived
  /MasterDataManagement/initiateupdateunitstask:
    post:
      tags:
      - MasterDataManagement
      operationId: InitiateUpdateUnitsTask
      requestBody:
        content:
          application/json-patch+json:
            schema:
              $ref: '#/components/schemas/SerticaWebApi.Models.MasterDataManagementModels.ApiUpdateUnitsArguments'
          application/json:
            schema:
              $ref: '#/components/schemas/SerticaWebApi.Models.MasterDataManagementModels.ApiUpdateUnitsArguments'
          text/json:
            schema:
              $ref: '#/components/schemas/SerticaWebApi.Models.MasterDataManagementModels.ApiUpdateUnitsArguments'
          application/*+json:
            schema:
              $ref: '#/components/schemas/SerticaWebApi.Models.MasterDataManagementModels.ApiUpdateUnitsArguments'
      responses:
        '200':
          description: OK
          content:
            text/plain:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.MasterDataManagementModels.ApiUpdateUnitsResult'
            application/json:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.MasterDataManagementModels.ApiUpdateUnitsResult'
            text/json:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.MasterDataManagementModels.ApiUpdateUnitsResult'
        '400':
          description: Bad Request
          content:
            text/plain:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.ValidationResult'
            application/json:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.ValidationResult'
            text/json:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.ValidationResult'
        '401':
          description: If user is unauthorized
        '403':
          description: User must have one of these User Rights</br><table><thead><tr><th>Key</th><th>Right</th></tr></thead><tbody><tr><td style='border-bottom:none;padding-right:5px'>MasterDataManagement_Update</td><td style='border-bottom:none'>Update</td></tr></tbody></table><br/><br/>Customer must have one of these License values set<table><thead><tr><th>Key</th><th>Right</th></tr></thead><tbody><tr><td style='border-bottom:none;padding-right:5px'>MasterDataManagementWeb</td></tr></tbody></table>
        '500':
          description: The api has encountered an unhandled exception. See Sertica logs for details
      security:
      - Bearer: []
      summary: Initiate update units task
      x-summary-source: derived
  /MasterDataManagement/initiatecopyunittask:
    post:
      tags:
      - MasterDataManagement
      operationId: InitiateCopyUnitTask
      requestBody:
        content:
          application/json-patch+json:
            schema:
              $ref: '#/components/schemas/SerticaWebApi.Models.MasterDataManagementModels.ApiMDMCopyUnitArguments'
          application/json:
            schema:
              $ref: '#/components/schemas/SerticaWebApi.Models.MasterDataManagementModels.ApiMDMCopyUnitArguments'
          text/json:
            schema:
              $ref: '#/components/schemas/SerticaWebApi.Models.MasterDataManagementModels.ApiMDMCopyUnitArguments'
          application/*+json:
            schema:
              $ref: '#/components/schemas/SerticaWebApi.Models.MasterDataManagementModels.ApiMDMCopyUnitArguments'
      responses:
        '200':
          description: OK
          content:
            text/plain:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.MasterDataManagementModels.ApiUpdateUnitsResult'
            application/json:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.MasterDataManagementModels.ApiUpdateUnitsResult'
            text/json:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.MasterDataManagementModels.ApiUpdateUnitsResult'
        '400':
          description: Bad Request
          content:
            text/plain:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.ValidationResult'
            application/json:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.ValidationResult'
            text/json:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.ValidationResult'
        '401':
          description: If user is unauthorized
        '403':
          description: User must have one of these User Rights</br><table><thead><tr><th>Key</th><th>Right</th></tr></thead><tbody><tr><td style='border-bottom:none;padding-right:5px'>MasterDataManagement_Update</td><td style='border-bottom:none'>Update</td></tr></tbody></table><br/><br/>Customer must have one of these License values set<table><thead><tr><th>Key</th><th>Right</th></tr></thead><tbody><tr><td style='border-bottom:none;padding-right:5px'>MasterDataManagementWeb</td></tr></tbody></table>
        '500':
          description: The api has encountered an unhandled exception. See Sertica logs for details
      security:
      - Bearer: []
      summary: Initiate copy unit task
      x-summary-source: derived
components:
  schemas:
    Logihold.BusinessObjects.LogiholdObjModel.SystemData_TaskStatus:
      enum:
      - Inactive
      - Waiting
      - Running
      - Completed
      - Failed
      - Cancelled
      - LockedOut
      type: string
    SerticaWebApi.Models.BrokenRule:
      type: object
      properties:
        type:
          $ref: '#/components/schemas/SerticaWebApi.Models.BrokenRuleType'
        index:
          type:
          - integer
          - 'null'
          format: int32
        objectGuid:
          type:
          - string
          - 'null'
          format: uuid
        field:
          type:
          - string
          - 'null'
        field2:
          type:
          - string
          - 'null'
        field3:
          type:
          - string
          - 'null'
        description:
          type:
          - string
          - 'null'
      additionalProperties: false
    SerticaWebApi.Models.ErrorReason:
      type: object
      properties:
        text:
          type:
          - string
          - 'null'
        fieldName:
          type:
          - string
          - 'null'
      additionalProperties: false
    SerticaWebApi.Models.MasterDataManagementModels.ApiUpdateUnitsArguments:
      type: object
      properties:
        userNo:
          type:
          - string
          - 'null'
        selectedPackageUnitInstances:
          type:
          - array
          - 'null'
          items:
            $ref: '#/components/schemas/SerticaWebApi.Models.MasterDataManagementModels.ApiSelectedPackageUnitInstance'
        duplicateJobsActions:
          type:
          - array
          - 'null'
          items:
            $ref: '#/components/schemas/SerticaWebApi.Models.MasterDataManagementModels.ApiDuplicateJobsAction'
      additionalProperties: false
    SerticaWebApi.Models.MasterDataManagementModels.MasterDataManagementTask:
      type: object
      properties:
        tsTaskTaskNo:
          type:
          - string
          - 'null'
        tsTaskRunTime:
          type:
          - string
          - 'null'
          format: date-time
        tsTaskNextRunTime:
          type:
          - string
          - 'null'
          format: date-time
        tsTaskActivated:
          type:
          - boolean
          - 'null'
        tsTaskDescription:
          type:
          - string
          - 'null'
        tsTaskTaskStatus:
          $ref: '#/components/schemas/Logihold.BusinessObjects.LogiholdObjModel.SystemData_TaskStatus'
        name:
          type:
          - string
          - 'null'
        taskNo:
          type:
          - string
          - 'null'
        taskType:
          $ref: '#/components/schemas/Logihold.BusinessObjects.LogiholdObjModel.MasterDataManagementTaskType'
        taskArguments: {}
        status:
          $ref: '#/components/schemas/Logihold.BusinessObjects.LogiholdObjModel.MasterDataManagementTaskStatus'
        progressText:
          type:
          - string
          - 'null'
        updateUserNo:
          type:
          - string
          - 'null'
        updateUserName:
          type:
          - string
          - 'null'
        updateDate:
          type:
          - string
          - 'null'
          format: date-time
        createUserNo:
          type:
          - string
          - 'null'
        createUserName:
          type:
          - string
          - 'null'
        createDate:
          type:
          - string
          - 'null'
          format: date-time
        guid:
          type:
          - string
          - 'null'
          format: uuid
        liveObjectGuid:
          type:
          - string
          - 'null'
          format: uuid
        unitGuid:
          type:
          - string
          - 'null'
          format: uuid
        deleted:
          type: boolean
        latestHistoryGuid:
          type:
          - string
          - 'null'
          format: uuid
        links:
          type:
          - array
          - 'null'
          items:
            $ref: '#/components/schemas/SerticaWebApi.Models.Link'
          readOnly: true
      additionalProperties: false
    SerticaWebApi.Models.MasterDataManagementModels.ApiDuplicateJobsAction:
      type: object
      properties:
        unitNo:
          type:
          - string
          - 'null'
        action:
          $ref: '#/components/schemas/SerticaWebApi.Models.MasterDataManagementModels.DuplicateJobsAction'
      additionalProperties: false
    Logihold.BusinessObjects.LogiholdObjModel.MasterDataManagementTaskStatus:
      enum:
      - Pending
      - Running
      - Completed
      - Error
      type: string
    Logihold.BusinessObjects.LogiholdObjModel.UpdateUnitsIssueReason:
      enum:
      - DuplicateDataOnUnit
      type: string
    SerticaWebApi.Models.MasterDataManagementModels.ApiMDMCopyUnitArguments:
      type: object
      properties:
        userNo:
          type:
          - string
          - 'null'
        sourceUnitNo:
          type:
          - string
          - 'null'
        targetUnitNo:
          type:
          - string
          - 'null'
        copyJobNo:
          type: boolean
        copyJobName:
          type: boolean
        copyExternalReference:
          type: boolean
        copyJobRelations:
          type: boolean
        copyClassRelated:
          type: boolean
        copyDisabled:
          type: boolean
      additionalProperties: false
    SerticaWebApi.Models.MasterDataManagementModels.ApiUpdatedPackageUnitInstance:
      type: object
      properties:
        packageUnitInstanceGuid:
          type:
          - string
          - 'null'
          format: uuid
        description:
          type:
          - string
          - 'null'
        unitNo:
          type:
          - string
          - 'null'
        unitName:
          type:
          - string
          - 'null'
        masterObjectComponentNo:
          type:
          - string
          - 'null'
        masterObjectComponentName:
          type:
          - string
          - 'null'
        unitComponentNo:
          type:
          - string
          - 'null'
        unitComponentName:
          type:
          - string
          - 'null'
        updateUserNo:
          type:
          - string
          - 'null'
        updateUserName:
          type:
          - string
          - 'null'
        displayName:
          type:
          - string
          - 'null'
        children:
          type:
          - array
          - 'null'
          items:
            $ref: '#/components/schemas/SerticaWebApi.Models.MasterDataManagementModels.ApiUpdatedPackageUnitInstance'
      additionalProperties: false
    Logihold.BusinessObjects.LogiholdObjModel.UpdateUnitsIssue:
      type: object
      properties:
        reason:
          $ref: '#/components/schemas/Logihold.BusinessObjects.LogiholdObjModel.UpdateUnitsIssueReason'
        message:
          type:
          - string
          - 'null'
      additionalProperties: false
    SerticaWebApi.Models.Link:
      type: object
      properties:
        key:
          type:
          - string
          - 'null'
        url:
          type:
          - string
          - 'null'
      additionalProperties: false
    SerticaWebApi.Models.MasterDataManagementModels.ApiSelectedPackageUnitInstance:
      type: object
      properties:
        packageUnitInstanceGuid:
          type: string
          format: uuid
        description:
          type:
          - string
          - 'null'
      additionalProperties: false
    Logihold.BusinessObjects.LogiholdObjModel.MasterDataManagementTaskType:
      enum:
      - UpdateUnits
      - CopyUnit
      type: string
    SerticaWebApi.Models.MasterDataManagementModels.ApiUpdateUnitsResult:
      type: object
      properties:
        success:
          type: boolean
          readOnly: true
        validationResult:
          $ref: '#/components/schemas/SerticaWebApi.Models.ValidationResult'
        issues:
          type:
          - array
          - 'null'
          items:
            $ref: '#/components/schemas/Logihold.BusinessObjects.LogiholdObjModel.UpdateUnitsIssue'
        task:
          $ref: '#/components/schemas/SerticaWebApi.Models.MasterDataManagementModels.MasterDataManagementTask'
      additionalProperties: false
    SerticaWebApi.Models.MasterDataManagementModels.ApiDuplicateJob:
      type: object
      properties:
        unitNo:
          type:
          - string
          - 'null'
        unitName:
          type:
          - string
          - 'null'
        mdmJobNo:
          type:
          - string
          - 'null'
        mdmJobName:
          type:
          - string
          - 'null'
        unitJobNo:
          type:
          - string
          - 'null'
        unitJobName:
          type:
          - string
          - 'null'
      additionalProperties: false
    SerticaWebApi.Models.MasterDataManagementModels.DuplicateJobsAction:
      enum:
      - AddAsNew
      - LinkToExisting
      type: string
    SerticaWebApi.Models.ValidationResult:
      type: object
      properties:
        isValid:
          type: boolean
          readOnly: true
        errors:
          type:
          - array
          - 'null'
          items:
            $ref: '#/components/schemas/SerticaWebApi.Models.ErrorReason'
          readOnly: true
        brokenRules:
          type:
          - array
          - 'null'
          items:
            $ref: '#/components/schemas/SerticaWebApi.Models.BrokenRule'
          readOnly: true
        subResults:
          type:
          - object
          - 'null'
          additionalProperties:
            $ref: '#/components/schemas/SerticaWebApi.Models.ValidationResult'
          readOnly: true
      additionalProperties: false
    SerticaWebApi.Models.BrokenRuleType:
      enum:
      - Default
      - ShouldBeFilled
      - Information
      - Warning
      - Error
      - Delete
      type: string
  securitySchemes:
    Bearer:
      type: http
      description: JWT Authorization header using the Bearer scheme
      scheme: bearer