How AI is applied across API Evangelist and APIs.io. Read my AI disclosure →
API Evangelist API Evangelist
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC

SERTICA Data Warehouse Analytics Templates API

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

SERTICA Data Warehouse Analytics Templates API is one of 254 APIs that SERTICA publishes on the APIs.io network, described by a machine-readable OpenAPI specification.

Tagged areas include DataWarehouseAnalyticsTemplates. The published artifact set on APIs.io includes an OpenAPI specification, API documentation, an API reference, and authentication docs.

This API exposes 17 operations across 14 paths, and defines 24 schemas. It is described by OpenAPI 3.2.0, at version v1.

Requests are made against a single base URL, /api.

17 operations 14 paths 24 schemas 1 DELETE9 GET6 POST1 PUT

Metadata

The identity and technical contract details declared by the specification.

Specification
OpenAPI 3.2.0
API Version
v1
Base URL
https://{sitename}.sertica.com/api
Authentication
HTTP Bearer
Resource Areas
1

Authentication & Security 1

SERTICA Data Warehouse Analytics Templates API declares 1 security scheme for authenticating requests. It accepts HTTP bearer tokens (Bearer).

  • Bearer — JWT Authorization header using the Bearer scheme

Paths & Operations 17

Across 14 paths, the API surfaces 17 operations — 1 DELETE, 9 GET, 6 POST, 1 PUT. Each is listed below with its method, path, parameters, and response codes.

DataWarehouseAnalyticsTemplates 17
GET
/DataWarehouseAnalyticsTemplates
Gets a list of DataWarehouseAnalyticsTemplate
GetDataWarehouseAnalyticsTemplates 2 params → 200401403500
POST
/DataWarehouseAnalyticsTemplates
Creates a new DataWarehouseAnalyticsTemplate record
CreateDataWarehouseTemplate body → 201400401403500
GET
/DataWarehouseAnalyticsTemplates/{templateNo}
Gets a specific DataWarehouseAnalyticsTemplate
GetDataWarehouseAnalyticsTemplate 1 param → 200400404401403500
PUT
/DataWarehouseAnalyticsTemplates/{templateNo}
Updates an existing DataWarehouseAnalyticsTemplate
UpdateDataWarehouseAnalyticsTemplate 1 param body → 200400401403500
DELETE
/DataWarehouseAnalyticsTemplates/{templateNo}
Deletes an DataWarehouseAnalyticsTemplate record
deleteDataWarehouseAnalyticsTemplatesByTemplateNo 1 param → 204400401403500
GET
/DataWarehouseAnalyticsTemplates/{templateNo}/history
Gets history for a specific DataWarehouseAnalyticsTemplate
GetDataWarehouseAnalyticsTemplateHistory 3 params → 200400404401403500
POST
/DataWarehouseAnalyticsTemplates/search
Search for DataWarehouseAnalyticsTemplate Takes a SearchDefinition input, which…
SearchDataWarehouseAnalyticsTemplate 2 params body → 200401403500
POST
/DataWarehouseAnalyticsTemplates/searchCount
Returns number of hits in a search for DataWarehouseAnalyticsTemplate Takes a…
SearchCountDataWarehouseAnalyticsTemplate body → 200401403500
POST
/DataWarehouseAnalyticsTemplates/searchIndex/{DataWarehouseTemplateGuid}
Get index of a record in a search for DataWarehouseAnalyticsTemplate Takes a…
SearchIndexDataWarehouseTemplate 2 params body → 200401403500
GET
/DataWarehouseAnalyticsTemplates/searchInfo
Returns structured information about what and how you can search for
SearchInfoDataWarehouseAnalyticsTemplate → 200500
GET
/DataWarehouseAnalyticsTemplates/{templateNo}/copy
Copies an existing DataWarehouseAnalyticsTemplate to a new object
CopyDataWarehouseAnalyticsTemplate 1 param → 200400401403500
POST
/DataWarehouseAnalyticsTemplates/{templateNo}/unlock
Unlock the DataWarehouse analytics Template
UnlockDataWarehouseAnalyticsTemplate 1 param → 204400401403500
GET
/DataWarehouseAnalyticsTemplates/{templateNo}/tasks
Get all DataWarehouse Analytics Template TS Tasks
GetDataWarehouseAnalyticsTemplateTsTasks 1 param → 200401403500
GET
/DataWarehouseAnalyticsTemplates/{templateNo}/tasks/{taskNo}
Get a DataWarehouse Analytics Template TS Task
GetDataWarehouseAnalyticsTemplateTsTask 2 params → 200401403500
POST
/DataWarehouseAnalyticsTemplates/{templateNo}/export
Creates a system task to export the Data Warehouse Template to the Data…
ExportToDataWarehouse 1 param → 204400401403500
GET
/DataWarehouseAnalyticsTemplates/{templateNo}/resources
Fetches all Resources attached to the Data Warehouse Template
GetDataWarehouseAnalyticsTemplateResources 1 param → 200401403500
GET
/DataWarehouseAnalyticsTemplates/{templateNo}/roles
Fetches all Roles attached to the Data Warehouse Template
GetDataWarehouseAnalyticsTemplateRoles 1 param → 200401403500

