1.1 Serial Numbers

Interface

It allows you:

  • to insert or update new Serial Numbers

If the ”ID's” columns are used then the corresponding columns for name or value would be ignored.

Serial Numbers

#

Field Name

Warehouse_ID

Warehouse

Product_ID

Description

SerialNumber_ID

Barcode1Name

Barcode1

Barcode2Name

Barcode2

Barcode3Name

Barcode3

Barcode4Name

Barcode4

Box1Name

Box1Barcode

Box2Name

Box2Barcode

Box3Name

Box3Barcode

Box4Name

Box4Barcode

Barcode1

SerialNumber_ID

StockLine_ID

Description

The unique ID of the warehouse

Name of warehouse

The unique ID of the product

Description of Serial Number

The unique ID of the WMS module unique serial.

The name of the first barcode

The first barcode

The name of the second barcode

The second barcode

The name of the third barcode

The third barcode

The name of the forth barcode

The forth barcode

Barcode name of the first packing level

Barcode of the first packing level

Barcode name of the second packing level

Barcode of the second packing level

Barcode name of the third packing level

Barcode of the third packing level

Barcode name of the forth packing level

Barcode of the forth packing level

Response

Barcode1

Numeric

(whole)

String

Numeric

(whole)

String (2000)

Numeric

(whole)

String(40)

String(40)

String(40)

String(40)

String(40)

String(40)

String(40)

String(40)

String(40)

String(40)

String(40)

String(40)

String(40)

String(40)

String(40)

String(40)

String(40)

Numeric

(whole)

Numeric

(whole)

Data

type

Action

Mandatory

Y

Y

Y

The unique ID of the serial number

Id stock line for unlock methode

],

"totalRows": 2

}

API Method

List serial numbers

URL: https://api.socratecloud.com/scwi/rest/serial_number/list/{version}?startRow={0}&endRow={100}&accessToken={access_token}&LocationWarehouse_ID={warehouse_ID}&Product_ID={Product ID}

Mandatory parameter:

    • LocationWarehouse_ID - generic warehouse ID or WMS warehouse ID from login. For using generic warehouse in login, role must have "Generic Warehouse" = true

Method: GET

Return: serial numbers for success or error message (start with "ERROR: ")

Data format:

