SERTICA

SERTICA Data Warehouse Analytics Templates API

The DataWarehouseAnalyticsTemplates API from SERTICA — 14 operation(s) for datawarehouseanalyticstemplates.

GitHub OpenAPI

Operations 17

GET /DataWarehouseAnalyticsTemplates Gets a list of DataWarehouseAnalyticsTemplate #
POST /DataWarehouseAnalyticsTemplates Creates a new DataWarehouseAnalyticsTemplate record #
GET /DataWarehouseAnalyticsTemplates/{templateNo} Gets a specific DataWarehouseAnalyticsTemplate #
PUT /DataWarehouseAnalyticsTemplates/{templateNo} Updates an existing DataWarehouseAnalyticsTemplate #
DELETE /DataWarehouseAnalyticsTemplates/{templateNo} Deletes an DataWarehouseAnalyticsTemplate record #
GET /DataWarehouseAnalyticsTemplates/{templateNo}/history Gets history for a specific DataWarehouseAnalyticsTemplate #
POST /DataWarehouseAnalyticsTemplates/search Search for DataWarehouseAnalyticsTemplate Takes a SearchDefinition input, which… #
POST /DataWarehouseAnalyticsTemplates/searchCount Returns number of hits in a search for DataWarehouseAnalyticsTemplate Takes a… #
POST /DataWarehouseAnalyticsTemplates/searchIndex/{DataWarehouseTemplateGuid} Get index of a record in a search for DataWarehouseAnalyticsTemplate Takes a… #
GET /DataWarehouseAnalyticsTemplates/searchInfo Returns structured information about what and how you can search for #
GET /DataWarehouseAnalyticsTemplates/{templateNo}/copy Copies an existing DataWarehouseAnalyticsTemplate to a new object #
POST /DataWarehouseAnalyticsTemplates/{templateNo}/unlock Unlock the DataWarehouse analytics Template #
GET /DataWarehouseAnalyticsTemplates/{templateNo}/tasks Get all DataWarehouse Analytics Template TS Tasks #
GET /DataWarehouseAnalyticsTemplates/{templateNo}/tasks/{taskNo} Get a DataWarehouse Analytics Template TS Task #
POST /DataWarehouseAnalyticsTemplates/{templateNo}/export Creates a system task to export the Data Warehouse Template to the Data… #
GET /DataWarehouseAnalyticsTemplates/{templateNo}/resources Fetches all Resources attached to the Data Warehouse Template #
GET /DataWarehouseAnalyticsTemplates/{templateNo}/roles Fetches all Roles attached to the Data Warehouse Template #

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-datawarehouseanalyticstemplates-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-datawarehouseanalyticstemplates-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-datawarehouseanalyticstemplates-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  title: SERTICA Web Data Warehouse Analytics Templates 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: DataWarehouseAnalyticsTemplates
paths:
  /DataWarehouseAnalyticsTemplates:
    get:
      tags:
      - DataWarehouseAnalyticsTemplates
      summary: Gets a list of DataWarehouseAnalyticsTemplate
      operationId: GetDataWarehouseAnalyticsTemplates
      parameters:
      - name: page
        in: query
        description: ''
        schema:
          type: integer
          format: int32
          default: 1
      - name: pageSize
        in: query
        description: ''
        schema:
          type: integer
          format: int32
          default: 25
      responses:
        '200':
          description: OK
          content:
            text/plain:
              schema:
                type: array
                items:
                  $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplate'
            application/json:
              schema:
                type: array
                items:
                  $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplate'
            text/json:
              schema:
                type: array
                items:
                  $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplate'
        '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'>DataWarehouseTemplate</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: []
    post:
      tags:
      - DataWarehouseAnalyticsTemplates
      summary: Creates a new DataWarehouseAnalyticsTemplate record
      operationId: CreateDataWarehouseTemplate
      requestBody:
        description: The DataWarehouseAnalyticsTemplate Object, including reference lists
        content:
          application/json-patch+json:
            schema:
              $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplate'
          application/json:
            schema:
              $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplate'
          text/json:
            schema:
              $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplate'
          application/*+json:
            schema:
              $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplate'
      responses:
        '201':
          description: Created
          content:
            text/plain:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplate'
            application/json:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplate'
            text/json:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplate'
        '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'>DataWarehouseTemplate_Update</td><td style='border-bottom:none'>Update</td></tr></tbody></table>
        '500':
          description: The api has encountered an unhandled exception. See Sertica logs for details
      security:
      - Bearer: []
  /DataWarehouseAnalyticsTemplates/{templateNo}:
    get:
      tags:
      - DataWarehouseAnalyticsTemplates
      summary: Gets a specific DataWarehouseAnalyticsTemplate
      operationId: GetDataWarehouseAnalyticsTemplate
      parameters:
      - name: templateNo
        in: path
        description: the templateNo to get
        required: true
        schema:
          type: string
      responses:
        '200':
          description: Returns the requested DataWarehouseAnalyticsTemplate
          content:
            text/plain:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplate'
            application/json:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplate'
            text/json:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplate'
        '400':
          description: Returns a validation result with information about the 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'
        '404':
          description: If an DataWarehouseAnalyticsTemplate with the supplied DataWarehouseAnalyticsTemplate No cannot be found
        '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'>DataWarehouseTemplate</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: []
    put:
      tags:
      - DataWarehouseAnalyticsTemplates
      summary: Updates an existing DataWarehouseAnalyticsTemplate
      operationId: UpdateDataWarehouseAnalyticsTemplate
      parameters:
      - name: templateNo
        in: path
        description: The templateNo of the DataWarehouseAnalyticsTemplate to update
        required: true
        schema:
          type: string
      requestBody:
        description: The DataWarehouseAnalyticsTemplate DTO object with the fields to update
        content:
          application/json-patch+json:
            schema:
              $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplate'
          application/json:
            schema:
              $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplate'
          text/json:
            schema:
              $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplate'
          application/*+json:
            schema:
              $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplate'
      responses:
        '200':
          description: Returns the updated DataWarehouseTemplate object
          content:
            text/plain:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplate'
            application/json:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplate'
            text/json:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplate'
        '400':
          description: Returns a ValidationResult with information about the 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'>DataWarehouseTemplate_Update</td><td style='border-bottom:none'>Update</td></tr></tbody></table>
        '500':
          description: The api has encountered an unhandled exception. See Sertica logs for details
      security:
      - Bearer: []
    delete:
      tags:
      - DataWarehouseAnalyticsTemplates
      summary: Deletes an DataWarehouseAnalyticsTemplate record
      parameters:
      - name: templateNo
        in: path
        description: The templateNo of the DataWarehouseAnalyticsTemplate to delete
        required: true
        schema:
          type: string
      responses:
        '204':
          description: No Content
        '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'>DataWarehouseTemplate_Delete</td><td style='border-bottom:none'>Delete</td></tr></tbody></table>
        '500':
          description: The api has encountered an unhandled exception. See Sertica logs for details
      security:
      - Bearer: []
      operationId: deleteDataWarehouseAnalyticsTemplatesByTemplateNo
      x-operation-id-source: derived
  /DataWarehouseAnalyticsTemplates/{templateNo}/history:
    get:
      tags:
      - DataWarehouseAnalyticsTemplates
      summary: Gets history for a specific DataWarehouseAnalyticsTemplate
      operationId: GetDataWarehouseAnalyticsTemplateHistory
      parameters:
      - name: templateNo
        in: path
        description: The templateNo to get
        required: true
        schema:
          type: string
      - name: page
        in: query
        description: ''
        schema:
          type: integer
          format: int32
          default: 1
      - name: pageSize
        in: query
        description: ''
        schema:
          type: integer
          format: int32
          default: 5
      responses:
        '200':
          description: Returns the requested DataWarehouseAnalyticsTemplate
          content:
            text/plain:
              schema:
                type: array
                items:
                  $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplate'
            application/json:
              schema:
                type: array
                items:
                  $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplate'
            text/json:
              schema:
                type: array
                items:
                  $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplate'
        '400':
          description: Returns a validation result with information about the 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'
        '404':
          description: If an DataWarehouseAnalyticsTemplate with the supplied DataWarehouseAnalyticsTemplate No cannot be found
        '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'>DataWarehouseTemplate_HistoryMode</td><td style='border-bottom:none'>HistoryMode</td></tr></tbody></table>
        '500':
          description: The api has encountered an unhandled exception. See Sertica logs for details
      security:
      - Bearer: []
  /DataWarehouseAnalyticsTemplates/search:
    post:
      tags:
      - DataWarehouseAnalyticsTemplates
      summary: Search for DataWarehouseAnalyticsTemplate Takes a SearchDefinition input, which…
      operationId: SearchDataWarehouseAnalyticsTemplate
      parameters:
      - name: page
        in: query
        description: Page
        schema:
          type: integer
          format: int32
          default: 1
      - name: pageSize
        in: query
        description: Pagesize
        schema:
          type: integer
          format: int32
          default: 25
      requestBody:
        description: The search definition
        content:
          application/json-patch+json:
            schema:
              $ref: '#/components/schemas/Logihold.BusinessObjects.LogiholdObjModel.Search.SearchDefinition'
          application/json:
            schema:
              $ref: '#/components/schemas/Logihold.BusinessObjects.LogiholdObjModel.Search.SearchDefinition'
          text/json:
            schema:
              $ref: '#/components/schemas/Logihold.BusinessObjects.LogiholdObjModel.Search.SearchDefinition'
          application/*+json:
            schema:
              $ref: '#/components/schemas/Logihold.BusinessObjects.LogiholdObjModel.Search.SearchDefinition'
      responses:
        '200':
          description: OK
          content:
            text/plain:
              schema:
                type: array
                items:
                  $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplate'
            application/json:
              schema:
                type: array
                items:
                  $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplate'
            text/json:
              schema:
                type: array
                items:
                  $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplate'
        '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'>DataWarehouseTemplate</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: []
  /DataWarehouseAnalyticsTemplates/searchCount:
    post:
      tags:
      - DataWarehouseAnalyticsTemplates
      summary: Returns number of hits in a search for DataWarehouseAnalyticsTemplate Takes a…
      operationId: SearchCountDataWarehouseAnalyticsTemplate
      requestBody:
        description: The search definition
        content:
          application/json-patch+json:
            schema:
              $ref: '#/components/schemas/Logihold.BusinessObjects.LogiholdObjModel.Search.SearchDefinition'
          application/json:
            schema:
              $ref: '#/components/schemas/Logihold.BusinessObjects.LogiholdObjModel.Search.SearchDefinition'
          text/json:
            schema:
              $ref: '#/components/schemas/Logihold.BusinessObjects.LogiholdObjModel.Search.SearchDefinition'
          application/*+json:
            schema:
              $ref: '#/components/schemas/Logihold.BusinessObjects.LogiholdObjModel.Search.SearchDefinition'
      responses:
        '200':
          description: OK
          content:
            text/plain:
              schema:
                type: integer
                format: int32
            application/json:
              schema:
                type: integer
                format: int32
            text/json:
              schema:
                type: integer
                format: int32
        '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'>DataWarehouseTemplate</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: []
  /DataWarehouseAnalyticsTemplates/searchIndex/{DataWarehouseTemplateGuid}:
    post:
      tags:
      - DataWarehouseAnalyticsTemplates
      summary: Get index of a record in a search for DataWarehouseAnalyticsTemplate Takes a…
      operationId: SearchIndexDataWarehouseTemplate
      parameters:
      - name: dataWarehouseAnalyticsTemplateGuid
        in: query
        description: The DataWarehouseAnalyticsTemplate to get index for
        schema:
          type: string
          format: uuid
      - name: DataWarehouseTemplateGuid
        in: path
        required: true
        schema:
          type: string
      requestBody:
        description: The search definition
        content:
          application/json-patch+json:
            schema:
              $ref: '#/components/schemas/Logihold.BusinessObjects.LogiholdObjModel.Search.SearchDefinition'
          application/json:
            schema:
              $ref: '#/components/schemas/Logihold.BusinessObjects.LogiholdObjModel.Search.SearchDefinition'
          text/json:
            schema:
              $ref: '#/components/schemas/Logihold.BusinessObjects.LogiholdObjModel.Search.SearchDefinition'
          application/*+json:
            schema:
              $ref: '#/components/schemas/Logihold.BusinessObjects.LogiholdObjModel.Search.SearchDefinition'
      responses:
        '200':
          description: OK
          content:
            text/plain:
              schema:
                type: integer
                format: int32
            application/json:
              schema:
                type: integer
                format: int32
            text/json:
              schema:
                type: integer
                format: int32
        '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'>DataWarehouseTemplate</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: []
  /DataWarehouseAnalyticsTemplates/searchInfo:
    get:
      tags:
      - DataWarehouseAnalyticsTemplates
      summary: Returns structured information about what and how you can search for
      operationId: SearchInfoDataWarehouseAnalyticsTemplate
      responses:
        '200':
          description: Returns a list of valid search fields
          content:
            text/plain:
              schema:
                $ref: '#/components/schemas/Logihold.BusinessObjects.LogiholdObjModel.Search.SearchInfo'
            application/json:
              schema:
                $ref: '#/components/schemas/Logihold.BusinessObjects.LogiholdObjModel.Search.SearchInfo'
            text/json:
              schema:
                $ref: '#/components/schemas/Logihold.BusinessObjects.LogiholdObjModel.Search.SearchInfo'
        '500':
          description: The api has encountered an unhandled exception. See Sertica logs for details
  /DataWarehouseAnalyticsTemplates/{templateNo}/copy:
    get:
      tags:
      - DataWarehouseAnalyticsTemplates
      summary: Copies an existing DataWarehouseAnalyticsTemplate to a new object
      operationId: CopyDataWarehouseAnalyticsTemplate
      parameters:
      - name: templateNo
        in: path
        description: The templateNo of the DataWarehouseAnalyticsTemplateto copy
        required: true
        schema:
          type: string
      responses:
        '200':
          description: Returns the new DataWarehouseAnalyticsTemplate object with properties from original
          content:
            text/plain:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplate'
            application/json:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplate'
            text/json:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplate'
        '400':
          description: Returns a ValidationResult with information about the 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'>DataWarehouseTemplate_Update</td><td style='border-bottom:none'>Update</td></tr></tbody></table>
        '500':
          description: The api has encountered an unhandled exception. See Sertica logs for details
      security:
      - Bearer: []
  /DataWarehouseAnalyticsTemplates/{templateNo}/unlock:
    post:
      tags:
      - DataWarehouseAnalyticsTemplates
      summary: Unlock the DataWarehouse analytics Template
      operationId: UnlockDataWarehouseAnalyticsTemplate
      parameters:
      - name: templateNo
        in: path
        required: true
        schema:
          type: string
      responses:
        '204':
          description: Returns no content if the template is unlocked
        '400':
          description: Returns a ValidationResult with information about the 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'>DataWarehouseTemplate_Update</td><td style='border-bottom:none'>Update</td></tr></tbody></table>
        '500':
          description: The api has encountered an unhandled exception. See Sertica logs for details
      security:
      - Bearer: []
  /DataWarehouseAnalyticsTemplates/{templateNo}/tasks:
    get:
      tags:
      - DataWarehouseAnalyticsTemplates
      summary: Get all DataWarehouse Analytics Template TS Tasks
      operationId: GetDataWarehouseAnalyticsTemplateTsTasks
      parameters:
      - name: templateNo
        in: path
        description: ''
        required: true
        schema:
          type: string
      responses:
        '200':
          description: OK
          content:
            text/plain:
              schema:
                type: array
                items:
                  $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplateTsTask'
            application/json:
              schema:
                type: array
                items:
                  $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplateTsTask'
            text/json:
              schema:
                type: array
                items:
                  $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplateTsTask'
        '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'>DataWarehouseTemplate</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: []
  /DataWarehouseAnalyticsTemplates/{templateNo}/tasks/{taskNo}:
    get:
      tags:
      - DataWarehouseAnalyticsTemplates
      summary: Get a DataWarehouse Analytics Template TS Task
      operationId: GetDataWarehouseAnalyticsTemplateTsTask
      parameters:
      - name: templateNo
        in: path
        description: ''
        required: true
        schema:
          type: string
      - name: taskNo
        in: path
        description: ''
        required: true
        schema:
          type: string
      responses:
        '200':
          description: OK
          content:
            text/plain:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplateTsTask'
            application/json:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplateTsTask'
            text/json:
              schema:
                $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplateTsTask'
        '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'>DataWarehouseTemplate</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: []
  /DataWarehouseAnalyticsTemplates/{templateNo}/export:
    post:
      tags:
      - DataWarehouseAnalyticsTemplates
      summary: Creates a system task to export the Data Warehouse Template to the Data…
      operationId: ExportToDataWarehouse
      parameters:
      - name: templateNo
        in: path
        description: ''
        required: true
        schema:
          type: string
      responses:
        '204':
          description: No Content
        '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'>DataWarehouseTemplate_Export</td><td style='border-bottom:none'>Function</td></tr></tbody></table>
        '500':
          description: The api has encountered an unhandled exception. See Sertica logs for details
      security:
      - Bearer: []
  /DataWarehouseAnalyticsTemplates/{templateNo}/resources:
    get:
      tags:
      - DataWarehouseAnalyticsTemplates
      summary: Fetches all Resources attached to the Data Warehouse Template
      operationId: GetDataWarehouseAnalyticsTemplateResources
      parameters:
      - name: templateNo
        in: path
        description: ''
        required: true
        schema:
          type: string
      responses:
        '200':
          description: OK
          content:
            text/plain:
              schema:
                type: array
                items:
                  $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplateResource'
            application/json:
              schema:
                type: array
                items:
                  $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplateResource'
            text/json:
              schema:
                type: array
                items:
                  $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplateResource'
        '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'>DataWarehouseTemplate</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: []
  /DataWarehouseAnalyticsTemplates/{templateNo}/roles:
    get:
      tags:
      - DataWarehouseAnalyticsTemplates
      summary: Fetches all Roles attached to the Data Warehouse Template
      operationId: GetDataWarehouseAnalyticsTemplateRoles
      parameters:
      - name: templateNo
        in: path
        description: ''
        required: true
        schema:
          type: string
      responses:
        '200':
          description: OK
          content:
            text/plain:
              schema:
                type: array
                items:
                  $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplateRole'
            application/json:
              schema:
                type: array
                items:
                  $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplateRole'
            text/json:
              schema:
                type: array
                items:
                  $ref: '#/components/schemas/SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplateRole'
        '401':
          description: If user is unauthorized
        '403':
          description: User must have one of these User R

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