1. Overview

Microservice containing the business logic for retrival of information relevant to manufacturing execution

1.1. URI scheme

Host : localhost:41021
BasePath : /mesdata-service/

1.2. Tags

  • batch-data-controller : Batch Data Controller

  • historian-data-controller : Historian Data Controller

  • historians-controller : Historians Controller

  • historians-tag-data-controller : Historians Tag Data Controller

  • kpi-data-controller : KPI Data Controller

  • process-order-data-controller : Process Order Data Controller

  • product-data-controller : Product Data Controller

  • site-name-controller : Site Name Controller

  • tag-data-controller : Tag Data Controller

  • variable-data-controller : Variable Data Controller

2. Resources

2.1. Batch-data-controller

Batch Data Controller

2.1.1. To get site name

GET /mesdataservice/v1/batchdata
Parameters
Type Name Description Schema Default

Query

asset
optional

asset

string

Query

bom
optional

bom

integer (int64)

Query

departmentId
optional

departmentId

integer (int64)

Query

endTime
required

endTime

string (date-time)

Query

isGoldenBatch
optional

isGoldenBatch

boolean

"false"

Query

lineId
optional

lineId

integer (int64)

Query

name
optional

name

string

Query

pageNumber
optional

pageNumber

integer (int64)

1

Query

pageSize
optional

pageSize

integer (int64)

20

Query

product
optional

product

string

Query

quantity
optional

quantity

string

Query

sortCol
optional

sortCol

string

"Name"

Query

sortOrder
optional

sortOrder

string

"Asc"

Query

startTime
required

startTime

string (date-time)

Query

status
optional

status

string

Query

unitId
optional

unitId

integer (int64)

Responses
HTTP Code Description Schema

200

OK

BatchDetails

Produces
  • application/json;charset=UTF-8

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.1.2. To get site name

GET /mesdataservice/v1/batchdata/adjacentbatchdata
Parameters
Type Name Description Schema

Query

endTime
optional

endTime

string (date-time)

Query

eventId
required

eventId

integer (int64)

Query

startTime
optional

startTime

string (date-time)

Responses
HTTP Code Description Schema

200

OK

BatchDetails

Produces
  • application/json

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.1.3. To get site name

GET /mesdataservice/v1/batchdata/batchproducttraverse
Parameters
Type Name Description Schema Default

Query

endTime
optional

endTime

string (date-time)

Query

eventId
required

eventId

integer (int64)

Query

isIncremental
optional

isIncremental

integer (int64)

0

Query

nextOrPrevious
required

nextOrPrevious

string

Query

startTime
optional

startTime

string (date-time)

Responses
HTTP Code Description Schema

200

OK

BatchData

Produces
  • application/json;charset=UTF-8

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.1.4. To get site name

GET /mesdataservice/v1/batchdata/batchtraverse
Parameters
Type Name Description Schema Default

Query

endTime
optional

endTime

string (date-time)

Query

eventId
required

eventId

integer (int64)

Query

isIncremental
optional

isIncremental

integer (int64)

0

Query

nextOrPrevious
required

nextOrPrevious

string

Query

startTime
optional

startTime

string (date-time)

Responses
HTTP Code Description Schema

200

OK

BatchData

Produces
  • application/json;charset=UTF-8

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.1.5. This method is not of any use

GET /mesdataservice/v1/batchdata/{id}
Caution

operation.deprecated

Parameters
Type Name Description Schema

Path

id
required

id

integer (int64)

Responses
HTTP Code Description Schema

200

OK

object

Produces
  • /

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.2. Historian-data-controller

Historian Data Controller

2.2.1. Gets the list of configured historian server details

GET /mesdataservice/v1/historians
Responses
HTTP Code Description Schema

200

OK

< HistoriansInfo > array

Produces
  • application/json;charset=UTF-8

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.2.2. getHistorianRecord

DELETE /mesdataservice/v1/historians/{id}
Parameters
Type Name Description Schema

Path

id
required

id

integer (int64)

Responses
HTTP Code Description Schema

200

OK

object

Produces
  • /

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.3. Historians-controller

Historians Controller

2.3.1. Create historian Alias

POST /mesdataservice/v1/plantapp/historian
Parameters
Type Name Description Schema

Body

aliasName
optional

Historian details

AliasName

Responses
HTTP Code Description Schema

200

OK

AliasNameResource

201

Created

AliasNameResource

400

Bad request

No Content

401

Unauthorized

No Content

500

Internal Server Error

No Content

503

Gateway timeout or Service Unavailable

No Content

Consumes
  • application/json

Produces
  • application/json

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.3.2. Get historians in pageable format

GET /mesdataservice/v1/plantapp/historian
Parameters
Type Name Description Schema Default

Query

page
optional

Page number to return 0 to N.

integer (int32)

0

Query

size
optional

Number of resources to return per page.

integer (int32)

20

Responses
HTTP Code Description Schema

200

Success

HistorianPage

400

Bad request

No Content

401

Unauthorized

No Content

500

Internal Server Error

No Content

503

Gateway timeout or Service Unavailable

No Content

Produces
  • application/json

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.3.3. Get historian based on Id

GET /mesdataservice/v1/plantapp/historian/{id}
Parameters
Type Name Description Schema

Path

id
required

Historian id

integer (int64)

Responses
HTTP Code Description Schema

