API Call to retrieve all items. For better results use API call pixiReadAddItems .

Since pixi version: LOU Official - Update 46 (6.9.46.27927) Additional notes:


Request

POST https://apigateway.descartes.com/tms/pixi/pixiReadItems

Request body

Name Type Required Description
ItemKey integer false

pixi* Item Key

Type: int

Default value: NULL

Example: 123

Available from: LOU Official - Update 46 (6.9.46.27927)

RowCount integer false

number of rows returned maximum

Type: int

Default value: NULL

Example: 123

Available from: LOU Official - Update 46 (6.9.46.27927)

CreateDateTo string false

Create Date to (excluding)

Type: datetime

Default value: NULL

Example: YYYY-MM-DD hh:mm:ss

Available from: LOU Official - Update 46 (6.9.46.27927)

UpdateDateTo string false

Update Date To (excluding)

Type: datetime

Default value: NULL

Example: YYYY-MM-DD hh:mm:ss

Available from: LOU Official - Update 46 (6.9.46.27927)

CreateDateFrom string false

Create Date from (including)

Type: datetime

Default value: NULL

Example: YYYY-MM-DD hh:mm:ss

Available from: LOU Official - Update 46 (6.9.46.27927)

UpdateDateFrom string false

Update Date from (including)

Type: datetime

Default value: NULL

Example: YYYY-MM-DD hh:mm:ss

Available from: LOU Official - Update 46 (6.9.46.27927)

CreateAndUpdateDateTo string false

Create or Update Date to (excluding)

Type: datetime

Default value: NULL

Example: YYYY-MM-DD hh:mm:ss

Available from: LOU Official - Update 46 (6.9.46.27927)

CreateAndUpdateDateFrom string false

Create or Update Date from (including)

Type: datetime

Default value: NULL

Example: YYYY-MM-DD hh:mm:ss

Available from: LOU Official - Update 46 (6.9.46.27927)


Response

1. Item information

Name Type Description
UPC string

Type: varchar

Available from: / (25.7.0.59144)

VPE string

Field is deprecated

Type: smallint

Available from: / (25.7.0.59144)

Price number

Type: money

Available from: / (25.7.0.59144)

Width number

Type: numeric

Available from: / (25.7.0.59144)

EANUPC string

Item barcode

Type: varchar

Available from: / (25.7.0.59144)

Heigth number

Type: numeric

Available from: / (25.7.0.59144)

Length number

Type: numeric

Available from: / (25.7.0.59144)

Weight number

Weight in grams

Type: numeric

Available from: / (25.7.0.59144)

DisDate string

Field is deprecated

Type: datetime

Available from: / (25.7.0.59144)

Enabled boolean

Type: bit

Available from: / (25.7.0.59144)

ItemKey integer

pixi* item ID

Type: int

Available from: / (25.7.0.59144)

RelDate string

Field is deprecated

Type: datetime

Available from: / (25.7.0.59144)

SupplNr string

Supplier number (code)

Type: varchar

Available from: / (25.7.0.59144)

IsBundle boolean

Type: bit

Available from: / (25.7.0.59144)

ItemName string

Item name

Type: varchar

Available from: / (25.7.0.59144)

MwStSatz string

VAT Rate

Type: smallint

Available from: / (25.7.0.59144)

Quantity integer

Type: int

Available from: / (25.7.0.59144)

AutoPrice boolean

Type: bit

Available from: / (25.7.0.59144)

DataSuppl string

Type: varchar

Available from: / (25.7.0.59144)

ItemNrInt string

Shop item number

Type: varchar

Available from: / (25.7.0.59144)

ItemNrOld string

Type: varchar

Available from: / (25.7.0.59144)

OrderUnit string

Type: varchar

Available from: / (25.7.0.59144)

SupplName string

Supplier name

Type: varchar

Available from: / (25.7.0.59144)

TontrText string

Name of the category

Type: varchar

Available from: / (25.7.0.59144)

UpdateEmp string

User who last updated the record

Type: varchar

Available from: / (25.7.0.59144)

ConfigType string

Type: varchar

Available from: / (25.7.0.59144)

CreateDate string

Create date

Type: smalldatetime

Available from: / (25.7.0.59144)

SupplPrice number

Supplier price of the item

Type: money

Available from: / (25.7.0.59144)

UpdateDate string

Last update date of the record

Type: smalldatetime

Available from: / (25.7.0.59144)

Curr_Source string

Type: varchar

Available from: / (25.7.0.59144)

ItemNrSuppl string

Supplier item number

Type: varchar

Available from: / (25.7.0.59144)

MinOrderQty integer

Field is deprecated

Type: int

Available from: / (25.7.0.59144)

MinStockQty integer

Minimum stock quantity for the item

Type: int

Available from: / (25.7.0.59144)

Manufacturer string

Name of the manufacturer

Type: varchar

Available from: / (25.7.0.59144)

PicLinkLarge string

URL to picture of the item (large size)

Type: varchar

Available from: / (25.7.0.59144)

PicLinkSmall string

URL to picture of the item (small size)

Type: varchar

Available from: / (25.7.0.59144)

BookAccountEu string

Type: varchar

Available from: / (25.7.0.59144)

ExportQtyAvail integer

Field is deprecated

Type: int

Available from: / (25.7.0.59144)

LastImportDate string

Type: datetime

Available from: / (25.7.0.59144)

AvgDeliveryTime integer

Field is deprecated

Type: int

Available from: / (25.7.0.59144)

BookAccountNonEu string

Type: varchar

Available from: / (25.7.0.59144)

SerialNrRequired boolean

Type: bit

Available from: / (25.7.0.59144)

CustomsTariffText string

Customs Tariff Text imported for the item with item import

Type: varchar

Available from: / (25.7.0.59144)

BookAccountEU_Suppl string

Type: varchar

Available from: / (25.7.0.59144)

CustomsTariffNumber string

Type: varchar

Available from: / (25.7.0.59144)

BookAccountEuCompanies string

Type: varchar

Available from: / (25.7.0.59144)

BookAccountNonEU_Suppl string

Type: varchar

Available from: / (25.7.0.59144)

CustomsCountryOfOrigin string

Country of Origin imported for the item with item import (ISO-2 format)

Type: varchar

Available from: / (25.7.0.59144)

CustomsPreviousProcess string

Type: varchar

Available from: / (25.7.0.59144)

ExportReportedQtyAvail integer

Field is deprecated

Type: int

Available from: / (25.7.0.59144)

ExportEstimatedDelivery string

Type: datetime

Available from: / (25.7.0.59144)

BookAccountEUCompanies_Suppl string

Type: varchar

Available from: / (25.7.0.59144)