API - Item Details


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

itemDetails

Source table

Item

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

systemId

Child objects

Available with $expand: units, variants, certificationPrograms

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


systemId

string

uuid

SystemId

Record ID

non-editable

number

string

max 20

Field “No.”, the item number.

primary key

number2

string

max 20

No. 2


description

string

max 100

Description


description2

string

max 50

Description 2


fullDescription

string


Description and Description 2, separated by a space.


latinDescription

string


The item translation for the item's “Latin Language Code”. Empty if there is none.


packageDescriptionType

string

enum

Package Description Type. Options: (blank), Trade Item, Irregular


packageDescription

string

max 30

Package Description


type

string

enum

Type. Options: Inventory, Service, Non-Inventory


tradeItemType

string

enum

Trade Item Type. Options: RawMat (Raw Material), WIP, Product


itemCategoryId

string

uuid

SystemId of the item category in Item Category Code


itemCategoryCode

string

max 20

Item Category Code


inventoryPostingGroupId

string

uuid

SystemId of the inventory posting group in Inventory Posting Group


inventoryPostingGroup

string

max 20

Inventory Posting Group


taxGroupCode

string

max 20

Tax Group Code


defaultStockCenterId

string

uuid

SystemId of the stock center in Default Stock Center


defaultStockCenter

string

max 20

Default Stock Center


blocked

boolean


Blocked


status

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.


irregularTradeItem

boolean


Irregular Trade Item. Specifies if the trade items can have variable weight.


baseUnitOfMeasure

string

max 10

Base Unit of Measure


qtyInBaseUnit

number

decimal

Qty. per Unit of Measure of the base unit (normally 1).


weightInBaseUnit

number

decimal

Weight of the base unit, from the item units of measure.


tradeItemUnitOfMeasure

string

max 10

Trade Item Unit of Measure


qtyInTradeItemUnit

number

decimal

Qty. per Unit of Measure of the trade item unit.


weightInTradeItemUnit

number

decimal

Weight of the trade item unit, from the item units of measure.


palletUnitOfMeasure

string

max 10

Pallet Unit of Measure


qtyInPalletUnit

number

decimal

Qty. per Unit of Measure of the pallet unit.


tradeItemsInPalletUnit

number

decimal

Number of trade items on a full pallet: qtyInPalletUnit divided by qtyInTradeItemUnit. 0 if the item has no pallet unit or no trade item unit.


weightInPalletUnit

number

decimal

Weight of the pallet unit, from the item units of measure.


weightUnitOfMeasure

string

max 10

Weight Unit of Measure


purchUnitOfMeasure

string

max 10

Purch. Unit of Measure


salesUnitOfMeasure

string

max 10

Sales Unit of Measure


units

array


The units of measure of the item. See Child objects.


unitPrice

number

decimal

Unit Price


priceIncludesTax

boolean


Field “Price Includes VAT”


unitCost

number

decimal

Unit Cost


countryOfOrigin

string

max 10

Country/Region of Origin Code


rawMaterial

string

max 20

The raw material item: the item itself for Raw Material items, otherwise the item in “Contrib. Raw Mat. No.”.


rawMaterialDescription

string

max 100

Description of the raw material item.


rawMaterialReportingCode

string

max 10

Field “Raw Mat. - Official Reporting Code”, the official raw material code, used in government reporting.


defaultRawMaterialState

string

max 10

Default Raw Material State, of the item when landed.


processingMethod

string

max 10

Processing Method Code


processingMethodDescription

string


Description of the processing method.


cutCode

string

max 10

Cut Code


sizeGrade

string

max 10

Product Size Grade


sizeGradeDescription

string


Description of the size grade.


qualityGrade

string

max 10

Product Quality Grade


qualityGradeDescription

string


Description of the quality grade.


grossWeight

number

decimal

Gross Weight


netWeight

number

decimal

Net Weight


palletNetWeight

number

decimal

Pallet Net Weight


gtin

string

max 14

GTIN


gtinTradeItem

string

max 14

GTIN (TI), the GTIN of the trade item.


variants

array


The variants of the item. See Child objects.


certificationPrograms

array


The certification programs of the item. See Child objects.


systemRowVersion

integer


System row version. Increments every time the record is modified.

non-editable

lastModified

string

date-time

SystemModifiedAt (date and time of last change)

non-editable


Object Example

An example of one object (without child objects):

JSON
{
    "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 the itemUnits endpoint. See API - Item Units.

  • variants: the item variants, from the itemVariants endpoint. See API - Item Variants.

  • certificationPrograms: the certification programs registered on the item (Source Type = Item), from the certificationPrograms endpoint. 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:

JSON
GET .../itemDetails?$filter=number eq '0034-840MSC'&$select=number,description,baseUnitOfMeasure,tradeItemUnitOfMeasure,palletUnitOfMeasure,tradeItemsInPalletUnit&$expand=units($select=code,qtyPerUnit)

Response:

JSON
{
    "@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