Unofficial Pixi-API-Documentation

by koempf24.de

pixiReportStockSalesOverview

Pixi-Docs
Old Pixi-Docs

Overiew of all items with Stocklevel, Stock movements and basic sales.

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

KPIs Reports Statistics

Request

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

Request body

Name Type Required Description
RowCount integer false

(optional) Nr of Rows to return (1000 default)

Type: int

Default value:

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)
ItemKeyStart integer false

(optional) Starting with ItemKey, for pagination.

Type: int

Default value:

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)
StatDateFrom string false

(0ptional) Set start date for the statistics. Sales and stock movement are only considered after that date (YYYYMMDD)

Type: datetime

Default value:

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)
OnlyItemsOnStock boolean false

(optional) Only show items with stock at the moment.

Type: bit

Default value:

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

Request Example

<Envelope xmlns="http://schemas.xmlsoap.org/soap/envelope/">
  <Body xmlns="">
    <pixiReportStockSalesOverview>
      <StatDateFrom>string</StatDateFrom>
      <ItemKeyStart>0</ItemKeyStart>
      <OnlyItemsOnStock>true</OnlyItemsOnStock>
      <RowCount>0</RowCount>
    </pixiReportStockSalesOverview>
  </Body>
</Envelope>

Response

Name Type Description

Response Example

<PixiReportStockSalesOverviewPost200TextXmlResponse />

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:pixiReportStockSalesOverview>
            <RowCount xsi:type="xsd:integer"></RowCount>
            <ItemKeyStart xsi:type="xsd:integer"></ItemKeyStart>
            <StatDateFrom xsi:type="xsd:string"></StatDateFrom>
            <OnlyItemsOnStock xsi:type="xsd:boolean"></OnlyItemsOnStock>
        </ns1:pixiReportStockSalesOverview>
    </SOAP-ENV:Body>
</SOAP-ENV:Envelope>

PHP Example

<?php

getPixiSoapClientResponse('pixiReportStockSalesOverview', [
    'RowCount' => '', // integer
    'ItemKeyStart' => '', // integer
    'StatDateFrom' => '', // string
    'OnlyItemsOnStock' => '', // boolean
]);

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);
}