The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"name": "v25.1.3",
"nodes": [
{
"parameters": {
"url": "=https://ws.dsnube.co/api/v1/consultasql?",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth",
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "consulta",
"value": "={{ $json.consulta }}"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
384,
2224
],
"id": "c4f85434-4b81-4d69-91be-ce53290b7b53",
"name": "GET Clients",
"credentials": {
"httpBasicAuth": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"options": {}
},
"type": "n8n-nodes-base.respondToWebhook",
"typeVersion": 1.4,
"position": [
320,
3216
],
"id": "82ba8283-b6e5-49b9-8b06-fbaaff519419",
"name": "Respond to Webhook1"
},
{
"parameters": {
"url": "=https://ws.dsnube.co/api/v1/consultasql?consulta={{ encodeURIComponent($json.consulta) }}",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth",
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
-208,
3088
],
"id": "333b7d5b-3e5a-4ff2-868f-d7d071472318",
"name": "GET Products",
"credentials": {
"httpBasicAuth": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"jsCode": "// Loop over input items and add a new field called 'myNewField' to the JSON of each one\nconst productos = $input.first().json.result.map(producto => ({\n nombre: producto.Producto,\n codigo: producto['C\u00f3digo'],\n modelo: producto.modelo,\n familia: producto.familia,\n grupo: producto.grupo,\n stock: producto.Disponible,\n precio: producto.Precio,\n codigoImpuesto: producto.codimp,\n porcentajeImpuesto: producto.porcentaje,\n idUnidad: producto.idunidad,\n marca: producto.marca\n}))\n\nreturn { productos };"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
0,
3088
],
"id": "3e872aee-842a-4efb-a787-5203497a66fc",
"name": "Mapear productos"
},
{
"parameters": {
"httpMethod": "POST",
"path": "pedidos",
"responseMode": "responseNode",
"options": {
"allowedOrigins": "https://pedidos.trimon.co,https://go-pedidos.trimon.co,http://localhost:5173"
}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
-1808,
4064
],
"id": "a6883ff5-bee4-4a30-9e9f-bae4598c5ae1",
"name": "Crear pedidos"
},
{
"parameters": {
"path": "productos",
"responseMode": "responseNode",
"options": {
"allowedOrigins": "https://pedidos.trimon.co,https://go-pedidos.trimon.co,http://localhost:5173"
}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
-1616,
3536
],
"id": "0c9f0688-0e0d-4e92-ab28-9014267a1dad",
"name": "Buscar productos"
},
{
"parameters": {
"path": "clientes",
"responseMode": "responseNode",
"options": {
"allowedOrigins": "https://pedidos.trimon.co,https://go-pedidos.trimon.co,http://localhost:5173"
}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
-1392,
2768
],
"id": "354e51f3-9572-4122-9fb3-ea711df734d5",
"name": "Buscar clientes"
},
{
"parameters": {
"jsCode": "const clientes = $input.first().json.result.map(cliente => ({\n nit: cliente.nit,\n razonSocial:cliente.razonsocial,\n sucursal: cliente.sucursal,\n telefono: cliente.telefono1,\n departamento: cliente.departamento,\n direccion: cliente.direccion1\n}))\n\nreturn {\n clientes\n};"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
752,
2192
],
"id": "9315171b-b452-4722-b8bd-5923bf723dfd",
"name": "Mapear clientes"
},
{
"parameters": {
"httpMethod": "=OPTIONS",
"path": "productos",
"responseMode": "responseNode",
"options": {
"allowedOrigins": "https://pedidos.trimon.co,https://go-pedidos.trimon.co,http://localhost:5173"
}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
-1696,
3392
],
"id": "ff4e5f45-b1f4-4348-8fd2-bf1f38f7d971",
"name": "Buscar productos options"
},
{
"parameters": {
"options": {}
},
"type": "n8n-nodes-base.respondToWebhook",
"typeVersion": 1.4,
"position": [
992,
2416
],
"id": "127fab98-50c7-4eb8-8213-ed0c5d31ef0a",
"name": "Respond to Webhook"
},
{
"parameters": {
"httpMethod": "=OPTIONS",
"path": "pedidos",
"responseMode": "responseNode",
"options": {
"allowedOrigins": "https://pedidos.trimon.co,https://go-pedidos.trimon.co,http://localhost:5173"
}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
-1776,
4256
],
"id": "35afe3e8-9bb2-4f96-ab37-08047a57563d",
"name": "Crear pedidos1"
},
{
"parameters": {
"table": {
"__rl": true,
"value": "pedido",
"mode": "list",
"cachedResultName": "pedido"
},
"dataMode": "defineBelow",
"valuesToSend": {
"values": [
{
"column": "id_estado",
"value": "=1"
},
{
"column": "nit",
"value": "={{ $json.sucursal.nit }}"
},
{
"column": "formaPagoId",
"value": "=1"
},
{
"column": "sucursal",
"value": "={{ JSON.stringify($json.sucursal) }}"
},
{
"column": "email_vendedor",
"value": "={{ $json.vendedor.email }}"
},
{
"column": "id_vendedor",
"value": "={{ $json.vendedor.idVendedor }}"
},
{
"column": "comentario",
"value": "={{ $json.pedido.comentarios }}"
}
]
},
"options": {
"detailedOutput": true
}
},
"type": "n8n-nodes-base.mySql",
"typeVersion": 2.5,
"position": [
1984,
3968
],
"id": "b1c935ea-c458-41b1-ab30-0c29b73a9bc0",
"name": "Insertar pedido en la tabla",
"credentials": {
"mySql": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"jsCode": "// const total = $input.first().json.pedido.items.reduce((acc, value) => acc + value.item.valorBruto, 0 )\n// const iva = $input.first().json.pedido.items.reduce((acc, value) => acc + value.item.iva, 0)\n// const subtotal = $input.first().json.pedido.items.reduce((acc, value) => acc + value.item.subtotal, 0)\n// const baseCalculo = $input.first().json.pedido.items.reduce((acc, value) => acc + value.item.neto, 0)\n// const impuestosPorItem = $input.first().json.pedido.items.reduce((acc, item) => {\n \n// return {\n// base_calculo: totalPedido.baseCalculo,\n// codimp: item.info.codimp,\n// liquida: \"S\",\n// valor: item.item.iva\n// }\n// }, {})\n\nconst totalPedido = $('Pedido completo').first().json.pedido.items.reduce((acc, item) => {\n return {\n total: acc.total + item.item.valorBruto,\n iva: acc.iva + item.item.iva,\n subtotal: acc.subtotal + item.item.subtotal,\n baseCalculo: item.item.neto,\n }\n}, { total: 0, iva: 0, subtotal: 0, baseCalculo: 0 })\n\n\n\nlet pedido = {\n \"encabezado\": {\n \"comentarios\": $input.first().json.pedido.comentarios,\n \"fecha\": new Date().toISOString().split('T')[0],\n \"idsuc\": 1,\n \"idvendedor\": $input.first().json.vendedor.idVendedor,\n \"numero\": $('Insertar pedido en la tabla').first().json.data.insertId,\n \"totalDet\": $input.first().json.pedido.items.length,\n \"nit\": $input.first().json.pedido.nit,\n iva: totalPedido.iva,\n subtotal: totalPedido.subtotal,\n \"total\": totalPedido.total,\n \"usuario\": \"VEND\",\n \"prefijo\": \"PEV\",\n },\n detalle: $input.first().json.pedido.items.map((detail, idx) => ({\n \"cantidad\": detail.item.cantidad,\n \"codimp\": \"IVA01\",\n \"idproducto\": detail.item.idProducto,\n \"idunidad\": detail.info.idunidad,\n \"iva\": detail.item.iva,\n \"neto\": detail.item.neto,\n \"porciva\": detail.item.porciva,\n \"pos\": idx + 1,\n \"precio\": detail.item.precio,\n \"subtotal\": detail.item.subtotal,\n \"unidades\": detail.item.cantidad,\n \"valorbruto\": detail.item.valorBruto,\n \"factor\": 1,\n \"idbodega\": detail.info.idbodega,\n \"operacion\": \"SA\",\n porcdcto: 0,\n vdescuento:0\n })),\n impuesto: [\n {\n base_calculo: totalPedido.subtotal,\n codimp: \"IVA01\",\n liquida: \"S\",\n valor: totalPedido.iva\n }\n ],\n pago: [\n {\n idformapago: 1,\n valor: totalPedido.total\n }\n ],\n sucursal: {\n idsuc: $input.first().json.sucursal.sucursal,\n nit: $input.first().json.pedido.nit\n } \n}\nreturn {\n codigo: 200,\n erpPayload: {\n documento: pedido\n }\n}"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
3696,
3152
],
"id": "7981de55-55cb-4f3c-8934-cf6cf834f6c0",
"name": "Constuir el payload del pedido para ERP"
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "ca06ff44-1a88-4e5c-9d71-ca9eb4cb0113",
"leftValue": "={{ $json.result }}",
"rightValue": "Exito",
"operator": {
"type": "string",
"operation": "contains"
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
4480,
3328
],
"id": "14f492fc-805e-4f2b-a8c0-b866b7aa80a9",
"name": "If"
},
{
"parameters": {
"operation": "update",
"table": {
"__rl": true,
"value": "pedido",
"mode": "list",
"cachedResultName": "pedido"
},
"dataMode": "defineBelow",
"columnToMatchOn": "id",
"valueToMatchOn": "={{ $('Insertar pedido en la tabla').first().json.data.insertId }}",
"valuesToSend": {
"values": [
{
"column": "id_estado",
"value": "3"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.mySql",
"typeVersion": 2.5,
"position": [
5488,
3104
],
"id": "0a0e80ee-4902-43f2-a25e-eb8809decaf9",
"name": "Actualizar pedido como guardado",
"credentials": {
"mySql": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"options": {}
},
"type": "n8n-nodes-base.respondToWebhook",
"typeVersion": 1.4,
"position": [
5760,
3968
],
"id": "fd0b3d47-0db2-4d2e-8fc5-c56af9f61dba",
"name": "Respuesta error pedido"
},
{
"parameters": {
"respondWith": "text",
"responseBody": "={{ $('Pedido completo').item.json }}",
"options": {}
},
"type": "n8n-nodes-base.respondToWebhook",
"typeVersion": 1.4,
"position": [
6896,
3312
],
"id": "3eb4b8c3-2b7f-461b-8646-816005dc5cf4",
"name": "Respuesta ok pedido"
},
{
"parameters": {
"jsCode": "// Loop over input items and add a new field called 'myNewField' to the JSON of each one\nlet items =$('Componer request').first().json.pedido.productos.map( det => ({\n ...det,\n idPedido: $input.first().json.data.insertId,\n}))\nreturn items;"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
2352,
3936
],
"id": "a7721dd4-ebf1-4edc-9280-7ef5ef607969",
"name": "Mapear detalle"
},
{
"parameters": {
"jsCode": "let pedido = $input.first().json.body\n\nlet consulta = `select nit, razonsocial, idsuc sucursal, idformapago, telefono1, direccion1, departamento, ciudad from matercerosuc WHERE nit = '` + pedido.nit + \"'\"\nreturn { consulta, pedido }\n"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
-1104,
4304
],
"id": "093b0481-0197-4b5a-84f1-5dfc8ed78f79",
"name": "Mapear pedido"
},
{
"parameters": {
"jsCode": "const consulta = \"select idvendedor from mavendedores where email ='\" + $input.first().json.email + \"'\"\n\nreturn {consulta, vendedor: $input.first().json };"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
-176,
3856
],
"id": "805114b2-cdcc-43af-a936-1b03e5c3285a",
"name": "QueryVendedor"
},
{
"parameters": {
"url": "=https://ws.dsnube.co/api/v1/consultasql?consulta={{ $json.consulta }}",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth",
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
80,
4048
],
"id": "f508b905-eb14-4063-b04c-67248e13ee62",
"name": "Get vendedor id",
"credentials": {
"httpBasicAuth": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"jsCode": "\nreturn { idVendedor: $input.first().json.result[0].idvendedor };"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
368,
4112
],
"id": "c13d0a75-c01f-4b26-b9cf-fa0f91cb6c3a",
"name": "Mapear id vendedor"
},
{
"parameters": {
"mode": "combine",
"combineBy": "combineByPosition",
"options": {}
},
"type": "n8n-nodes-base.merge",
"typeVersion": 3.2,
"position": [
640,
3808
],
"id": "1575901c-a9af-4cff-b376-c393c62a3fe9",
"name": "Componer vendedor info"
},
{
"parameters": {
"options": {
"responseCode": 401
}
},
"type": "n8n-nodes-base.respondToWebhook",
"typeVersion": 1.4,
"position": [
1824,
3184
],
"id": "a92a1cc9-5166-4ff9-8ebf-1e3153863a24",
"name": "No Authorizado"
},
{
"parameters": {
"workflowId": {
"__rl": true,
"value": "lbbPigwzL1zoCCVG",
"mode": "id"
},
"workflowInputs": {
"mappingMode": "defineBelow",
"value": {},
"matchingColumns": [],
"schema": [],
"attemptToConvertTypes": false,
"convertFieldsToString": true
},
"options": {
"waitForSubWorkflow": true
}
},
"type": "n8n-nodes-base.executeWorkflow",
"typeVersion": 1.2,
"position": [
-1280,
3344
],
"id": "5830b32e-9ca1-473b-bd94-86a35b15b6ce",
"name": "Call 'GetUserInfo'1",
"alwaysOutputData": false,
"onError": "continueRegularOutput"
},
{
"parameters": {
"jsCode": "let clienteNit = $('Buscar productos').first().json.query.clientenit \nlet sucursalId = $('Buscar productos').first().json.query.sucursalId\nconst search = $('Buscar productos').first().json.query.search\nlet consulta = `SELECT SP.idproducto AS \"C\u00f3digo\", mp.nombreproducto AS \"Producto\", Familia, Grupo, Marca, Modelo, SP.disponible AS \"Disponible\", SP.idunidad AS \"Unidad\", CASE ( SELECT listaprecios FROM matercerosuc WHERE nit = '900339960' AND idsuc = '1' LIMIT 1 ) WHEN 1 THEN mp.lista1 WHEN 2 THEN mp.lista2 WHEN 3 THEN mp.lista3 WHEN 4 THEN mp.lista4 WHEN 5 THEN mp.lista5 WHEN 6 THEN mp.lista6 ELSE NULL END AS \"Precio\", imp.porcentaje, imp.codimp FROM SPSALDOSINVENTARIO (CURRENT_DATE,'N','','','S','JCORTES') SP INNER JOIN maproductos mp ON SP.idproducto = mp.idproducto INNER JOIN vpareto_producto ON SP.idproducto = vpareto_producto.idproducto INNER JOIN maperfilproducto pf ON mp.idperfil = pf.idperfil INNER JOIN maimpuestos imp ON imp.codimp = pf.ivaventa WHERE SP.SALDO > 0 AND mp.activo = 'S'AND SP.idbodega = '1'`\nif(search) {\n consulta += `AND SP.idproducto like '${search.toUpperCase()}%'` \n}\n\nconsulta += ` ORDER BY 1, 2`\n\nreturn ({ clienteNit, sucursalId, consulta, search }) "
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
-528,
3056
],
"id": "94aa67db-6086-4670-bf6a-bce86c2f595f",
"name": "Extraer cliente y sucursal"
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "a6cc6f6f-fdef-4d1e-9279-8668dcd46ebc",
"leftValue": "={{ $json.error }}",
"rightValue": "",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
-832,
2832
],
"id": "081a4728-c3d2-4688-a526-e7c5ec2877fc",
"name": "Hay error1"
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "a6cc6f6f-fdef-4d1e-9279-8668dcd46ebc",
"leftValue": "={{ $json.error }}",
"rightValue": "",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
-816,
3712
],
"id": "dc0708fa-123c-4991-9faf-649e7eeb968a",
"name": "If1"
},
{
"parameters": {
"workflowId": {
"__rl": true,
"value": "lbbPigwzL1zoCCVG",
"mode": "id"
},
"workflowInputs": {
"mappingMode": "defineBelow",
"value": {},
"matchingColumns": [],
"schema": [],
"attemptToConvertTypes": false,
"convertFieldsToString": true
},
"options": {
"waitForSubWorkflow": true
}
},
"type": "n8n-nodes-base.executeWorkflow",
"typeVersion": 1.2,
"position": [
-1232,
3728
],
"id": "3b2d4672-516e-4454-946c-a343935035a7",
"name": "Call 'GetUserInfo'2",
"alwaysOutputData": false,
"onError": "continueRegularOutput"
},
{
"parameters": {
"httpMethod": "=OPTIONS",
"path": "clientes",
"options": {
"allowedOrigins": "https://pedidos.trimon.co,https://go-pedidos.trimon.co,http://localhost:5173"
}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
-1392,
2576
],
"id": "93cc3160-ea00-47d3-a13a-849d838b4690",
"name": "Buscar clientes options"
},
{
"parameters": {
"mode": "combine",
"combineBy": "combineByPosition",
"options": {}
},
"type": "n8n-nodes-base.merge",
"typeVersion": 3.2,
"position": [
1440,
4256
],
"id": "85a22bdd-383e-4070-b774-813904cf7a2e",
"name": "Componer request"
},
{
"parameters": {
"url": "=https://ws.dsnube.co/api/v1/consultasql?consulta={{ $json.consulta }}",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth",
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
3392,
4160
],
"id": "dca63da3-ff0f-4430-bba5-34c0c68ff290",
"name": "GET Products1",
"credentials": {
"httpBasicAuth": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"jsCode": "\nreturn {\n vendedor: {\n ...$input.first().json.vendedor,\n idVendedor: $input.first().json.idVendedor,\n }\n};"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
1024,
3856
],
"id": "cf5c83c3-7a66-4189-ba4a-f7831b62ebb5",
"name": "Mapear vendedor"
},
{
"parameters": {
"url": "=https://ws.dsnube.co/api/v1/consultasql?consulta={{ $json.consulta }}",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth",
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
-592,
4048
],
"id": "4a297b36-738e-4248-8483-779e8ed3441d",
"name": "Get Sucursal info",
"credentials": {
"httpBasicAuth": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"jsCode": "let pedido = $('Mapear pedido').first().json.pedido\nlet sucursal = $input.first().json.result[0]\n\nreturn { pedido, sucursal };"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
384,
4656
],
"id": "79b75c92-66d6-429c-9a30-a5f9e984dcf7",
"name": "Componer pedido y sucursal"
},
{
"parameters": {
"jsCode": "const pedidoId = $('Insertar pedido en la tabla').first().json.data.insertId\nconst items = $input.all().map(det => det.json)\nconst { vendedor, pedido, sucursal } = $('Componer request').first().json\nconst errorInventario = items.filter(item => item.item.cantidad > item.item.disponible)\nreturn {\n vendedor,\n pedido: {\n ...pedido,\n items,\n id: pedidoId,\n errorInventario\n },\n sucursal,\n}"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
3024,
3360
],
"id": "c74503a1-b102-4b81-81e2-b333a4289e97",
"name": "Pedido completo"
},
{
"parameters": {
"jsCode": "const { cantidad, idProducto, idPedido } = $input.first().json\n\nlet consulta = ` SELECT SP.idproducto AS \"C\u00f3digo\", mp.nombreproducto AS \"Producto\", Familia, Grupo, Marca, Modelo, SP.disponible AS \"Disponible\", SP.idunidad, SP.idbodega, CASE ( SELECT listaprecios FROM matercerosuc WHERE nit = '` + $('Componer pedido y sucursal').first().json.sucursal.nit +`' AND idsuc = `+ $('Componer pedido y sucursal').first().json.sucursal.sucursal +` LIMIT 1 ) WHEN 1 THEN mp.lista1 WHEN 2 THEN mp.lista2 WHEN 3 THEN mp.lista3 WHEN 4 THEN mp.lista4 WHEN 5 THEN mp.lista5 WHEN 6 THEN mp.lista6 ELSE NULL END AS \"Precio\", imp.porcentaje, imp.codimp FROM SPSALDOSINVENTARIO (CURRENT_DATE,'N','','','S','JCORTES') SP INNER JOIN maproductos mp ON SP.idproducto = mp.idproducto INNER JOIN vpareto_producto ON SP.idproducto = vpareto_producto.idproducto INNER JOIN maperfilproducto pf ON mp.idperfil = pf.idperfil INNER JOIN maimpuestos imp ON imp.codimp = pf.ivaventa WHERE SP.SALDO > 0 AND mp.activo = 'S'AND SP.idbodega = '1' AND SP.idproducto = '` + idProducto +`' ORDER BY 1, 2 ` \n\nreturn {consulta, cantidad, idProducto, idPedido};"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
3120,
3856
],
"id": "3471129d-0974-4b20-9c36-ddffacfabb8d",
"name": "item de pedido"
},
{
"parameters": {
"jsCode": "let detailInfo = $input.first().json.result[0]\nlet item = $('Get product info').first().json\nitem.porcentajeImpuesto = detailInfo.porcentaje\nitem.precio = detailInfo.Precio\nitem.subtotal = item.precio * item.cantidad\nitem.neto = item.subtotal\nitem.iva = item.neto * item.porcentajeImpuesto / 100\nitem.codigoImpuesto = detailInfo.codimp\nitem.idPedido = $('Insertar pedido en la tabla').first().json.data.insertId\nitem.disponible = detailInfo.Disponible\nitem.valorBruto = item.neto + item.iva\n\nreturn { item, detailInfo };"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
3632,
3856
],
"id": "8f7b4d57-f0c2-456a-8a14-12b8e8696c3a",
"name": "item y detalle info"
},
{
"parameters": {
"options": {}
},
"type": "n8n-nodes-base.splitInBatches",
"typeVersion": 3,
"position": [
2800,
3760
],
"id": "cded059e-1ad6-44f7-9fa5-2da0fe424e48",
"name": "Get product info"
},
{
"parameters": {
"table": {
"__rl": true,
"value": "detalle_pedido",
"mode": "list",
"cachedResultName": "detalle_pedido"
},
"dataMode": "defineBelow",
"valuesToSend": {
"values": [
{
"column": "pedido_id",
"value": "={{ $input.first().json.item.idPedido }}"
},
{
"column": "id_producto",
"value": "={{ $input.first().json.item.idProducto }}"
},
{
"column": "id_unidad",
"value": "={{ $input.first().json.detailInfo.idunidad }}"
},
{
"column": "unidad",
"value": "={{ $input.first().json.item.cantidad }}"
}
]
},
"options": {
"detailedOutput": true
}
},
"type": "n8n-nodes-base.mySql",
"typeVersion": 2.5,
"position": [
3808,
4112
],
"id": "bb2dc519-2cd4-460c-93f0-7e895e98ad1a",
"name": "Insertar detalle pedido en la tabla1",
"credentials": {
"mySql": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"jsCode": "const itemId = $input.first().json.data.insertId\nconst item = {...$('item y detalle info').first().json.item, id: itemId}\nconst info = $('item y detalle info').first().json.detailInfo\nreturn { item,info };"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
4000,
4304
],
"id": "1322f0a5-c2de-4b17-a4c4-6a55564ee160",
"name": "set detalle id"
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "a6cc6f6f-fdef-4d1e-9279-8668dcd46ebc",
"leftValue": "={{ $json.error }}",
"rightValue": "",
"operator": {
"type": "string",
"operation": "notExists",
"singleValue": true
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
-304,
2496
],
"id": "52502eac-5b24-4e09-a4e5-e6a4e457a1b6",
"name": "Sin error"
},
{
"parameters": {
"method": "POST",
"url": "=https://ws.dsnube.co/api/v1/pec",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth",
"sendBody": true,
"specifyBody": "json",
"jsonBody": "={{ JSON.stringify($input.first().json.erpPayload) }}",
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
4208,
3168
],
"id": "11ac6fc1-ff70-4c56-a964-a6b4c84c18c7",
"name": "POST pedido",
"credentials": {
"httpBasicAuth": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"url": "=https://ws.dsnube.co/api/v1/consultasql?consulta={{ $json.consulta }}",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth",
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
3680,
6016
],
"id": "fd3bf581-173e-4520-b5e2-3dd32e65f4bd",
"name": "HTTP Request1",
"credentials": {
"httpBasicAuth": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"respondWith": "allIncomingItems",
"options": {}
},
"type": "n8n-nodes-base.respondToWebhook",
"typeVersion": 1.4,
"position": [
4112,
5440
],
"id": "670655c6-1ca6-42e6-a2f6-a5b8f88fe8b4",
"name": "Respond to Webhook5"
},
{
"parameters": {
"jsCode": "let { fechaInicio, fechaFin } = $('Historial-pedidos').first().json.query\nconst idvendedor = $input.first().json.idVendedor\nconst consulta = \"select tr.fecha, tr.nit, tr.numero, tr.estado, tr.total, ma.razonsocial from trotrosdocinv tr inner join materceros ma on tr.nit = ma.nit where prefijo = 'PEV' and idvendedor = '\"+idvendedor+\"' and fecha BETWEEN '\"+fechaInicio+\"' and '\"+fechaFin+\"' order by 1 desc, nit, numero\"\nreturn { consulta };"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
3344,
5904
],
"id": "d5305d11-bdc2-41dd-ad1a-4641d0f51b8c",
"name": "Code in JavaScript1"
},
{
"parameters": {
"workflowId": {
"__rl": true,
"value": "lbbPigwzL1zoCCVG",
"mode": "id"
},
"workflowInputs": {
"mappingMode": "defineBelow",
"value": {},
"matchingColumns": [],
"schema": [],
"attemptToConvertTypes": false,
"convertFieldsToString": true
},
"options": {
"waitForSubWorkflow": true
}
},
"type": "n8n-nodes-base.executeWorkflow",
"typeVersion": 1.2,
"position": [
-944,
5040
],
"id": "b55fb67f-6146-47e4-b631-e78564d80179",
"name": "Call 'GetUserInfo'4",
"alwaysOutputData": false,
"onError": "continueRegularOutput"
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "a6cc6f6f-fdef-4d1e-9279-8668dcd46ebc",
"leftValue": "={{ $json.error }}",
"rightValue": "",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
-16,
5296
],
"id": "6415544f-bff0-45a9-985e-52dc3ab1d673",
"name": "If2"
},
{
"parameters": {
"options": {
"responseCode": 401
}
},
"type": "n8n-nodes-base.respondToWebhook",
"typeVersion": 1.4,
"position": [
1632,
5168
],
"id": "70266157-29f4-4e5f-a762-aaf760e03fdd",
"name": "No Authorizado1"
},
{
"parameters": {
"jsCode": "const consulta = \"select idvendedor from mavendedores where email ='\" + $input.first().json.email + \"'\"\n\nreturn {consulta};"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
1248,
5904
],
"id": "5d148e5c-95a8-4520-9c02-d51b25e8012c",
"name": "QueryVendedor1"
},
{
"parameters": {
"url": "=https://ws.dsnube.co/api/v1/consultasql?consulta={{ $json.consulta }}",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth",
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
2000,
6112
],
"id": "2167bbf9-218a-4c6e-a81a-d1bfc84e9312",
"name": "Get vendedor id1",
"credentials": {
"httpBasicAuth": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"jsCode": "\nreturn {idVendedor: $input.first().json.result[0].idvendedor};"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
2688,
6128
],
"id": "55022f53-361f-4b2f-a246-511651b8dd77",
"name": "Mapear id vendedor1"
},
{
"parameters": {
"mode": "combine",
"combineBy": "combineAll",
"options": {}
},
"type": "n8n-nodes-base.merge",
"typeVersion": 3.2,
"position": [
3136,
6096
],
"id": "fa54661b-80a0-4cb0-b1c8-f528d09bbf8e",
"name": "Componer vendedor info1"
},
{
"parameters": {
"jsCode": "const pedidos = $input.first().json.result.map(pedido => {\n const nuevoPedido = {\n nit: pedido.nit,\n id: pedido.numero,\n estado: pedido.estado,\n total: pedido.total,\n cliente: pedido.razonsocial,\n fecha: pedido.fecha.substring(0, 10),\n }\n return nuevoPedido\n})\nreturn pedidos"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
3824,
5760
],
"id": "982a23e7-0bea-492b-90c6-2788ce599a2f",
"name": "Code in JavaScript3"
},
{
"parameters": {
"path": "pedidos",
"responseMode": "responseNode",
"options": {
"allowedOrigins": "https://pedidos.trimon.co,https://go-pedidos.trimon.co,http://localhost:5173"
}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2.1,
"position": [
-1760,
4832
],
"id": "2a2f8aa7-8247-4edd-9c7e-d95b71afa40b",
"name": "Historial-pedidos"
},
{
"parameters": {
"mailagent": "74347d727301a3de",
"fromaddress": {
"address": "info@trimon.co"
},
"toaddress": "santiagopenasierra@gmail.com,gabrielsimpsons@gmail.com",
"subject": "=Vendedor: {{$('Mapear vendedor').first().json.vendedor.displayName }} Orden de compra: {{ $('Pedido completo').item.json.pedido.id }}",
"htmlbody": "={{ $json.html }}",
"cc": "monicasierrar@gmail.com",
"attachment": {}
},
"type": "n8n-nodes-zohozeptomail.zohoZeptomail",
"typeVersion": 1,
"position": [
6176,
3584
],
"id": "d28e8615-7ece-4666-b256-279a2b7895f9",
"name": "Send Mail",
"credentials": {
"zohoZeptomailOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {},
"type": "n8n-nodes-base.merge",
"typeVersion": 3.2,
"position": [
6480,
3344
],
"id": "09d656e8-a010-4ed5-b7e4-006565befe87",
"name": "Merge"
},
{
"parameters": {
"html": "<!DOCTYPE html>\n<html lang=\"es\">\n<head>\n <meta charset=\"UTF-8\">\n <title>Orden de Pedido</title>\n <style>\n body {\n font-family: Arial, sans-serif;\n margin: 0;\n padding: 0;\n background: #f5f5f5;\n }\n .container {\n width: 90%;\n max-width: 800px;\n margin: 20px auto;\n background: #fff;\n padding: 20px;\n border: 1px solid #ddd;\n }\n .header {\n margin-bottom: 20px;\n }\n .header-table {\n width: 100%;\n }\n .header-table td {\n vertical-align: top;\n padding: 5px;\n }\n .header img {\n max-width: 120px;\n }\n .header-info {\n text-align: right;\n font-size: 14px;\n line-height: 1.3;\n color: #444;\n }\n .section {\n margin-bottom: 20px;\n }\n .section h2 {\n font-size: 16px;\n border-bottom: 1px solid #ddd;\n padding-bottom: 5px;\n margin-bottom: 10px;\n color: #444;\n }\n .section p {\n line-height: 1.4;\n margin: 2px 0;\n font-size: 14px;\n }\n table {\n width: 100%;\n border-collapse: collapse;\n font-size: 14px;\n }\n th, td {\n border: 1px solid #ddd;\n padding: 6px;\n text-align: center;\n }\n th {\n background: #f0f0f0;\n font-weight: bold;\n }\n .totales {\n margin-top: 20px;\n width: 100%;\n }\n .totales td {\n padding: 6px;\n }\n .totales .label {\n text-align: right;\n font-weight: bold;\n background: #f9f9f9;\n }\n .totales .value {\n text-align: right;\n }\n .footer {\n margin-top: 30px;\n font-size: 12px;\n color: #777;\n text-align: center;\n }\n </style>\n</head>\n<body>\n <div class=\"container\">\n <!-- Encabezado con logo y datos -->\n <div class=\"header\">\n <table class=\"header-table\">\n <tr>\n <td>\n <!-- Logo dummy -->\n <img src=\"https://pedidos.trimon.co/assets/logo-BkBSmhWf.png\" alt=\"Logo Empresa\">\n </td>\n <td class=\"header-info\">\n <strong>BTRES S.A.S</strong><br>\n NIT: 900.587.306-2<br>\n CLL 68 N\u00b087-40<br>\n BOGOTA DC - BOGOTA<br>\n PBX: 4370408 / 9260050 CEL: 317 501 26 42<br>\n www.trimon.co<br>\n Email: Contabilidad@trimon.co\n </td>\n </tr>\n </table>\n <hr>\n <h1 style=\"text-align:center; margin:10px 0;\">Orden de Pedido</h1>\n <p style=\"text-align:center; margin:2px 0;\"><strong>No. Pedido:</strong>{{ $('Pedido completo').item.json.pedido.id }}</p>\n <p style=\"text-align:center; margin:2px 0;\"><strong>Fecha:</strong> {{ $now.format('yyyy-MM-dd') }}</p>\n </div>\n\n <!-- Cliente -->\n <div class=\"section\">\n <h2>Datos del Cliente</h2>\n <p><strong>Raz\u00f3n Social:</strong>{{ $('Pedido completo').item.json.sucursal.razonsocial }}</p>\n <p><strong>NIT:</strong> {{ $('Pedido completo').item.json.sucursal.nit }}</p>\n <p><strong>Sucursal:</strong> {{ $('Pedido completo').item.json.sucursal.sucursal }}</p>\n <p><strong>Direcci\u00f3n:</strong> {{ $('Pedido completo').item.json.sucursal.direccion1 }}, {{ $('Pedido completo').item.json.sucursal.ciudad }}, {{ $('Pedido completo').item.json.sucursal.departamento }}</p>\n </div>\n\n <!-- Productos -->\n <div class=\"section\">\n <h2>Detalle de Productos</h2>\n <table>\n <thead>\n <tr>\n <th>C\u00f3digo</th>\n <th>Cantidad</th>\n <th>Unidad</th>\n <th>Precio Unitario</th>\n <th>Subtotal</th>\n <th>IVA</th>\n <th>Total</th>\n </tr>\n </thead>\n <tbody>\n {{ $json.itemsHtml }}\n </tbody>\n </table>\n </div>\n\n <!-- Totales -->\n <div class=\"section\">\n <h2>Totales</h2>\n <table class=\"totales\">\n <tr>\n <td class=\"label\">Subtotal:</td>\n <td class=\"value\">{{ $json.subtotal.toLocaleString('es-CO', {\n style: 'currency',\n currency: 'COP',\n minimumFractionDigits: 0, // Colombian Peso is often displayed without cents\n maximumFractionDigits: 0\n}) }}</td>\n </tr>\n <tr>\n <td class=\"label\">IVA:</td>\n <td class=\"value\">{{ $json.iva.toLocaleString('es-CO', {\n style: 'currency',\n currency: 'COP',\n minimumFractionDigits: 0, // Colombian Peso is often displayed without cents\n maximumFractionDigits: 0\n}) }}</td>\n </tr>\n <tr>\n <td class=\"label\">Total a Pagar:</td>\n <td class=\"value\"><strong>{{ $json.total.toLocaleString('es-CO', {\n style: 'currency',\n currency: 'COP',\n minimumFractionDigits: 0, // Colombian Peso is often displayed without cents\n maximumFractionDigits: 0\n}) }}</strong></td>\n </tr>\n </table>\n </div>\n\n <!-- Comentarios -->\n <div class=\"section\">\n <h2>Comentarios</h2>\n <p>Comentarios pruebas pedido</p>\n </div>\n\n <!-- Pie -->\n <div class=\"footer\">\n <p>Este documento es generado electr\u00f3nicamente y no requiere firma.</p>\n </div>\n </div>\n</body>\n</html>\n\n"
},
"type": "n8n-nodes-base.html",
"typeVersion": 1.2,
"position": [
5632,
3520
],
"id": "35d274b7-3027-476a-84f3-d9e8ced3f9b8",
"name": "HTML"
},
{
"parameters": {
"jsCode": "\nconst code = $input.first().json.query.code\nreturn { code, redirectUrl: \"https://pedidos-api.trimon.co/webhook/authorize\" };"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
480,
320
],
"id": "41109aa1-c005-4798-b937-c37a04e44491",
"name": "Code"
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "aadb05bb-87cc-4dad-a992-4bcbc819e0ab",
"leftValue": "={{ $json.error }}",
"rightValue": "",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
1056,
192
],
"id": "fd215886-ef97-40b8-8866-d532c06f0703",
"name": "error"
},
{
"parameters": {
"jsCode": "const accessToken = $input.first().json.access_token;\nconst expiresIn = $input.first().json.expires_in;\n\nreturn { accessToken, expiresIn }"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
1408,
352
],
"id": "883dbe28-1a29-4d32-af22-b375ad8e84a7",
"name": "Code1"
},
{
"parameters": {
"jsCode": "const error = $input.first().json.error\nreturn { error };"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
1536,
128
],
"id": "127c9b9c-5d77-47f5-95e6-b59eea92a3ac",
"name": "Code3"
},
{
"parameters": {
"path": "authorize",
"responseMode": "responseNode",
"options": {
"allowedOrigins": "https://pedidos.trimon.co,http://localhost:5173"
}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
48,
368
],
"id": "cb176cea-f86a-466a-9bda-943942340d9c",
"name": "Authorize code"
},
{
"parameters": {
"httpMethod": "=OPTIONS",
"path": "authorize",
"responseMode": "lastNode",
"options": {
"allowedOrigins": "https://pedidos.trimon.co"
}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
48,
208
],
"id": "19637da6-a07c-4112-831d-151c934ddb19",
"name": "Authorize code options"
},
{
"parameters": {
"method": "POST",
"url": "https://accounts.zoho.com/oauth/v2/token",
"sendBody": true,
"contentType": "form-urlencoded",
"bodyParameters": {
"parameters": [
{
"name": "code",
"value": "={{ $json.code }}"
},
{
"name": "grant_type",
"value": "authorization_code"
},
{
"name": "client_id",
"value": "1000.5U8I460UG3WLLU85J5GLAKUDXLN9WZ"
},
{
"name": "client_secret",
"value": "45a9b1dfc9b716ff3912a2be813b9fb18440256f01"
},
{
"name": "redirect_uri",
"value": "=https://pedidos-api.trimon.co/webhook/authorize"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
784,
320
],
"id": "7197e3c2-e586-46bf-b114-a46ad390d258",
"name": "Get token"
},
{
"parameters": {
"path": "user-info",
"responseMode": "responseNode",
"options": {
"allowedOrigins": "https://pedidos.trimon.co,http://localhost:5173"
}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
160,
752
],
"id": "7decd825-6db8-4732-8e97-e4c5f562c1e8",
"name": "User info"
},
{
"parameters": {
"jsCode": "const { firstName, email, lastName, displayName } = $input.first().json\nreturn {\n firstName,\n email,\n lastName,\n displayName\n}"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
1360,
784
],
"id": "21205ccb-fd39-4e08-9b3d-e13265285248",
"name": "Code6"
},
{
"parameters": {
"httpMethod": "=OPTIONS",
"path": "user-info",
"responseMode": "lastNode",
"options": {
"allowedOrigins": "https://pedidos.trimon.co"
}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
160,
880
],
"id": "09c7b03f-d057-4278-a176-d44c113589cf",
"name": "User info options"
},
{
"parameters": {
"respondWith": "redirect",
"redirectURL": "=https://pedidos.trimon.co/auth/callback?access_token={{ $json.accessToken }}&expires_in={{ $json.expiresIn }}",
"options": {
"responseCode": 302
}
},
"type": "n8n-nodes-base.respondToWebhook",
"typeVersion": 1.4,
"position": [
1616,
432
],
"id": "c754c4ce-4b8f-4872-88f5-e0bf701d5b91",
"name": "Respond to Webhook3"
},
{
"parameters": {
"respondWith": "redirect",
"redirectURL": "https://pedidos.trimon.co/",
"options": {}
},
"type": "n8n-nodes-base.respondToWebhook",
"typeVersion": 1.4,
"position": [
1712,
80
],
"id": "f1698d71-2fa2-4da0-a5bf-ebff2acaa8cf",
"name": "Respond to Webhook4"
},
{
"parameters": {
"content": "## Auth0",
"height": 1120,
"width": 1968
},
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
0
],
"typeVersion": 1,
"id": "765322ae-ad36-4837-a888-4142ae3394a6",
"name": "Sticky Note1"
},
{
"parameters": {
"workflowId": {
"__rl": true,
"value": "lbbPigwzL1zoCCVG",
"mode": "id"
},
"workflowInputs": {
"mappingMode": "defineBelow",
"value": {},
"matchingColumns": [],
"schema": [],
"attemptToConvertTypes": false,
"convertFieldsToString": true
},
"options": {
"waitForSubWorkflow": true
}
},
"type": "n8n-nodes-base.executeWorkflow",
"typeVersion": 1.2,
"position": [
448,
656
],
"id": "7dbb9d65-a55d-42de-a86c-f66fed92600f",
"name": "Call 'GetUserInfo'3",
"alwaysOutputData": false
},
{
"parameters": {
"options": {
"responseCode": 401
}
},
"type": "n8n-nodes-base.respondToWebhook",
"typeVersion": 1.4,
"position": [
1184,
480
],
"id": "cd198899-b430-4620-b2be-a3c7156d2bc3",
"name": "Respond to Webhook2"
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "a6cc6f6f-fdef-4d1e-9279-8668dcd46ebc",
"leftValue": "={{ $json.error }}",
"rightValue": "",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
976,
576
],
"id": "e1747213-f86c-4dcd-9dbe-f32af54103da",
"name": "Hay error2"
},
{
"parameters": {
"path": "rest/oauth2-credential/callback",
"responseMode": "responseNode",
"options": {
"allowedOrigins": "https://pedidos.trimon.co"
}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
48,
560
],
"id": "3b72881a-71ae-409e-aa24-3a4012be4d8f",
"name": "Authorize code1"
},
{
"parameters": {
"table": {
"__rl": true,
"value": "pedido",
"mode": "list",
"cachedResultName": "pedido"
},
"dataMode": "defineBelow",
"valuesToSend": {
"values": [
{
"column": "id_estado",
"value": "=1"
},
{
"column": "nit",
"value": "={{ $json.sucursal.nit }}"
},
{
"column": "formaPagoId",
"value": "=1"
},
{
"column": "sucursal",
"value": "={{ JSON.stringify($json.sucursal) }}"
},
{
"column": "email_vendedor",
"value": "={{ $json.vendedor.email }}"
},
{
"column": "id_vendedor",
"value": "={{ $json.vendedor.idVendedor }}"
},
{
"column": "comentario",
"value": "={{ $json.pedido.comentarios }}"
}
]
},
"options": {
"detailedOutput": true
}
},
"type": "n8n-nodes-base.mySql",
"typeVersion": 2.5,
"position": [
992,
8624
],
"id": "585c9fcb-7e91-4dd9-80a2-958f77671a02",
"name": "Insertar pedido en la tabla1",
"credentials": {
"mySql": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"jsCode": "const items = $('Pedido completo').first().json.pedido.items\n\nlet subtotal = 0\nlet iva = 0\nlet total = 0\nlet itemsHtml = ``\nfor(const item of items) {\n itemsHtml += `\n <tr>\n <td>${item.item.idProducto}</td>\n <td>${item.item.cantidad}</td>\n <td>${item.info.idunidad}</td>\n <td>$${item.item.precio.toLocaleString('es-CO', {\n style: 'currency',\n currency: 'COP',\n minimumFractionDigits: 0, // Colombian Peso is often displayed without cents\n maximumFractionDigits: 0\n}) }</td>\n <td>$${item.item.subtotal.toLocaleString('es-CO', {\n style: 'currency',\n currency: 'COP',\n minimumFractionDigits: 0, // Colombian Peso is often displayed without cents\n maximumFractionDigits: 0\n}) }</td>\n <td>$${item.item.iva.toLocaleString('es-CO', {\n style: 'currency',\n currency: 'COP',\n minimumFractionDigits: 0, // Colombian Peso is often displayed without cents\n maximumFractionDigits: 0\n}) }</td>\n <td>$${item.item.valorBruto.toLocaleString('es-CO', {\n style: 'currency',\n currency: 'COP',\n minimumFractionDigits: 0, // Colombian Peso is often displayed without cents\n maximumFractionDigits: 0\n}) }</td>\n </tr>\n `\n subtotal += item.item.subtotal\n iva += item.item.iva\n total += item.item.valorBruto\n \n}\n\nreturn [{\n itemsHtml, iva, subtotal, total\n}]"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
5296,
3472
],
"id": "db882148-0267-4bac-8d86-e8ff8fd9f87f",
"name": "Preparar items de factura"
},
{
"parameters": {
"jsCode": "const search = $('Buscar clientes').first().json.query.search\n\nlet consulta = `select nit,razonsocial,idsuc sucursal,idformapago,telefono1,direccion1,departamento,ciudad from matercerosuc`\nif(search ) {\n consulta += ` where razonsocial like '${search.toUpperCase()}%'` \n}\nconsulta += ` order by razonsocial`\nreturn {\n consulta,\n search\n};"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
80,
2352
],
"id": "377beb56-e9d8-4a2b-b189-d2893971997c",
"name": "extraer parametros"
},
{
"parameters": {
"workflowId": {
"__rl": true,
"value": "lbbPigwzL1zoCCVG",
"mode": "id"
},
"workflowInputs": {
"mappingMode": "defineBelow",
"value": {},
"matchingColumns": [],
"schema": [],
"attemptToConvertTypes": false,
"convertFieldsToString": true
},
"options": {
"waitForSubWorkflow": true
}
},
"type": "n8n-nodes-base.executeWorkflow",
"typeVersion": 1.2,
"position": [
-944,
2576
],
"id": "84df88c8-9775-4fa4-b316-221d8457c6ec",
"name": "Call 'Get user info'",
"alwaysOutputData": false,
"onError": "continueRegularOutput"
},
{
"parameters": {
"httpMethod": "=OPTIONS",
"path": "pedidos",
"responseMode": "responseNode",
"options": {
"allowedOrigins": "https://pedidos.trimon.co,https://go-pedidos.trimon.co,http://localhost:5173"
}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2.1,
"position": [
-1792,
5072
],
"id": "d42da6c8-4108-41e7-882f-638c3312712a",
"name": "Historial-pedidos1"
},
{
"parameters": {
"path": "transacciones",
"responseMode": "responseNode",
"options": {
"allowedOrigins": "https://pedidos.trimon.co,https://go-pedidos.trimon.co,http://localhost:5173"
}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2.1,
"position": [
-1776,
5520
],
"id": "8e81902d-92d0-4820-9f2d-f000c02ab43f",
"name": "Webhook"
},
{
"parameters": {
"workflowId": {
"__rl": true,
"value": "lbbPigwzL1zoCCVG",
"mode": "id"
},
"workflowInputs": {
"mappingMode": "defineBelow",
"value": {},
"matchingColumns": [],
"schema": [],
"attemptToConvertTypes": false,
"convertFieldsToString": true
},
"options": {}
},
"type": "n8n-nodes-base.executeWorkflow",
"typeVersion": 1.2,
"position": [
-1472,
5504
],
"id": "47d9a151-1a66-4447-9b4c-45aa8fef81e8",
"name": "Call 'Get user info'1"
},
{
"parameters": {
"httpMethod": "=OPTIONS",
"path": "transacciones",
"options": {
"allowedOrigins": "https://pedidos.trimon.co,https://go-pedidos.trimon.co,http://localhost:5173"
}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2.1,
"position": [
-1744,
5760
],
"id": "a345b716-01f3-43a2-a8c2-e262307ad79c",
"name": "Webhook1"
},
{
"parameters": {
"respondWith": "json",
"responseBody": "{\n \"error\": \"fechaInicio o fechaFin no valida\"\n}",
"options": {}
},
"type": "n8n-nodes-base.respondToWebhook",
"typeVersion": 1.4,
"position": [
-448,
5376
],
"id": "fc395642-68bb-4fd5-bb50-8773ff060e8f",
"name": "Respond to Webhook6"
},
{
"parameters": {
"respondWith": "allIncomingItems",
"options": {}
},
"type": "n8n-nodes-base.respondToWebhook",
"typeVersion": 1.4,
"position": [
80,
5632
],
"id": "020a565d-2517-42c9-ab22-48b83120ef9e",
"name": "Respond to Webhook7",
"alwaysOutputData": true
},
{
"parameters": {
"jsCode": "const vendedorEmail = $input.first().json.email\nconst { fechaInicio, fechaFin } = $('Webhook').first().json.query\n\nreturn {\n vendedorEmail,\n fechaInicio,\n fechaFin,\n}"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
-1136,
5504
],
"id": "a4a479eb-ab06-48e3-891a-f940219e9ff8",
"name": "Mapear parametros"
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "a889d027-b69c-4b85-8835-dc9f80ed567f",
"leftValue": "={{ $json.fechaInicio }}",
"rightValue": "",
"operator": {
"type": "string",
"operation": "notExists",
"singleValue": true
}
},
{
"id": "090ca770-25a1-4b3b-99e0-79f6fcbbb650",
"leftValue": "={{ $json.fechaFin }}",
"rightValue": "",
"operator": {
"type": "string",
"operation": "notExists",
"singleValue": true
}
}
],
"combinator": "or"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
-832,
5488
],
"id": "058c90a0-fd1f-4194-addd-fbfea8f10ef9",
"name": "Validar parametros"
},
{
"parameters": {
"operation": "executeQuery",
"query": "SEL
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
httpBasicAuthmySqlzohoZeptomailOAuth2Api
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
How this works
This workflow streamlines order processing by automatically fetching client and product details via HTTP requests, mapping them with custom code, and sending tailored email confirmations through Zoho Zeptomail. It's ideal for e-commerce managers or small business owners handling inbound webhooks from order forms, saving hours on manual data entry and follow-ups. The key step involves the code nodes that transform raw API data into structured formats for seamless MySQL storage and personalised notifications.
Use this when integrating webhook-driven orders with Zoho for quick customer communications, especially in high-volume scenarios without complex AI needs. Avoid it for non-webhook triggers or if you require advanced analytics beyond basic mapping. Common variations include swapping MySQL for PostgreSQL or adding Slack alerts for internal order reviews.
About this workflow
v25.1.3. Uses httpRequest, mySql, n8n-nodes-zohozeptomail. Webhook trigger; 98 nodes.
Source: https://github.com/monicasierrar/trimon-pedidos-fe/blob/2bcd583c2ae7ea51a42286d616937afc7ecb7d33/n8n/v25.1.3.json — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
BP_check. Uses googleSheets, @n-octo-n/n8n-nodes-json-database, httpRequest, itemLists. Webhook trigger; 99 nodes.
Google Sheets, @N Octo N/N8N Nodes Json Database, HTTP Request +2
This workflow demonstrates how to export SQL to XML and present the data nicely formatted using an XSL Template.
MySQL, Item Lists, XML +2
Join Data From Postgres And Mysql. Uses mySql, httpRequest, postgres. Webhook trigger; 6 nodes.
MySQL, HTTP Request, Postgres
query data from two different databases handle and unify in a single return
MySQL, HTTP Request, Postgres
This template automates sending a DingTalk message on new Azure Dev Ops Pull Request Created Events. It uses a MySQL database to store mappings between Azure users and DingTalk users; so the right use
MySQL, HTTP Request