200

Success

Historian

400

Bad request

No Content

401

Unauthorized

No Content

500

Internal Server Error

No Content

503

Gateway timeout or Service Unavailable

No Content

Produces
  • application/json

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.3.4. Update historian

PUT /mesdataservice/v1/plantapp/historian/{id}
Parameters
Type Name Description Schema

Path

id
required

Historian id

integer (int32)

Body

historianInfo
optional

Historian details

HistorianInfo

Responses
HTTP Code Description Schema

200

Success

HistorianInfoResource

400

Bad request

No Content

401

Unauthorized

No Content

422

Unprocessable Entity

No Content

500

Internal Server Error

No Content

503

Gateway timeout or Service Unavailable

No Content

Consumes
  • application/json

Produces
  • application/json

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.3.5. Delete Specific Historian

DELETE /mesdataservice/v1/plantapp/historian/{id}
Parameters
Type Name Description Schema

Path

id
required

Historian id

integer (int32)

Responses
HTTP Code Description Schema

200

OK

DeleteHistorianResource

202

Accepted

DeleteHistorianResource

400

Bad request

No Content

401

Unauthorized

No Content

422

Unprocessable Entity

No Content

500

Internal Server Error

No Content

503

Gateway timeout or Service Unavailable

No Content

Produces
  • application/json

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.3.6. Get historian options

GET /mesdataservice/v1/plantapp/historian/{id}/options
Parameters
Type Name Description Schema

Path

id
required

Historian id

integer (int32)

Responses
HTTP Code Description Schema

200

Success

HistorianOptionResource

400

Bad request

No Content

401

Unauthorized

No Content

422

Unprocessable Entity

No Content

500

Internal Server Error

No Content

503

Gateway timeout or Service Unavailable

No Content

Produces
  • application/json

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.3.7. Get historians with os list and historian type list

GET /mesdataservice/v1/plantapp/historians
Responses
HTTP Code Description Schema

200

Success

Historians

400

Bad request

No Content

401

Unauthorized

No Content

500

Internal Server Error

No Content

503

Gateway timeout or Service Unavailable

No Content

Produces
  • application/json

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.3.8. Get historian type

GET /mesdataservice/v1/plantapp/historiantypes
Parameters
Type Name Description Schema Default

Query

page
optional

Page number to return 0 to N.

integer (int32)

0

Query

size
optional

Number of resources to return per page.

integer (int32)

20

Responses
HTTP Code Description Schema

200

Success

HistorianTypePage

400

Bad request

No Content

401

Unauthorized

No Content

500

Internal Server Error

No Content

503

Gateway timeout or Service Unavailable

No Content

Produces
  • application/json

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.3.9. Get operating system list

GET /mesdataservice/v1/plantapp/operatingsystems
Parameters
Type Name Description Schema Default

Query

page
optional

Page number to return 0 to N.

integer (int32)

0

Query

size
optional

Number of resources to return per page.

integer (int32)

20

Responses
HTTP Code Description Schema

200

Success

OperatingSystemPage

400

Bad request

No Content

401

Unauthorized

No Content

500

Internal Server Error

No Content

503

Gateway timeout or Service Unavailable

No Content

Produces
  • application/json

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.4. Historians-tag-data-controller

Historians Tag Data Controller

2.4.1. Gets Data points for the tag names specified from particular historian server based on the request parameters

GET /v1/historianTagsDataPoints
Parameters
Type Name Description Schema

Query

calculationMode
optional

This parameter is only applied if the Sampling Mode is set to Calculated. It represents the type of calculation to use on the archive data.

enum (Average, StandardDeviation, Total, Minimum, Maximum, Count, RawAverage, RawStandardDeviation, RawTotal, MinimumTime, MaximumTime, TimeGood, StateCount, StateTime, OPCAnd, OPCOr, FirstRawValue, FirstRawTime, LastRawValue, LastRawTime, TagStats)

Query

dataPointType
required

Data point type end point which needs to be queried from Historian Service

enum (raw, interpolated, currentvalue, calculated, sampled)

Query

direction
optional

Specifies the direction (Forward (0) or Backward (1) from the starting time) of data sampling from the archive.

integer (int32)

Query

endTime
optional

End time in ISO 8601 format (yyyy-MM-dd’T’HH:mm:ss.SSSZ)

string (date-time)

Query

historianServerName
required

Historian Service host name as configured in the service

string

Query

intervalMS
optional

Interval in milliseconds.

integer (int32)

Query

sampleCount
optional

Count of archive values within each calculation interval.

integer (int32)

Query

samplingMode
optional

The SamplingModeType parameter is the mode of sampling data from the archive.

enum (CurrentValue, Interpolated, Trend, RawByTime, RawByNumber, Calculated, Lab, InterpolatedToRaw, TrendToRaw, LabToRaw, RawByFilterToggling)

Query

startTime
optional

Start time in ISO 8601 format (yyyy-MM-dd’T’HH:mm:ss.SSSZ)

string (date-time)

Query

tagNames
required

Historians tag name. Multiple tag names are separated by semicolons (;). Also supports wildcard character (*) in the name

string

Responses
HTTP Code Description Schema

200

OK

< HistorianTagData«TagDataPoint«int»» > array

400

Bad Request, request parameters not valid. See message for details

HttpErrorResponse

500

