Overview
The list page that contains the Trade Items with details: descriptions, units of measure, prices, tracing information (raw material, processing method, cut), grades, weights and GTINs. The units, variants and certification programs of each item are available as child objects. No data update is allowed: the items are maintained in Business Central.
Only items that are Trade Items are in this endpoint, i.e. items with the field “Trade Item Type” set to Raw Material, WIP or Product, and with a base unit of measure. For a light-weight list of all items use items, see API - Items.
|
Endpoint name |
|
|
Source table |
|
|
Fixed view |
Trade Item Type = Raw Material, WIP or Product, and Base Unit of Measure not blank. |
|
Requests allowed |
GET |
|
Primary key |
“No.” |
|
Record ID |
|
|
Child objects |
Available with |
|
Procedures |
None |
Units of measure
Wisefish uses three units for a trade item, in addition to the base unit: the trade item unit (for example BOX), the pallet unit and the weight unit. For the base, trade item and pallet units the endpoint shows the quantity per unit (Qty. per Unit of Measure) and the weight of the unit, as set up in the item units of measure. For the pallet unit it also shows how many trade items fit on a pallet (tradeItemsInPalletUnit). These values are only read from the unit setup. All units of the item are available in the child object units.
Raw material
For an item of type Raw Material, rawMaterial is the item itself. For WIP and Product items it is the item in “Contrib. Raw Mat. No.”, i.e. the raw material the product is made from.
Data
Field List
|
Property |
Type |
Format |
Description |
|
|
|
string |
uuid |
SystemId |
Record ID non-editable |
|
|
string |
max 20 |
Field “No.”, the item number. |
primary key |
|
|
string |
max 20 |
No. 2 |
|
|
|
string |
max 100 |
Description |
|
|
|
string |
max 50 |
Description 2 |
|
|
|
string |
|
Description and Description 2, separated by a space. |
|
|
|
string |
|
The item translation for the item's “Latin Language Code”. Empty if there is none. |
|
|
|
string |
enum |
Package Description Type. Options: (blank), Trade Item, Irregular |
|
|
|
string |
max 30 |
Package Description |
|
|
|
string |
enum |
Type. Options: Inventory, Service, Non-Inventory |
|
|
|
string |
enum |
Trade Item Type. Options: RawMat (Raw Material), WIP, Product |
|
|
|
string |
uuid |
SystemId of the item category in Item Category Code |
|
|
|
string |
max 20 |
Item Category Code |
|
|
|
string |
uuid |
SystemId of the inventory posting group in Inventory Posting Group |
|
|
|
string |
max 20 |
Inventory Posting Group |
|
|
|
string |
max 20 |
Tax Group Code |
|
|
|
string |
uuid |
SystemId of the stock center in Default Stock Center |
|
|
|
string |
max 20 |
Default Stock Center |
|
|
|
boolean |
|
Blocked |
|
|
|
string |
enum |
Status (Wisefish field). Options: (blank), On Hold, Quit. Items on hold cannot be purchased, sold, consumed or added. Items with status Quit cannot be purchased, produced or added. |
|
|
|
boolean |
|
Irregular Trade Item. Specifies if the trade items can have variable weight. |
|
|
|
string |
max 10 |
Base Unit of Measure |
|
|
|
number |
decimal |
Qty. per Unit of Measure of the base unit (normally 1). |
|
|
|
number |
decimal |
Weight of the base unit, from the item units of measure. |
|
|
|
string |
max 10 |
Trade Item Unit of Measure |
|
|
|
number |
decimal |
Qty. per Unit of Measure of the trade item unit. |
|
|
|
number |
decimal |
Weight of the trade item unit, from the item units of measure. |
|
|
|
string |
max 10 |
Pallet Unit of Measure |
|
|
|
number |
decimal |
Qty. per Unit of Measure of the pallet unit. |
|
|
|
number |
decimal |
Number of trade items on a full pallet: |
|
|
|
number |
decimal |
Weight of the pallet unit, from the item units of measure. |
|
|
|
string |
max 10 |
Weight Unit of Measure |
|
|
|
string |
max 10 |
Purch. Unit of Measure |
|
|
|
string |
max 10 |
Sales Unit of Measure |
|
|
|
array |
|
The units of measure of the item. See Child objects. |
|
|
|
number |
decimal |
Unit Price |
|
|
|
boolean |
|
Field “Price Includes VAT” |
|
|
|
number |
decimal |
Unit Cost |
|
|
|
string |
max 10 |
Country/Region of Origin Code |
|
|
|
string |
max 20 |
The raw material item: the item itself for Raw Material items, otherwise the item in “Contrib. Raw Mat. No.”. |
|
|
|
string |
max 100 |
Description of the raw material item. |
|
|
|
string |
max 10 |
Field “Raw Mat. - Official Reporting Code”, the official raw material code, used in government reporting. |
|
|
|
string |
max 10 |
Default Raw Material State, of the item when landed. |
|
|
|
string |
max 10 |
Processing Method Code |
|
|
|
string |
|
Description of the processing method. |
|
|
|
string |
max 10 |
Cut Code |
|
|
|
string |
max 10 |
Product Size Grade |
|
|
|
string |
|
Description of the size grade. |
|
|
|
string |
max 10 |
Product Quality Grade |
|
|
|
string |
|
Description of the quality grade. |
|
|
|
number |
decimal |
Gross Weight |
|
|
|
number |
decimal |
Net Weight |
|
|
|
number |
decimal |
Pallet Net Weight |
|
|
|
string |
max 14 |
GTIN |
|
|
|
string |
max 14 |
GTIN (TI), the GTIN of the trade item. |
|
|
|
array |
|
The variants of the item. See Child objects. |
|
|
|
array |
|
The certification programs of the item. See Child objects. |
|
|
|
integer |
|
System row version. Increments every time the record is modified. |
non-editable |
|
|
string |
date-time |
SystemModifiedAt (date and time of last change) |
non-editable |
Object Example
An example of one object (without child objects):
{
"systemId": "a41c7e0b-5d2f-ef11-9f8b-6045bde9cc61",
"number": "0034-840MSC",
"number2": "",
"description": "Haddock portions block 160x7.5 kg",
"description2": "MSC",
"fullDescription": "Haddock portions block 160x7.5 kg MSC",
"latinDescription": "Melanogrammus aeglefinus",
"packageDescriptionType": " ",
"packageDescription": "",
"type": "Inventory",
"tradeItemType": "Product",
"itemCategoryId": "6b2d1e95-dd11-ef11-9f8b-6045bde9cc61",
"itemCategoryCode": "PRODUCTS",
"inventoryPostingGroupId": "4f2d1e95-dd11-ef11-9f8b-6045bde9cc61",
"inventoryPostingGroup": "PRODUCTS",
"taxGroupCode": "",
"defaultStockCenterId": "00000000-0000-0000-0000-000000000000",
"defaultStockCenter": "",
"blocked": false,
"status": " ",
"irregularTradeItem": true,
"baseUnitOfMeasure": "KG",
"qtyInBaseUnit": 1,
"weightInBaseUnit": 1,
"tradeItemUnitOfMeasure": "BOX",
"qtyInTradeItemUnit": 7.5,
"weightInTradeItemUnit": 7.5,
"palletUnitOfMeasure": "PALLET",
"qtyInPalletUnit": 900,
"tradeItemsInPalletUnit": 120,
"weightInPalletUnit": 900,
"weightUnitOfMeasure": "KG",
"purchUnitOfMeasure": "KG",
"salesUnitOfMeasure": "KG",
"unitPrice": 0,
"priceIncludesTax": false,
"unitCost": 0,
"countryOfOrigin": "IS",
"rawMaterial": "02",
"rawMaterialDescription": "Haddock",
"rawMaterialReportingCode": "002",
"defaultRawMaterialState": "",
"processingMethod": "FROZEN",
"processingMethodDescription": "Frozen",
"cutCode": "",
"sizeGrade": "160",
"sizeGradeDescription": "160 g portions",
"qualityGrade": "",
"qualityGradeDescription": "",
"grossWeight": 0,
"netWeight": 1,
"palletNetWeight": 0,
"gtin": "",
"gtinTradeItem": "",
"systemRowVersion": 2579533,
"lastModified": "2026-10-14T13:05:22.817Z"
}
Child objects
The child objects are read with $expand and are documented on their own pages:
-
units: the item units of measure, from theitemUnitsendpoint. See API - Item Units. -
variants: the item variants, from theitemVariantsendpoint. See API - Item Variants. -
certificationPrograms: the certification programs registered on the item (Source Type = Item), from thecertificationProgramsendpoint. See API - Certification Programs.
Examples
Read items
Read all entries
Reads all trade items. The response is a list of item objects, as shown in Object Example.
GET .../itemDetails
Read a specific item
Items are read by their Record ID (systemId). To find an item by its number, use $filter:
GET .../itemDetails?$filter=number eq '0034-840MSC'
Read an item with its units
Reads item 0034-840MSC with its units of measure and the number of trade items per pallet, and returns only a few fields with $select.
Request:
GET .../itemDetails?$filter=number eq '0034-840MSC'&$select=number,description,baseUnitOfMeasure,tradeItemUnitOfMeasure,palletUnitOfMeasure,tradeItemsInPalletUnit&$expand=units($select=code,qtyPerUnit)
Response:
{
"@odata.context": "https://containers.wisefish.com/BC/api/wisefish/base/v1.0/$metadata#companies(cf9f7b85-dd11-ef11-9f8b-6045bde9cc61)/itemDetails(number,description,baseUnitOfMeasure,tradeItemUnitOfMeasure,palletUnitOfMeasure,tradeItemsInPalletUnit,units(code,qtyPerUnit))",
"value": [
{
"@odata.etag": "W/\"JzE5OzEyMzQ1Njc4OTAxMjM0NTY3ODkwOzAwOyc=\"",
"number": "0034-840MSC",
"description": "Haddock portions block 160x7.5 kg",
"baseUnitOfMeasure": "KG",
"tradeItemUnitOfMeasure": "BOX",
"palletUnitOfMeasure": "PALLET",
"tradeItemsInPalletUnit": 120,
"units": [
{
"@odata.etag": "W/\"JzE5OzIzNDU2Nzg5MDEyMzQ1Njc4OTAxOzAwOyc=\"",
"code": "BOX",
"qtyPerUnit": 7.5
},
{
"@odata.etag": "W/\"JzE5OzM0NTY3ODkwMTIzNDU2Nzg5MDEyOzAwOyc=\"",
"code": "KG",
"qtyPerUnit": 1
},
{
"@odata.etag": "W/\"JzE5OzQ1Njc4OTAxMjM0NTY3ODkwMTIzOzAwOyc=\"",
"code": "PALLET",
"qtyPerUnit": 900
}
]
}
]
}
Read products with their certification programs
Reads the non-blocked products made from raw material 02, with variants and certification programs.
GET .../itemDetails?$filter=tradeItemType eq 'Product' and rawMaterial eq '02' and blocked eq false&$expand=variants,certificationPrograms
Read items changed since a given time
Reads the items that have been changed after a given date and time, for example to synchronize item data to another system.
GET .../itemDetails?$filter=lastModified gt 2026-11-01T00:00:00Z