Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overview
Anchor
top
top

This page serves as a central hub where you can find detailed descriptions of common models used repeatedly across various Workbench APIs.

Form Models

Common models found on Workbench forms.

BoolViewData

Field

Type

Description

BoolValue

Boolean

The boolean value of the field.

Name

String

The name of the field.

Disabled

Boolean

A flag to indicate if the field is editable.

Required

Boolean

A flag to indicate if the field is required.

DateViewData

Field

Type

Description

DateValue

String

The date value of the field, as an ISO 8601 formatted string format ("YYYY-MM-DDT00:00:00Z").

Name

String

The name of the field.

Disabled

Boolean

A flag to indicate if the field is editable.

Required

Boolean

A flag to indicate if the field is required.

DecimalViewData

Field

Type

Description

DecimalValue

Number

The decimal value of the field.

Name

String

The name of the field.

Disabled

Boolean

A flag to indicate if the field is editable.

Required

Boolean

A flag to indicate if the field is required.

DropdownViewData

Field

Type

Description

SelectedValue

String

The selected value of the field.

Name

String

The name of the field.

Disabled

Boolean

A flag to indicate if the field is editable.

Required

Boolean

A flag to indicate if the field is required.

FileAttachmentsViewData

Field

Type

Description

RelatedRecordID

String

The ID of this document. Used when uploading files to the StoredFilesApi endpoint.

RelatedRecord

String

The type of this document. Used when uploading files to the StoredFilesApi endpoint.

Disabled

Boolean

A flag to indicate if the field is editable.

Required

Boolean

A flag to indicate if the field is required.

MultiPickerViewData

Field

Type

Description

StringValue

String

A comma-delimited list of the selected value of the field.

Name

String

The name of the field.

Disabled

Boolean

A flag to indicate if the field is editable.

Required

Boolean

A flag to indicate if the field is required.

OptionsViewData

Field

Type

Description

SelectedOption

String

The selected option of the field.

Name

String

The name of the field.

Disabled

Boolean

A flag to indicate if the field is editable.

Required

Boolean

A flag to indicate if the field is required.

PercentageViewData

Field

Type

Description

DecimalValue

Number

The decimal value of the field, representing a percentage.

Name

String

The name of the field.

Disabled

Boolean

A flag to indicate if the field is editable.

Required

Boolean

A flag to indicate if the field is required.

PickerViewData

Field

Type

Description

SelectedValue

String

The selected value of the field.

SelectedText

String

A description of the selected value of the field (read-only).

Name

String

The name of the field.

Disabled

Boolean

A flag to indicate if the field is editable.

Required

Boolean

A flag to indicate if the field is required.

StringViewData

Field

Type

Description

StringValue

String

The string value of the field.

Name

String

The name of the field.

Disabled

Boolean

A flag to indicate if the field is editable.

Required

Boolean

A flag to indicate if the field is required.

TimeViewData

Field

Type

Description

TimeValue

String

The time value of the field, as a formatted string ("hh:mm:ss").

Is24H

Boolean

24h format

Name

String

The name of the field.

Disabled

Boolean

A flag to indicate if the field is editable.

Required

Boolean

A flag to indicate if the field is required.

⬆️ Back to top

Grid

Filter Models

CellData

Field

Type

Description

CellId

CellValue

CellNumValue

CellBoolValue

CellTag

CellValueDate

CellValueInt

ColModel

Common models used in requests to Workbench List endpoints for filtering and sorting data.

GridRequestParameters

Field

Type

Description

Required

Boolean

Name

Sidx

String

Title

String

Index

The field that the data will be sorted on.

Sort

String

ShowGroupingHeader

Boolean

Hidden

Boolean

Editable

Boolean

IsNumeric

Boolean

IsCenteredText

Boolean

LabelClasses

String

Resizable

Boolean

Format

Integer

FormatWidth

Integer

DateWidthSpecified

Boolean

DatasheetsDatasheetKey

Field

Type

Description

DatasheetId

Integer

DatasheetTemplateId

Integer

KeyStr

String

KeyInt

Integer

DatasheetsDatasheetModelLine

Field

Type

Description

Datasheet

CellData

Template

CellData

Date

String

Name

String

KeyTable

String

Subject

String

Rating

Number

Complete

Boolean

JSON

String

Status

String

