Create Inventory Integration
DESCRIPTION
Web Service for inserting barcode and invoice information.
Request
Method: POST
Content-Type: application/json
URL:
Test Environment: | https://training.logiztikalliance.com:5005/logCloudWSSprint/api/v2/InventarioTemporalCliente/Insertar |
Production Environment: | https://cloud.logiztikalliance.com:5005/logCloudWS/api/v2/InventarioTemporalCliente/Insertar |
INPUT PARAMETERS
Name | Type | Required | Description |
AuthenticationToken | string(50) (Required) | Yes | Alliance cloud security token (Api Key). |
Body
Name | Type | Required | Description |
awb | string(16) | Yes | Shipment number. |
fechaDespacho | string(10)(yyyy-MM-dd) | No | Shipment date. |
origen | string(3) | Yes | Origin airport IATA code. |
destino | string(3) | Yes | Destination airport IATA code. |
tipoEnvio | string(16) | Yes | Send always OPERACION. |
hawb | string(32) | Yes | HAWB number. This number has to be correct in order for the integration to work. To make sure that the HAWB is valid you can use our “House Validation” API. |
codigoClienteExportador | string(16) | No | Distribution customer code. |
nombreClienteExportador | string(256) | No | Distribution customer name. |
codigoCultivo | string(16) | Yes | Exporter code. |
nombreCultivo | string(256) | No | Exporter name. |
packing | string(10) | Yes | Number of pieces in the HAWB. |
numeroDae | string(32) | No | DAE number. |
codigoCliente | string(16) | Yes | Ship-to (final client) code. |
nombreCliente | string(256) | No | Ship-to name. |
codigoPieza | string(32) | Yes | Barcode number, has to be a unique number per box, maximum 11 digits long. Logiztik Alliance Group provides a 2-letter prefix that should be used together with an alphanumeric sequential that can be defined by the client. |
codigoProducto | string(16) | Yes | Product category code (ex. ROS for roses). |
descripcionProducto | string(256) | No | Name of the product category (ex. ROSES). |
descripcionVariedad | string(127) | Yes | Product variety, can be used whatever text of max. 127 digits to explain what exact product is in the box. |
empaque | string(16) | Yes | Box type (ex. FB, HB, QB…). |
factura | string(60) | No | Invoice number. |
unidades | int | No | Number of units per piece. |
piezas | int | No | Send always 1. |
largo | decimal(9,3) | No | Length in cm. |
alto | decimal(9,3) | No | Height in cm. |
ancho | decimal(9,3) | No | Width in cm. |
kilos | decimal(9,3) | No | Weight in kg. |
tallos_ramo | int | No | Number of units per bunch. |
ramos_caja | int | No | Number of bunches per box. |
precio | decimal(9,3) | No | Price per unit. |
valortotal | decimal(9,3) | No | Price of the piece (price per unit * number of units per piece). |
precio_ramo | decimal(9,3) | No | Price of the bunch. |
po | string(32) | No | PO number. |
caja_transportador | string(16) | No | Carrier code in destination. |
caja_fecha_transportador | string(10)(yyyy-MM-dd) | No | Shipping date in destination. |
EXAMPLE
{
“ReservasExportadores”: {
“masterAwb”: [
{
“awb”: “145-0755 6662”,
“fechaDespacho”: “2020-02-20”,
“origen”: “UIO”,
“destino”: “MIA”,
“tipoEnvio”: “OPERACION”,
“House”: [
{
“hawb”: “LA0021703629”,
“codigoClienteExportador”: “”,
“nombreClienteExportador”: “”,
“codigoCultivo”: “FL-657”,
“nombreCultivo”: “Sande Ecuador Cía. Ltda.”,
“packing”: “6”,
“box”: [
{
“numeroDae”: “05520204000073316”,
“codigoCliente”: “”,
“nombreCliente”: “EC FLOWERS MORE”,
“codigoPieza”: “SU4638429”,
“codigoProducto”: “ORL”,
“descripcionProducto”: “ORIENTAL LILY”,
“descripcionVariedad”: “OR CORCOVADO ORANGEYELLOW 2BL 10ST SGOL”,
“empaque”: “QB”,
“factura”: “5421111”,
“unidades”: “60”,
“piezas”: “1”,
“largo”: “107”,
“alto”: “15”,
“ancho”: “31.2”,
“kilos”: “6.000”,
“tallos_ramo”: “10”,
“ramos_caja”: “6”,
“precio”: “0”,
“valortotal”: “22.68”,
“precio_ramo”: “0”,
“po”: “FEDEX PO 11788”,
“caja_transportador”: “”,
“caja_fecha_transportador”: “”
}
]
}
]
}
]
}
}
Response
Output Success
BODY
EXAMPLE
File Uploaded Correctly
Output Error
BODY
Name | Type | Description |
ReservasExportadores.masterAwb[0].House[0].box[0].{Variable} | string(256) | In case of an error, we return the error message in this field. |
EXAMPLE
{
“ReservasExportadores.masterAwb[0].House[0].box[0].unidades”: [
“Could not convert string to integer: 60l. Path ‘ReservasExportadores.masterAwb[0]
.House[0].box[0].unidades’, line 29, position 35.”
]
}
Output Error
BODY
Name | Type | Description |
numeroGuia | string(32) | |
cliente | string(256) | |
exportador | string(256) | |
house | string(15) | |
observaciones | string(256) | |
general | string(50) | |
nombreElemento | string(50) | |
codigoExportador | string(32) | |
codigoProducto | string(32) | |
codigoError | string(32) | |
errorNroGuia | string(32) | |
estado | string(32) | |
nombreCarrier | string(256) | |
codigoCarrier | string(32) | |
codigoPieza | string(32) | |
tipoError | string(32) | |
noExcluirHouse | string(50) |
EXAMPLE
[
{
“numeroGuia”: “145-0755 6662”,
“cliente”: “EC FLOWERS MORE”,
“exportador”: “Sande Ecuador Cía. Ltda.”,
“house”: “LA0021703629”,
“observaciones”: “La guía LOG00316004 , está en estado EMBARCADO y no carga sus datos.“,
“general”: null,
“nombreElemento”: null,
“codigoExportador”: null,
“codigoProducto”: null,
“codigoError”: null,
“errorNroGuia”: null,
“estado”: null,
“nombreCarrier”: null,
“codigoCarrier”: null,
“codigoPieza”: null,
“tipoError”: null,
“noExcluirHouse”: false
}
]
ERRORS MESSAGES
DATE FORMATE ERROR
{
“ReservasExportadores.masterAwb[0].fechaDespacho”: [
“Could not convert string to DateTime: 2020-02-20f. Path ‘ReservasExportadores.masterAwb[0]
.fechaDespacho’, line 6, position 40.”
]
}
Data type error (PACKING)
{
“ReservasExportadores.masterAwb[0].House[0].packing”: [
“Could not convert string to integer: 6h. Path ‘ReservasExportadores.masterAwb[0]
.House[0].packing’, line 17, position 29.”
]
}
Data type error (UNIDADES)
{
“ReservasExportadores.masterAwb[0].House[0].box[0].unidades”: [
“Could not convert string to integer: 60F. Path ‘ReservasExportadores.masterAwb[0]
.House[0].box[0].unidades’, line 29, position 35.”
]
}
Data type error (PIEZAS)
{
“ReservasExportadores.masterAwb[0].House[0].box[0].piezas”: [
“Could not convert string to integer: 1S. Path ‘ReservasExportadores.masterAwb[0]
.House[0].box[0].piezas’, line 30, position 32.”
]
}
Data type error (LARGO)
{
“ReservasExportadores.masterAwb[0].House[0].box[0].largo”: [
“Could not convert string to decimal: 107S. Path ‘ReservasExportadores.masterAwb[0]
.House[0].box[0].largo’, line 31, position 33.”
]
}
DATA TYPE ERROR (ALTO)
{
“ReservasExportadores.masterAwb[0].House[0].box[0].alto”: [
“Could not convert string to decimal: 15D. Path ‘ReservasExportadores.masterAwb[0]
.House[0].box[0].alto’, line 32, position 31.”
]
}
DATA TYPE ERROR (ANCHO)
{
“ReservasExportadores.masterAwb[0].House[0].box[0].ancho”: [
“Could not convert string to decimal: 31.2S. Path ‘ReservasExportadores.masterAwb[0]
.House[0].box[0].ancho’, line 33, position 34.”
]
}
DATA TYPE ERROR (KILOS)
{
“ReservasExportadores.masterAwb[0].House[0].box[0].kilos”: [
“Could not convert string to decimal: 6.000S. Path ‘ReservasExportadores.masterAwb[0]
.House[0].box[0].kilos’, line 34, position 35.”
]
}
DATA TYPE ERROR (TALLOS_RAMO)
{
“ReservasExportadores.masterAwb[0].House[0].box[0].tallos_ramo”: [
“Could not convert string to decimal: 10D. Path ‘ReservasExportadores.masterAwb[0]
.House[0].box[0].tallos_ramo’, line 35, position 38.”
]
}
DATA TYPE ERROR (RAMOS_CAJA)
{
“ReservasExportadores.masterAwb[0].House[0].box[0].ramos_caja”: [
“Could not convert string to integer: 6F. Path ‘ReservasExportadores.masterAwb[0]
.House[0].box[0].ramos_caja’, line 36, position 36.”
]
}
DATA TYPE ERROR (PRECIO)
{
“ReservasExportadores.masterAwb[0].House[0].box[0].precio”: [
“Could not convert string to decimal: 0S. Path ‘ReservasExportadores.masterAwb[0]
.House[0].box[0].precio’, line 37, position 32.”
]
}
DATA TYPE ERROR (VALORTOTAL)
{
“ReservasExportadores.masterAwb[0].House[0].box[0].valortotal”: [
“Could not convert string to double: 22.68S. Path ‘ReservasExportadores.masterAwb[0]
.House[0].box[0].valortotal’, line 38, position 40.”
]
}
DATA TYPE ERROR (PRECIO_RAMO)
{
“ReservasExportadores.masterAwb[0].House[0].box[0].precio_ramo”: [
“Could not convert string to decimal: 0S. Path ‘ReservasExportadores.masterAwb[0]
.House[0].box[0].precio_ramo’, line 39, position 37.”
]
}
DATA FORMAT ERROR (VALORTOTAL)
{
“ReservasExportadores.masterAwb[0].House[0].box[0].caja_fecha_transportador”: [
“Could not convert string to DateTime: SSS. Path ‘ReservasExportadores.masterAwb[0]
.House[0].box[0].caja_fecha_transportador’, line 42, position 51.”
]
}
UNAUTHORIZED
401 Unauthorized
GUIDE IN EMBARKED STATE
[
{
“numeroGuia”: “145-0755 6662”,
“cliente”: “EC FLOWERS MORE”,
“exportador”: “Sande Ecuador Cía. Ltda.”,
“house”: “LA0021703629”,
“observaciones”: “La guía LOG00316004 , está en estado EMBARCADO y no carga sus datos.“,
“general”: null,
“nombreElemento”: null,
“codigoExportador”: null,
“codigoProducto”: null,
“codigoError”: null,
“errorNroGuia”: null,
“estado”: null,
“nombreCarrier”: null,
“codigoCarrier”: null,
“codigoPieza”: null,
“tipoError”: null,
“noExcluirHouse”: false
}
]
GUIDE IS ALREADY PROCESSED
[
{
“numeroGuia”: “17651308283”,
“cliente”: “EC FLOWERS MORE”,
“exportador”: “Sande Ecuador Cía. Ltda.”,
“house”: “BG1090130734”,
“observaciones”: “The 17651308283 / BG1090130734 Guide is already processed and cannot be edited. Please contact Customer Service for more details.”,
“general”: null,
“nombreElemento”: null,
“codigoExportador”: null,
“codigoProducto”: null,
“codigoError”: null,
“errorNroGuia”: null,
“estado”: null,
“nombreCarrier”: null,
“codigoCarrier”: null,
“codigoPieza”: null,
“tipoError”: null,
“noExcluirHouse”: false
}
]