The API call creates one single Bin or multiple Bins.

Since pixi version: 22.06 (22.6.0.28129) Additional notes: Using parameter @BinsXML we allow to create new Bin(s).

    **Important**
    Input XML is parsed to values and validated:
     - Name **mandatory**: max 50 characters, should be unique on Database or on Location (setting FilterStockOperationsWithLocation)
     - LocId **mandatory**: LocId should exist in pixi
     - Group **optional**: can be empty - default is [empty string]
     - SortNr **mandatory**: numeric value, positive
     - MaxItems **mandatory**: numeric value, positive
     - TransportBin **optional**: bit value, default 0 [false]
    
    We do not allow to create new bin if new record will introduce duplicates on Database or on Location.
    This is controlled with setting FilterStockOperationsWithLocation.
     - Value = 0: Bin Names are unique on Database
     - Value = 1: same Bin Names can exist in different Locations
    We check for duplicated also in input XML
    
    For transport bins we do not allow duplicates on database.
    
    **XML example:**
    		<Bins>
    			<Bin>
    				<Name>A26-16-A-2</Name>
    				<LocId>001</LocId>
    				<Group>Lager A</Group>
    				<SortNr>456312</SortNr>
    				<MaxItems>100</MaxItems>
                    <TransportBin>1</TransportBin>
    			</Bin>
    			<Bin>
    				<Name>A26-16-A-3</Name>
    				<LocId>001</LocId>
    				<SortNr>456312</SortNr>
    				<MaxItems>1</MaxItems>
                    <TransportBin>0</TransportBin>
    			</Bin>
    		</Bins>
    
    **Return result**
    On success we return a list of values parsed from XML with status and message per each row.
    If XML cannot be parsed we return error with status message.
    
    **Possible return error messages**
    XML contains no data.
    Cannot parse XML
    Bin not created (Duplicated).
    Bin not created. Name is empty.
    Bin not created. Location is empty.
    Bin not created. Datatype error (SortNr).
    Bin not created. SortNr is empty.
    Bin not created. SortNr should be positive.
    Bin not created. Datatype error (MaxItems).
    Bin not created. MaxItems is empty.
    Bin not created. MaxItems should be positive.
    Bin not created (Location does not exist).

Request

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

Request body

Name Type Required Description
BinsXML string true

Data for Bin(s) in XML format.

Type: varchar(-1)

Default value:

Example: Check additional information

Available from: 22.06 (22.6.0.28129)

CreateEmp string false

User who requested the change.

Type: varchar(50)

Default value: API

Example: API

Available from: 22.06 (22.6.0.28129)


Response

1. Result

Name Type Description
Row integer

Row number of resultset

Type: INT

Available from: 25.06 (25.6.0.58802)

LocId string

Location Id from table Location

Type: VARCHAR

Available from: 25.06 (25.6.0.58802)

BinKey integer

Id from table InvBin

Type: INT

Available from: 25.06 (25.6.0.58802)

SortNr integer

Bin Sort Number

Type: INT

Available from: 25.06 (25.6.0.58802)

Status string

Response status (CREATED/INFO/ERROR)

Type: VARCHAR

Available from: 25.06 (25.6.0.58802)

BinName string

Bin Name

Type: VARCHAR

Available from: 25.06 (25.6.0.58802)

Message string

Response detail message

Type: VARCHAR

Available from: 25.06 (25.6.0.58802)

BinGroup string

Bin Group

Type: VARCHAR

Available from: 25.06 (25.6.0.58802)

MaxItems integer

Maximum number of items in one Bin

Type: INT

Available from: 25.06 (25.6.0.58802)

TransportBin boolean

Boolean indicating if bin is a transport bin

Type: BIT

Available from: 25.06 (25.6.0.58802)

2. Status output

Name Type Description
Status string

Execution status (CREATED/INFO/ERROR)

Type: varchar

Available from: 25.06 (25.6.0.58802)

Message string

Description of the status

Type: varchar

Available from: 25.06 (25.6.0.58802)