ReadonlyFlag

Integer

ReadonlyMessage

String

OriginalKey

DatasheetsDatasheetKey

CurrentKey

DatasheetsDatasheetKey

Key

DatasheetsDatasheetKey

Index

Integer

DynamicPredicateApi

The sort order (“asc”, or “desc”).

Page

Integer

The specific page to be retrieved.

Rows

Integer

The number of records returned per page.

Predicate

DynamicPredicate

The filter to apply to the data.

Jobcode

String

Some list API endpoints will accept additional context to filter the data by.

finCode

String

functionalCode

String

IntValue

Integer

StringValue

String

BoolValue

Boolean

DateValue

Date

DynamicPredicate

Field

Type

Description

PredicateRows

DynamicPredicateRowApi

Field

Type

Description

LeftOperand

RightOperand

Operator

Display

ExtensionFieldsViewData

Array<DynamicPredicateRow>

A row for each column to be filtered on.

DynamicPredicateRow

Form

Object

Disabled

Boolean

Name

Field

Type

Description

Fields

Array [FieldViewData]

LeftOperand

String

Visible

Boolean

Required

Boolean

InfoText

InfoText

FormItem

Field

Type

Description

Name

String

Value

String

GeneralAddressLine

Field

Type

Description

Title

String

Company name

Name

String

Address name.

Line1

String

Street line 1 information

Line2

String

Street line 2 information

CompanyId

Integer

Code of the company.

Company

String

Company name

Inactive

Boolean

Status

IsPostalAddress

Boolean

This is a Post address or not.

IsPhysicalAddress

Boolean

This is a physical address or not.

Email

String

Email address.

Phone

String

Phone number.

PostCode

String

Post code.

Select

CellData

TitleValue

CellData

NameValue

CellData

Line1Value

CellData

Address line 1.

Line2Value

CellData

Address line 2.

CompanyValue

CellData

Company name.

EmailValue

CellData

Email address.

PhoneValue

CellData

Phone number.

PostCodeValue

CellData

Post code.

HasMore

CellData

Delete

CellData

Status

String

Status.

ReadonlyFlag

Integer

Marked as Read Only.

ReadonlyMessage

String

OriginalKey

GeneralAddressKey

CurrentKey

GeneralAddressKey

Key

GeneralAddressKey

Index

Integer

GeneralAttributeKey

The name of the field to be filtered

Operator

Operator

The operator to apply to the filtered field.

RightOperand

Array<String>

The value(s) to filter the field by.

Operator

Value

Right Operands Required

Description

“Lt“

1

Less than the first item of the Right Operand.

“Gt“

1

Greater than the first item of the Right Operand.

“Eq“

1

Equal to the first item of the Right Operand.

“Ne“

1

Not equal to the first item of the Right Operand.

“Le”

1

Less than or equal to the first item of the Right Operand.

“Ge”

1

Greater than or equal to the first item of the Right Operand.

“Like”

1

Contains the first item of the Right Operand.

“IsOneOf”

Multiple

Is equal to any item in the Right Operand.

“IsNotOneOf”

Multiple

Is not equal to any item in the Right Operand.

“Between”

2

Between the first 2 items in the Right Operand.

“StartsWith”

1

Starts with the first item in the Right Operand.

“StartsWithIsOneOf”

Multiple

Starts with any item in the Right Operand

⬆️ Back to top

Grid Models

Common models in responses from Workbench List endpoints for filtered data.

GridResult

Field

Type

Description

records

Integer

The total number of records in the filtered dataset.

total

Integer

The total number of pages in the filtered dataset.

page

Integer

The specific page requested and retrieved.

rows

Array<T>

The page of filtered data.

CellData

Field

Type

Description

Category

CellId

Group

GeneralAttributeLine

Field

Type

Description

Category

Group

CategoryValue

GroupValue

Value

Delete

Status

ReadonlyFlag

Read Only status.

ReadonlyMessage

String

Read Only message.

OriginalKey

CurrentKey

Key

Index

GeneralExtensionFields

String

The ID of the value of the field.

CellValue

String

The text value of the field.

CellNumValue

Decimal

The decimal value of the field.

CellBoolValue

Boolean

The boolean value of the field.

CellValueDate

Date

The data value of the field.

CellValueInt

Integer

the integer value of the field.