{

"data": [

{

"Organization_ID": 1000001,

"Organization": "Demo SRL",

"Warehouse_ID": 1001883,

"Warehouse": "Gestiune WMS fizica Brasov",

"Created": "2018-05-22 09:14:16+0000",

"CreatedBy_ID": 1000002,

"CreatedBy": "AdminTitular",

"Updated": "2018-05-24 07:13:04+0000",

"UpdatedBy_ID": 1000002,

"UpdatedBy": "AdminTitular",

"Line": 1,

"Product": "Art4 SN WMS",

"Product_ID": 1015103,

"Barcode1Name": null,

"Barcode1": "8821",

"Barcode2Name": null,

"Barcode2": null,

"Barcode3Name": null,

"Barcode3": null,

"Barcode4Name": null,

"Barcode4": null,

"Box1Name": null,

"Box1Barcode": "88",

"Box2Name": null,

"Box2Barcode": null,

"Box3Name": null,

"Box3Barcode": null,

"Box4Name": null,

"Box4Barcode": null,

"SerialNumber_ID": 1003203,

"StockLine_ID": 1007375

},

{

"Organization_ID": 1000001,

"Organization": "Demo SRL",

"Warehouse_ID": 1001883,

"Warehouse": "Gestiune WMS fizica Brasov",

"Created": "2018-05-22 09:15:08+0000",

"CreatedBy_ID": 1000002,

"CreatedBy": "AdminTitular",

"Updated": "2018-05-24 07:13:04+0000",

"UpdatedBy_ID": 1000002,

"UpdatedBy": "AdminTitular",

"Line": 2,

"Product": "Art4 SN WMS",

"Product_ID": 1015103,

"Barcode1Name": null,

"Barcode1": "9924",

"Barcode2Name": null,

"Barcode2": null,

"Barcode3Name": null,

"Barcode3": null,

"Barcode4Name": null,

"Barcode4": null,

"Box1Name": null,

"Box1Barcode": "99",

"Box2Name": null,

"Box2Barcode": null,

"Box3Name": null,

"Box3Barcode": null,

"Box4Name": null,

"Box4Barcode": null,

"SerialNumber_ID": 1003208,

"StockLine_ID": 1007375

}

{

"Barcode1": "8821abab",

"SerialNumber_ID": 1003860

}

}

Create one serial number

URL: https://api.socratecloud.com/scwi/rest/serial_number/create/{version}?startRow={0}&endRow={100}&accessToken={access_token}&LocationWarehouse_ID={warehouse_ID}

Mandatory parameter:

    • LocationWarehouse_ID - generic warehouse ID or WMS warehouse ID from login. For using generic warehouse in login, role must have "Generic Warehouse" = true

    • Warehouse_ID - the warehouse where the serial number is created. The Organization is determined on base of this warehouse definition.

Method: POST

Return: stockline ID for success or error message (start with "ERROR: ")

Data format:

{

"Warehouse_ID": 1001883,

"Warehouse": "Gestiune WMS fizica Brasov",

"Product_ID": 1015103,

"Barcode1Name": "SN",

"Barcode1": "8821abab",

"Barcode2Name": "IMEI1",

"Barcode2": "aaa",

"Barcode3Name": "IMEI2",

"Barcode3": "bbb",

"Barcode4Name": null,

"Barcode4": null,

"Box1Name": "BAX",

"Box1Barcode": "88",

"Box2Name": "Palet",

"Box2Barcode": "99",

"Box3Name": null,

"Box3Barcode": null,

"Box4Name": null,

"Box4Barcode": null

}

Return:

{

"Values":

Create serial numbers

URL: https://api.socratecloud.com/scwi/rest/serial_number/create_array/{version}?startRow={0}&endRow={100}&accessToken={access_token}&LocationWarehouse_ID={warehouse_ID}

Mandatory parameter:

    • LocationWarehouse_ID - generic warehouse ID or WMS warehouse ID from login. For using generic warehouse in login, role must have "Generic Warehouse" = true

    • Warehouse_ID - the warehouse where serial numbers are created. The Organization is determined on base of this warehouse definition.

Method: POST

Return: stockline IDs for success or error message (start with "ERROR: ")

Data format:

{

"SerialNumbers":

[

{

"Warehouse_ID": 1001883,

"Warehouse": "Gestiune WMS fizica Brasov",

"Product_ID": 1015103,

"Barcode1Name": "SN",

"Barcode1": "8821cccc",

"Barcode2Name": "IMEI1",

"Barcode2": "aaa",

"Barcode3Name": "IMEI2",

"Barcode3": "bbb",

"Barcode4Name": null,

"Barcode4": null,

"Box1Name": "BAX",

"Box1Barcode": "88",

"Box2Name": "Palet",

"Box2Barcode": "99",

"Box3Name": null,

"Box3Barcode": null,

"Box4Name": null,

"Box4Barcode": null

},

{

"Warehouse_ID": 1001883,

"Warehouse": "Gestiune WMS fizica Brasov",

"Product_ID": 1015103,

"Barcode1Name": "SN",

"Barcode1": "8821dddd",

"Barcode2Name": "IMEI1",

"Barcode2": "aaa",

"Barcode3Name": "IMEI2",

"Barcode3": "bbb",

"Barcode4Name": null,

"Barcode4": null,

"Box1Name": "BAX",

"Box1Barcode": "88",

"Box2Name": "Palet",

"Box2Barcode": "99",

"Box3Name": null,

"Box3Barcode": null,

"Box4Name": null,

"Box4Barcode": null

}

]

}

Return:

{

"values":

{

"SerialNumbers":

[

{

"Barcode1": "8821cccc",

"SerialNumber_ID": 1003861

},

{

"Barcode1": "8821dddd",

"SerialNumber_ID": 1003862

}

]

}

}

{

"Barcode1": "8821AAA",

"SerialNumber_ID": 1003203

}

}

Unlock serial number

URL: https://api.socratecloud.com/scwi/rest/unlock/{version}?startRow={0}&endRow={100}&accessToken={access_token}&LocationWarehouse_ID={warehouse_ID}&Barcode1={Barcode1 SN}

Mandatory parameter:

    • Barcode1

    • LocationWarehouse_ID - generic warehouse ID or WMS warehouse ID from login. For using generic warehouse in login, role must have "Generic Warehouse" = true

    • Warehouse_ID - the warehouse where the serial number is. The Organization is determined on base of this warehouse definition.

Method: POST

Return:

    • Barcode 1 of serial number

    • Serial number ID

    • StockLine ID - status stock unlock

for success or error message (start with "ERROR: ")

Data format:

{

"Warehouse_ID": 1001883,

"Warehouse": "Gestiune WMS fizica Brasov",

"Product_ID": 1015103,

"Description": "Descriere",

"Barcode1Name": "SN",

"Barcode1": "8821AAA",

"Barcode2Name": "IMEI1",

"Barcode2": "123123",

"Barcode3Name": "IMEI2",

"Barcode3": "321321",

"Barcode4Name": null,

"Barcode4": null,

"Box1Name": "BAX",

"Box1Barcode": "88",

"Box2Name": "Palet",

"Box2Barcode": "99",

"Box3Name": null,

"Box3Barcode": null,

"Box4Name": null,

"Box4Barcode": null

}

Return:

{

"Values":

{

"Barcode1": "8821AAA",

"SerialNumber_ID": 1003203,

"StockLine_ID": 125899

}

}

Update serial number

URL: https://api.socratecloud.com/scwi/rest/update/{version}?startRow={0}&endRow={100}&accessToken={access_token}&LocationWarehouse_ID={warehouse_ID}&Barcode1={Barcode1 SN}

Mandatory parameter:

    • Barcode1

    • LocationWarehouse_ID - generic warehouse ID or WMS warehouse ID from login. For using generic warehouse in login, role must have "Generic Warehouse" = true

    • Warehouse_ID - the warehouse where the serial number is. The Organization is determined on base of this warehouse definition.

Method: POST

Return:

    • Barcode 1 of serial number

    • Serial number ID for success or error message (start with "ERROR: ")

Data format:

{

"Warehouse_ID": 1001883,

"Warehouse": "Gestiune WMS fizica Brasov",

"Product_ID": 1015103,

"Description": "Descriere",

"Barcode1Name": "SN",

"Barcode1": "8821AAA",

"Barcode2Name": "IMEI1",

"Barcode2": "123123",

"Barcode3Name": "IMEI2",

"Barcode3": "321321",

"Barcode4Name": null,

"Barcode4": null,

"Box1Name": "BAX",

"Box1Barcode": "88",

"Box2Name": "Palet",

"Box2Barcode": "99",

"Box3Name": null,

"Box3Barcode": null,

"Box4Name": null,

"Box4Barcode": null

}

Return:

{

"Values":