SERTICA

SERTICA Excel Import API

The ExcelImport API from SERTICA — 4 operation(s) for excelimport.

GitHub OpenAPI

Operations 4

GET /ExcelImport Get #
POST /ExcelImport/Validate Validate #
POST /ExcelImport/Build Build #
POST /ExcelImport/Import Import #

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-excelimport-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-excelimport-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-excelimport-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  title: SERTICA Web Excel Import 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: ExcelImport
paths:
  /ExcelImport:
    get:
      tags:
      - ExcelImport
      operationId: Get
      responses:
        '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'>ExcelImport</td><td style='border-bottom:none'>View</td></tr></tbody></table>
        '500':
          description: The api has encountered an unhandled exception. See Sertica logs for details
      security:
      - Bearer: []
      summary: Get
      x-summary-source: derived
  /ExcelImport/Validate:
    post:
      tags:
      - ExcelImport
      operationId: Validate
      requestBody:
        description: Choose the file to upload
        content:
          multipart/form-data:
            schema:
              required:
              - File
              type: object
              properties:
                File:
                  type: string
                  format: binary
        required: true
      responses:
        '400':
          description: Bad Request
          content:
            text/plain:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.LoadSheet.LoadSheetResult'
            application/json:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.LoadSheet.LoadSheetResult'
            text/json:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.LoadSheet.LoadSheetResult'
        '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'>ExcelImport</td><td style='border-bottom:none'>View</td></tr></tbody></table>
        '500':
          description: The api has encountered an unhandled exception. See Sertica logs for details
      security:
      - Bearer: []
      summary: Validate
      x-summary-source: derived
  /ExcelImport/Build:
    post:
      tags:
      - ExcelImport
      operationId: Build
      requestBody:
        content:
          application/json-patch+json:
            schema:
              $ref: '#/components/schemas/SerticaWebApi.Models.LoadSheet.LoadSheetResult'
          application/json:
            schema:
              $ref: '#/components/schemas/SerticaWebApi.Models.LoadSheet.LoadSheetResult'
          text/json:
            schema:
              $ref: '#/components/schemas/SerticaWebApi.Models.LoadSheet.LoadSheetResult'
          application/*+json:
            schema:
              $ref: '#/components/schemas/SerticaWebApi.Models.LoadSheet.LoadSheetResult'
      responses:
        '400':
          description: Bad Request
          content:
            text/plain:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.LoadSheet.LoadSheetResult'
            application/json:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.LoadSheet.LoadSheetResult'
            text/json:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.LoadSheet.LoadSheetResult'
        '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'>ExcelImport</td><td style='border-bottom:none'>View</td></tr></tbody></table>
        '500':
          description: The api has encountered an unhandled exception. See Sertica logs for details
      security:
      - Bearer: []
      summary: Build
      x-summary-source: derived
  /ExcelImport/Import:
    post:
      tags:
      - ExcelImport
      operationId: Import
      requestBody:
        content:
          application/json-patch+json:
            schema:
              $ref: '#/components/schemas/SerticaWebApi.Models.LoadSheet.LoadSheetResult'
          application/json:
            schema:
              $ref: '#/components/schemas/SerticaWebApi.Models.LoadSheet.LoadSheetResult'
          text/json:
            schema:
              $ref: '#/components/schemas/SerticaWebApi.Models.LoadSheet.LoadSheetResult'
          application/*+json:
            schema:
              $ref: '#/components/schemas/SerticaWebApi.Models.LoadSheet.LoadSheetResult'
      responses:
        '400':
          description: Bad Request
          content:
            text/plain:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.LoadSheet.LoadSheetResult'
            application/json:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.LoadSheet.LoadSheetResult'
            text/json:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.LoadSheet.LoadSheetResult'
        '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'>ExcelImport</td><td style='border-bottom:none'>View</td></tr></tbody></table>
        '500':
          description: The api has encountered an unhandled exception. See Sertica logs for details
      security:
      - Bearer: []
      summary: Import
      x-summary-source: derived
components:
  schemas:
    SerticaWebApi.Models.Job.JobJobGroup:
      type: object
      properties:
        jobGroupNo:
          type:
          - string
          - 'null'
        jobGroupName:
          type:
          - string
          - 'null'
        jobNo:
          type:
          - string
          - 'null'
        jobName:
          type:
          - string
          - 'null'
        unitNo:
          type:
          - string
          - 'null'
        guidForReferencedObject:
          type:
          - string
          - 'null'
          format: uuid
        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.Job.JobAssignee:
      type: object
      properties:
        resourceNo:
          type:
          - string
          - 'null'
        resourceName:
          type:
          - string
          - 'null'
        jobNo:
          type:
          - string
          - 'null'
        jobName:
          type:
          - string
          - 'null'
        jobUnitNo:
          type:
          - string
          - 'null'
        allDay:
          type:
          - boolean
          - 'null'
        startTime:
          type:
          - string
          - 'null'
          format: date-time
        endTime:
          type:
          - string
          - 'null'
          format: date-time
        componentNo:
          type:
          - string
          - 'null'
        componentName:
          type:
          - string
          - 'null'
        componentUnitNo:
          type:
          - string
          - 'null'
        nextDate:
          type:
          - string
          - 'null'
          format: date-time
        highlight:
          type:
          - boolean
          - 'null'
        windowsUserName:
          type:
          - string
          - 'null'
        isJobOverdue:
          type: boolean
        jobOverdueDays:
          type:
          - integer
          - 'null'
          format: int32
        isJobActivated:
          type: boolean
        isJobIdle:
          type: boolean
        isJobPostponed:
          type: boolean
        externalReference:
          type:
          - string
          - 'null'
        jobEstimatedHours:
          type: number
          format: double
        lastAllowedDoneDate:
          type:
          - string
          - 'null'
          format: date-time
        guidForReferencedObject:
          type:
          - string
          - 'null'
          format: uuid
        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.LoadSheet.LoadSheetData_1__Logihold.BusinessObjects.Excel.LoadSheet.LoadSheetItem__LogiholdBusinessObjects__Version_5.26.9.1__Culture_neutral__PublicKeyToken_null
    : type: object
      properties:
        isValid:
          type: boolean
          readOnly: true
        excelRow:
          type: integer
          format: int32
        data:
          $ref: '#/components/schemas/Logihold.BusinessObjects.Excel.LoadSheet.LoadSheetItem'
        validationResult:
          $ref: '#/components/schemas/SerticaWebApi.Models.ValidationResult'
        validationResultAsString:
          type:
          - string
          - 'null'
          readOnly: true
      additionalProperties: false
    Logihold.BusinessObjects.Excel.LoadSheet.LoadSheetPlanningType:
      enum:
      - Floating
      - Fixed
      type: string
    ? SerticaWebApi.Models.LoadSheet.LoadSheetData_1__SerticaWebApi.Models.Job.Job__SerticaWebApi__Version_5.26.9.1__Culture_neutral__PublicKeyToken_null
    : type: object
      properties:
        isValid:
          type: boolean
          readOnly: true
        excelRow:
          type: integer
          format: int32
        data:
          $ref: '#/components/schemas/SerticaWebApi.Models.Job.Job'
        validationResult:
          $ref: '#/components/schemas/SerticaWebApi.Models.ValidationResult'
        validationResultAsString:
          type:
          - string
          - 'null'
          readOnly: true
      additionalProperties: false
    SerticaWebApi.Models.Framework.Amount:
      type: object
      properties:
        value:
          type: number
          format: double
        currencyNo:
          type:
          - string
          - 'null'
        decimalPlaces:
          type: integer
          format: int32
      additionalProperties: false
    SerticaWebApi.Models.LoadSheet.LoadSheetResult:
      type: object
      properties:
        loadSheetIsValid:
          type: boolean
          readOnly: true
        isValid:
          type: boolean
          readOnly: true
        loadSheetComponents:
          type:
          - array
          - 'null'
          items:
            $ref: '#/components/schemas/SerticaWebApi.Models.LoadSheet.LoadSheetData_1__Logihold.BusinessObjects.Excel.LoadSheet.LoadSheetComponent__LogiholdBusinessObjects__Version_5.26.9.1__Culture_neutral__PublicKeyToken_null'
        components:
          type:
          - array
          - 'null'
          items:
            $ref: '#/components/schemas/SerticaWebApi.Models.LoadSheet.LoadSheetData_1__SerticaWebApi.Models.Component.Component__SerticaWebApi__Version_5.26.9.1__Culture_neutral__PublicKeyToken_null'
        loadSheetJobs:
          type:
          - array
          - 'null'
          items:
            $ref: '#/components/schemas/SerticaWebApi.Models.LoadSheet.LoadSheetData_1__Logihold.BusinessObjects.Excel.LoadSheet.LoadSheetJob__LogiholdBusinessObjects__Version_5.26.9.1__Culture_neutral__PublicKeyToken_null'
        jobs:
          type:
          - array
          - 'null'
          items:
            $ref: '#/components/schemas/SerticaWebApi.Models.LoadSheet.LoadSheetData_1__SerticaWebApi.Models.Job.Job__SerticaWebApi__Version_5.26.9.1__Culture_neutral__PublicKeyToken_null'
        loadSheetDocuments:
          type:
          - array
          - 'null'
          items:
            $ref: '#/components/schemas/SerticaWebApi.Models.LoadSheet.LoadSheetData_1__Logihold.BusinessObjects.Excel.LoadSheet.LoadSheetDocument__LogiholdBusinessObjects__Version_5.26.9.1__Culture_neutral__PublicKeyToken_null'
        documents:
          type:
          - array
          - 'null'
          items:
            $ref: '#/components/schemas/SerticaWebApi.Models.LoadSheet.LoadSheetData_1__SerticaWebApi.Models.Document.Document__SerticaWebApi__Version_5.26.9.1__Culture_neutral__PublicKeyToken_null'
        loadSheetComponentDocuments:
          type:
          - array
          - 'null'
          items:
            $ref: '#/components/schemas/SerticaWebApi.Models.LoadSheet.LoadSheetData_1__Logihold.BusinessObjects.Excel.LoadSheet.LoadSheetComponentDocument__LogiholdBusinessObjects__Version_5.26.9.1__Culture_neutral__PublicKeyToken_null'
        loadSheetJobDocuments:
          type:
          - array
          - 'null'
          items:
            $ref: '#/components/schemas/SerticaWebApi.Models.LoadSheet.LoadSheetData_1__Logihold.BusinessObjects.Excel.LoadSheet.LoadSheetJobDocument__LogiholdBusinessObjects__Version_5.26.9.1__Culture_neutral__PublicKeyToken_null'
        items:
          type:
          - array
          - 'null'
          items:
            $ref: '#/components/schemas/SerticaWebApi.Models.LoadSheet.LoadSheetData_1__SerticaWebApi.Models.Item.Item__SerticaWebApi__Version_5.26.9.1__Culture_neutral__PublicKeyToken_null'
        loadSheetItems:
          type:
          - array
          - 'null'
          items:
            $ref: '#/components/schemas/SerticaWebApi.Models.LoadSheet.LoadSheetData_1__Logihold.BusinessObjects.Excel.LoadSheet.LoadSheetItem__LogiholdBusinessObjects__Version_5.26.9.1__Culture_neutral__PublicKeyToken_null'
        loadSheetComponentItems:
          type:
          - array
          - 'null'
          items:
            $ref: '#/components/schemas/SerticaWebApi.Models.LoadSheet.LoadSheetData_1__Logihold.BusinessObjects.Excel.LoadSheet.LoadSheetComponentItem__LogiholdBusinessObjects__Version_5.26.9.1__Culture_neutral__PublicKeyToken_null'
        loadSheetJobItems:
          type:
          - array
          - 'null'
          items:
            $ref: '#/components/schemas/SerticaWebApi.Models.LoadSheet.LoadSheetData_1__Logihold.BusinessObjects.Excel.LoadSheet.LoadSheetJobItem__LogiholdBusinessObjects__Version_5.26.9.1__Culture_neutral__PublicKeyToken_null'
        loadSheetItemDocuments:
          type:
          - array
          - 'null'
          items:
            $ref: '#/components/schemas/SerticaWebApi.Models.LoadSheet.LoadSheetData_1__Logihold.BusinessObjects.Excel.LoadSheet.LoadSheetItemDocument__LogiholdBusinessObjects__Version_5.26.9.1__Culture_neutral__PublicKeyToken_null'
        importComponents:
          type: boolean
        importJobs:
          type: boolean
        importDocuments:
          type: boolean
        importComponentDocuments:
          type: boolean
        importJobDocuments:
          type: boolean
        importItems:
          type: boolean
        importComponentItems:
          type: boolean
        importJobItems:
          type: boolean
        importItemDocuments:
          type: boolean
      additionalProperties: false
    Logihold.BusinessObjects.Excel.LoadSheet.LoadSheetItem:
      type: object
      properties:
        itemNo:
          type:
          - string
          - 'null'
        name:
          type:
          - string
          - 'null'
        measureUnitNo:
          type:
          - string
          - 'null'
        itemTypeNo:
          type:
          - string
          - 'null'
        expireDate:
          type:
          - string
          - 'null'
          format: date-time
        text:
          type:
          - string
          - 'null'
        currencyNo:
          type:
          - string
          - 'null'
        price:
          type:
          - number
          - 'null'
          format: double
        certificate:
          type:
          - boolean
          - 'null'
        critical:
          type:
          - boolean
          - 'null'
        manufacturer:
          type:
          - string
          - 'null'
        manufacturerNo:
          type:
          - string
          - 'null'
        typeNo:
          type:
          - string
          - 'null'
        standardNo:
          type:
          - string
          - 'null'
        referenceNo:
          type:
          - string
          - 'null'
        referencePosNo:
          type:
          - string
          - 'null'
        drawingNo:
          type:
          - string
          - 'null'
        drawingPosNo:
          type:
          - string
          - 'null'
        classification:
          type:
          - string
          - 'null'
        dimension:
          type:
          - string
          - 'null'
        qrCode:
          type:
          - string
          - 'null'
        warehouseNo:
          type:
          - string
          - 'null'
        locationNo:
          type:
          - string
          - 'null'
        minimumStock:
          type:
          - number
          - 'null'
          format: double
        maximumStock:
          type:
          - number
          - 'null'
          format: double
        itemGroupNo:
          type:
          - string
          - 'null'
        supplierNo:
          type:
          - string
          - 'null'
        supplierPartNo:
          type:
          - string
          - 'null'
        supplierPartDescription:
          type:
          - string
          - 'null'
        deliveryDays:
          type:
          - integer
          - 'null'
          format: int32
        customProperties: {}
        internalRemark:
          type:
          - string
          - 'null'
      additionalProperties: false
    Logihold.BusinessObjects.Excel.LoadSheet.LoadSheetComponentDocument:
      type: object
      properties:
        componentNo:
          type:
          - string
          - 'null'
        documentNo:
          type:
          - string
          - 'null'
        pageNo:
          type:
          - integer
          - 'null'
          format: int32
      additionalProperties: false
    Logihold.BusinessObjects.LogiholdObjModel.SystemData_JobInstancePostponementStatus:
      enum:
      - All
      - NotRequested
      - Requested
      - Rejected
      - Approved
      type: string
    ? SerticaWebApi.Models.LoadSheet.LoadSheetData_1__Logihold.BusinessObjects.Excel.LoadSheet.LoadSheetComponent__LogiholdBusinessObjects__Version_5.26.9.1__Culture_neutral__PublicKeyToken_null
    : type: object
      properties:
        isValid:
          type: boolean
          readOnly: true
        excelRow:
          type: integer
          format: int32
        data:
          $ref: '#/components/schemas/Logihold.BusinessObjects.Excel.LoadSheet.LoadSheetComponent'
        validationResult:
          $ref: '#/components/schemas/SerticaWebApi.Models.ValidationResult'
        validationResultAsString:
          type:
          - string
          - 'null'
          readOnly: true
      additionalProperties: false
    SerticaWebApi.Models.Job.OrdinalNumbers:
      enum:
      - First
      - Second
      - Third
      - Fourth
      - Last
      type: string
    SerticaWebApi.Models.Job.JobTrigger:
      type: object
      properties:
        triggerType:
          $ref: '#/components/schemas/SerticaWebApi.Models.Job.TriggerType'
        jobNo:
          type:
          - string
          - 'null'
        jobName:
          type:
          - string
          - 'null'
        nextDate:
          type:
          - string
          - 'null'
          format: date-time
        startDate:
          type:
          - string
          - 'null'
          format: date-time
        endDate:
          type:
          - string
          - 'null'
          format: date-time
        planningType:
          $ref: '#/components/schemas/SerticaWebApi.Models.Job.PlanningType'
        frequence:
          type: number
          format: double
        longDescription:
          type:
          - string
          - 'null'
        recurringType:
          $ref: '#/components/schemas/SerticaWebApi.Models.Job.RecurrenceType'
        every:
          type:
          - integer
          - 'null'
          format: int32
          default: 0
        everyWeekday:
          type:
          - boolean
          - 'null'
        monday:
          type:
          - boolean
          - 'null'
        tuesday:
          type:
          - boolean
          - 'null'
        wednesday:
          type:
          - boolean
          - 'null'
        thursday:
          type:
          - boolean
          - 'null'
        friday:
          type:
          - boolean
          - 'null'
        saturday:
          type:
          - boolean
          - 'null'
        sunday:
          type:
          - boolean
          - 'null'
        dayOfMonth:
          type:
          - integer
          - 'null'
          format: int32
          default: 0
        ordinal:
          $ref: '#/components/schemas/SerticaWebApi.Models.Job.OrdinalNumbers'
        month:
          $ref: '#/components/schemas/SerticaWebApi.Models.Job.Months'
        useFloatingFixed:
          type:
          - boolean
          - 'null'
        seasonal:
          type: boolean
        seasonStartDay:
          type:
          - integer
          - 'null'
          format: int32
        seasonStartMonth:
          $ref: '#/components/schemas/SerticaWebApi.Models.Job.Months'
        seasonEndDay:
          type:
          - integer
          - 'null'
          format: int32
        seasonEndMonth:
          $ref: '#/components/schemas/SerticaWebApi.Models.Job.Months'
        componentCounterRelationGuid:
          type:
          - string
          - 'null'
          format: uuid
        counterNo:
          type:
          - string
          - 'null'
        counterName:
          type:
          - string
          - 'null'
        counterFrequence:
          type:
          - number
          - 'null'
          format: double
        counterStart:
          type:
          - number
          - 'null'
          format: double
        postponedCounterStart:
          type:
          - number
          - 'null'
          format: double
        nextRunValue:
          type:
          - number
          - 'null'
          format: double
        componentCounterEstimatedNow:
          type:
          - number
          - 'null'
          format: double
        measureGuid:
          type:
          - string
          - 'null'
          format: uuid
        measureNo:
          type:
          - string
          - 'null'
        measureName:
          type:
          - string
          - 'null'
        measureTriggerType:
          $ref: '#/components/schemas/SerticaWebApi.Models.Job.MeasureTriggerType'
        nominal:
          type:
          - number
          - 'null'
          format: double
        highLimit:
          type:
          - number
          - 'null'
          format: double
        lowLimit:
          type:
          - number
          - 'null'
          format: double
        deviationPercent:
          type:
          - number
          - 'null'
          format: double
        highLimitNumberOfExceedings:
          type:
          - integer
          - 'null'
          format: int32
        highLimitLatestNoOfDays:
          type:
          - integer
          - 'null'
          format: int32
        lowLimitNumberOfExceedings:
          type:
          - integer
          - 'null'
          format: int32
        lowLimitLatestNoOfDays:
          type:
          - integer
          - 'null'
          format: int32
        averageOverReadings:
          type:
          - integer
          - 'null'
          format: int32
        predictionValue:
          type:
          - number
          - 'null'
          format: double
        dockListGuid:
          type:
          - string
          - 'null'
          format: uuid
        dockListNo:
          type:
          - string
          - 'null'
        dockListDescription:
          type:
          - string
          - 'null'
        opcMachineName:
          type:
          - string
          - 'null'
        opcServerName:
          type:
          - string
          - 'null'
        opcItemId:
          type:
          - string
          - 'null'
        opcActive:
          type:
          - boolean
          - 'null'
        opcItemIDAck:
          type:
          - string
          - 'null'
        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.Component.ComponentDocument:
      type: object
      properties:
        componentNo:
          type:
          - string
          - 'null'
        componentName:
          type:
          - string
          - 'null'
        documentNo:
          type:
          - string
          - 'null'
        documentDescription:
          type:
          - string
          - 'null'
        fileName:
          type:
          - string
          - 'null'
        url:
          type:
          - string
          - 'null'
        fileSize:
          type:
          - integer
          - 'null'
          format: int64
        pageNo:
          type:
          - integer
          - 'null'
          format: int32
        documentTypeNo:
          type:
          - string
          - 'null'
        documentTypeName:
          type:
          - string
          - 'null'
        documentTypeUnitNo:
          type:
          - string
          - 'null'
        documentGroupName:
          type:
          - string
          - 'null'
        documentGroupNo:
          type:
          - string
          - 'null'
        documentGroupUnitNo:
          type:
          - string
          - 'null'
        documentUnitNo:
          type:
          - string
          - 'null'
        documentUnitName:
          type:
          - string
          - 'null'
        documentDataOwner:
          $ref: '#/components/schemas/Logimatic.BaseClasses30.DataOwner'
        previewFormat:
          $ref: '#/components/schemas/Logihold.BusinessObjects.LogiholdObjModel.DocumentPreview.PreviewFormat'
        guidForReferencedObject:
          type:
          - string
          - 'null'
          format: uuid
        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
    Logihold.BusinessObjects.Excel.LoadSheet.LoadSheetComponent:
      type: object
      properties:
        componentNo:
          type:
          - string
          - 'null'
        name:
          type:
          - string
          - 'null'
        parentComponentNo:
          type:
          - string
          - 'null'
        supplierNo:
          type:
          - string
          - 'null'
        manufacturer:
          type:
          - string
          - 'null'
        manufacturerNo:
          type:
          - string
          - 'null'
        typeNo:
          type:
          - string
          - 'null'
        serialNo:
          type:
          - string
          - 'null'
        drawingNo:
          type:
          - string
          - 'null'
        classification:
          type:
          - string
          - 'null'
        technicalInfo:
          type:
          - string
          - 'null'
        locationNo:
          type:
          - string
          - 'null'
        installedDate:
          type:
          - string
          - 'null'
          format: date-time
        criticalEquipment:
          type:
          - boolean
          - 'null'
        accountNo:
          type:
          - string
          - 'null'
        estimatedLifetime:
          type:
          - integer
          - 'null'
          format: int32
        systemNo:
          type:
          - string
          - 'null'
        purchaseYear:
          type:
          - integer
          - 'null'
          format: int32
        createdYear:
          type:
          - integer
          - 'null'
          format: int32
        scrapYear:
          type:
          - integer
          - 'null'
          format: int32
        price:
          type:
          - number
          - 'null'
          format: double
        initialPrice:
          type:
          - number
          - 'null'
          format: double
        priceYear:
          type:
          - integer
          - 'null'
          format: int32
        counterNo:
          type:
          - string
          - 'null'
        sectionNo:
          type:
          - string
          - 'null'
        gpsLatitude:
          type:
          - number
          - 'null'
          format: double
        gpsLongitude:
          type:
          - number
          - 'null'
          format: double
        componentTypeNo:
          type:
          - string
          - 'null'
        sortOrder:
          type:
          - integer
          - 'null'
          format: int32
        customProperties: {}
        qrCode:
          type:
          - string
          - 'null'
      additionalProperties: false
    Logihold.BusinessObjects.Excel.LoadSheet.LoadSheetComponentItem:
      type: object
      properties:
        componentNo:
          type:
          - string
          - 'null'
        itemNo:
          type:
          - string
          - 'null'
        quantity:
          type:
          - number
          - 'null'
          format: double
        remark:
          type:
          - string
          - 'null'
      additionalProperties: false
    SerticaWebApi.Models.Document.FileType:
      enum:
      - None
      - File
      - Link
      - Folder
      type: string
    SerticaWebApi.Models.Document.DocumentWeblink:
      type: object
      properties:
        document2Guid:
          type: string
          format: uuid
        description:
          type:
          - string
          - 'null'
        expireDate:
          type:
          - string
          - 'null'
    

# --- truncated at 32 KB (112 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/sertica/refs/heads/main/openapi/sertica-excelimport-api-openapi.yml