pixiReportInvlines
Invlines report.
Since pixi version: LOU Official - Update 46 (6.9.46.27927) Additional notes:
Request
Request body
Name | Type | Required | Description |
---|---|---|---|
EAN | string | false | Filter by item (ean barcode). Type: varchar(13) Default value: NULL Example: Available from: LOU Official - Update 46 (6.9.46.27927) |
DateTo | string | false | Date until when invlines are taken. Type: datetime Default value: NULL Example: Available from: LOU Official - Update 46 (6.9.46.27927) |
ShopID | string | false | Shop Id Type: varchar(3) Default value: NULL Example: Available from: LOU Official - Update 46 (6.9.46.27927) |
SupplNr | string | false | Filter by Supplier number. Type: varchar(4) Default value: NULL Example: Available from: LOU Official - Update 46 (6.9.46.27927) |
Category | string | false | Filter by Category. Type: varchar(50) Default value: NULL Example: Available from: LOU Official - Update 46 (6.9.46.27927) |
DateFrom | string | false | Required date from when report is created. Type: datetime Default value: NULL Example: Available from: LOU Official - Update 46 (6.9.46.27927) |
Rowcount | integer | false | Number of returned records. Type: int Default value: 1000 Example: Available from: LOU Official - Update 46 (6.9.46.27927) |
ItemNrInt | string | false | Filter by internal item number. Type: varchar(50) Default value: NULL Example: Available from: LOU Official - Update 46 (6.9.46.27927) |
PaymentType | string | false | Filter by Payment type. Type: char Default value: NULL Example: Available from: LOU Official - Update 46 (6.9.46.27927) |
Request Example
<Envelope xmlns="http://schemas.xmlsoap.org/soap/envelope/">
<Body xmlns="">
<pixiReportInvlines>
<Rowcount>0</Rowcount>
<DateFrom>string</DateFrom>
<DateTo>string</DateTo>
<ShopID>string</ShopID>
<PaymentType>string</PaymentType>
<SupplNr>string</SupplNr>
<Category>string</Category>
<EAN>string</EAN>
<ItemNrInt>string</ItemNrInt>
</pixiReportInvlines>
</Body>
</Envelope>
Response
1. Return status
Name | Type | Description |
---|---|---|
EANUPC | string | EANUPC Type: varchar Available from: 25.06 (25.6.0.58802) |
ShopID | string | ShopID Type: varchar Available from: 25.06 (25.6.0.58802) |
InvDate | string | InvDate Type: varchar Available from: 25.06 (25.6.0.58802) |
ItemQty | integer | ItemQty Type: int Available from: 25.06 (25.6.0.58802) |
Itemkey | integer | Itemkey Type: int Available from: 25.06 (25.6.0.58802) |
SupplNR | string | SupplNR Type: varchar Available from: 25.06 (25.6.0.58802) |
Category | string | Category Type: varchar Available from: 25.06 (25.6.0.58802) |
ItemName | string | ItemName Type: varchar Available from: 25.06 (25.6.0.58802) |
Supplier | string | Supplier Type: varchar Available from: 25.06 (25.6.0.58802) |
InvoiceNR | string | InvoiceNR Type: varchar Available from: 25.06 (25.6.0.58802) |
ItemNrInt | string | ItemNrInt Type: varchar Available from: 25.06 (25.6.0.58802) |
InvoiceKey | integer | InvoiceKey Type: int Available from: 25.06 (25.6.0.58802) |
SupplPrice | integer | SupplPrice Type: int Available from: 25.06 (25.6.0.58802) |
ItemNrSuppl | string | ItemNrSuppl Type: varchar Available from: 25.06 (25.6.0.58802) |
PaymentType | string | PaymentType Type: varchar Available from: 25.06 (25.6.0.58802) |
orderlinekey | integer | orderlinekey Type: int Available from: 25.06 (25.6.0.58802) |
ItemPrice_VAT | integer | ItemPrice_VAT Type: int Available from: 25.06 (25.6.0.58802) |
ItemPrice_netto | integer | ItemPrice_netto Type: int Available from: 25.06 (25.6.0.58802) |
ItemPrice_Brutto | integer | ItemPrice_Brutto Type: int Available from: 25.06 (25.6.0.58802) |
OrderCurrencyCode | string | OrderCurrencyCode Type: varchar Available from: 25.06 (25.6.0.58802) |
Response Example
<PixiReportInvlinesPost200TextXmlResponse>
<Itemkey>0</Itemkey>
<InvoiceKey>0</InvoiceKey>
<InvoiceNR>string</InvoiceNR>
<InvDate>string</InvDate>
<PaymentType>string</PaymentType>
<orderlinekey>0</orderlinekey>
<ShopID>string</ShopID>
<SupplNR>string</SupplNR>
<Supplier>string</Supplier>
<ItemName>string</ItemName>
<EANUPC>string</EANUPC>
<ItemNrInt>string</ItemNrInt>
<ItemNrSuppl>string</ItemNrSuppl>
<Category>string</Category>
<ItemQty>0</ItemQty>
<SupplPrice>0</SupplPrice>
<ItemPrice_Brutto>0</ItemPrice_Brutto>
<ItemPrice_netto>0</ItemPrice_netto>
<ItemPrice_VAT>0</ItemPrice_VAT>
<OrderCurrencyCode>string</OrderCurrencyCode>
</PixiReportInvlinesPost200TextXmlResponse>
HTTP Example
POST https://apigateway.descartes.com/tms/pixi/
Content-Type: text/xml; charset=utf-8
# echo -n '{{username}}:{{password}}' | base64 | pbcopy
Authorization: Basic {{token}}
<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:ns1="https://apigateway.descartes.com/tms/pixi/"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<SOAP-ENV:Body>
<ns1:pixiReportInvlines>
<EAN xsi:type="xsd:string"></EAN>
<DateTo xsi:type="xsd:string"></DateTo>
<ShopID xsi:type="xsd:string"></ShopID>
<SupplNr xsi:type="xsd:string"></SupplNr>
<Category xsi:type="xsd:string"></Category>
<DateFrom xsi:type="xsd:string"></DateFrom>
<Rowcount xsi:type="xsd:integer"></Rowcount>
<ItemNrInt xsi:type="xsd:string"></ItemNrInt>
<PaymentType xsi:type="xsd:string"></PaymentType>
</ns1:pixiReportInvlines>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
PHP Example
<?php
getPixiSoapClientResponse('pixiReportInvlines', [
'EAN' => '', // string
'DateTo' => '', // string
'ShopID' => '', // string
'SupplNr' => '', // string
'Category' => '', // string
'DateFrom' => '', // string
'Rowcount' => '', // integer
'ItemNrInt' => '', // string
'PaymentType' => '', // string
]);
function getPixiSoapClientResponse(string $method, array $arguments = [])
{
$soapArguments = [];
foreach ($arguments as $key => $value) {
$soapArguments[] = new SoapVar($value, null, '', '', $key);
}
$soapClient = new SoapClient(null, [
'login' => '...',
'password' => '...',
'uri' => 'https://apigateway.descartes.com/tms/pixi/',
'location' => 'https://apigateway.descartes.com/tms/pixi/',
]);
return $soapClient->__call($method, $soapArguments);
}