Internal Server error, error occurred while communicating to Historian. See message for details

HttpErrorResponse

Produces
  • application/json;charset=UTF-8

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.4.2. Gets Trend Data points for the tag names specified from particular historian server based on the request parameters

GET /v1/historianTagsTrendDataPoints
Parameters
Type Name Description Schema

Query

calculationMode
optional

This parameter is only applied if the Sampling Mode is set to Calculated. It represents the type of calculation to use on the archive data.

enum (Average, StandardDeviation, Total, Minimum, Maximum, Count, RawAverage, RawStandardDeviation, RawTotal, MinimumTime, MaximumTime, TimeGood, StateCount, StateTime, OPCAnd, OPCOr, FirstRawValue, FirstRawTime, LastRawValue, LastRawTime, TagStats)

Query

direction
optional

Specifies the direction (Forward (0) or Backward (1) from the starting time) of data sampling from the archive.

integer (int32)

Query

endTime
required

End time in ISO 8601 format (yyyy-MM-dd’T’HH:mm:ss.SSSZ)

string (date-time)

Query

historianServerName
required

Historian Service host name as configured in the service

string

Query

intervalMS
optional

Interval in milliseconds.

integer (int32)

Query

sampleCount
optional

Count of archive values within each calculation interval.

integer (int32)

Query

samplingMode
required

The SamplingModeType parameter is the mode of sampling data from the archive.

enum (CurrentValue, Interpolated, Trend, RawByTime, RawByNumber, Calculated, Lab, InterpolatedToRaw, TrendToRaw, LabToRaw, RawByFilterToggling)

Query

startTime
required

Start time in ISO 8601 format (yyyy-MM-dd’T’HH:mm:ss.SSSZ)

string (date-time)

Query

tagNames
required

Historians tag name. Multiple tag names are separated by semicolons (;). Also supports wildcard character (*) in the name

string

Responses
HTTP Code Description Schema

200

OK

< HistorianTagData«List«TagDataPoint«boolean»»» > array

400

Bad Request, request parameters not valid. See message for details

HttpErrorResponse

500

Internal Server error, error occurred while communicating to Historian. See message for details

HttpErrorResponse

Produces
  • application/json;charset=UTF-8

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.5. Kpi-data-controller

KPI Data Controller

2.5.1. getKPI

GET /mesdataservice/v1/KPI
Parameters
Type Name Description Schema Default

Query

asset
optional

asset

string

Query

interval
optional

interval

string

Query

lineDescription
optional

lineDescription

string

Query

lineId
optional

lineId

integer (int64)

Query

name
optional

name

string

Query

oEEType
optional

oEEType

string

Query

pageNumber
optional

pageNumber

integer (int64)

1

Query

pageSize
optional

pageSize

integer (int64)

20

Query

sortCol
optional

sortCol

string

"Name"

Query

sortOrder
optional

sortOrder

string

"Asc"

Query

unitId
optional

unitId

integer (int64)

Responses
HTTP Code Description Schema

200

OK

object

Produces
  • /

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.5.2. getKPIData

GET /mesdataservice/v1/KPIData
Parameters
Type Name Description Schema Default

Query

endTime
required

endTime

string (date-time)

Query

inputId
required

inputId

integer (int64)

Query

isIncremental
optional

isIncremental

integer (int64)

0

Query

kpiType
required

kpiType

string

Query

level
required

level

string

Query

startTime
required

startTime

string (date-time)

Responses
HTTP Code Description Schema

200

OK

object

Produces
  • /

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.6. Process-order-data-controller

Process Order Data Controller

2.6.1. getProcessOrderData

GET /mesdataservice/v1/processorder
Parameters
Type Name Description Schema Default

Query

asset
optional

asset

string

Query

bom
optional

bom

integer (int64)

Query

departmentId
optional

departmentId

integer (int64)

Query

endTime
required

endTime

string (date-time)

Query

lineId
optional

lineId

integer (int64)

Query

name
optional

name

string

Query

pageNumber
optional

pageNumber

integer (int64)

1

Query

pageSize
optional

pageSize

integer (int64)

20

Query

product
optional

product

string

Query

quantity
optional

quantity

string

Query

sortCol
optional

sortCol

string

"Name"

Query

sortOrder
optional

sortOrder

string

"Asc"

Query

startTime
required

startTime

string (date-time)

Query

status
optional

status

string

Query

unitId
optional

unitId

integer (int64)

Responses
HTTP Code Description Schema

200

OK

object

Produces
  • application/json;charset=UTF-8

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.6.2. getProcessOrderVariableSpecificationLimit

GET /mesdataservice/v1/processorder/ProcessOrderVariableSpecificationLimit
Parameters
Type Name Description Schema Default

Query

endTime
required

endTime

string (date-time)

Query

isLive
optional

isLive

boolean

"false"

Query

startTime
required

startTime

string (date-time)

Query

variable
required

variable

integer (int64)

Responses
HTTP Code Description Schema

200

OK

object

Produces
  • application/json;charset=UTF-8

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.6.3. getAdjacentProcessOrderData

GET /mesdataservice/v1/processorder/adjacentprocessorderdata
Parameters
Type Name Description Schema

Query

endTime
optional

endTime

string (date-time)

Query

productionPlanStartId
required

productionPlanStartId

integer (int64)

Query

startTime
optional

startTime

