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": "Syscom \u279c Odoo 17 Sync (con im\u00e1genes)",
"active": false,
"nodes": [
{
"id": 1,
"name": "Manual Trigger",
"type": "n8n-nodes-base.manualTrigger",
"typeVersion": 1,
"position": [
100,
200
]
},
{
"id": 2,
"name": "Get Syscom Token",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 2,
"position": [
300,
200
],
"parameters": {
"url": "https://developers.syscom.mx/oauth/token",
"method": "POST",
"contentType": "form-urlencoded",
"sendBody": true,
"bodyParameters": {
"parameters": [
{
"name": "client_id",
"value": "={{$env.SYSCOM_CLIENT_ID}}"
},
{
"name": "client_secret",
"value": "={{$env.SYSCOM_CLIENT_SECRET}}"
},
{
"name": "grant_type",
"value": "client_credentials"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "Content-Type",
"value": "application/x-www-form-urlencoded"
}
]
}
}
},
{
"id": 3,
"name": "Init Page",
"type": "n8n-nodes-base.set",
"typeVersion": 2,
"position": [
500,
200
],
"parameters": {
"values": {
"number": [
{
"name": "page",
"value": 1
},
{
"name": "per_page",
"value": 2
}
]
}
}
},
{
"id": 4,
"name": "HTTP Syscom Products",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 2,
"position": [
700,
200
],
"parameters": {
"url": "https://developers.syscom.mx/api/v1/productos",
"method": "GET",
"sendQuery": true,
"queryParametersUi": {
"parameter": [
{
"name": "per_page",
"value": "={{$node[\"Init Page\"].json.per_page}}"
},
{
"name": "page",
"value": "={{$node[\"Init Page\"].json.page}}"
}
]
},
"sendHeaders": true,
"headerParametersUi": {
"parameter": [
{
"name": "Authorization",
"value": "=Bearer {{$node[\"Get Syscom Token\"].json.access_token}}"
}
]
}
}
},
{
"id": 5,
"name": "SplitInBatches",
"type": "n8n-nodes-base.splitInBatches",
"typeVersion": 1,
"position": [
900,
200
],
"parameters": {
"batchSize": 50
}
},
{
"id": 6,
"name": "HTTP Imagen",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 2,
"position": [
1100,
140
],
"parameters": {
"url": "={{$json.img_portada}}",
"responseFormat": "binary",
"dataPropertyName": "data"
}
},
{
"id": 7,
"name": "Binary \u2192 Base64",
"type": "n8n-nodes-base.moveBinaryData",
"typeVersion": 1,
"position": [
1100,
260
],
"parameters": {
"mode": "binaryToJson",
"sourceKey": "data",
"destinationKey": "data"
}
},
{
"id": 8,
"name": "Map Syscom \u279c Odoo",
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
1300,
200
],
"parameters": {
"mode": "runOnceForEachItem",
"functionCode": "// margen y cuentas contables\nconst GASTO = { CCTV:5101, INCENDIO:5102, POS:5103, ACCESO:5104, REDES:5105, AUDIOVIDEO:5106 };\nconst MARGEN = 0.7;\nreturn items.map(i => {\n const p = i.json;\n const costo = parseFloat(p.precios?.precio_descuento || 0);\n const venta = +(costo / MARGEN).toFixed(2);\n const fam = (p.familia || '').toUpperCase();\n return {\n json: {\n sku: p.sku || p.modelo,\n name: p.titulo,\n standard_price: costo,\n list_price: venta,\n qty_available: p.total_existencia,\n property_account_income_id: 4010102,\n property_account_expense_id: GASTO[fam] || 5100,\n unspsc_code: p.clave_unidad_sat,\n image_1920: i.json.data\n }\n };\n});"
}
},
{
"id": 9,
"name": "search_read",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 2,
"position": [
1500,
200
],
"parameters": {
"url": "https://{{$env.ODOO_DOMAIN}}/jsonrpc",
"method": "POST",
"sendHeaders": true,
"headerParametersUi": {
"parameter": [
{
"name": "Content-Type",
"value": "application/json"
},
{
"name": "X-Api-Key",
"value": "={{$credentials.ODOO_API_KEY}}"
}
]
},
"specifyBody": "json",
"jsonBody": "={\"jsonrpc\":\"2.0\",\"method\":\"call\",\"params\":{\"service\":\"object\",\"method\":\"execute_kw\",\"args\":[\"{{$env.ODOO_DB}}\",{{$env.ODOO_UID}},\"{{$credentials.ODOO_API_KEY}}\",\"product.template\",\"search_read\",[[[\"default_code\",\"=\",$json.sku]],[\"id\"]]]}}}"
}
},
{
"id": 10,
"name": "\u00bfExiste?",
"type": "n8n-nodes-base.if",
"typeVersion": 2,
"position": [
1700,
200
],
"parameters": {
"conditions": {
"number": [
{
"value1": "={{$json.result.length}}",
"operation": "largerEqual",
"value2": 1
}
]
}
}
},
{
"id": 11,
"name": "create",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 2,
"position": [
1900,
100
],
"parameters": {
"url": "https://{{$env.ODOO_DOMAIN}}/jsonrpc",
"method": "POST",
"sendHeaders": true,
"headerParametersUi": {
"parameter": [
{
"name": "Content-Type",
"value": "application/json"
},
{
"name": "X-Api-Key",
"value": "={{$credentials.ODOO_API_KEY}}"
}
]
},
"specifyBody": "json",
"jsonBody": "={\"jsonrpc\":\"2.0\",\"method\":\"call\",\"params\":{\"service\":\"object\",\"method\":\"execute_kw\",\"args\":[\"{{$env.ODOO_DB}}\",{{$env.ODOO_UID}},\"{{$credentials.ODOO_API_KEY}}\",\"product.template\",\"create\",[{$json}]]}}}"
}
},
{
"id": 12,
"name": "write",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 2,
"position": [
1900,
300
],
"parameters": {
"url": "https://{{$env.ODOO_DOMAIN}}/jsonrpc",
"method": "POST",
"sendHeaders": true,
"headerParametersUi": {
"parameter": [
{
"name": "Content-Type",
"value": "application/json"
},
{
"name": "X-Api-Key",
"value": "={{$credentials.ODOO_API_KEY}}"
}
]
},
"specifyBody": "json",
"jsonBody": "={\"jsonrpc\":\"2.0\",\"method\":\"call\",\"params\":{\"service\":\"object\",\"method\":\"execute_kw\",\"args\":[\"{{$env.ODOO_DB}}\",{{$env.ODOO_UID}},\"{{$credentials.ODOO_API_KEY}}\",\"product.template\",\"write\",[[$json.result[0].id],$json]]}}}"
}
},
{
"id": 13,
"name": "Next page?",
"type": "n8n-nodes-base.if",
"typeVersion": 2,
"position": [
900,
50
],
"parameters": {
"conditions": {
"number": [
{
"value1": "={{$node[\"HTTP Syscom Products\"].json.data.length}}",
"operation": "larger",
"value2": 0
}
]
}
}
},
{
"id": 14,
"name": "Inc page",
"type": "n8n-nodes-base.set",
"typeVersion": 2,
"position": [
700,
50
],
"parameters": {
"values": {
"number": [
{
"name": "page",
"value": "={{$node[\"Init Page\"].json.page + 1}}"
}
]
}
}
}
],
"connections": {
"Manual Trigger": {
"main": [
[
{
"node": "Get Syscom Token",
"type": "main",
"index": 0
}
]
]
},
"Get Syscom Token": {
"main": [
[
{
"node": "Init Page",
"type": "main",
"index": 0
}
]
]
},
"Init Page": {
"main": [
[
{
"node": "HTTP Syscom Products",
"type": "main",
"index": 0
}
]
]
},
"HTTP Syscom Products": {
"main": [
[
{
"node": "SplitInBatches",
"type": "main",
"index": 0
}
],
[
{
"node": "Next page?",
"type": "main",
"index": 1
}
]
]
},
"SplitInBatches": {
"main": [
[
{
"node": "HTTP Imagen",
"type": "main",
"index": 0
}
]
]
},
"HTTP Imagen": {
"main": [
[
{
"node": "Binary \u2192 Base64",
"type": "main",
"index": 0
}
]
]
},
"Binary \u2192 Base64": {
"main": [
[
{
"node": "Map Syscom \u279c Odoo",
"type": "main",
"index": 0
}
]
]
},
"Map Syscom \u279c Odoo": {
"main": [
[
{
"node": "search_read",
"type": "main",
"index": 0
}
]
]
},
"search_read": {
"main": [
[
{
"node": "\u00bfExiste?",
"type": "main",
"index": 0
}
]
]
},
"\u00bfExiste?": {
"main": [
[
{
"node": "write",
"type": "main",
"index": 0
}
],
[
{
"node": "create",
"type": "main",
"index": 1
}
]
]
},
"Next page?": {
"main": [
[
{
"node": "Inc page",
"type": "main",
"index": 0
}
]
]
},
"Inc page": {
"main": [
[
{
"node": "HTTP Syscom Products",
"type": "main",
"index": 0
}
]
]
}
}
}
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Syscom ➜ Odoo 17 Sync (con imágenes). Uses httpRequest, moveBinaryData. Event-driven trigger; 14 nodes.
Source: https://gist.github.com/pipsgdl/3530a2a5b130b3f597db60075b445e71 — 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.
This workflow illustrates how HTML reports can be created using Markdown Node. An example data consists of a Time Sheet table for 2 persons. Based on this table a markdown document is generated using
Item Lists, Email Send, HTTP Request +1
This workflow allows you to import any workflow from a file or another n8n instance and map the credentials easily. A multi-form setup guides you through the entire process At the beginning you have t
Execute Command, Read Write File, HTTP Request +3
[n8n] Advanced URL Parsing and Shortening Workflow - Switchy.io Integration. Uses splitInBatches, stickyNote, httpRequest, html. Event-driven trigger; 56 nodes.
HTTP Request, GitHub, Stop And Error +1
[](https://youtu.be/c7yCZhmMjtI)
HTTP Request, GitHub, Stop And Error +1
This automation organizes your n8n workflows files into categorizes (Active, Template, Done, Archived) and uploads them directly to a categorized Google Drive folders. It is designed to help users man
Google Drive, HTTP Request, Time Saved