Common models
Overview
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 ("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. |
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. |
Sord | 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 | 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 | Array<DynamicPredicateRow> | A row for each column to be filtered on. |
DynamicPredicateRow
Field | Type | Description |
---|---|---|
LeftOperand | String | The name of the field to be filtered |
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 |
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 |
---|---|---|
CellId | 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. |
Line Models
Common line models shared by the Company, Job, and People endpoints.
AttributeKey
Field | Type | Description |
---|---|---|
Category | String | The Job Group Category. |
Group | String | The Job Group Code. |
AttributeLine
Field | Type | Description |
---|---|---|
Key | The unique key for the line. | |
Category | String | The Job Group Category of the Attribute. |
CategoryValue | The Job Group Category of the Attribute. | |
Group | String | The Job Group of the Attribute. |
GroupValue | The Job Group of the Attribute. | |
Value | The value of the Attribute. |
NoteKey
Field | Type | Description |
---|---|---|
ToDoNoteId | Integer | The unique ID of the Note. |
KeyTable | String | The type of the document this Note belongs to. |
NoteLine
Field | Type | Description |
---|---|---|
Key | The unique key for the line. | |
Description | String | The description on the Note. |
DescriptionValue | The description on the Note. | |
Details | String | The details on the Note. |
DetailsValue | The details on the Note. | |
NoteTypeId | Integer | The ID of the Note Type. |
NoteType | String | The description of the Note Type. |
NoteTypeValue | 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 | The Person who created this Note. | |
CreatedDate | DateTime | The date this Note was created. |
CreatedDateValue | The date this Note was created. | |
KeyTable | String | The type of the document this Note belongs to. |
EntityValue | The type of the document this Note belongs to. | |
EntityDescription | String | The description of the document this Note belongs to. |
EntityDescriptionValue | 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 | The unique key for the line. | |
Description | String | The description on the To Do Note. |
DescriptionValue | The description on the To Do Note. | |
Details | String | The details on the To Do Note. |
DetailsValue | The details on the To Do Note. | |
NoteTypeId | Integer | The ID of the Note Type. |
NoteType | String | The description of the Note Type. |
NoteTypeValue | The Note Type. | |
NoteStatusId | Integer | The ID of the To Do Note Status. |
NoteStatus | String | The description of the To Do Note Status. |
NoteStatusValue | 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 | The Person who is assigned this To Do Note. | |
KeyTable | String | The type of the document this To Do Note belongs to. |
EntityValue | 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 | The description of the document this To Do Note belongs to. | |
DoByDate | DateTime | The Do By Date on the To Do Note. |
DoByDateValue | The Do By Date on the To Do Note. | |
Completed | Boolean | The Completed flag on the To Do Note. |
CompletedValue | The Completed flag on the To Do Note. | |
CreatedById | Integer | The ID of the Person who created this To Do Note. |
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. |
On this page
- 1 Overview
- 2 Form Models
- 2.1 BoolViewData
- 2.2 DateViewData
- 2.3 DecimalViewData
- 2.4 DropdownViewData
- 2.5 FileAttachmentsViewData
- 2.6 MultiPickerViewData
- 2.7 OptionsViewData
- 2.8 PercentageViewData
- 2.9 PickerViewData
- 2.10 StringViewData
- 2.11 TimeViewData
- 3 Filter Models
- 3.1 GridRequestParameters
- 3.2 DynamicPredicate
- 3.3 DynamicPredicateRow
- 3.4 Operator
- 4 Grid Models
- 4.1 GridResult
- 4.2 CellData
- 5 Line Models
- 5.1 AttributeKey
- 5.2 AttributeLine
- 5.3 NoteKey
- 5.4 NoteLine
- 5.5 ToDoKey
- 5.6 ToDoLine
- 6 Update Models
- 6.1 SaveResult
- 6.2 MvcValidationError