⬆️ Back to top

Line Models

Common line models shared by the Company, Job, and People endpoints.

AttributeKey

Field

Type

Description

Fields

Array [FieldViewData]

ReturnFields

Array [FormItem]

GeneralNoteKey

Field

Type

Description

ToDoNoteId

KeyTable

GridId

GeneralNoteLine

Category

String

The Job Group Category.

Group

String

The Job Group Code.

AttributeLine

Field

Type

Description

Description

Key

Details

NoteTypeId

NoteType

CreatedById

CreatedBy

CreatedDate

KeyTable

EntityDescription

Select

DescriptionValue

DetailsValue

NoteTypeValue

CreatedByValue

CreatedDateValue

EntityValue

EntityDescriptionValue

Delete

Status

ReadonlyFlag

ReadonlyMessage

OriginalKey

CurrentKey

Key

Index

GeneralToDoKey

AttributeKey

The unique key for the line.

Category

String

The Job Group Category of the Attribute.

CategoryValue

CellData

The Job Group Category of the Attribute.

Group

String

The Job Group of the Attribute.

GroupValue

CellData

The Job Group of the Attribute.

Value

CellData

The value of the Attribute.

NoteKey

Field

Type

Description

ToDoNoteId

KeyTable

GeneralToDoLine

Field

Type

Description

Details

NoteTypeId

NoteType

NoteStatusId

NoteStatus

DoById

CreatedByID

DoBy

KeyTable

EntityDescription

DoByDate

Completed

Select

DescriptionValue

DetailsValue

NoteTypeValue

NoteStatusValue

DoByValue

EntityValue

EntityDescriptionValue

DoByDateValue

CompletedValue

Delete

Status

ReadonlyFlag

ReadonlyMessage

OriginalKey

CurrentKey

Key

Index

GridModel

Integer

The unique ID of the Note.

KeyTable

String

The type of the document this Note belongs to.

NoteLine

Field

Type

Description

GridId

Key

String

ColModel

Array [ColModel]

NewRowPosition

String

UpdateColumnEditable

Boolean

Hidden

Boolean

GridRequestParameters

Field

Type

Description

Sidx

Sord

Page

Rows

Jobcode

finCode

functionalCode

IntValue

StringValue

BoolValue

DateValue

GridResult

Field

Type

Description

total

page

records

rows

form

widgets

HeaderColumnViewData

Field

Type

Description

ColumnNo

Integer

Headers

Array [FieldViewData]

HeaderViewData

Field

Type

Description

Headers

Array [FieldViewData]

Columns

Array [HeaderColumnViewData]

KeyValuePair

Field

Type

Description

Key

String

Value

String

Layout

Field

Type

Description

Caption

String

MvcValidationError

Field

Type

Description

n

String

m

String

SaveResult

Field

Type

Description

successMessage

String

Successful message.

warningMessage

String

Wanning message.

errorMessage

String

Error message.

validationErrors

Array [MvcValidationError]

KeyStr

String

KeyDate

String

KeyInt

Integer

StoredFilesApiKey

Field

Type

Description

StoredFileId

Integer

StoredFilesApiModel

Field

Type

Description

Key

StoredFilesApiKey

RelatedRecord

String

RelatedRecordId

String

FileGroupId

Integer

Details

String

FileName

String

Url

String

ImageDocument

Boolean

SecondaryPath

String

KeyStr

String

KeyDate

String

KeyInt

Integer

TabletSerialLine

Field

Type

Description

SerialNo

CellData

SerialNoSelect

CellData

SerialNoSelect

CellData

BatchNoSelect

CellData

ExpiryDate

String

SerialDetails

CellData

Quantity

CellData

TransDetails

CellData

Delete

CellData

Status

String

ReadonlyFlag

Integer

ReadonlyMessage

String

OriginalKey

TabletSerialLineKey

CurrentKey

TabletSerialLineKey

Key

TabletSerialLineKey

Index

Integer

TabletSerialLineKey

Field

Type

Description

SNID

Integer

SNTranID

Integer

Tuple_String

Field

Type

Description

Item1

String

Item2

String

ViewData_GridWidget

Field

Type

Description

WidgetId

LayoutCode

Name

Colour

BGColour

Icon

Type

Visible

Order

Count

WidgetLines

ViewData_GridWidgetLine

Field

