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 functions models used repeatedly across various Workbench APIs.

ApiGridLines_%name%

Field

Type

Description

Rows

Number of rows returned

Form Models

Common models found on Workbench forms.

BoolViewData

Field

Type

Description

UseAttrDisable

Boolean

NotRelative

Boolean

Field

Type

Description

BoolValue

Boolean

Name

String

Visible

Boolean

InfoText

String

ButtonViewData

Boolean

The boolean value of the field.

Name

String

Visible

The name of the field.

Disabled

Boolean

InfoText

String

CellData

Field

Type

Description

CellId

CellValue

CellNumValue

CellBoolValue

CellTag

CellValueDate

CellValueInt

ColModel

Field

Type

Description

Required

Boolean

Name

String

Title

String

Index

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

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, format ("YYYY-MM-DDT00:00:00Z").

Name

String

Visible

BooleanThe name of the field.

Disabled

Boolean

A flag to indicate if the field is editable.

Required

Boolean

InfoText

String

A flag to indicate if the field is required.

DecimalViewData

Field

Type

Description

DecimalValue

Number

The decimal value of the field.

Name

String

Visible

Boolean

InfoText

StringThe 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

SelectedText

StringThe selected value of the field.

Name

String

Visible

BooleanThe name of the field.

Disabled

Boolean

A flag to indicate if the field is editable.

Required

Boolean

InfoText

String

DynamicPredicateApi

A flag to indicate if the field is required.

FileAttachmentsViewData

Field

Type

Description

PredicateRows

RelatedRecordID

DynamicPredicateRowApi

Field

Type

Description

LeftOperand

RightOperand

Operator

Display

ExtensionFieldsViewData

Field

Type

Description

Fields

Array [FieldViewData]

Form

Object

Disabled

Boolean

Name

String

Visible

Boolean

Required

Boolean

InfoText

InfoText

FieldViewData

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

Name

StringValue

String

Field name

Visible

Boolean

Displayed or not

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

Name

String

The name of the field.

Disabled

Boolean

Disabled or not

A flag to indicate if the field is editable.

Required

Boolean

Required or not.

InfoText

String

FieldViewDataAddon

A flag to indicate if the field is required.

OptionsViewData

Field

Type

Description

NgClick

SelectedOption

String

NgDisabled

The selected option of the field.

Name

String

NgHide

String

Icon

String

Title

String

FileAttachmentsViewData

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

RelatedRecordID

String

RelatedRecord

Number

The decimal value of the field, representing a percentage.

Name

String

FileUrl

StringViewData

Name

String

File name.

InfoText

String

Description text.

FileViewData

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

FileName

SelectedValue

String

File name

The selected value of the field.

ExtensionsAccepted

SelectedText

String

File extension

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

Name

String

Name

Visible

Boolean

Visible parameter

The name of the field.

Disabled

Boolean

Disable status

A flag to indicate if the field is editable.

Required

Boolean

Required or not

A flag to indicate if the field is required.

InfoText

String

Text.

FormItem

StringViewData

Field

Type

Description

Name

StringValue

String

Value

String

GeneralAddressLine

Field

Type

Description

Title

String

Company name

The string value of the field.

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

Field

Type

Description

Category

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

Field

Type

Description

Fields

Array [FieldViewData]

ReturnFields

Array [FormItem]

GeneralNoteKey

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

Filter Models

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

GridRequestParameters

Field

Type

Description

Sidx

String

The field that the data will be sorted on.

Sort

String

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

ToDoNoteId

PredicateRows

KeyTable

GridId

GeneralNoteLine

Array<DynamicPredicateRow>

A row for each column to be filtered on.

DynamicPredicateRow

Field

Type

Description

Description

DoBy

KeyTable

EntityDescription

DoByDate

Completed

Select

DescriptionValue

DetailsValue

NoteTypeValue

NoteStatusValue

DoByValue

EntityValue

EntityDescriptionValue

DoByDateValue

CompletedValue