string (date-time)

Responses
HTTP Code Description Schema

200

OK

object

Produces
  • /

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.6.4. getProcressOrderProductData

GET /mesdataservice/v1/processorder/adjecentProcessOrderProduct
Parameters
Type Name Description Schema Default

Query

endTime
optional

endTime

string (date-time)

Query

isIncremental
optional

isIncremental

integer (int64)

0

Query

productionPlanStartId
required

productionPlanStartId

integer (int64)

Query

startTime
optional

startTime

string (date-time)

Responses
HTTP Code Description Schema

200

OK

object

Produces
  • application/json;charset=UTF-8

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.6.5. getProcessOrderProductTraverse

GET /mesdataservice/v1/processorder/processOrderProductTraverse
Parameters
Type Name Description Schema Default

Query

endTime
optional

endTime

string (date-time)

Query

isIncremental
optional

isIncremental

integer (int64)

0

Query

nextOrPrevious
required

nextOrPrevious

string

Query

productionPlanStartId
required

productionPlanStartId

integer (int64)

Query

startTime
optional

startTime

string (date-time)

Responses
HTTP Code Description Schema

200

OK

object

Produces
  • application/json;charset=UTF-8

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.6.6. getNextOrPreviousProcessOrder

GET /mesdataservice/v1/processorder/processordertraverse
Parameters
Type Name Description Schema Default

Query

endTime
optional

endTime

string (date-time)

Query

isIncremental
optional

isIncremental

integer (int64)

0

Query

nextOrPrevious
required

nextOrPrevious

string

Query

productionPlanStartId
required

productionPlanStartId

integer (int64)

Query

startTime
optional

startTime

string (date-time)

Responses
HTTP Code Description Schema

200

OK

object

Produces
  • application/json;charset=UTF-8

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.6.7. getProcessOrderRecord

DELETE /mesdataservice/v1/processorder/{id}
Parameters
Type Name Description Schema

Path

id
required

id

integer (int64)

Responses
HTTP Code Description Schema

200

OK

object

Produces
  • /

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.7. Product-data-controller

Product Data Controller

2.7.1. getProductData

GET /mesdataservice/v1/products
Parameters
Type Name Description Schema Default

Query

endTime
optional

endTime

string (date-time)

Query

event
required

event

integer (int64)

Query

isIncremental
optional

isIncremental

integer (int64)

0

Query

startTime
optional

startTime

string (date-time)

Responses
HTTP Code Description Schema

200

OK

object

Produces
  • application/json;charset=UTF-8

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.8. Site-name-controller

Site Name Controller

2.8.1. To get site name

GET /mesdataservice/v1/sitename
Responses
HTTP Code Description Schema

200

OK

SiteName

Produces
  • /

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.9. Tag-data-controller

Tag Data Controller

2.9.1. getTagsBasedOnCriteria

GET /mesdataservice/v1/tags
Parameters
Type Name Description Schema Default

Query

aliasName
optional

aliasName

string

"abc"

Query

asset
optional

asset

string

Query

dataSource
optional

dataSource

string

"abc"

Query

dataType
optional

dataType

string

Query

departmentId
optional

departmentId

integer (int64)

Query

interval
optional

interval

string

Query

lineId
optional

lineId

integer (int64)

Query

pageNumber
optional

pageNumber

integer (int64)

1

Query

pageSize
optional

pageSize

integer (int64)

10

Query

sampleType
optional

sampleType

string

Query

sortCol
optional

sortCol

string

"Name"

Query

sortOrder
optional

sortOrder

string

"Asc"

Query

tagDescription
optional

tagDescription

string

Query

tagName
optional

tagName

string

Query

unitId
optional

unitId

integer (int64)

Query

variableGroupId
optional

variableGroupId

integer (int64)

Query

variables
optional

variables

string

Responses
HTTP Code Description Schema

200

OK

object

Produces
  • application/json;charset=UTF-8

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.9.2. getTagRecord

DELETE /mesdataservice/v1/tags/{id}
Parameters
Type Name Description Schema

Path

id
required

id

integer (int64)

Responses
HTTP Code Description Schema

200

OK

object

Produces
  • /

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.10. Variable-data-controller

Variable Data Controller

2.10.1. Get SPC Chart Data by variable id

GET /mesdataservice/v1/variabledata
Parameters
Type Name Description Schema

Query

endTime
required

endTime

string (date-time)

Query

lastKnownValue
optional

Flag to tell the api to fetch the latest test record(as per the result_on column of Tests table) within the start and end time supplied.
This would take precedence over resultOn parameter.

boolean

Query

plotFor
optional

Introduced to support spc

string

Query

resultOn
optional

result_on column value of tests table

string (date-time)

Query

startTime
required

startTime

string (date-time)

Query

variable
required

var_id from tests table

integer (int64)

Responses
HTTP Code Description Schema

200

OK

VariableData

Produces
  • application/json;charset=UTF-8

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.10.2. Get Variable specification limit within a time range

GET /mesdataservice/v1/variabledata/VariableSpecificationLimit
Parameters
Type Name Description Schema Default

Query

endTime
required

endTime

string (date-time)

Query

isLive
optional

isLive

boolean

"false"

Query

startTime
required

startTime

string (date-time)

Query

variable
required

variable

integer (int64)

Responses
HTTP Code Description Schema

200