Schemas 24

The contract defines 24 schemas that model the data the API accepts and returns. The most detailed are SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplate (42 properties), SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplateTsTask (14 properties), SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplateResource (12 properties), SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplateRole (10 properties). Each schema is shown below with its type and property counts.

SerticaWebApi.Models.BrokenRuleType
string
SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplateResource
object
12 properties
Logihold.BusinessObjects.LogiholdObjModel.Search.SearchDataType
string
Logihold.BusinessObjects.LogiholdObjModel.SystemData_DataWarehouseExportFrequencyRecurrence
string
SerticaWebApi.Models.ValidationResult
object
4 properties
Logihold.BusinessObjects.LogiholdObjModel.Search.SearchInfoField
object
5 properties
Logihold.BusinessObjects.LogiholdObjModel.Search.SearchInfo
object
2 properties
Logihold.BusinessObjects.LogiholdObjModel.Search.ForDeviceRequest
object
4 properties
SerticaWebApi.Models.ErrorReason
object
2 properties
Logimatic.Analytics.Component.Model.TemplateType
string
SerticaWebApi.Models.Link
object
2 properties
Logihold.BusinessObjects.LogiholdObjModel.Search.ValuesMatching
string
SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplateRole
object
10 properties
SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplate
object
42 properties
Logihold.BusinessObjects.LogiholdObjModel.Search.SearchCriteria
object
4 properties
Logihold.BusinessObjects.LogiholdObjModel.Search.OrderBy
object
2 properties
Logihold.BusinessObjects.LogiholdObjModel.Search.SearchOperator
string
SerticaWebApi.Models.BrokenRule
object
7 properties
Logihold.BusinessObjects.LogiholdObjModel.Search.SearchDefinition
object
8 properties
Logihold.BusinessObjects.LogiholdObjModel.View.SortDirection
string
Logihold.BusinessObjects.LogiholdObjModel.SystemData_AnalyticsTemplateAvailableTo
string
Logihold.BusinessObjects.LogiholdObjModel.SystemData_DataWarehouseDataPersistence
string
Logihold.BusinessObjects.LogiholdObjModel.SystemData_TaskStatus
string
SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseAnalyticsTemplateTsTask
object
14 properties

Specification

The full machine-readable OpenAPI contract behind this narrative.

Source

sertica-datawarehouseanalyticstemplates-api-openapi.yml Raw ↑

Other APIs SERTICA publishes across the network.

SERTICA Accounting Dimensions API
SERTICA Accounting Dimensions Cache API
SERTICA Accounts API
SERTICA Activity Groups API
SERTICA Address Categories API
SERTICA Address Classifications API
SERTICA Addresses API
SERTICA AI Client API
SERTICA Analytics API
SERTICA Analytics Custom Menus API
SERTICA Analytics Custom Templates API
SERTICA Analytics Excel Templates API
Where this information came from

This is an independent, third-party profile of SERTICA Data Warehouse Analytics Templates API, published by API Evangelist. We do not operate, host, resell, or support these APIs, and we are not affiliated with or endorsed by the company unless stated above. Everything here is built from publicly available information — the company's own site, developer portal, documentation, public repositories, and the specifications it publishes for public use. Nothing is obtained by breaching a system, defeating an access control, or using credentials.

The Kin Score and Agent Readiness rating are independently calculated assessments of a company's public API artifacts, scored against a published rubric. They are not certifications, endorsements, security assessments, or audits.

Corrections, re-scores, and removal are free — no partnership or purchase required, and you do not need to justify the request. A removed company is recorded as unrated, never scored zero for having asked. Acknowledgement within one business day; removal within two.

info@apievangelist.com · Read the full data-sourcing policy →
On a security or compliance team? Put security in the subject line and you will get a person, not a form — we will tell you exactly which public URLs this profile was built from.