EP API - Items

Endpoint name	`items`
Source table in Wisefish	`Item`
Fixed view	Shows all entries in the Item table.
Editable	No data modification possible.
Procedures	There are no procedures on this endpoint.
Primary key of table	the field “No” is the primary key.

Data

Field List

Property	Type	Table Field	Field Type (TODO: add length)	Note
`no`	string	No.	Code[20]	this field (and only this field) is the primary key of the table.
`systemId`	string uuid	SystemId	GUID
`no2`	string	No. 2	Code[20]
`description`	string	Description	Text[100]
`description2`	string	Description 2	Text]50}
`baseUnitOfMeasure`	string	Base Unit of Measure	Code[10]
`type`	string	Type	Option	Options: Inventory, Service, Non-Inventory
`unitPrice`	Decimal	Unit Price	Decimal
`grossWeight`	Decimal	Gross Weight	Decimal
`netWeight`	Decimal	Net Weight	Decimal
`blocked`	true/false	Blocked	Boolean
`lastDateTimeModified`	DateTime	Last DateTime Modified	DateTime
`countryRegionOfOriginCode`	string	Country/Region of Origin Code	Text
`gtin`	string	GTIN	Text
`wfItemType`	string	Item Type	Option	If the Item is a Trade Item, the options are Raw Material, WIP, Product
`tiUnitOfMeasure`	string	TI Unit of Measure	Text
`irregularTradeItem`	true/false	Irregular Trade Item	Boolean
`weightUnitOfMeasure`	string	Weight Unit of Measure	Text
`processingMethodCode`	string	Processing Method Code	Text
`palletUnitOfMeasure`	string	Pallet Unit of Measure	Text
`gtinTI`	string	GTIN (TI)	Text
`gtinOuter`	string	GTIN (Outer)	Text
`palletMixing`	string	Pallet Mixing	Text
`latinLanguageCode`	string	Latin Language Code	Text
`latinDescription`	string	Latin Description	Text
`expirationUnit`	Integer	Expiration Unit	Integer
`expirationType`	string	Expiration Type	Option	Days, Months, Years
`packageDescriptionType`	string	Package Description Type	Text
`packageDescription`	string	Package Description	Text
`defaultPieceCount`	Integer	Default Piece Count	Integer
`minimumPieces`	Integer	Minimum Pieces	Integer
`maximumPieces`	Integer	Maximum Pieces	Integer
`minimumWeight`	Decimal	Minimum Weight	Decimal
`maximumWeight`	Decimal	Maximum Weight	Decimal
`tradeItemPackingMethod`	string	Trade Item Packing Method	Option
`tradeItemTareType`	string	Trade Item Tare Type	Option
`tradeItemTareWeight`	Decimal	Trade Item Tare Weight	Decimal
`tradeItemWeight`	Decimal	Trade Item Weight	Decimal
`noOfTradeItemLabels`	Integer	No. of Trade Item Labels	Integer
`targetIceGlazing`	Decimal	Target Ice Glazing %	Decimal
`palletNetWeight`	Decimal	Pallet Net Weight	Decimal
`palletGrossWeight`	Decimal	Pallet Gross Weight	Decimal
`bestBeforeVsUseBy`	string	Best Before vs. Use By	Option
`barcodeLabelDetailsCode`	string	BarcodeLabel Details Code	Text
`minMaxTaraProfile`	string	Min, Max, Tara Profile	Text
`innerTareWeight`	Decimal	Inner Tare Weight	Decimal
`innerMaximumWeight`	Decimal	Inner Maximum Weight	Decimal
`innerMinimumWeight`	Decimal	Inner Minimum Weight	Decimal
`innerLabel`	string	Inner Label	Text
`tradeItemLabel`	string	Trade Item Label	Text
`outerLabel`	string	Outer Label	Text
`labelImage1`	string	Label Image 1	Text
`labelImage2`	string	Label Image 2	Text
`tradeItemNetWeightKg`	Decimal	Trade Item Net Weight kg	Decimal
`tradeItemNetWeightLb`	Decimal	Trade Item Net Weight lb	Decimal
`productSizeGrade`	string	Product Size Grade	Text
`sizeGradeDescription`	string	SizeGrade.Description	Text
`productQualityGrade`	string	Product Quality Grade	Text
`qualityGradeDescription`	string	QualityGrade.Description	Text
`defaultRawMaterialState`	string	Default Raw Mat State	Text
`cutCode`	string	Cut Code	Text
`innovaItem`	true/false	Innova Item	Boolean Can be used as an indicator for external production system. The idea behind this field, is that external production system should only read the field, if it is set to true.
`noOfExternalItems`	Integer	Integer	Counts the number of “External Item Nos” associated with this Item. BlankZero = true (can be benefical for external production system, as it can then check if the number of labels matches the number of labels they have).
`lastModified`	DateTime	SystemModifiedAt	Note: The name of this field in business central is “systemmodifedAt” and it can be seen in page inspection in the user interface.

