API_v4 - GET Endpoints
A continuación podrá encontrar todas las acciones de la class=GET el cual le permitirá obtener el listado o información de su empresa en InterFuerza.
Recuerde que son dos variables que deben ser enviados junto con cualquier variable adicional en formato JSON al API de InterFuerza.
Conectándose con el API
Para realizar las comunicaciones con el API, es con HTTPS. Toda las peticiones deben ser enviadas a la dirección:
https://app.interfuerza.com/api/v4/
Esta, debe llevar el siguiente encabezado o HTTP Header:
X-IFX-Token:
Donde es el token obtenido en el siguiente enlace: Introducción
Acciones GET:
GET - customers
Obtener la lista de todos los clientes.
La variable page se refiere a la página que desea obtener. Recuerde que un límite de 25 registros por llamada, es aplicada.
Filtros:
Puede utilizar filtros para optimizar la búsqueda con un array JSON llamando filtros. Por ejemplo:
{
"class":"GET",
"action":"customers",
"filters" : [
{ "field":"Email", "type":"=", "value":"[email protected]" }
]
}
{"class":"GET","action":"customers","page":"1"}
{
"class": "GET",
"action": "customers",
"customers": [{
"Cliente": "C0003",
"Tipo": "CLIENTE",
"RUC": "00000",
"DV": null,
"Nombre": "SULLY RODRIGUEZ",
"Email": "[email protected]",
"Status": "ACTIVE",
"Telefono_1": "0",
"Telefono_2": "",
"Cellular": "",
"Direccion": "",
"Ciudad": "",
"Estado": "",
"Pais": "PANAMA",
"Empleados": "",
"Industria": "",
"Credit_Term": "C.O.D.",
"Due_Days": "0",
"Credit_Amount_Limit": "0.00",
"Vendedor": null,
"CuentaXCobrar": "ACC0010",
"CuentaXCobrar_Nombre": "[1101] Cuentas por cobrar - cliente",
"BirthDate": "0000-00-00",
"Taxable": "YES",
"Tipo_Contribuyente": null,
"Clase": "Jurídica"
}],
"count": 1
}
GET - customer
Obtener la información y balance de un cliente.
La variable id es requerido y es el id interno del cliente.
{"class":"GET","action":"customer","id":"CUS0001"}
{"class":"GET","action":"customer",
"customer":
{"Cliente":"CUS13446",
"Tipo":"CLIENTE",
"RUC":"",
"DV":"",
"Nombre":"ABB Consultores",
"Email":"[email protected]",
"Status":"ACTIVE",
"Telefono_1":"520-0201",
"Telefono_2":"",
"Cellular":"",
"Direccion":"",
"Ciudad":"",
"Estado":"",
"Pais":"ARUBA",
"Empleados":"",
"Industria":"",
"Credit_Term":"CREDIT",
"Due_Days":"28",
"Credit_Amount_Limit":"0.00",
"Vendedor":"",
"CuentaXCobrar":"ACC0010",
"CuentaXCobrar_Nombre":"1101 - Cuentas por cobrar - cliente",
"BirthDate":"1980-02-21",
"Taxable":"NO",
"Tipo_Contribuyente":"",
"Clase":"Juridica",
"Balance":"209622.02"
}
}
GET - contacts
Obtener la lista de todos los contactos.
La variable page se refiere a la página que desea obtener. Recuerde que un límite de 25 registros por llamada, es aplicada.
Puede colocar un filtro opcional llamado customer el cual traerá los contactos de un cliente en especifico. En caso de enviar vacío, traerá todos los contactos de forma paginada.
{"class":"GET","action":"contacts","customer":"XXXX","page":"1"}
{"class":"GET",
"action":"contacts",
"contacts":
[{
"id":"18",
"Contacto":"Ana Di\u00e1z",
"Cliente":"C0139",
"Titulo":"Due\u00f1a",
"Email_Personal":"[email protected]",
"Email_Trabajo":"[email protected]",
"Direccion":"",
"Ciudad":"",
"Apartado":"",
"Pais":"",
"Sitio_Web":"",
"Fax":"",
"Empresa":"",
"Posicion":"-",
"Departamento":"-",
"Agente":"IF_DEMO",
"Updated":"2018-12-16 12:48:42",
"BirthDate":"0000-00-00",
"Portal_Access":"NO",
"Portal_User":"",
"Portal_Pass":"",
"Portal_Profile":"",
"Email":"","Estado":"",
"Telefono_1":"505-0000",
"Telefono_2":"",
"Cellular":""}
],"count":"1"}
GET - payments
Obtener la lista de todos los cobros o pagos de clientes.
La variable page se refiere a la página que desea obtener. Recuerde que un límite de 25 registros por llamada, es aplicada.
{"class":"GET","action":"payments","page":"1"}
{"class":"GET",
"action":"payments",
"payments":
[
{"Payment":
{"id":"PC101000001",
"Referencia":"",
"Cliente":"C0001",
"Nombre":"ALBIS. ROJAS",
"Pais":"PANAMA",
"Bodega":"TIENDA ",
"Status":"DELETED",
"Fecha":"2016-08-16",
"Comentario":null,
"Monto":"-10.00",
"Cash_Account":"",
"Type":"BILL-COD",
"Balance":null,
"Quote_Related":null
},
"Detail":
[{
"id":"76",
"Payment":"PC101000001",
"Factura":"NC101000001",
"Descripcion":"PAGO A FACTURA: NC101000001",
"Monto":"-10.00",
"Type":"Invoice",
"WareHouse":"TIENDA ",
"Account":"",
"Job":"",
"Project":null,
"Timestamp":"2016-08-16 11:13:17"
}
]
}
]
,"count":"1"}
GET - providers
Obtener la lista de todos los proveedores.
La variable page se refiere a la página que desea obtener. Recuerde que un límite de 25 registros por llamada, es aplicada.
{"class":"GET","action":"providers","page":"1"}
{
"class": "GET",
"action": "providers",
"providers": [
{"Proveedor":"00001",
"Tipo":"LOCAL",
"Nombre":"AutoPartes Jap\u00c3\u00b3n",
"Email":"[email protected]",
"Status":"ACTIVE",
"Telefono_1":"5072026981",
"Telefono_2":"5072026981",
"Cellular":"2333-2333",
"Direccion":"Via Per\u00c3\u00ba",
"Ciudad":"Panam\u00c3\u00a1",
"Estado":"Panam\u00c3\u00a1",
"Pais":"Panam\u00c3\u00a1",
"Empleados":null,
"Industria":null,
"Credit_Term":"CREDIT",
"Due_Days":"0",
"Credit_Amount_Limit":"100.00",
"CuentaXPagar":"ACC0043",
"CuentaXCobrar_Nombre":"[2001] Cuenta por Pagar - Proveedores",
"Tipo_Contribuyente":null,
"Clase":null
},],
"count": 1
}
GET - provider
Obtener la información y balance de un proveedor.
La variable id es el id interno del proveedor y es un campo requerido.
{"class":"GET","action":"provider","id":"PROV27"}
{"class":"GET","action":"provider",
"provider":
{"Proveedor":"PROV27",
"Tipo":"LOCAL",
"Nombre":"Agencias Feduro S.A.",
"Email":"",
"Status":"ACTIVE",
"Telefono_1":"3009856",
"Telefono_2":"",
"Cellular":"",
"Direccion":"",
"Ciudad":"",
"Estado":"Panama",
"Pais":"PANAMA",
"Empleados":"20",
"Industria":"Consumer Products",
"Credit_Term":"C.O.D.",
"Due_Days":"0",
"Credit_Amount_Limit":"0.00",
"CuentaXPagar":"ACC0044",
"CuentaXCobrar_Nombre":"2005 - Exterior",
"Tipo_Contribuyente":"",
"Clase":"Juridica",
"Balance":"108469.10"
}}
GET - users
Obtener la lista de todos los usuarios e invitados asociados a la empresa.
{"class":"GET","action":"users"}
{
"class": "GET",
"action": "users",
"users": [{
"username": "[email protected]",
"Nombre": "delia",
"Email": "[email protected]",
"Telefono": "2233",
"Cellular": "",
"MaxProductDisc": null,
"MaxGeneralDisc": null,
"Language": "Spanish",
"Tipo": "Usuario"
}, {
"username": "[email protected]",
"Nombre": "Moises Vega",
"Email": "[email protected]",
"Telefono": "+57 1 508-7904",
"Cellular": "",
"MaxProductDisc": null,
"MaxGeneralDisc": null,
"Language": "Spanish",
"Tipo": "Invitado"
}],
"count": 2
}
GET - external_users
Obtener información sobre external_users
{
"class":"GET",
"action":"external_users"
}
{
"class": "GET",
"action": "external_users",
"external_users": [
{
"id": "0a8086bd57fcba83e9b3851f0acb13df",
"name": "Juan Gomez",
"first_name": "Juan",
"last_name": "Gomez",
"email": "[email protected]",
"Source": "AUTOGEN",
"Customerld": "Panama",
"extraData":[]
},
{
"id": "109599427772691967206",
"name": "Gabriela Batista",
"first_name": "Gabriela",
"last_name": "Batista",
"email": "[email protected]",
"Source": "GOOGLE",
"CustomerId": "C0028",
"Direccion": null,
"extraData": []
},
{
"id": "2b7ef4745aaaed9809542de330df2a08",
"name": "Jorge Batista",
"first_name": "Jorge",
"last_name": "Batista",
"email": "[email protected]",
"Source": "AUTOGEN",
"CustomerId": "C0006",
"Direccion": "Colon",
"extraData": []
},
{
"id": "332907cad015f39d4a9c8cead341613b",
"name": "Adrian Rodriguez",
"first_name": "Adrian",
"last_name": "Rodriguez",
"email": "[email protected]",
"Source": "AUTOGEN",
"CustomerId": "C0016",
"Direccion": "panama",
"extraData": []
}
],
"count": "4"
}
GET - categories
Obtener árbol de categorías definidas en los productos.
{"class":"GET","action":"categories"}
{
"class": "GET",
"action": "categories",
"categories": [{
"Category_L1": "Hogar",
"Category_L2": "Línea Blanca",
"Category_L3": "Lavaplatos"
}, {
"class": "GET",
"action": "categories",
"categories": [{
"Category_L1": "Hogar",
"Category_L2": "Línea Blanca",
"Category_L3": "Lavadoras"
}],
"count": 2
}
GET - brands
Obtener las marcas definidas en los productos.
Api Ver. 3.0.5
{"class":"GET","action":"brands"}
{
"class": "GET",
"action": "brands",
"
brands":[{"Brand":"Ameritrade"},
{"Brand":"Zara"}]
}
GET - products
Obtener la lista de todos los productos y servicios. La variable page se refiere a la página que desea obtener. Recuerde que un límite de 25 registros por llamada, es aplicado.
Puede agregar un “id” para obtener un producto en especifico, por ejemplo: {“class”:”GET”,”action”:”products”,”id”:”PS0000003″}.
Filtros:
Puede utilizar filtros para optimizar la búsqueda con un array JSON llamado filtros. Por ejemplo:
{
"class":"GET",
"action":"products",
"filters" : [
{ "field":"Category_L1", "type":"=", "value":"HOGAR" },
{ "field":"Category_L2", "type":"=", "value":"LINEA BLANCA" },
]
}
Tienda Virtual
Puede obtener los datos de productos para tienda virtual cambiando el action a products-eshop el cual le mostrará datos, tales como fotos y propiedades de la tienda virtual.
{"class":"GET","action":"products","page":"1"}
{"class":"GET","action":"products","products":[
{"Producto": {
"id": "PS0000003",
"UPC_Code": "7702113022346",
"Item_Number": "GMD04",
"Type": "PRODUCTO",
"Nombre": "KERATINA SALON BRASIL CACAU",
"Status": "ACTIVO",
"Category_L1": "PRODUCTOS DEL SALON",
"Category_L2": "",
"Category_L3": "",
"Marca": "BRASIL CACAO",
"Proveedor_Principal": "BRASIL CACAU",
"Peso": "0.00",
"Sales_Account": "ACC0079",
"Cost_Account": "ACC0083",
"Inventory_Account": "ACC0015",
"Service_Sales_Account": "",
"Precio_Venta": "20.00"
},
"InStock": [{
"WareHouse": "SLN BRIGOLF ARRIJAN",
"Intransit": "0.00",
"Display": "0.00",
"Reservado": "0.00",
"InStock": "-10.25",
"Available": "-10.25"
}, {
"WareHouse": "Bodega General",
"Intransit": "0.00",
"Display": "0.00",
"Reservado": "0.00",
"InStock": "0.00",
"Available": "0"
}, {
"WareHouse": "Bodega Principal",
"Intransit": "0.00",
"Display": "0.00",
"Reservado": "0.00",
"InStock": "-17.00",
"Available": "-17.00"
}],
"PriceLists": [{
"Name": "SERVICIO SALON",
"Precio": "20.00"}]
}],
"count":1}
GET - Products-eshop
Obtener productos eshop.
{
"class":"GET",
"action":"products-eshop"
}
{
"class":"GET",
"action":"products-eshop",
"products-eshop":[
{
"Producto": {
"id": "PRO1",
"UPC_Code": "vinilo adhesivo",
"Item_Number": "212312345",
"Type": "PRODUCTO",
"Nombre": "Vinilo adhesivo",
"Status": "ACTIVO",
"Category_L1": "",
"Category_L2": "",
"Category_L3": "",
"Marca": "Sister",
"Proveedor_Principal": null,
"Peso": "1.00",
"Sales_Account": "ACC0079",
"Cost_Account": "ACC0083",
"Inventory_Account": "ACC0015",
"Service_Sales_Account": "ACC0080",
"Precio_Venta": "3.00",
"Precio_Venta_Real": "3.00",
"Ancho": "0.00",
"Largo": "",
"Taxid": "1",
"Eshop_Name": null,
"Eshop_Description": null,
"Public": null,
"Matrix": "NO",
"Matrix_Parent": "",
"Matrix_Child": "",
"Units_X_Caja": null,
"Custom_Fields": null,
"extraData": null,
"Ignore_Avalable_Control": null,
"Has_Promotion": "NO",
"Has_Promotion_Type": "AMOUNT",
"Has_Promotion_Value":"0.00",
"Has_Promotion_Default_Price": "NO",
"Has_Promotion_Date_Final": "2023-02-22 00:00:00",
"Has_Promotion_Date_Init": "2023-02-22 00:00:00",
"Has_Promotion_Reff": null,
"Actualizado": "2023-02-22 13:55:54"
},
"InStock": [
{
"WareHouse": "Bodega Principal",
"Intransit": "0.00",
"Display": "0.00",
"Reservado": "0.00",
"InStock": "100.00",
"Available": "100.0000"
},
{
"WareHouse": "Bodega Chitré",
"Intransit": "0.00",
"Display": "0.00",
"Reservado": "0.00",
"InStock": "0.00",
"Available": "0"
},
{
"WareHouse": "alimentos",
"Intransit": "0.00",
"Display": "0.00",
"Reservado": "0.00",
"InStock": "0.00",
"Available": "0.00"
},
{
"WareHouse": "The Spa At santa Maria-conseción",
"Intransit": "0.00",
"Display": "0.00",
"Reservado": "0.00",
"Instock": "0.00",
"Available": "0"
}
],
"PriceLists": [
{
"Name": "Precio a partir de 50 unidades",
"Precio": "0.00",
"Precio_Real": "0.00"
},
{
"Name": "Lista 1",
"Precio": "0.00",
"Precio_Real": "0.00"
},
{
"Name": "Precio de Venta",
"Precio": "3.00",
"Precio_Real": "3.00"
}
],
"Images": [],
"Matrix": []
}
],
"count": "1"
}
GET - Products-eshop-instock
Obtener todos los productos eshop en stock.
{
"class":"GET",
"action":"products-eshop-instock"
}
{
"class":"GET",
"action":"products-eshop-instock",
"products-eshop-instock":[
{
"Producto": {
"id": "PRO1708",
"UPC_Code": "B027RD",
"Item_Number": "B027RD",
"Nombre": "VASO TEQUILERO",
"Ignore_Avalable_Control": null,
"Flags_Change_Stock": "Y",
"Actualizado": null,
},
"InStock": [
{
"WareHouse": "Bodega Principal",
"Intransit": "0.00",
"Display": "0.00",
"Reservado": "0.00",
"InStock": "100.00",
"Available": "100.0000"
},
{
"WareHouse": "Bodega secundaria",
"Intransit": "0.00",
"Display": "0.00",
"Reservado": "0.00",
"InStock": "0.00",
"Available": "0"
},
{
"WareHouse": "Bodega Chitré",
"Intransit": "0.00",
"Display": "0.00",
"Reservado": "0.00",
"InStock": "0.00",
"Available": "0.00"
},
{
"WareHouse": "Bodega tres",
"Intransit": "0.00",
"Display": "0.00",
"Reservado": "0.00",
"InStock": "0.00",
"Available": "0.00"
},
{
"WareHouse": "alimentos",
"Intransit": "0.00",
"Display": "0.00",
"Reservado": "0.00",
"InStock": "0.00",
"Available": "0.00"
},
{
"WareHouse": "Bodega David",
"Intransit": "0.00",
"Display": "0.00",
"Reservado": "0.00",
"InStock": "0.00",
"Available": "0.00"
},
{
"WareHouse": "The Spa At santa Maria-conseción",
"Intransit": "0.00",
"Display": "0.00",
"Reservado": "0.00",
"Instock": "0.00",
"Available": "0"
},
{
"WareHouse": "BODEGA PRINCIPAL",
"Intransit": "0.00",
"Display": "0.00",
"Reservado": "0.00",
"InStock": "0.00",
"Available": "0.00"
}
],
"PriceLists": null,
"Matrix": []
},
}
],
"count": "1"
}
GET - Categories-eshop
Petición
{
"class":"GET",
"action":"categories-eshop"
}
{
"class":"GET",
"action":"categories-eshop",
"categories-eshop":[
{
"Category_L1": "ALMOHADA",
"Category_L2": "SUBLIMACION",
"Category_L3": "",
},
{
"Category_L1": "ARTE",
"Category_L2": "",
"Category_L3": ""
},
{
"Category_L1": "BOLSOS",
"Category_L2": "BOLSO",
"Category_L3": "",
},
{
"Category_L1": "ZAPATOS DE DAMAS",
"Category_L2": "",
"Category_L3": ""
}
]
}
GET - webusers-eshop
Obtener información de los usuarios de tienda virtual. Si password va vacío el mismo será validado como usuario que se registró como GOOGLE. Si es un usuario AUTOGEN (Local) requiere enviar el campo password con el md5 de la contraseña del usuario para poder obtener información correcta.
Api Ver. 3.0.5
{"class":"GET","action":"webusers-eshop", "email":"[email protected]", "password":"<md5 of password>"}
{
"class": "GET",
"action": "webusers-eshop",
"webusers-eshop":[array con información de usuario y cliente si fue correctamente autenticado]
}
GET - warehouses
Obtener la lista completa de bodegas.
{"class":"GET","action":"warehouses"}
{
"class": "GET",
"action": "warehouses",
"warehouses": [{
"Nombre": "SLN BRIGOLF ARRIJAN",
"Status": "ACTIVE",
"Type": "PUBLIC",
"Venta_POS": "YES",
"Tienda": "YES"
}, {
"Nombre": "Bodega General",
"Status": "ACTIVE",
"Type": "PUBLIC",
"Venta_POS": "YES",
"Tienda": "YES"
}, {
"Nombre": "Bodega Principal",
"Status": "ACTIVE",
"Type": "PUBLIC",
"Venta_POS": "YES",
"Tienda": "YES"
}],
"count": 3
}
GET - prices_list
Obtener todas las listas de precios.
{"class":"GET","action":"prices_list"}
{
"class": "GET",
"action": "prices_list",
"prices_list": [{
"Name": "SERVICIO SALON",
"DefaultPrice": "Y",
"Inactive": "N",
"OrderBy": "1"
}],
"count": 1
}
GET - taxes_list
Obtener todas las listas de impuestos.
{"class":"GET","action":"taxes_list"}
{
"class": "GET",
"action": "taxes_list",
"taxes_list": [{
"id": "1",
"Name": "ITBMS",
"TaxFactor": "0.07",
"OrderBy": "1",
"DefaultDetails": "NO",
"FiscalID": "G"
}, {
"id": "2",
"Name": "EXENTO",
"TaxFactor": "0.00",
"OrderBy": "2",
"DefaultDetails": "NO",
"FiscalID": "G"
}],
"count": 2
}
GET - acc_accounts
Obtener el listado de todas las cuentas contables.
{"class":"GET","action":"acc_accounts"}
{
"class": "GET",
"action": "acc_accounts",
"acc_accounts": [{
"Internal_Code": "ACC00005",
"Codigo": "1003",
"Name": "CAJA GENERAL APERTURA",
"Jerarquia": "AUXILIAR",
"Categoria": "Assets",
"Type": "Cash",
"Created": "2015-10-20 09:15:34",
"Inactive": "NO",
"Balance": "50.00"
}...
], "count":10
}
GET - acc_accounts_defaults
Obtener la configuración del maestro de cuentas.
{"class":"GET","action":"acc_accounts_defaults"}
{
"class": "GET",
"action": "acc_accounts_defaults",
"acc_accounts_defaults": [{
"id": "1",
"Name": "Cuenta X Cobrar",
"Account": "ACC0010",
"GroupBy": "CUSTOMER",
"Aux_Lock": "NO"
}, {
"id": "2",
"Name": "Cuenta de Impuestos",
"Account": "ACC0051",
"GroupBy": "BILLING",
"Aux_Lock": "NO"
}, {
"id": "3",
"Name": "Cuenta de Descuentos",
"Account": "ACC0081",
"GroupBy": "BILLING",
"Aux_Lock": "NO"
}, {
"id": "4",
"Name": "Cuenta de Otros",
"Account": "ACC0079",
"GroupBy": "BILLING",
"Aux_Lock": "NO"
}, {
"id": "5",
"Name": "Cuenta de Cargo por Tarjetas",
"Account": "ACC0079",
"GroupBy": "BILLING",
"Aux_Lock": "NO"
}, {
"id": "6",
"Name": "Cuenta de Venta",
"Account": "ACC0079",
"GroupBy": "INVENTORY",
"Aux_Lock": "NO"
}, {
"id": "7",
"Name": "Cuenta de Costos",
"Account": "ACC0083",
"GroupBy": "INVENTORY",
"Aux_Lock": "NO"
}, {
"id": "8",
"Name": "Cuenta de Inventario",
"Account": "ACC0015",
"GroupBy": "INVENTORY",
"Aux_Lock": "NO"
}, {
"id": "9",
"Name": "Cuenta de Cobro de Efectivo",
"Account": "ACC0002",
"GroupBy": "BILLING-PAYMENTS",
"Aux_Lock": "NO"
}, {
"id": "11",
"Name": "Cuenta Predetermidada",
"Account": "ACC0084",
"GroupBy": "INVENTORY-AJUST",
"Aux_Lock": "NO"
}, {
"id": "12",
"Name": "Cuenta X Pagar",
"Account": "ACC0043",
"GroupBy": "PROVIDER",
"Aux_Lock": "NO"
}, {
"id": "13",
"Name": "Cuenta de Impuestos",
"Account": "ACC0051",
"GroupBy": "PURCHASES",
"Aux_Lock": "NO"
}, {
"id": "14",
"Name": "Cuenta de Otros",
"Account": "ACC0016",
"GroupBy": "PURCHASES",
"Aux_Lock": "NO"
}, {
"id": "15",
"Name": "Cuenta de Banco",
"Account": "ACC0004",
"GroupBy": "PURCHASES-PAYMENTS",
"Aux_Lock": "NO"
}, {
"id": "16",
"Name": "Cuenta en Transito",
"Account": "ACC0016",
"GroupBy": "PURCHASES",
"Aux_Lock": "NO"
}, {
"id": "17",
"Name": "Cuenta de SETUP de Servicios",
"Account": "ACC0080",
"GroupBy": "SERVICES",
"Aux_Lock": "NO"
}, {
"id": "18",
"Name": "Cuenta de Ventas de Servicios",
"Account": "ACC0080",
"GroupBy": "SERVICES",
"Aux_Lock": "NO"
}, {
"id": "19",
"Name": "Cuenta de Certificados",
"Account": "ACC0070",
"GroupBy": "BILLING",
"Aux_Lock": "NO"
}, {
"id": "20",
"Name": "Cuenta de Cobro de Tarjetas de Credito",
"Account": "ACC0005",
"GroupBy": "BILLING-PAYMENTS",
"Aux_Lock": "NO"
}, {
"id": "21",
"Name": "Cuenta de Cobro de Certificado",
"Account": "ACC0070",
"GroupBy": "BILLING-PAYMENTS",
"Aux_Lock": "NO"
}, {
"id": "22",
"Name": "Cuenta de Cobro de Cheque",
"Account": "ACC0004",
"GroupBy": "BILLING-PAYMENTS",
"Aux_Lock": "NO"
}, {
"id": "23",
"Name": "Cuenta de Cobro de Otros",
"Account": "ACC0008",
"GroupBy": "BILLING-PAYMENTS",
"Aux_Lock": "NO"
}, {
"id": "24",
"Name": "Cuenta de Costo de Servicio",
"Account": "ACC0080",
"GroupBy": "SERVICES",
"Aux_Lock": "NO"
}, {
"id": "25",
"Name": "Cuenta de Activo Fijo",
"Account": "ACC0027",
"GroupBy": "FIXED-ASSETS",
"Aux_Lock": "NO"
}, {
"id": "26",
"Name": "Cuenta de Depreciacion",
"Account": "ACC0034",
"GroupBy": "FIXED-ASSETS",
"Aux_Lock": "NO"
}, {
"id": "27",
"Name": "Cuenta de Gasto",
"Account": "ACC0126",
"GroupBy": "FIXED-ASSETS",
"Aux_Lock": "NO"
}, {
"id": "28",
"Name": "Cuenta de Utilidades Retenidas",
"Account": "ACC0075",
"GroupBy": "ACCOUNTING",
"Aux_Lock": "NO"
}, {
"id": "29",
"Name": "Cuenta de Faltantes o RMA",
"Account": "ACC0083",
"GroupBy": "PURCHASES",
"Aux_Lock": "NO"
}, {
"id": "30",
"Name": "Cuenta de Otros Costos N\/C",
"Account": "ACC0083",
"GroupBy": "PURCHASES",
"Aux_Lock": "NO"
}],
"count": 29
}
GET - quotes
Obtener el listado de todas las cotizaciones y su detalle. La variable page se refiere a la página que desea obtener. Recuerde que un límite de 25 registros por llamada, es aplicado.
{"class":"GET","action":"quotes", "page":1}
{
"class": "GET",
"action": "quotes",
"quotes": [{
"Quote": {
"id": "00001",
"Cliente": "C0001",
"Nombre": "CONTADO",
"Pais": "PANAMA",
"Bodega": "SLN BRIGOLF ARRIJAN",
"Status": "APROVED",
"Date": "2015-01-14",
"Comentario": "",
"SubTotal": "5.00",
"Discount": "0.00",
"Taxes": "0.00",
"Total": "5.00",
"Reservar_Productos": "NO",
"Type": "SALES-TEAM",
"Vendedor": "DELIA DOMINGUEZ",
"Currency": "USD",
"Currency_Rate": "1.000000000"
},
"Lines": [{
"Codigo": "PS0000118",
"Descripcion": "CORTE DE CABELLO - GLORIA",
"Item_Number": "0002",
"Nombre": "CORTE DE CABELLO - GLORIA",
"Marca": "GLORIA",
"Category_L1": "SERVICIO SALON",
"Category_L2": "",
"Category_L3": "",
"Unidades": "1.00",
"Precio_Unitario": "5.0000",
"Discount": "0.00",
"DiscountFactor": "0.00",
"TaxID": "1",
"TaxName": "ITBMS",
"TaxFactor": "0.00",
"TaxValue": "0.0000",
"Total": "5.00"
}]
}],
"count": 1
}
GET - quote
Obtener una cotización específica.
{
"class":"GET",
"action":"quote"
}
{
"class": "GET",
"action": "quote",
"quote": [],
"count": 0
}
GET - invoices
Obtener el listado de las facturas y su detalle. La variable page se refiere a la página que desea obtener. Recuerde que un límite de 25 registros por llamada, es aplicado.
{"class":"GET","action":"invoices", "page":"1"}
{
"class": "GET",
"action": "invoices",
"quotes": [{
"Invoice": {
"id": "00001",
"Cliente": "C0001",
"Nombre": "CONTADO",
"Pais": "PANAMA",
"Bodega": "SLN BRIGOLF ARRIJAN",
"Status": "APROVED",
"Date": "2015-01-14",
"Comentario": "",
"SubTotal": "5.00",
"Discount": "0.00",
"Taxes": "0.00",
"Total": "5.00",
"Reservar_Productos": "NO",
"Type": "SALES-TEAM",
"Vendedor": "DELIA DOMINGUEZ",
"Currency": "USD",
"Currency_Rate": "1.000000000"
},
"Lines": [{
"Codigo": "PS0000118",
"Descripcion": "CORTE DE CABELLO - GLORIA",
"Item_Number": "0002",
"Nombre": "CORTE DE CABELLO - GLORIA",
"Marca": "GLORIA",
"Category_L1": "SERVICIO SALON",
"Category_L2": "",
"Category_L3": "",
"Unidades": "1.00",
"Precio_Unitario": "5.0000",
"Discount": "0.00",
"DiscountFactor": "0.00",
"TaxID": "1",
"TaxName": "ITBMS",
"TaxFactor": "0.00",
"TaxValue": "0.0000",
"Total": "5.00"
}]
}],
"count": 1
}
Filtro de Timestamp
Puedes agregar el filtro de timestamp para filtrar facturas de cierto rango de tiempo de la siguiente manera:
{"class":"GET","action":"invoices", "page":"1", "timestamp":[{"from":"2020-10-01", "to":"2020-10-31"}]}
GET - invoice
Obtener el detalle de una factura específica. La variable id es utilizada para obtener la factura deseada.
{"class":"GET","action":"invoice", "id":"00001"}
{
"class": "GET",
"action": "invoice",
"Invoice": [{
"Quote": {
"id": "00001",
"Cliente": "C0001",
"Nombre": "CONTADO",
"Pais": "PANAMA",
"Bodega": "SLN BRIGOLF ARRIJAN",
"Status": "APROVED",
"Date": "2015-01-14",
"Comentario": "",
"SubTotal": "5.00",
"Discount": "0.00",
"Taxes": "0.00",
"Total": "5.00",
"Reservar_Productos": "NO",
"Type": "SALES-TEAM",
"Vendedor": "DELIA DOMINGUEZ",
"Currency": "USD",
"Currency_Rate": "1.000000000"
},
"Lines": [{
"Codigo": "PS0000118",
"Descripcion": "CORTE DE CABELLO - GLORIA",
"Item_Number": "0002",
"Nombre": "CORTE DE CABELLO - GLORIA",
"Marca": "GLORIA",
"Category_L1": "SERVICIO SALON",
"Category_L2": "",
"Category_L3": "",
"Unidades": "1.00",
"Precio_Unitario": "5.0000",
"Discount": "0.00",
"DiscountFactor": "0.00",
"TaxID": "1",
"TaxName": "ITBMS",
"TaxFactor": "0.00",
"TaxValue": "0.0000",
"Total": "5.00"
}]
}],
"count": 1
}
GET - credit - note
Obtener la lista de todos los clientes.
La variable Page se refiere a la página que desea obtener. Recuerde que un límite de 25 registros por llamada, es aplicada.
{
"class":"GET",
"action":"credit-notes",
"page":1",
}
Obtener la lista de una nota de crédito específico
La variable id se utiliza para mostrar una nota de crédito especifica
{"class":"GET","action":"credit-note","id":"SNC0006" }
{"class":"GET",
"action":"credit-note",
"credit-note":[
{
"Invoice":{
"id": "SNC0006",
"Cliente": "C0009",
"Nombre":"Abraham Hemsword",
"Pais": "USA",
"Bodega": "Bodega Principal",
"Status": "CLOSED",
"Date": "2023-04-04",
"Comentario": "",
"SubTotal": "50.00",
"Discount": "0.00",
"Taxes": "3.50",
"Total": "53.50",
"Credit_Term": "C.O.D.",
"Balance": null,
"Vendedor": "David Correa"
},
"Lines": [
{
"Codigo": "PS0000028",
"Descripcion": "Fletes SA\\nPeriodo:March 2023 Ciclo:MENSUAL\\nfactura fletes",
"Item_Number": "6565",
"Nombre": "Fletes SA",
"Marca": "",
"Category_L1": "",
"Category_L2": "",
"Category_L3": "",
"Unidades": "1.000",
"Precio_Unitario": "50.0000",
"Discount": "0.00",
"DiscountFactor": "0.00",
"TaxID": "1",
"TaxName": "ITBMS",
"TaxFactor": "0.07",
"TaxValue": "3.5000",
"Total": "50.00",
"Account": "ACC0080"
}
]
}
],
"count": 1
}
GET - purchases
Obtener el listado de las compras y su detalle. La variable page se refiere a la página que desea obtener. Recuerde que un límite de 25 registros por llamada, es aplicado.
{"class":"GET","action":"purchases"}
{"class":"GET","action":"purchases","purchases":[
{"Purchase":{"id":"00001","Proveedor":"P0002","Nombre":"FELIX BORJA","Pais":"PANAMA","Bodega":"Bodega Principal","Status":"ABORTED","Date":"2016-06-04","Comentario":"","SubTotal":"35.00","OtherType":"OTROS","Others":"0.00","Taxes":"0.00","Total":"35.00","Credit_Term":"C.O.D.","Balance":"35.00","Type":"PURCHASE"},"Lines":[{"Codigo":"PS0000002","Descripcion":"aceite ","Item_Number":null,"Nombre":null,"Marca":null,"Category_L1":null,"Category_L2":null,"Category_L3":null,"Unidades":"20.00","Precio_Unitario":"1.7500","Total":"35.00","Account":"ACC0016"}]},{"Quote":{"id":"00002","Proveedor":"P0002","Nombre":"FELIX BORJA","Pais":"PANAMA","Bodega":"Bodega Principal","Status":"ABORTED","Date":"2016-06-07","Comentario":"","SubTotal":"120.00","OtherType":"OTROS","Others":"0.00","Taxes":"8.40","Total":"128.40","Credit_Term":"C.O.D.","Balance":"128.40","Type":"PURCHASE"},"Lines":[{"Codigo":"","Descripcion":"LENTEJAS AMAPOLAS ","Item_Number":null,"Nombre":null,"Marca":null,"Category_L1":null,"Category_L2":null,"Category_L3":null,"Unidades":"60.00","Precio_Unitario":"2.0000","Total":"120.00","Account":"ACC0016"}]},{"Quote":{"id":"00003","Proveedor":"P0002","Nombre":"FELIX BORJA","Pais":"PANAMA","Bodega":"Bodega Principal","Status":"ABORTED","Date":"2016-06-07","Comentario":"","SubTotal":"200.00","OtherType":"OTROS","Others":"0.00","Taxes":"0.00","Total":"200.00","Credit_Term":"C.O.D.","Balance":"200.00","Type":"PURCHASE"},"Lines":[{"Codigo":"","Descripcion":"LENTEJAS","Item_Number":null,"Nombre":null,"Marca":null,"Category_L1":null,"Category_L2":null,"Category_L3":null,"Unidades":"100.00","Precio_Unitario":"2.0000","Total":"200.00","Account":"ACC0016"}]},{"Quote":{"id":"00004","Proveedor":"P0002","Nombre":"FELIX BORJA","Pais":"PANAMA","Bodega":"Bodega Principal","Status":"ABORTED","Date":"2016-06-07","Comentario":"","SubTotal":"200.00","OtherType":"OTROS","Others":"0.00","Taxes":"0.00","Total":"200.00","Credit_Term":"C.O.D.","Balance":"200.00","Type":"PURCHASE"},"Lines":[{"Codigo":"","Descripcion":"LENTEJAS","Item_Number":null,"Nombre":null,"Marca":null,"Category_L1":null,"Category_L2":null,"Category_L3":null,"Unidades":"100.00","Precio_Unitario":"2.0000","Total":"200.00","Account":"ACC0015"}]},{"Quote":{"id":"00005","Proveedor":"P0002","Nombre":"FELIX BORJA","Pais":"PANAMA","Bodega":"Bodega Principal","Status":"ABORTED","Date":"2016-06-07","Comentario":"","SubTotal":"200.00","OtherType":"OTROS","Others":"0.00","Taxes":"0.00","Total":"200.00","Credit_Term":"C.O.D.","Balance":"200.00","Type":"PURCHASE"},"Lines":[{"Codigo":"","Descripcion":"LENTEJAS","Item_Number":null,"Nombre":null,"Marca":null,"Category_L1":null,"Category_L2":null,"Category_L3":null,"Unidades":"100.00","Precio_Unitario":"2.0000","Total":"200.00","Account":"ACC0016"}]},{"Quote":{"id":"00006","Proveedor":"P0005","Nombre":"JOEL PEREZ","Pais":"","Bodega":"Bodega Principal","Status":"CLOSED","Date":"2016-06-08","Comentario":"","SubTotal":"45.00","OtherType":"OTROS","Others":"0.00","Taxes":"0.00","Total":"45.00","Credit_Term":"C.O.D.","Balance":"0.00","Type":"PURCHASE"},"Lines":[{"Codigo":"PS0000004","Descripcion":"ARROZ","Item_Number":null,"Nombre":null,"Marca":null,"Category_L1":null,"Category_L2":null,"Category_L3":null,"Unidades":"30.00","Precio_Unitario":"1.5000","Total":"45.00","Account":"ACC0016"}]},{"Quote":{"id":"00007","Proveedor":"P0005","Nombre":"JOEL PEREZ","Pais":"","Bodega":"Bodega Principal","Status":"ABORTED","Date":"2016-06-08","Comentario":"","SubTotal":"1.50","OtherType":"OTROS","Others":"0.00","Taxes":"0.00","Total":"1.50","Credit_Term":"C.O.D.","Balance":"1.50","Type":"PURCHASE"},"Lines":[{"Codigo":"PS0000004","Descripcion":"ARROZ","Item_Number":null,"Nombre":null,"Marca":null,"Category_L1":null,"Category_L2":null,"Category_L3":null,"Unidades":"1.00","Precio_Unitario":"1.5000","Total":"1.50","Account":"ACC0016"}]},{"Quote":{"id":"00008","Proveedor":"P0006","Nombre":"DKFASHION","Pais":"","Bodega":"Bodega Principal","Status":"CLOSED","Date":"2016-06-08","Comentario":"","SubTotal":"50.00","OtherType":"OTROS","Others":"0.00","Taxes":"0.00","Total":"50.00","Credit_Term":"CREDIT","Balance":"0.00","Type":"PURCHASE"},"Lines":[{"Codigo":"","Descripcion":"SEGURIDAD","Item_Number":null,"Nombre":null,"Marca":null,"Category_L1":null,"Category_L2":null,"Category_L3":null,"Unidades":"1.00","Precio_Unitario":"50.0000","Total":"50.00","Account":"ACC0099"}]},{"Quote":{"id":"00009","Proveedor":"P0002","Nombre":"FELIX BORJA","Pais":"PANAMA","Bodega":"Bodega Principal","Status":"ABORTED","Date":"2016-06-08","Comentario":"","SubTotal":"60.00","OtherType":"OTROS","Others":"0.00","Taxes":"0.00","Total":"60.00","Credit_Term":"C.O.D.","Balance":"60.00","Type":"PURCHASE"},"Lines":[{"Codigo":"PS0000003","Descripcion":"Lentejas","Item_Number":null,"Nombre":null,"Marca":null,"Category_L1":null,"Category_L2":null,"Category_L3":null,"Unidades":"2.00","Precio_Unitario":"30.0000","Total":"60.00","Account":"ACC0016"}]},{"Quote":{"id":"00010","Proveedor":"P0002","Nombre":"FELIX BORJA","Pais":"PANAMA","Bodega":"Bodega Principal","Status":"ABORTED","Date":"2016-06-10","Comentario":"","SubTotal":"60.00","OtherType":"","Others":"0.00","Taxes":"4.20","Total":"64.20","Credit_Term":"C.O.D.","Balance":"64.20","Type":"PURCHASE-REL-COSTS"},"Lines":[{"Codigo":"","Descripcion":"costo de transporte ","Item_Number":null,"Nombre":null,"Marca":null,"Category_L1":null,"Category_L2":null,"Category_L3":null,"Unidades":"1.00","Precio_Unitario":"60.0000","Total":"60.00","Account":"ACC0016"}]},{"Quote":{"id":"00011","Proveedor":"P0006","Nombre":"DKFASHION","Pais":"","Bodega":"Bodega Principal","Status":"ABORTED","Date":"2016-06-13","Comentario":"","SubTotal":"3000.00","OtherType":"OTROS","Others":"0.00","Taxes":"2.10","Total":"3002.10","Credit_Term":"CREDIT","Balance":"3002.10","Type":"PURCHASE"},"Lines":[{"Codigo":"","Descripcion":"LAPTOP MACBOOK AIR","Item_Number":null,"Nombre":null,"Marca":null,"Category_L1":null,"Category_L2":null,"Category_L3":null,"Unidades":"2.00","Precio_Unitario":"1500.0000","Total":"3000.00","Account":"ACC0015"}]},{"Quote":{"id":"00012","Proveedor":"P0006","Nombre":"DKFASHION","Pais":"","Bodega":"Bodega Principal","Status":"CLOSED","Date":"2016-06-13","Comentario":"","SubTotal":"3000.00","OtherType":"OTROS","Others":"0.00","Taxes":"0.00","Total":"3000.00","Credit_Term":"CREDIT","Balance":"0.00","Type":"PURCHASE"},"Lines":[{"Codigo":"","Descripcion":"LAPTOP MACBOOK AIR","Item_Number":null,"Nombre":null,"Marca":null,"Category_L1":null,"Category_L2":null,"Category_L3":null,"Unidades":"2.00","Precio_Unitario":"1500.0000","Total":"3000.00","Account":"ACC0016"}]},{"Quote":{"id":"00013","Proveedor":"P0004","Nombre":"INVERSIONES RICABAR","Pais":"","Bodega":"Bodega Principal","Status":"IN-WHOUSE","Date":"2016-06-13","Comentario":"COMPRA DE AZUCAR Y LENTEJAS ","SubTotal":"187.50","OtherType":"OTROS","Others":"0.00","Taxes":"0.00","Total":"187.50","Credit_Term":"C.O.D.","Balance":"0.00","Type":"PURCHASE"},"Lines":[{"Codigo":"PS0000001","Descripcion":"azucar","Item_Number":null,"Nombre":null,"Marca":null,"Category_L1":null,"Category_L2":null,"Category_L3":null,"Unidades":"50.00","Precio_Unitario":"1.7500","Total":"87.50","Account":"ACC0016"},{"Codigo":"PS0000003","Descripcion":"Lentejas","Item_Number":null,"Nombre":null,"Marca":null,"Category_L1":null,"Category_L2":null,"Category_L3":null,"Unidades":"50.00","Precio_Unitario":"2.0000","Total":"100.00","Account":"ACC0016"}]},{"Quote":{"id":"00014","Proveedor":"P0006","Nombre":"DKFASHION","Pais":"","Bodega":"Bodega Principal","Status":"CLOSED","Date":"2016-06-14","Comentario":"","SubTotal":"115.00","OtherType":"OTROS","Others":"0.00","Taxes":"0.00","Total":"115.00","Credit_Term":"CREDIT","Balance":"0.00","Type":"PURCHASE"},"Lines":[{"Codigo":"PS0000002","Descripcion":"aceite ","Item_Number":null,"Nombre":null,"Marca":null,"Category_L1":null,"Category_L2":null,"Category_L3":null,"Unidades":"23.00","Precio_Unitario":"5.0000","Total":"115.00","Account":"ACC0016"}]},{"Quote":{"id":"00015","Proveedor":"P0001","Nombre":"XYZ","Pais":"PANAMA","Bodega":"Bodega Principal","Status":"INVENTORY","Date":"2016-06-15","Comentario":"","SubTotal":"90.00","OtherType":"OTROS","Others":"0.00","Taxes":"6.30","Total":"96.30","Credit_Term":"C.O.D.","Balance":"96.30","Type":"PURCHASE"},"Lines":[{"Codigo":"PS0000005","Descripcion":"JABON ","Item_Number":null,"Nombre":null,"Marca":null,"Category_L1":null,"Category_L2":null,"Category_L3":null,"Unidades":"30.00","Precio_Unitario":"3.0000","Total":"90.00","Account":"ACC0016"}]},{"Quote":{"id":"00016","Proveedor":"P0001","Nombre":"XYZ","Pais":"PANAMA","Bodega":"Bodega Principal","Status":"CLOSED","Date":"2016-06-15","Comentario":"","SubTotal":"20.00","OtherType":"","Others":"0.00","Taxes":"0.00","Total":"20.00","Credit_Term":"C.O.D.","Balance":"20.00","Type":"PURCHASE-REL-COSTS"},"Lines":[{"Codigo":"","Descripcion":"COSTO DE TRANSPORTE ","Item_Number":null,"Nombre":null,"Marca":null,"Category_L1":null,"Category_L2":null,"Category_L3":null,"Unidades":"1.00","Precio_Unitario":"20.0000","Total":"20.00","Account":"ACC0016"}]},{"Quote":{"id":"00017","Proveedor":"P0001","Nombre":"XYZ","Pais":"PANAMA","Bodega":"Bodega Principal","Status":"INVENTORY","Date":"2016-06-15","Comentario":"","SubTotal":"2000.00","OtherType":"OTROS","Others":"0.00","Taxes":"0.00","Total":"2000.00","Credit_Term":"C.O.D.","Balance":"2000.00","Type":"PURCHASE"},"Lines":[{"Codigo":"PS0000008","Descripcion":"sofa","Item_Number":null,"Nombre":null,"Marca":null,"Category_L1":null,"Category_L2":null,"Category_L3":null,"Unidades":"2.00","Precio_Unitario":"1000.0000","Total":"2000.00","Account":"ACC0016"}]},{"Quote":{"id":"00018","Proveedor":"P0002","Nombre":"FELIX BORJA","Pais":"PANAMA","Bodega":"Bodega Principal","Status":"INVENTORY","Date":"2016-06-15","Comentario":"","SubTotal":"20.00","OtherType":"OTROS","Others":"0.00","Taxes":"0.00","Total":"20.00","Credit_Term":"C.O.D.","Balance":"20.00","Type":"PURCHASE"},"Lines":[{"Codigo":"PS0000003","Descripcion":"Lentejas","Item_Number":null,"Nombre":null,"Marca":null,"Category_L1":null,"Category_L2":null,"Category_L3":null,"Unidades":"10.00","Precio_Unitario":"2.0000","Total":"20.00","Account":"ACC0016"}]},{"Quote":{"id":"00019","Proveedor":"P0006","Nombre":"DKFASHION","Pais":"","Bodega":"Bodega Principal","Status":"INVENTORY","Date":"2016-06-15","Comentario":"","SubTotal":"6.00","OtherType":"OTROS","Others":"0.00","Taxes":"0.00","Total":"6.00","Credit_Term":"CREDIT","Balance":"0.00","Type":"PURCHASE"},"Lines":[{"Codigo":"PS0000002","Descripcion":"aceite","Item_Number":null,"Nombre":null,"Marca":null,"Category_L1":null,"Category_L2":null,"Category_L3":null,"Unidades":"2.00","Precio_Unitario":"3.0000","Total":"6.00","Account":"ACC0016"}]},{"Quote":{"id":"00020","Proveedor":"P0006","Nombre":"DKFASHION","Pais":"","Bodega":"Bodega Principal","Status":"INVENTORY","Date":"2016-06-16","Comentario":"","SubTotal":"20.00","OtherType":"OTROS","Others":"0.00","Taxes":"0.00","Total":"20.00","Credit_Term":"CREDIT","Balance":"0.00","Type":"PURCHASE"},"Lines":[{"Codigo":"PS0000001","Descripcion":"azucar ","Item_Number":null,"Nombre":null,"Marca":null,"Category_L1":null,"Category_L2":null,"Category_L3":null,"Unidades":"10.00","Precio_Unitario":"2.0000","Total":"20.00","Account":"ACC0016"}]},{"Quote":{"id":"00021","Proveedor":"P0002","Nombre":"FELIX BORJA","Pais":"PANAMA","Bodega":"Bodega Principal","Status":"INVENTORY","Date":"2016-06-16","Comentario":"","SubTotal":"60.00","OtherType":"OTROS","Others":"0.00","Taxes":"0.00","Total":"60.00","Credit_Term":"C.O.D.","Balance":"60.00","Type":"PURCHASE"},"Lines":[{"Codigo":"PS0000003","Descripcion":"Lentejas","Item_Number":null,"Nombre":null,"Marca":null,"Category_L1":null,"Category_L2":null,"Category_L3":null,"Unidades":"2.00","Precio_Unitario":"30.0000","Total":"60.00","Account":"ACC0084"}]},{"Quote":{"id":"00022","Proveedor":"P0006","Nombre":"DKFASHION","Pais":"","Bodega":"Bodega Principal","Status":"CLOSED","Date":"2016-06-22","Comentario":"","SubTotal":"3180.00","OtherType":"OTROS","Others":"0.00","Taxes":"0.00","Total":"3180.00","Credit_Term":"CREDIT","Balance":"0.00","Type":"PURCHASE"},"Lines":[{"Codigo":"PS0000008","Descripcion":"sofa ","Item_Number":null,"Nombre":null,"Marca":null,"Category_L1":null,"Category_L2":null,"Category_L3":null,"Unidades":"3.00","Precio_Unitario":"1000.0000","Total":"3000.00","Account":"ACC0084"},{"Codigo":"PS0000005","Descripcion":"JABON ","Item_Number":null,"Nombre":null,"Marca":null,"Category_L1":null,"Category_L2":null,"Category_L3":null,"Unidades":"10.00","Precio_Unitario":"18.0000","Total":"180.00","Account":"ACC0084"}]},{"Quote":{"id":"00023","Proveedor":"P0006","Nombre":"DKFASHION","Pais":"","Bodega":"Bodega Principal","Status":"IN-TRANSIT","Date":"2016-06-28","Comentario":"","SubTotal":"60.00","OtherType":"OTROS","Others":"0.00","Taxes":"0.00","Total":"60.00","Credit_Term":"CREDIT","Balance":"0.00","Type":"PURCHASE"},"Lines":[{"Codigo":"PS0000004","Descripcion":"ARROZ ","Item_Number":null,"Nombre":null,"Marca":null,"Category_L1":null,"Category_L2":null,"Category_L3":null,"Unidades":"3.00","Precio_Unitario":"20.0000","Total":"60.00","Account":"ACC0084"}]},{"Quote":{"id":"00024","Proveedor":"P0006","Nombre":"DKFASHION","Pais":"","Bodega":"Bodega Principal","Status":"INVENTORY","Date":"2016-07-20","Comentario":"","SubTotal":"5.00","OtherType":"OTROS","Others":"0.00","Taxes":"0.00","Total":"5.00","Credit_Term":"CREDIT","Balance":"0.00","Type":"PURCHASE"},"Lines":[{"Codigo":"PS0000009","Descripcion":"AVAYA\r\n\r\nSERIAL 123455","Item_Number":null,"Nombre":null,"Marca":null,"Category_L1":null,"Category_L2":null,"Category_L3":null,"Unidades":"1.00","Precio_Unitario":"5.0000","Total":"5.00","Account":"ACC0084"}]},{"Quote":{"id":"00025","Proveedor":"P0002","Nombre":"FELIX BORJA","Pais":"PANAMA","Bodega":"exibici\u00f3n","Status":"INVENTORY","Date":"2016-07-20","Comentario":"","SubTotal":"30.00","OtherType":"OTROS","Others":"0.00","Taxes":"0.00","Total":"30.00","Credit_Term":"C.O.D.","Balance":"30.00","Type":"PURCHASE"},"Lines":[{"Codigo":"PS0000003","Descripcion":"Lentejas ","Item_Number":null,"Nombre":null,"Marca":null,"Category_L1":null,"Category_L2":null,"Category_L3":null,"Unidades":"1.00","Precio_Unitario":"30.0000","Total":"30.00","Account":"ACC0084"}]}
],"count":25}
GET - purchase
Obtener el detalle de una compra específica. La variable id es utilizada para obtener la compra deseada.
{"class":"GET","action":"purchase", "id":"00001"}
{"class":"GET","action":"purchase","purchase":[
{"Purchase":{"id":"00001","Proveedor":"P0002","Nombre":"FELIX BORJA","Pais":"PANAMA","Bodega":"Bodega Principal","Status":"ABORTED","Date":"2016-06-04","Comentario":"","SubTotal":"35.00","OtherType":"OTROS","Others":"0.00","Taxes":"0.00","Total":"35.00","Credit_Term":"C.O.D.","Balance":"35.00","Type":"PURCHASE"},"Lines":[{"Codigo":"PS0000002","Descripcion":"aceite ","Item_Number":null,"Nombre":null,"Marca":null,"Category_L1":null,"Category_L2":null,"Category_L3":null,"Unidades":"20.00","Precio_Unitario":"1.7500","Total":"35.00","Account":"ACC0016"}]}
],"count":1}
GET – purchases - credit - notes
Obtener el listado de las facturas y su detalle. La variable Page se refiere a la página que desea obtener. Recuerde que un límite de 25 registros por llamada, es aplicado.
{"class":"GET","action":"purchase_credit-notes", "page":"1"}
Obtener la lista de una nota de crédito especifica
La variable id se utiliza para mostrar una nota de crédito especifica.
{"class":"GET","action":"purchase_credit-note", "id":"CNC00016"}
{
"class": "GET",
"action": "purchase_credit-note",
"purchase_credit-note": [
{
"purchase_credit-note": {
"id": "CNC00016",
"Credit_Reference": "",
"id_proveedor": "P0002",
"nombre_proveedor": "China MH",
"Date": "2023-12-04",
"WareHouse": "Bodega Principal",
"Comentario": "",
"Subtotal": "11.57",
"Taxes": "0.00",
"Total": "11.57",
"WorkFlow": "PENDING-WO",
"Status": "PENDING",
"Lines": [
{
"Item": "PROD0000070",
"Item_Number": "Colageno Hidrolizado",
"Nombre": "GELICART SOBRES UND",
"Marca": "SANOFI",
"Category_L1": "",
"Category_L2": "",
"Category_L3": "",
"Unidades": "13.00",
"Precio_Unitario": "0.8900",
"Total": "11.57"
}
]
}
}
],
"count": "1"
}
GET - accounting_journal
Obtener el mayor en base a rango de fecha y otros filtros opcionales.
{
"class":"GET",
"action":"accounting_journal",
"Date_From":"2018-01-01",
"Date_To":"2018-01-31"
}
{
"class": "GET",
"action": "projects",
"projects": [{
"id": "PROJ0002",
"Titulo": "meyers group",
"Cliente": "C0005",
"Departamento": "HR",
"Fecha_Inicio": "2016-07-07",
"Fecha_Terminacion": "2016-07-07",
"Agente": "[email protected]",
"Asignado": "[email protected]",
"Dias": "523",
"Status": "ABIERTO"
}, {
"id": "PROJ0003",
"Titulo": "panamcom",
"Cliente": "C0007",
"Departamento": "RECEPCION",
"Fecha_Inicio": "2016-07-14",
"Fecha_Terminacion": "2016-07-14",
"Agente": "[email protected]",
"Asignado": "[email protected]",
"Dias": "516",
"Status": "ABIERTO"
}],
"count": 2
}
Cualquier consulta comuníquese en el chat de atención al cliente para asesoramiento.
GET - warehouse_transfer
Este endpoint permite obtener las transferencias basadas en filtros de campos.
Obtener el mayor en base a rango de fecha y otros filtros opcionales.
{
"class": "GET",
"action": "warehouse_transfers",
"filters":[
{
"field":"WareHouse_From",
"type":"=",
"value":"Bodega Principal"
},{
"field":"Date",
"type":">=",
"value":"2022-02-01"
}
]
}
{
"class": "GET",
"action": "warehouse_transfers",
"warehouse_transfers": [
{
"warehouse_transfer": {
"id": "101",
"WareHouse_From": "Bodega Principal",
"WareHouse_To": "Tienda Virtual",
"Date": "2022-02-09",
"Comentario": "prueba de endpoint éü",
"Status": "INTRANSIT",
"CreatedBy": "API",
"CreatedDate": "2022-02-09 17:38:49",
"ClosedBy": "",
"ClosedDate": "0000-00-00 00:00:00",
"Lines": [
{
"Item": "PRO18544",
"Item_Number": "357543.20D12",
"Nombre": "AB 17 ZAPATILLA (PUWHFUCPUR)",
"Marca": "PUMA",
"Category_L1": "CALZADO",
"Category_L2": "ZAPATILLA",
"Category_L3": "00AF",
"Units": "1.00",
"CheckOut": "1.00",
"Checkin": "1.00",
"WareHouse_From": "Bodega Principal",
"WareHouse_To": "Tienda Virtual"
},
{
"Item": "PS0000562",
"Item_Number": "123123",
"Nombre": "123123",
"Marca": "324",
"Category_L1": "ALIMENTOS",
"Category_L2": "",
"Category_L3": "",
"Units": "1.00",
"CheckOut": "1.00",
"Checkin": "1.00",
"WareHouse_From": "Bodega Principal",
"WareHouse_To": "Tienda Virtual"
},
{
"Item": "PS0000562",
"Item_Number": "123123",
"Nombre": "123123",
"Marca": "324",
"Category_L1": "ALIMENTOS",
"Category_L2": "",
"Category_L3": "",
"Units": "2.00",
"CheckOut": "2.00",
"Checkin": "2.00",
"WareHouse_From": "Bodega Principal",
"WareHouse_To": "Tienda Chorrera"
}
]
}
},
{
"warehouse_transfer": {
"id": "102",
"WareHouse_From": "Bodega Principal",
"WareHouse_To": "Tienda Virtual",
"Date": "2022-02-15",
"Comentario": "prueba de endpoint",
"Status": "INTRANSIT",
"CreatedBy": "API",
"CreatedDate": "2022-02-15 09:46:04",
"ClosedBy": "",
"ClosedDate": "0000-00-00 00:00:00",
"Lines": [
{
"Item": "PRO18479",
"Item_Number": "078260.4047",
"Nombre": " Teaspot",
"Marca": "LISE",
"Category_L1": "DECORACIÓN",
"Category_L2": "",
"Category_L3": "",
"Units": "2.00",
"CheckOut": "0.00",
"Checkin": "0.00",
"WareHouse_From": "Bodega Principal",
"WareHouse_To": "Tienda Virtual"
}
]
}
},
{
"warehouse_transfer": {
"id": "97",
"WareHouse_From": "Bodega Principal",
"WareHouse_To": "Tienda Chorrera",
"Date": "2022-02-08",
"Comentario": "prueba para api v4",
"Status": "CLOSED",
"CreatedBy": "IF_DEMO",
"CreatedDate": "2022-02-08 20:11:19",
"ClosedBy": "IF_DEMO",
"ClosedDate": "2022-02-08 20:16:33",
"Lines": [
{
"Item": "PS0000562",
"Item_Number": "123123",
"Nombre": "123123",
"Marca": "324",
"Category_L1": "ALIMENTOS",
"Category_L2": "",
"Category_L3": "",
"Units": "10.00",
"CheckOut": "10.00",
"Checkin": "10.00",
"WareHouse_From": "Bodega Principal",
"WareHouse_To": "Bodega Alvarez"
}
]
}
},
{
"warehouse_transfer": {
"id": "98",
"WareHouse_From": "Bodega Principal",
"WareHouse_To": "Tienda Chorrera",
"Date": "2022-02-08",
"Comentario": "",
"Status": "INTRANSIT",
"CreatedBy": "IF_DEMO",
"CreatedDate": "2022-02-08 20:23:31",
"ClosedBy": "",
"ClosedDate": "0000-00-00 00:00:00",
"Lines": [
{
"Item": "PS0000562",
"Item_Number": "123123",
"Nombre": "123123",
"Marca": "324",
"Category_L1": "ALIMENTOS",
"Category_L2": "",
"Category_L3": "",
"Units": "2.00",
"CheckOut": "0.00",
"Checkin": "0.00",
"WareHouse_From": "Bodega Principal",
"WareHouse_To": "Tienda Chorrera"
},
{
"Item": "PS0000562",
"Item_Number": "123123",
"Nombre": "123123",
"Marca": "324",
"Category_L1": "ALIMENTOS",
"Category_L2": "",
"Category_L3": "",
"Units": "2.00",
"CheckOut": "0.00",
"Checkin": "0.00",
"WareHouse_From": "Bodega Principal",
"WareHouse_To": "SHOWROOM"
},
{
"Item": "PS0000562",
"Item_Number": "123123",
"Nombre": "123123",
"Marca": "324",
"Category_L1": "ALIMENTOS",
"Category_L2": "",
"Category_L3": "",
"Units": "2.00",
"CheckOut": "0.00",
"Checkin": "0.00",
"WareHouse_From": "Bodega Principal",
"WareHouse_To": "Bodega Alvarez"
}
]
}
},
{
"warehouse_transfer": {
"id": "99",
"WareHouse_From": "Bodega Principal",
"WareHouse_To": "Tienda Chorrera",
"Date": "2022-02-09",
"Comentario": "",
"Status": "CLOSED",
"CreatedBy": "IF_DEMO",
"CreatedDate": "2022-02-09 10:08:29",
"ClosedBy": "IF_DEMO",
"ClosedDate": "2022-02-09 10:08:49",
"Lines": [
{
"Item": "PRO18479",
"Item_Number": "078260.4047",
"Nombre": " Teaspot",
"Marca": "LISE",
"Category_L1": "DECORACIÓN",
"Category_L2": "",
"Category_L3": "",
"Units": "10.00",
"CheckOut": "10.00",
"Checkin": "10.00",
"WareHouse_From": "Bodega Principal",
"WareHouse_To": "Tienda Chorrera"
},
{
"Item": "PS0000350",
"Item_Number": "60440240897",
"Nombre": "2 - Little Deco2",
"Marca": "3M USA",
"Category_L1": "COLECCCION PARIS",
"Category_L2": "",
"Category_L3": "",
"Units": "12.00",
"CheckOut": "12.00",
"Checkin": "12.00",
"WareHouse_From": "Bodega Principal",
"WareHouse_To": "Tienda Chorrera"
},
{
"Item": "PS0000562",
"Item_Number": "123123",
"Nombre": "123123",
"Marca": "324",
"Category_L1": "ALIMENTOS",
"Category_L2": "",
"Category_L3": "",
"Units": "7.00",
"CheckOut": "7.00",
"Checkin": "7.00",
"WareHouse_From": "Bodega Principal",
"WareHouse_To": "Bodega Sencuandaria"
}
]
}
}
],
"count": "5"
}
GET - purchase_orders
Este endpoint permite obtener las ordenes de compra basadas en filtros de campos.
Obtener el mayor en base a rango de fecha y otros filtros opcionales.
{
"class": "GET",
"action": "purchase_orders",
"filters":[
{
"field":"WareHouse",
"type":"=",
"value":"Bodega Principal"
},{
"field":"Date",
"type":">=",
"value":"2022-02-07"
}
]
}
{
"class": "GET",
"action": "purchase_orders",
"purchase_orders": [
{
"purchase_order": {
"id": "10138",
"id_proveedor": "P0064",
"nombre_proveedor": "3M Panama",
"Date": "2022-02-10",
"WareHouse": "Bodega Principal",
"Comentario": "",
"Subtotal": "5.64",
"Taxes": "0.00",
"Total": "5.64",
"Status": "PENDING",
"Lines": [
{
"Item": "PS0000350",
"Item_Number": "60440240897",
"Nombre": "2 - Little Deco2",
"Marca": "3M USA",
"Category_L1": "COLECCCION PARIS",
"Category_L2": "",
"Category_L3": "",
"Unidades": "1.00",
"Precio_Unitario": "5.6400",
"Total": "5.64"
}
]
}
},
{
"purchase_order": {
"id": "10144",
"id_proveedor": "P0064",
"nombre_proveedor": "3M Panama",
"Date": "2022-02-10",
"WareHouse": "Bodega Principal",
"Comentario": "prueba de endpoint po éü",
"Subtotal": "63.21",
"Taxes": "1.63",
"Total": "64.84",
"Status": "PENDING",
"Lines": [
{
"Item": "PS0000562",
"Item_Number": "123123",
"Nombre": "123123",
"Marca": "324",
"Category_L1": "ALIMENTOS",
"Category_L2": "",
"Category_L3": "",
"Unidades": "3.00",
"Precio_Unitario": "7.7500",
"Total": "23.25"
},
{
"Item": "PRO18544",
"Item_Number": "357543.20D12",
"Nombre": "AB 17 ZAPATILLA (PUWHFUCPUR)",
"Marca": "PUMA",
"Category_L1": "CALZADO",
"Category_L2": "ZAPATILLA",
"Category_L3": "00AF",
"Unidades": "4.00",
"Precio_Unitario": "9.9900",
"Total": "39.96"
}
]
}
},
{
"purchase_order": {
"id": "10145",
"id_proveedor": "P0064",
"nombre_proveedor": "3M Panama",
"Date": "2022-02-10",
"WareHouse": "Bodega Principal",
"Comentario": "prueba de endpoint",
"Subtotal": "63.21",
"Taxes": "1.63",
"Total": "64.84",
"Status": "PENDING",
"Lines": [
{
"Item": "PS0000562",
"Item_Number": "123123",
"Nombre": "123123",
"Marca": "324",
"Category_L1": "ALIMENTOS",
"Category_L2": "",
"Category_L3": "",
"Unidades": "3.00",
"Precio_Unitario": "7.7500",
"Total": "23.25"
},
{
"Item": "PRO18544",
"Item_Number": "357543.20D12",
"Nombre": "AB 17 ZAPATILLA (PUWHFUCPUR)",
"Marca": "PUMA",
"Category_L1": "CALZADO",
"Category_L2": "ZAPATILLA",
"Category_L3": "00AF",
"Unidades": "4.00",
"Precio_Unitario": "9.9900",
"Total": "39.96"
}
]
}
}
],
"count": "3"
}
GET -Projects
Permite obtener todos los proyectos creados en el sistema.
{
"class": "GET",
"action": "projects",
}
{
"class": "GET",
"action": "projects",
"projects": [
{
"id": "PROJ0001",
"Título": "Instalación de servidor",
"Cliente": "C0004",
"Departamento": "DESARROLLO",
"Fecha_Inicio": "2023-02-24",
"Fecha_Terminacion": "2023-03-03",
"Agente": "[email protected]",
"Asignado": "[email protected]",
"Dias": "540",
"Status": "ABIERTO"
},
{
"id":"PROJ0002",
"Título": "Creación de blog",
"Cliente": "C0014",
"Departamento": "DESARROLLO",
"Fecha_Inicio": "2023-02-27",
"Fecha_Terminacion": "2023-03-02",
"Agente": "[email protected]",
"Asignado": "[email protected]",
"Dias": "537",
"Status": "EN PROCESO"
}
],
"count": "2"
}
GET - inventory_adjustments
Obtener todos los ajustes de inventario.
{
"class":"GET",
"action":"inventory_adjustments"
}
{
"class": "GET",
"action": "inventory_adjustments",
"inventory_adjustments": [
{
"inventory_adjustment": {
"id": "AI-10",
"WareHouse": "Bodega Principal",
"Categoria": "Balance Inicial",
"Date": "2023-02-22",
"Comentario": "",
"Status": "CLOSED",
"TOTAL": "75.00",
"CreatedBy": "[email protected]",
"Created": "2023-02-22 16:30:00",
"ClosedBy": "[email protected]",
"ClosedDate": "2023-02-22 16:30:00",
"Lines":[
{
"Item": "PS0000019",
"Item_Number": "3456",
"Nombre": "tinta de sublimación",
"Marca": "big",
"Category_L1": "",
"Catergory_L2": "",
"Category_L3": "",
"Units": "50.000",
"Costs": "1.5000",
"Total": "75.0000",
"WHControl": "50.000"
}
]
}
},
{
"inventory_adjustment": {
"id": "AI-100",
"WareHouse": "Bodega Principal",
"Categoria": "Balance Inicial",
"Date": "2024-01-03",
"Comentario": "",
"Status": "PEND-REVISION",
"Total": "12.60",
"CreatedBy": "[email protected]",
"Created": "2024-01-03 14:48:29",
"ClosedBy": "",
"ClosedDate": "0000-00-00 00:00:00",
"Lines":[
{
"Item": "PRO5718",
"Item_Number": "F7-05",
"Nombre": "00018-05 FERRUL HIDRAULICO R7 5/16\"",
"Marca": "FERRULCA",
"Category_L1": "FERRETERIA",
"Category_L2": "",
"Category_L3": "",
"Units": "90.000",
"Costs": "0.1400",
"Total": "12.6000",
"WHControl": "0.000"
}
]
}
},
],
"count": "2"
}
Updated 3 months ago