Overview
The list page that contains the External Items, i.e. the item numbers and descriptions that an external party (a customer, vendor, country or stock center) uses for a Wisefish item. Each external item points to one item in Wisefish, and gives the external party's own item number and description, the units and quantities for shipping, the shelf life and the label codes. No data update is allowed: the external items are maintained in Business Central.
An item can have many external items (one per external party), and each external party can have many external items. The label selection for an external item, per ship-to address or stock center, is available with the externalItemLabels endpoint, see Related endpoints.
|
Endpoint name |
|
|
Source table |
|
|
Fixed view |
No filter. Returns the external items of all types of external party. |
|
Requests allowed |
GET |
|
Primary key |
“Type of Ext. Party”, “External Party Code”, “Ext. Item No.” |
|
Record ID |
|
|
Procedures |
None |
External party
The external party is given by typeOfExternalParty and externalPartyCode. Depending on the type, the code is a stock center code, a customer number, a vendor number or a country/region code. The external item number is unique per external party.
Data
Field List
|
Property |
Type |
Format |
Description |
|
|
|
string |
uuid |
SystemId |
Record ID non-editable |
|
|
string |
enum |
Type of Ext. Party. Options: Stock Center, Customer, Vendor, Country |
primary key |
|
|
string |
max 20 |
External Party Code: a stock center code, customer number, vendor number or country/region code, depending on |
primary key |
|
|
string |
max 20 |
Ext. Item No., the external party's item number. |
primary key |
|
|
string |
max 100 |
Ext. Item Description, the external party's description of the item. |
|
|
|
string |
max 300 |
Ext. Item Description 2 |
|
|
|
string |
max 20 |
Item No., the Wisefish item (a trade item) that the external item points to. |
|
|
|
string |
max 100 |
Item Description, the description of the Wisefish item. |
|
|
|
string |
max 10 |
Trademark |
|
|
|
string |
max 10 |
Country of Origin (country/region code) |
|
|
|
string |
max 10 |
TI Unit of Measure, the trade item unit for the external party, for example BOX. A unit of the item. |
|
|
|
string |
max 10 |
Pallet Unit of Measure. A unit of the item. |
|
|
|
number |
decimal |
No. of TIs per Pallet, how many trade items (for example boxes) are on a full pallet. |
|
|
|
number |
decimal |
No. of TIs per Container, how many trade items are in a container (of the type in |
|
|
|
string |
max 10 |
Container Unit of Measure, for example a 20 ft or 40 ft container. A unit of the item. |
|
|
|
integer |
|
Shelf Life Days. Some parties use the shelf life days left rather than a best-before date. |
|
|
|
integer |
|
Expiration Unit, the time from production to expiration. The unit (days, months or years) is the “Expiration Type” of the item. For example 18 with Expiration Type Months means 18 months after the production date. |
|
|
|
string |
max 30 |
Country Inner Label, the code of the inner label. |
|
|
|
string |
max 30 |
Country Trade Item Label, the code of the trade item label. |
|
|
|
string |
max 30 |
Country Outer Label, the code of the outer label. |
|
|
|
string |
max 30 |
Country Pallet Label, the code of the pallet label. |
|
|
|
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:
{
"systemId": "a5264353-9f94-f011-b41a-00224875847c",
"typeOfExternalParty": "Customer",
"externalPartyCode": "41000",
"externalItemNo": "HAD-160-MSC",
"externalItemDescription": "Haddock portions 160 g, frozen",
"externalItemDescription2": "",
"itemNo": "0034-840MSC",
"itemDescription": "Haddock portions block 160x7.5 kg",
"trademark": "",
"countryOfOrigin": "IS",
"tradeItemUnitOfMeasure": "BOX",
"palletUnitOfMeasure": "PALLET",
"noOfTIsPerPallet": 120,
"noOfTIsPerContainer": 2400,
"containerUnitOfMeasure": "40FT",
"shelfLifeDays": 0,
"expirationUnit": 18,
"countryInnerLabel": "F_DK_INNER",
"countryTradeItemLabel": "D_DK_9405",
"countryOuterLabel": "",
"countryPalletLabel": "",
"systemRowVersion": 2580117,
"lastModified": "2026-09-18T14:54:54.987Z"
}
Related endpoints
-
externalItemLabels: the label selection for external items, per ship-to address or stock center. See API - External Item Labels. -
itemDetails: the Wisefish item initemNo. See API - Item Details.
Examples
Read external items
Read all entries
Reads all external items, for all types of external party. The response is a list of external item objects, as shown in Object Example.
GET .../externalItems
Read the external items of a customer
Reads the external items of customer 41000.
GET .../externalItems?$filter=typeOfExternalParty eq 'Customer' and externalPartyCode eq '41000'
Find the external numbers of an item
Reads the external item numbers that external parties use for item 0034-840MSC, and returns only a few fields with $select.
Request:
GET .../externalItems?$filter=itemNo eq '0034-840MSC'&$select=typeOfExternalParty,externalPartyCode,externalItemNo,externalItemDescription
Response:
{
"@odata.context": "https://containers.wisefish.com/BC/api/wisefish/base/v1.0/$metadata#companies(cf9f7b85-dd11-ef11-9f8b-6045bde9cc61)/externalItems(typeOfExternalParty,externalPartyCode,externalItemNo,externalItemDescription)",
"value": [
{
"@odata.etag": "W/\"JzE5OzIzOTA2ODkyMTQ3NTUyNTY5NzExOzAwOyc=\"",
"typeOfExternalParty": "Customer",
"externalPartyCode": "41000",
"externalItemNo": "HAD-160-MSC",
"externalItemDescription": "Haddock portions 160 g, frozen"
},
{
"@odata.etag": "W/\"JzIwOzEzNjMyOTEwNTg2MjUyNTExNDI3MTswMDsn\"",
"typeOfExternalParty": "Country",
"externalPartyCode": "DK",
"externalItemNo": "KULLER-160",
"externalItemDescription": "Kuller portioner 160 g"
},
{
"@odata.etag": "W/\"JzIwOzE0NzI5MzA1ODYyNTI1MTE0MjcxOzAwOyc=\"",
"typeOfExternalParty": "Stock Center",
"externalPartyCode": "BLUE",
"externalItemNo": "HAD160",
"externalItemDescription": "Haddock 160 g block"
}
]
}
Read external items changed since a given time
Reads the external items that have been changed after a given date and time, for example to synchronize them to a production system.
GET .../externalItems?$filter=lastModified gt 2026-11-01T00:00:00Z