Delete

Status

ReadonlyFlag

ReadonlyMessage

OriginalKey

CurrentKey

Key

Index

GridModel

Field

Type

Description

GridId

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

LeftOperand

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

Field

Type

Description

ToDoNoteId

KeyTable

GeneralToDoLine

Field

Type

Description

Details

NoteTypeId

NoteType

NoteStatusId

NoteStatus

DoById

CreatedByID

String

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

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

MultiPickerViewData

Field

Type

Description

InputWidth

string

Value list: 'None', 'Small', 'Medium', 'Large', 'MoreLarge', 'ExtraLarge', 'SuperLarge'

KeyProperty

String

TagDisplayProperty

String

Template

String

AllowedTagsPattern

String

MinTags

Integer

AutoCompleteOnly

Boolean

NgSource

String

MinAutocompleteLength

Integer

AutocompleteDisplayProperty

String

LoadOnFocus

Boolean

LoadOnEmpty

Boolean

MaxAutocompleteResults

Integer

OnTagAdding

String

OnTagAdded

String

OnTagRemoved

String

StringValue

String

Name

String

Visible

Boolean

Disabled

Boolean

Required

Boolean

InfoText

String

OptionsViewData
total

Field

Type

Description

page

records

rows

form

widgets

HeaderColumnViewData

Field

Type

Description

ColumnNo

Integer

Headers

Array [FieldViewData]

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

SelectedOptionName

CellId

String

Settings

Array[KeyValuePair]

The ID of the value of the field.

CellValue

String

Visible

Boolean

Disabled

Boolean

Required

Boolean

InfoText

String

PercentageViewData

Field

Type

Description

DecimalValue

Number

Name

String

Visible

Boolean

DisableChange

Boolean

ControlSize

String

FontStyle

String

None, Bold, Italic

ClearViewDataAddon

FieldViewDataAddon

WrapLabel

Boolean

InfoText

String

PickerViewData

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

SelectedValue

Category

String

SelectedText

String

Name

String

Visible

Boolean

Disabled

Boolean

Required

Boolean

InfoText

String

SaveResult

The Job Group Category.

Group

String

The Job Group Code.

AttributeLine

Field

Type

Description

successMessage

Key

String

Successful message

AttributeKey

The unique key for the line.

warningMessage

Category

String

Wanning message

The Job Group Category of the Attribute.

errorMessage

CategoryValue

String

Error message

CellData

The Job Group Category of the Attribute.

validationErrors

Array [MvcValidationError]

KeyStr

String

KeyDate

String

KeyInt

Integer

SplitButtonViewData

Field

Type

Description

StandardTextViewData

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

IsButtonHidden

Boolean

Name

String

Visible

Boolean

Disabled

Boolean

Required

Boolean

InfoText

String

StoredFilesApiKey

ToDoNoteId

Integer

The unique ID of the Note.

KeyTable

String

The type of the document this Note belongs to.

NoteLine

Field

Type

Description

StoredFileId

Key

Integer

StoredFilesApiModel

Field

Type

Description

Key

StoredFilesApiKey

RelatedRecord

String

RelatedRecordId

String

FileGroupId

Integer

NoteKey

The unique key for the line.

Description

String

The description on the Note.

DescriptionValue

CellData

The description on the Note.

Details

String

FileName

String

Url

String

ImageDocument

Boolean

SecondaryPath

String

KeyStr

String

KeyDate

String

KeyInt

Integer

StringViewData

Field

Type

Description

StringValue

Name

Visible

Disabled

Required

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

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

SNID

ToDoNoteId

Integer

SNTranID

Integer

TimeViewData

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

TimeValue

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

Key

String

Time value

Is24H

Boolean

24h format

Name

String

Visible

Boolean

Disabled

Boolean

Required

Boolean

InfoText

String

Tuple_String

Field

Type

Description

Item1

String

Item2

String

ViewData_GridWidget

Field

Type

Description

WidgetId

LayoutCode

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