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