OK

VariableSpecificationLimit

Produces
  • application/json;charset=UTF-8

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.10.3. Comparison Operators

GET /mesdataservice/v1/variabledata/comparisonoperators
Responses
HTTP Code Description Schema

200

Success

ComparisonOperatorsData

400

Bad request

No Content

401

Unauthorized

No Content

500

Internal Server Error

No Content

503

Gateway timeout or Service Unavailable

No Content

Produces
  • application/json;charset=UTF-8

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.10.4. Data_Source

GET /mesdataservice/v1/variabledata/datasource
Responses
HTTP Code Description Schema

200

Success

DataSourceValues

400

Bad request

No Content

401

Unauthorized

No Content

500

Internal Server Error

No Content

503

Gateway timeout or Service Unavailable

No Content

Produces
  • application/json;charset=UTF-8

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.10.5. Sampling Type

GET /mesdataservice/v1/variabledata/samplingtype
Responses
HTTP Code Description Schema

200

Success

SamplingTypes

400

Bad request

No Content

401

Unauthorized

No Content

500

Internal Server Error

No Content

503

Gateway timeout or Service Unavailable

No Content

Produces
  • application/json;charset=UTF-8

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.10.6. Search variables based on input parameters

GET /mesdataservice/v1/variabledata/variables
Parameters
Type Name Description Schema Default

Query

asset
optional

asset

string

Query

departmentId
optional

departmentId

integer (int64)

Query

interval
optional

interval

string

Query

lineId
optional

lineId

integer (int64)

Query

name
optional

name

string

Query

pageNumber
optional

pageNumber

integer (int64)

1

Query

pageSize
optional

pageSize

integer (int64)

20

Query

sample
optional

sample

string

Query

sortCol
optional

sortCol

string

"Name"

Query

sortOrder
optional

sortOrder

string

"Asc"

Query

source
optional

source

string

Query

tagIn
optional

tagIn

string

Query

tagOut
optional

tagOut

string

Query

type
optional

type

string

Query

unitId
optional

unitId

integer (int64)

Query

varGroupId
optional

varGroupId

integer (int64)

Query

variableIds
optional

variableIds

< integer (int64) > array(multi)

Responses
HTTP Code Description Schema

200

OK

VariableSearchDetails

Produces
  • application/json;charset=UTF-8

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

2.10.7. Get SPC Chart Data by variable id

GET /mesdataservice/v1/variabledata/{variableId}
Parameters
Type Name Description Schema Default

Path

variableId
required

Selected variable to report on

integer (int64)

Query

direction
optional

Direction for NoD query from End Time. 0 = Forward; 1 = Backwards (Default)

integer (int32)

1

Query

endTime
optional

End time of report range if time range filter selected or reference point if NoD selected

string (date-time)

Query

numberOfSamplePoints
optional

Number of data (NoD) points if NoD filter selected, data will be selected for based on NoD from the specified End Time

integer (int64)

0

Query

startTime
optional

Start time of report range if time range filter selected

string (date-time)

Responses
HTTP Code Description Schema

200

Success

WsSPCVariableData

400

Bad request

No Content

401

Unauthorized

No Content

500

Internal Server Error

No Content

503

Gateway timeout or Service Unavailable

No Content

Produces
  • application/json;charset=UTF-8

Security
Type Name Scopes

oauth2

access_token

default

oauth2

client_creds

default

oauth2

resource_owner

default

oauth2

implicit_grant

default

3. Definitions

3.1. AliasName

Name Schema

aliasName
optional

string

id
optional
read-only

integer (int32)

3.2. AliasNameResource

Name Schema

aliasName
optional

string

id
optional
read-only

integer (int32)

links
optional

< Link > array

3.3. BatchData

Name Schema

batchDetails
optional

BatchInfo

id
optional

integer (int64)

productionDetails
optional

ProductionInfo

3.4. BatchDetails

Name Schema

content
optional

< EntityModel«BatchData» > array

filterData
optional

BatchFilterData

id
optional

integer (int64)

page
optional

Page

3.5. BatchFilterData

Name Schema

asset
optional

< IdNameValue > array

product
optional

< IdNameValue > array

status
optional

< IdNameValue > array

3.6. BatchInfo

Name Schema

batch
optional

IdNameValue

bom
optional

integer (int32)

endTime
optional

string (date-time)

goldenBatchId
optional

integer (int64)

id
optional

integer (int64)

quantity
optional

number (double)

startTime
optional

string (date-time)

status
optional

IdNameValue

uom
optional

string

utcTimeStamp
optional

Timestamp

3.7. ComparisonOperators

Name Schema

comparisonOperatorId
optional

integer (int64)

comparisonOperatorValue
optional

string

stringComparisonOperatorSQL
optional

string

stringComparisonOperatorsVB
optional

string

3.8. ComparisonOperatorsData

Name Schema

comparisonOperatorsData
optional

< ComparisonOperators > array

3.9. DataSource

Name Schema

clientId
optional

string

clientSecret
optional

string

port
optional

string

serverName
optional

string

source
optional

string

uaaOrigin
optional

string

uaaPort
optional

string

3.10. DataSourceInfo

Name Schema

active
optional

integer (int32)

bulkImport
optional

integer (int32)

dsDesc
optional

string

dsId
optional

integer (int64)

3.11. DataSourceValues