Type

Description

WidgetLineId

WidgetId

Name

Predicate

Order

Count

WebEAVGridLine

Field

Type

Description

WBNodeId

CellData

Col00

CellData

Col01

CellData

Col02

CellData

Col03

CellData

Col04

CellData

Col05

CellData

Col06

CellData

Col07

CellData

Col08

CellData

Col09

CellData

Col10

CellData

Col11

CellData

Col12

CellData

Col13

CellData

Col14

CellData

Col15

CellData

Col16

CellData

Col17

CellData

Col18

CellData

Col19

CellData

Col20

CellData

Col21

CellData

Col22

CellData

Col23

CellData

Col24

CellData

Col25

CellData

Col26

CellData

Col27

CellData

Col28

CellData

Col29

CellData

RowId

CellData

Delete

CellData

Status

String

ReadonlyFlag

Integer

ReadonlyMessage

String

OriginalKey

WebEAVGridKey

CurrentKey

WebEAVGridKey

Key

WebEAVGridKey

Index

Integer

NoteKey

The unique key for the line.

Description

String

The description on the Note.

DescriptionValue

CellData

The description on the Note.

Details

String

The details on the Note.

DetailsValue

CellData

The details on the Note.

NoteTypeId

Integer

The ID of the Note Type.

NoteType

String

The description of the Note Type.

NoteTypeValue

CellData

The Note Type.

CreatedById

Integer

The ID of the Person who created this Note.

CreatedBy

String

The name of the Person who created this Note.

CreatedByValue

CellData

The Person who created this Note.

CreatedDate

DateTime

The date this Note was created.

CreatedDateValue

CellData

The date this Note was created.

KeyTable

String

The type of the document this Note belongs to.

EntityValue

CellData

The type of the document this Note belongs to.

EntityDescription

String

The description of the document this Note belongs to.

EntityDescriptionValue

CellData

The description of the document this Note belongs to.

ToDoKey

Field

Type

Description

ToDoNoteId

Integer

The unique ID of the To Do Item.

KeyTable

String

The type of the document this To Do Item belongs to.

ToDoLine

Field

Type

Description

Key

ToDoKey

The unique key for the line.

Description

String

The description on the To Do Note.

DescriptionValue

CellData

The description on the To Do Note.

Details

String

The details on the To Do Note.

DetailsValue

CellData

The details on the To Do Note.

NoteTypeId

Integer

The ID of the Note Type.

NoteType

String

The description of the Note Type.

NoteTypeValue

CellData

The Note Type.

NoteStatusId

Integer

The ID of the To Do Note Status.

NoteStatus

String

The description of the To Do Note Status.

NoteStatusValue

CellData

The To Do Note Status.

DoById

Integer

The ID of the Person who is assigned this To Do Note.

DoBy

String

The name of the Person who is assigned this To Do Note.

DoByValue

CellData

The Person who is assigned this To Do Note.

KeyTable

String

The type of the document this To Do Note belongs to.

EntityValue

CellData

The type of the document this To Do Note belongs to.

EntityDescription

String

The description of the document this To Do Note belongs to.

EntityDescriptionValue

CellData

The description of the document this To Do Note belongs to.

DoByDate

DateTime

The Do By Date on the To Do Note.

DoByDateValue

CellData

The Do By Date on the To Do Note.

Completed

Boolean

The Completed flag on the To Do Note.

CompletedValue

CellData

The Completed flag on the To Do Note.

CreatedById

Integer

The ID of the Person who created this To Do Note.

⬆️ Back to top

Update Models

Common models in responses from Workbench Detail endpoints to save data.

SaveResult

Field

Type

Description

successMessage

String

The success message if the save was successful.

warningMessage

String

A possible warning message if the save was successful.

errorMessage

String

The error message if the save was unsuccessful.

validationErrors

Array<MvcValidationError>

A list of specific validation errors if the save was unsuccessful.

KeyStr

String

Some endpoints will return additional context relating to the updated document.

KeyDate

String

KeyInt

Integer

MvcValidationError

Field

Type

Description

n

String

The name of the field with a validation error.

m

String

The validation error message.

⬆️ Back to top

On this page

Table of Contents
minLevel1
maxLevel4
outlinefalse
styledefault
typelist
printablefalse


Include Page
footer API doc
footer API doc