Products
To view the products
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
ID of the product | |
| ProductName | String | False |
Name of the product | |
| ProductCode | String | False |
Reference code of the product | |
| ProductCategory | String | False |
Category to which the product belongs | |
| Description | String | False |
Description of the product | |
| UnitPrice | Decimal | False |
Price of the product | |
| CreatedTime | Datetime | True |
Time of adding the product to the help desk portal | |
| ModifiedTime | Datetime | True |
Time of modifying product details | |
| CustomFields | String | True |
Custom fields | |
| CreatedBy | String | True |
User who added the product to the help desk portal | |
| DepartmentIds | String | False |
ID of departments associated with the product | |
| Departments | String | True |
Department details associated with the product | |
| IsDeleted | Boolean | True |
Key that returns if the product is deleted or not | |
| LayoutId | String | True |
ID of the layout | |
| ModifiedBy | String | True |
User who modified the details of the product | |
| Owner | String | True |
Owner details of the product | |
| OwnerId | String | True |
ID of user to whom the product is assigned |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| ViewId | String |
ID of the view to filter products |
| IncludeFields | String |
Comma-separated list of fields to include in the response |
| Include | String |
The allowed values are owner and departments for retrieving individual records, whereas for listing records, only owner is supported. |