pixiReportGetStockItems

Pixi-Docs

Old Pixi-Docs

Enabled but undocumented

API Call for stock evaluation and recalculation of prices.

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

KPIs Reports Statistics

Request

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

Request body

Name	Type	Required	Description
SupplNr	string	false	Supplier number Type: varchar(4) Default value: NULL Example: Available from: LOU Official - Update 46 (6.9.46.27927)
SoldRange1	integer	false	Sold quantity over defined days (default 30) Type: int Default value: 30 Example: 123 Available from: LOU Official - Update 46 (6.9.46.27927)
SoldRange2	integer	false	Sold quantity over defined days (default 90) Type: int Default value: 90 Example: 123 Available from: LOU Official - Update 46 (6.9.46.27927)
SoldRange3	integer	false	Sold quantity over defined days (default 120) Type: int Default value: 120 Example: 123 Available from: LOU Official - Update 46 (6.9.46.27927)

Request Example

<Envelope xmlns="http://schemas.xmlsoap.org/soap/envelope/">
  <Body xmlns="">
    <pixiReportGetStockItems>
      <SupplNr>string</SupplNr>
      <SoldRange1>0</SoldRange1>
      <SoldRange2>0</SoldRange2>
      <SoldRange3>0</SoldRange3>
    </pixiReportGetStockItems>
  </Body>
</Envelope>

Response

1. Result set

Name	Type	Description
EK	number	EK Type: money Available from: / (25.7.0.59144)
VK	number	VK Type: money Available from: / (25.7.0.59144)
EANUPC	string	EANUPC Type: varchar Available from: / (25.7.0.59144)
ItemKey	integer	ItemKey Type: int Available from: / (25.7.0.59144)
EKGesamt	number	EKGesamt Type: money Available from: / (25.7.0.59144)
Lieferant	string	Lieferant Type: varchar Available from: / (25.7.0.59144)
soldRange1	integer	soldRange1 Type: int Available from: / (25.7.0.59144)
soldRange2	integer	soldRange2 Type: int Available from: / (25.7.0.59144)
soldRange3	integer	soldRange3 Type: int Available from: / (25.7.0.59144)
Artikelname	string	Artikelname Type: varchar Available from: / (25.7.0.59144)
AufLagerSeit	string	AufLagerSeit Type: datetime Available from: / (25.7.0.59144)
Artikelnummer	string	Artikelnummer Type: varchar Available from: / (25.7.0.59144)
AufLagerSeitTage	integer	AufLagerSeitTage Type: int Available from: / (25.7.0.59144)
LetzteBestellung	string	LetzteBestellung Type: datetime Available from: / (25.7.0.59144)
LetzteBestellungTage	integer	LetzteBestellungTage Type: int Available from: / (25.7.0.59144)
AnzahlArtikelAufLager	integer	AnzahlArtikelAufLager Type: int Available from: / (25.7.0.59144)

Response Example

<PixiReportGetStockItemsPost200TextXmlResponse>
  <ItemKey>0</ItemKey>
  <Artikelnummer>string</Artikelnummer>
  <EANUPC>string</EANUPC>
  <Lieferant>string</Lieferant>
  <Artikelname>string</Artikelname>
  <VK>0</VK>
  <EK>0</EK>
  <AnzahlArtikelAufLager>0</AnzahlArtikelAufLager>
  <EKGesamt>0</EKGesamt>
  <AufLagerSeit>string</AufLagerSeit>
  <AufLagerSeitTage>0</AufLagerSeitTage>
  <LetzteBestellung>string</LetzteBestellung>
  <LetzteBestellungTage>0</LetzteBestellungTage>
  <soldRange1>0</soldRange1>
  <soldRange2>0</soldRange2>
  <soldRange3>0</soldRange3>
</PixiReportGetStockItemsPost200TextXmlResponse>

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:pixiReportGetStockItems>
            <SupplNr xsi:type="xsd:string"></SupplNr>
            <SoldRange1 xsi:type="xsd:integer">123</SoldRange1>
            <SoldRange2 xsi:type="xsd:integer">123</SoldRange2>
            <SoldRange3 xsi:type="xsd:integer">123</SoldRange3>
        </ns1:pixiReportGetStockItems>
    </SOAP-ENV:Body>
</SOAP-ENV:Envelope>

PHP Example

<?php

getPixiSoapClientResponse('pixiReportGetStockItems', [
    'SupplNr' => '', // string
    'SoldRange1' => '123', // integer
    'SoldRange2' => '123', // integer
    'SoldRange3' => '123', // integer
]);

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

Unofficial Pixi-API-Documentation

by koempf24.de