Example

Expand to see the example json

An example of one object in the list:

JSON

    "value": [
        {
            "@odata.etag": "W/\"JzE5OzUxNTM2MDI2OTY0MjczODk5OTYxOzAwOyc=\"",
            "systemId": "74cc9924-54d2-4470-8501-bd7f0cbcb151",
            "no": "SHR001",
            "no2": "",
            "description": "Shrimp, cooked and peeled, IQF, 200-300 pcs/lb, 8-12% glazing. Well done 16 x 225 g Net wt",
            "description2": "",
            "baseUnitOfMeasure": "KG",
            "type": "Inventory",
            "unitPrice": 0,
            "grossWeight": 1.1,
            "netWeight": 1,
            "blocked": false,
            "lastDateTimeModified": "2024-08-01T20:42:18.473Z",
            "countryRegionOfOriginCode": "",
            "gtin": "7071357106588",
            "wfItemType": "Product",
            "tiUnitOfMeasure": "KRT",
            "irregularTradeItem": false,
            "weightUnitOfMeasure": "KG",
            "processingMethodCode": "IQF",
            "palletUnitOfMeasure": "PALLE",
            "gtinTI": "2098765907281",
            "gtinOuter": "",
            "palletMixing": " ",
            "latinLanguageCode": "LAT",
            "latinDescription": "PANDALUS BOREALIS",
            "expirationUnit": 24,
            "expirationType": "Months",
            "packageDescriptionType": " ",
            "packageDescription": "16 x 0,23",
            "defaultPieceCount": 0,
            "minimumPieces": 0,
            "maximumPieces": 0,
            "minimumWeight": 3.6,
            "maximumWeight": 4,
            "tradeItemPackingMethod": "Default (TIs as recorded)",
            "tradeItemTareType": "On Scale",
            "tradeItemTareWeight": 0,
            "tradeItemWeight": 0,
            "noOfTradeItemLabels": 0,
            "targetIceGlazing": 12,
            "palletNetWeight": 388.8,
            "palletGrossWeight": 432,
            "bestBeforeVsUseBy": "Best before",
            "barcodeLabelDetailsCode": "NETTO",
            "minMaxTaraProfile": "",
            "innerTareWeight": 1.4,
            "innerMaximumWeight": 0.25,
            "innerMinimumWeight": 0.225,
            "innerLabel": "F_Bidfood_225g",
            "tradeItemLabel": "D_Baltisk_EAN13",
            "outerLabel": "",
            "labelImage1": "",
            "labelImage2": "",
            "tradeItemNetWeightKg": 3.6,
            "tradeItemNetWeightLb": 7.93664143865559289,
            "productSizeGrade": "200-300",
            "sizeGradeDescription": "200-300",
            "productQualityGrade": "",
            "qualityGradeDescription": "",
            "defaultRawMaterialState": "",
            "cutCode": "",
            "innovaItem": false,
            "lastModified": "2025-10-21T14:29:50.557Z"}
      ]

Overview

Data

Field List

Example