Name Schema

dataSourceInfo
optional

< DataSourceInfo > array

3.12. DataValue

Name Schema

quality
optional

boolean

testId
optional

integer (int64)

timeStamp
optional

string (date-time)

value
optional

string

3.13. DeleteHistorianResource

Name Schema

links
optional

< Link > array

3.14. EntityModel«BatchData»

Name Schema

batchDetails
optional

BatchInfo

id
optional

integer (int64)

links
optional

< Link > array

productionDetails
optional

ProductionInfo

3.15. EntityModel«VariableDetails»

Name Schema

dataSource
optional

IdNameValue

dataType
optional

IdNameValue

department
optional

IdNameValue

engUnits
optional

string

eventType
optional

integer (int32)

group
optional

IdNameValue

inputTag
optional

string

interval
optional

integer (int64)

line
optional

IdNameValue

links
optional

< Link > array

outputTag
optional

string

type
optional

IdNameValue

unit
optional

IdNameValue

userDefinedDesc1
optional

string

userDefinedDesc2
optional

string

userDefinedDesc3
optional

string

variable
optional

IdNameValue

3.16. Error

Name Schema

code
optional

string

details
optional

object

3.17. FilterData

Name Schema

asset
optional

< IdNameValue > array

dataSource
optional

< IdNameValue > array

dataType
optional

< IdNameValue > array

interval
optional

< IdNameValue > array

samplingType
optional

< IdNameValue > array

variable
optional

< IdNameValue > array

3.18. Historian

Name Schema

active
optional

boolean

alias
optional

string

histDefault
optional

boolean

histId
optional

integer (int64)

histPassword
optional

string

histPassword2
optional

string

histServername
optional

string

histTypeDesc
optional

string

histTypeDllName
optional

string

histTypeId
optional

integer (int64)

histUsername
optional

string

osDesc
optional

string

osId
optional

integer (int64)

remote
optional

boolean

3.19. HistorianInfo

Name Schema

active
optional

boolean

alias
optional

string

histDefault
optional

boolean

histPassword
optional

string

histServername
optional

string

histTypeId
optional

integer (int32)

histUsername
optional

string

id
optional
read-only

integer (int32)

osId
optional

integer (int32)

remote
optional

boolean

3.20. HistorianInfoResource

Name Schema

active
optional

boolean

alias
optional

string

histDefault
optional

boolean

histPassword
optional

string

histServername
optional

string

histTypeId
optional

integer (int32)

histUsername
optional

string

id
optional
read-only

integer (int32)

links
optional

< Link > array

osId
optional

integer (int32)

remote
optional

boolean

3.21. HistorianOptionData

Name Schema

fieldTypeDesc
optional

string

fieldTypeId
optional

integer (int64)

histOptionDesc
optional

string

histOptionId
optional

integer (int64)

spLookup
optional

integer (int64)

storeId
optional

integer (int64)

value
optional

string

valueText
optional

string

3.22. HistorianOptionInfo

Name Schema

active
optional

boolean

alias
optional

string

remote
optional

boolean

3.23. HistorianOptionResource

Name Schema

historianOptionData
optional

< HistorianOptionData > array

historianOptionInfo
optional

< HistorianOptionInfo > array

links
optional

< Link > array

3.24. HistorianPage

Name Schema

content
optional

< HistorianResource > array

links
optional

< Link > array

page
optional

PageMetadata

3.25. HistorianResource

Name Schema

active
optional

boolean

alias
optional

string

histDefault
optional

boolean

histId
optional

integer (int64)

histPassword
optional

string

histPassword2
optional

string

histServername
optional

string

histTypeDesc
optional

string

histTypeDllName
optional

string

histTypeId
optional

integer (int64)

histUsername
optional

string

links
optional

< Link > array

osDesc
optional

string

osId
optional

integer (int64)

remote
optional

boolean

3.26. HistorianTagData«List«TagDataPoint«boolean»»»

Encapsulates the Tag specific properties and data

Name Description Schema

dataType
optional

Data type of this tag

string

errorCode
optional

Error code if any as given from Historian service, 0 mean success

integer (int32)

tagDataPoints
optional

Data points for this tag

< < TagDataPoint«boolean» > array > array

tagName
optional

The name of the Historian Tag

string

3.27. HistorianTagData«TagDataPoint«int»»

Encapsulates the Tag specific properties and data

Name Description Schema

dataType
optional

Data type of this tag

string

errorCode
optional

Error code if any as given from Historian service, 0 mean success

integer (int32)

tagDataPoints
optional

Data points for this tag

< TagDataPoint«int» > array

tagName
optional

The name of the Historian Tag

string

3.28. HistorianTypePage

Name Schema

content
optional

< HistorianTypeResource > array

links
optional

< Link > array

page
optional

PageMetadata

3.29. HistorianTypeResource

Name Schema

histTypeDesc
optional

string

histTypeDllName
optional

string

histTypeId
optional

integer (int64)

links
optional

< Link > array

3.30. HistorianTypes

Name Schema

histTypeDesc
optional

string

histTypeDllName
optional

string

histTypeId
optional

integer (int64)

3.31. Historians

Name Schema

historianList
optional

< Historian > array

historianTypeList
optional

< HistorianTypes > array

operatingSystemList
optional

< OperatingSystems > array

3.32. HistoriansInfo

