API - External Items


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

externalItems

Source table

WiFi External Item No.

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

systemId

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


systemId

string

uuid

SystemId

Record ID

non-editable

typeOfExternalParty

string

enum

Type of Ext. Party. Options: Stock Center, Customer, Vendor, Country

primary key

externalPartyCode

string

max 20

External Party Code: a stock center code, customer number, vendor number or country/region code, depending on typeOfExternalParty.

primary key

externalItemNo

string

max 20

Ext. Item No., the external party's item number.

primary key

externalItemDescription

string

max 100

Ext. Item Description, the external party's description of the item.


externalItemDescription2

string

max 300

Ext. Item Description 2


itemNo

string

max 20

Item No., the Wisefish item (a trade item) that the external item points to.


itemDescription

string

max 100

Item Description, the description of the Wisefish item.


trademark

string

max 10

Trademark


countryOfOrigin

string

max 10

Country of Origin (country/region code)


tradeItemUnitOfMeasure

string

max 10

TI Unit of Measure, the trade item unit for the external party, for example BOX. A unit of the item.


palletUnitOfMeasure

string

max 10

Pallet Unit of Measure. A unit of the item.


noOfTIsPerPallet

number

decimal

No. of TIs per Pallet, how many trade items (for example boxes) are on a full pallet.


noOfTIsPerContainer

number

decimal

No. of TIs per Container, how many trade items are in a container (of the type in containerUnitOfMeasure).


containerUnitOfMeasure

string

max 10

Container Unit of Measure, for example a 20 ft or 40 ft container. A unit of the item.


shelfLifeDays

integer


Shelf Life Days. Some parties use the shelf life days left rather than a best-before date.


expirationUnit

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.


countryInnerLabel

string

max 30

Country Inner Label, the code of the inner label.


countryTradeItemLabel

string

max 30

Country Trade Item Label, the code of the trade item label.


countryOuterLabel

string

max 30

Country Outer Label, the code of the outer label.


countryPalletLabel

string

max 30

Country Pallet Label, the code of the pallet label.


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:

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


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:

JSON
GET .../externalItems?$filter=itemNo eq '0034-840MSC'&$select=typeOfExternalParty,externalPartyCode,externalItemNo,externalItemDescription

Response:

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