pixi Developer & Integration Documentation

pixiReadItems

Description

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


Request Parameters

# Name Type Required Example Description
1 ItemKey integer 0 123 pixi* Item Key
2 CreateDateFrom string 0 YYYY-MM-DD hh:mm:ss Create Date from (including)
3 CreateDateTo string 0 YYYY-MM-DD hh:mm:ss Create Date to (excluding)
4 UpdateDateFrom string 0 YYYY-MM-DD hh:mm:ss Update Date from (including)
5 UpdateDateTo string 0 YYYY-MM-DD hh:mm:ss Update Date To (excluding)
6 CreateAndUpdateDateFrom string 0 YYYY-MM-DD hh:mm:ss Create or Update Date from (including)
7 CreateAndUpdateDateTo string 0 YYYY-MM-DD hh:mm:ss Create or Update Date to (excluding)
8 RowCount integer 0 123 number of rows returned maximum

Request body

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:dem="https://api.pixi.eu/soap/demosandbox/">
   <soapenv:Header/>
   <soapenv:Body>
      <dem:pixiReadItems>
         <dem:ItemKey>123</dem:ItemKey>
         <dem:CreateDateFrom>YYYY-MM-DD hh:mm:ss</dem:CreateDateFrom>
         <dem:CreateDateTo>YYYY-MM-DD hh:mm:ss</dem:CreateDateTo>
         <dem:UpdateDateFrom>YYYY-MM-DD hh:mm:ss</dem:UpdateDateFrom>
         <dem:UpdateDateTo>YYYY-MM-DD hh:mm:ss</dem:UpdateDateTo>
         <dem:CreateAndUpdateDateFrom>YYYY-MM-DD hh:mm:ss</dem:CreateAndUpdateDateFrom>
         <dem:CreateAndUpdateDateTo>YYYY-MM-DD hh:mm:ss</dem:CreateAndUpdateDateTo>
         <dem:RowCount>123</dem:RowCount>
      </dem:pixiReadItems>
   </soapenv:Body>
</soapenv:Envelope>

Response


Body 1: Item information

# Name Type Description
1 ItemKey integer pixi* item ID
2 EANUPC string Item barcode
3 UPC string
4 ItemNrSuppl string Supplier item number
5 ItemNrInt string Shop item number
6 ItemNrOld string
7 SupplNr string Supplier number (code)
8 DataSuppl string
9 ItemName string Item name
10 ConfigType string
11 Price number
12 SupplPrice number Supplier price of the item
13 Curr_Source string
14 MwStSatz string VAT Rate
15 AutoPrice boolean
16 RelDate string Field is deprecated
17 DisDate string Field is deprecated
18 Weight number Weight in grams
19 Heigth number
20 Width number
21 Length number
22 PicLinkLarge string URL to picture of the item (large size)
23 PicLinkSmall string URL to picture of the item (small size)
24 VPE string Field is deprecated
25 MinOrderQty integer Field is deprecated
26 CreateDate string Create date
27 UpdateDate string Last update date of the record
28 AvgDeliveryTime integer Field is deprecated
29 Quantity integer
30 MinStockQty integer Minimum stock quantity for the item
31 BookAccountEu string
32 BookAccountNonEu string
33 BookAccountEuCompanies string
34 SerialNrRequired boolean
35 OrderUnit string
36 ExportQtyAvail integer Field is deprecated
37 ExportReportedQtyAvail integer Field is deprecated
38 ExportEstimatedDelivery string
39 Enabled boolean
40 BookAccountEU_Suppl string
41 BookAccountNonEU_Suppl string
42 BookAccountEUCompanies_Suppl string
43 CustomsTariffNumber string
44 CustomsCountryOfOrigin string Country of Origin imported for the item with item import (ISO-2 format)
45 CustomsTariffText string Customs Tariff Text imported for the item with item import
46 CustomsPreviousProcess string
47 UpdateEmp string User who last updated the record
48 LastImportDate string
49 IsBundle boolean
50 SupplName string Supplier name
51 TontrText string Name of the category
52 Manufacturer string Name of the manufacturer

Additional Notes