Name Schema

alias
optional

string

dataSource
optional

DataSource

isDefault
optional

boolean

serverName
optional

string

3.33. HttpErrorResponse

Name Schema

error
optional

Error

path
optional

string

timestamp
optional

string

3.34. IdNameValue

Name Schema

id
optional

integer (int64)

name
optional

string

Name Schema

deprecation
optional

string

href
optional

string

hreflang
optional

string

media
optional

string

name
optional

string

profile
optional

string

rel
optional

string

template
optional

UriTemplate

templated
optional

boolean

title
optional

string

type
optional

string

3.36. OperatingSystemPage

Name Schema

content
optional

< OperatingSystemResource > array

links
optional

< Link > array

page
optional

PageMetadata

3.37. OperatingSystemResource

Name Schema

links
optional

< Link > array

osDesc
optional

string

osId
optional

integer (int64)

3.38. OperatingSystems

Name Schema

osDesc
optional

string

osId
optional

integer (int64)

3.39. Page

Name Schema

pageNumber
optional

integer (int64)

pageSize
optional

integer (int64)

totalElements
optional

integer (int64)

totalPages
optional

integer (int64)

3.40. PageMetadata

Name Schema

number
optional

integer (int64)

size
optional

integer (int64)

totalElements
optional

integer (int64)

totalPages
optional

integer (int64)

3.41. ProductionInfo

Name Schema

department
optional

IdNameValue

endTime
optional

string (date-time)

id
optional

integer (int64)

isAppliedProduct
optional

integer (int64)

line
optional

IdNameValue

product
optional

IdNameValue

productUTCTimeStamp
optional

Timestamp

startTime
optional

string (date-time)

status
optional

string

unit
optional

IdNameValue

3.42. SamplingType

Name Schema

stDesc
optional

string

stId
optional

integer (int64)

3.43. SamplingTypes

Name Schema

samplingTypesData
optional

< SamplingType > array

3.44. SiteName

Name Schema

batchOrProcessOrder
optional

string

siteName
optional

string

3.45. TagDataPoint«boolean»

Data for a tag at a point of time as recieved from Historian Service

Name Description Schema

quality
optional

Quality of the value. This can be Bad(0), Uncertain(1), NA(2) or Good(3)
Example : false

boolean

timeStamp
optional

Time when this data point is taken

string (date-time)

value
optional

Value of the Tag at a particular time

object

3.46. TagDataPoint«int»

Data for a tag at a point of time as recieved from Historian Service

Name Description Schema

quality
optional

Quality of the value. This can be Bad(0), Uncertain(1), NA(2) or Good(3)

integer (int32)

timeStamp
optional

Time when this data point is taken

string (date-time)

value
optional

Value of the Tag at a particular time

object

3.47. TemplateVariable

Name Schema

description
optional

string

name
optional

string

type
optional

enum (, ?, &, /, #, *)

3.48. TemplateVariables

Type : object

3.49. Timestamp

Name Schema

date
optional

integer (int32)

day
optional

integer (int32)

hours
optional

integer (int32)

minutes
optional

integer (int32)

month
optional

integer (int32)

nanos
optional

integer (int32)

seconds
optional

integer (int32)

time
optional

integer (int64)

timezoneOffset
optional

integer (int32)

year
optional

integer (int32)

3.50. UriTemplate

Name Schema

variableNames
optional

< string > array

variables
optional

TemplateVariables

3.51. VariableData

Name Schema

data
optional

< DataValue > array

variable
optional

integer (int64)

variableDescription
optional

string

3.52. VariableDetails

Name Schema

dataSource
optional

IdNameValue

dataType
optional

IdNameValue

department
optional

IdNameValue

engUnits
optional

string

eventType
optional

integer (int32)

group
optional

IdNameValue

inputTag
optional

string

interval
optional

integer (int64)

line
optional

IdNameValue

outputTag
optional

string

type
optional

IdNameValue

unit
optional

IdNameValue

userDefinedDesc1
optional

string

userDefinedDesc2
optional

string

userDefinedDesc3
optional

string

variable
optional

IdNameValue

3.53. VariableSearchDetails

Name Schema

content
optional

< EntityModel«VariableDetails» > array

filterData
optional

FilterData

id
optional

integer (int64)

page
optional

Page

3.54. VariableSpecificationLimit

Name Schema

lowerControl
optional

string

lowerEntry
optional

string

lowerReject
optional

string

lowerUser
optional

string

lowerWarning
optional

string

product
optional

integer (int64)

productDescription
optional

string

startTime
optional

string (date-time)

target
optional

string

targetControl
optional

string

upperControl
optional

string

upperEntry
optional

string

upperReject
optional

string

upperUser
optional

string

upperWarning
optional

string

variable
optional

integer (int64)

3.55. WsSPCCriteriaSummary

Name Schema

hyperlink
optional

string

id
optional

integer (int64)

name
optional

string

value
optional

string

valueParameter
optional

string

3.56. WsSPCProductRunning

Name Description Schema

isBasisProduct
optional

boolean

prodCode
optional

Product code

string

rawValue
optional

number (double)

subgroupId
optional

Property is used for internal calculation inside store proc

integer (int64)

timestamp
optional

Result_On value of tests table

string (date-time)

value
optional

Variable data value(Result) from tests table

string

xid
optional

Identity column

integer (int64)

3.57. WsSPCStatistics

Name Description Schema

promptId
optional

Identity column

integer (int64)

promptName
optional

Hold information like: CriteriaSummary, ControlChart, Average, Maximum, ProcessMaximum, ProcessMinimum, Zlsl

string

promptValue
optional

string

promptValueParameter
optional

string

promptValueParameter2
optional

string

promptValueParameter3
optional

string

promptValueParameter4
optional

string

3.58. WsSPCStatistics2

Name Description Schema

average
optional

Average of subgroups

number (float)

cp
optional

Cp is Process Capability. The SPC Cp measurement shows how well the Six Sigma range fits into the specification range

number (float)

cpk
optional

Cpk stands for Process Capability Index. The SPC Cpk measurement shows the relationship of the Six Sigma spread to the specification limits.

number (float)

cpm
optional

Six Sigma Material. Cpm is a Process Capability Index

number (float)

cr
optional

Capability Ratio

number (float)

estimatedSigma
optional

number (float)

lcl
optional

Lower Control Specification Limit

number (float)

lsl
optional

Lower Reject Specification Limit

number (float)

maximum
optional

Maximum subgroup value

number (float)

mininmum
optional

Minimum subgroup value

number (float)

numberOfPoints
optional

Number to sample points for calculation

number (float)

pp
optional

PP (also written as PK) stands for Process Performance

number (float)

ppk
optional

PPK means Process Performance Index

number (float)

processMaximum
optional

Maximum of individuals

number (float)

processMean
optional

Average of individuals

number (float)

processMinimum
optional

Minimum of individuals

number (float)

prodDesc
optional

Product Description of a Running Product

string

prodId
optional

Product Id of a Running Product

integer (int64)

runId
optional

Identity column

integer (int64)

sigma
optional

Standard Deviation of individuals

number (float)

target
optional

Target Specification

number (float)

ucl
optional

Upper Control Specification Limit

number (float)

usl
optional

Upper Reject Specification Limit

number (float)

zlsl
optional

Number of sigmas, the LSL is away from the mean

number (float)

zt
optional

number (float)

zusl
optional

Number of sigmas, the USL is away from the mean

number (float)

3.59. WsSPCVariableChartInfo

Name Description Schema

alarm
optional

integer (int32)

dataPointText
optional

Alarm related description

string

mr
optional

Moving Range value of SPC variable

number (float)

mrscl
optional

Calculated Control (Target Control) Specification Limit for SPC calculation type

number (float)

mrslcl
optional

Calculated Lower Control Specification Limit for SPC calculation type

number (float)

mrslsl
optional

Lower Reject Specification Limit for SPC calculation type

number (float)

mrslul
optional

Lower User Specification Limit for SPC calculation type

number (float)

mrslwl
optional

Lower Warning Specification Limit for SPC calculation type

number (float)

mrsucl
optional

Calculated Upper Control Specification Limit for SPC calculation type

number (float)

mrsusl
optional

Upper Reject Specification Limit for SPC calculation type

number (float)

mrsuul
optional

Upper User Specification Limit for SPC calculation type

number (float)

mrsuwl
optional

Upper Warning Specification Limit for SPC calculation type

number (float)

pchart
optional

number (float)

r
optional

Range value of SPC variable

number (float)

result
optional

Variable data value(Result) from tests table

string

s
optional

Standard Deviation of SPC variable

number (float)

subgroupId
optional

Identity column

integer (int64)

timestamp
optional

Result_On value from tests table

string (date-time)

uchart
optional

number (float)

xcl
optional

Calculated Control Specification Limit

number (float)

xlcl
optional

Calculated Lower Control Specification Limit

number (float)

xlsl
optional

Calculated Lower Reject Specification Limit(LSL) based on GoodValueMin

number (float)

xlul
optional

Lower User Specification Limit

number (float)

xlwl
optional

Lower Warning Specification Limit

number (float)

xucl
optional

Calculated Uppder Control Specification Limit

number (float)

xusl
optional

Calculated Upper Reject Specification Limit(USL) based on GoodValueMax

number (float)

xuul
optional

Upper User Specification Limit

number (float)

xuwl
optional

Upper Warning Specification Limit

number (float)

3.60. WsSPCVariableData

Name Schema

calculationType
optional

string

criteriaSummary
optional

< WsSPCCriteriaSummary > array

productRunning
optional

< WsSPCProductRunning > array

statistics
optional

< WsSPCStatistics > array

statistics2
optional

< WsSPCStatistics2 > array

variableChartInfo
optional

< WsSPCVariableChartInfo > array

variableId
optional

integer (int64)

4. Security

4.1. access_token

Type : oauth2
Flow : accessCode
Token URL : https://localhost/uaa/oauth/authorize
Token URL : https://localhost/uaa/oauth/token

Name Description

default

Default oauth2 scope.

4.2. resource_owner

Type : oauth2
Flow : password
Token URL : https://localhost/uaa/oauth/token

Name Description

default

Default oauth2 scope.

4.3. implicit_grant

Type : oauth2
Flow : implicit
Token URL : https://localhost/uaa/oauth/authorize

Name Description

default

Default oauth2 scope.

4.4. client_creds

Type : oauth2
Flow : application
Token URL : https://localhost/uaa/oauth/token

Name Description

default

Default oauth2 scope.