Thanks for your help, much appreciated.
I had already exchanged some information about the situation I am facing and performed some tests recommended by @hoiyothaheem the other person kindly assisting in this thread. Yoy may find information of interest regarding my particular situation.
Regarding your questions:
- I will paste the workflows here below. They are the 2 workflows used as teaching material in n8n level one course.
- No execution was ever completed on my computer. I have run the longer one once on the computer of a colleague, sitting right across my table.
- The connection lost message appears even before executing any workflow.
Workflow 1:
{
“nodes”: [
{
“parameters”: {},
“type”: “n8n-nodes-base.manualTrigger”,
“typeVersion”: 1,
“position”: [
0,
0
],
“id”: “035cfd07-7c23-44d7-87ad-ec2cdb519ae5”,
“name”: “When clicking ‘Execute workflow’”
},
{
“parameters”: {
“resource”: “all”,
“limit”: 10,
“additionalFields”: {
“keyword”: “automation”
}
},
“type”: “n8n-nodes-base.hackerNews”,
“typeVersion”: 1,
“position”: [
208,
0
],
“id”: “1008ae60-72fe-47f7-b008-0f8d51478e7c”,
“name”: “Hacker News”,
“notesInFlow”: true
}
],
“connections”: {
“When clicking ‘Execute workflow’”: {
“main”: [
[
{
“node”: “Hacker News”,
“type”: “main”,
“index”: 0
}
]
]
}
},
“pinData”: {},
“meta”: {
“templateCredsSetupCompleted”: true,
“instanceId”: “f9c074921e5d594997f09c12157c527ad0a9d5e0695614601a2503db6e5f97f0”
}
}
Workflow 2 :
{
“nodes”: [
{
“parameters”: {
“url”: “https://learn.app.n8n.cloud/webhook/custom-erp”,
“authentication”: “genericCredentialType”,
“genericAuthType”: “httpHeaderAuth”,
“sendHeaders”: true,
“headerParameters”: {
“parameters”: [
{
“name”: “unique_id”,
“value”: “a49f98ff15279f652a023153a6f4fc00”
}
]
},
“options”: {}
},
“type”: “n8n-nodes-base.httpRequest”,
“typeVersion”: 4.3,
“position”: [
224,
0
],
“id”: “2fbf78f9-a49a-4ff0-bfe5-366e8ee3b655”,
“name”: “HTTP Request”,
“credentials”: {
“httpHeaderAuth”: {
“id”: “LYMa3Qrg2lPJvTVN”,
“name”: “Header Auth account”
}
}
},
{
“parameters”: {
“operation”: “create”,
“base”: {
“__rl”: true,
“value”: “appQfnjq5nWiK7oLb”,
“mode”: “list”,
“cachedResultName”: “n8n level 1 course”,
“cachedResultUrl”: “https://airtable.com/appQfnjq5nWiK7oLb”
},
“table”: {
“__rl”: true,
“value”: “tblrXK943C0kqp9CO”,
“mode”: “list”,
“cachedResultName”: “processingOrders”,
“cachedResultUrl”: “https://airtable.com/appQfnjq5nWiK7oLb/tblrXK943C0kqp9CO”
},
“columns”: {
“mappingMode”: “autoMapInputData”,
“value”: {},
“matchingColumns”: ,
“schema”: [
{
“id”: “orderID”,
“displayName”: “orderID”,
“required”: false,
“defaultMatch”: false,
“canBeUsedToMatch”: true,
“display”: true,
“type”: “number”,
“readOnly”: false,
“removed”: false
},
{
“id”: “employeeName”,
“displayName”: “employeeName”,
“required”: false,
“defaultMatch”: false,
“canBeUsedToMatch”: true,
“display”: true,
“type”: “string”,
“readOnly”: false,
“removed”: false
}
],
“attemptToConvertTypes”: false,
“convertFieldsToString”: false
},
“options”: {}
},
“type”: “n8n-nodes-base.airtable”,
“typeVersion”: 2.1,
“position”: [
880,
-128
],
“id”: “565c09aa-4089-4469-a5d7-2aada2a03427”,
“name”: “Create a record”,
“credentials”: {
“airtableTokenApi”: {
“id”: “EvLBK2GT3NzUeFsQ”,
“name”: “Airtable Personal Access Token account”
}
}
},
{
“parameters”: {
“conditions”: {
“options”: {
“caseSensitive”: true,
“leftValue”: “”,
“typeValidation”: “strict”,
“version”: 3
},
“conditions”: [
{
“id”: “7b7db419-9d44-4897-9349-337bc28a20a4”,
“leftValue”: “={{ $json.orderStatus }}”,
“rightValue”: “processing”,
“operator”: {
“type”: “string”,
“operation”: “equals”,
“name”: “filter.operator.equals”
}
}
],
“combinator”: “and”
},
“options”: {}
},
“type”: “n8n-nodes-base.if”,
“typeVersion”: 2.3,
“position”: [
448,
0
],
“id”: “78a32255-27fa-449b-afe3-346cb41adbc6”,
“name”: “If”
},
{
“parameters”: {
“assignments”: {
“assignments”: [
{
“id”: “0becb8a2-a3e7-4c36-9ce8-32a7349e4f38”,
“name”: “orderID”,
“value”: “={{ $json.orderID }}”,
“type”: “number”
},
{
“id”: “cb8f90c9-e4b2-4bdf-b759-f68a0d9d3724”,
“name”: “employeeName”,
“value”: “={{ $json.employeeName }}”,
“type”: “string”
}
]
},
“options”: {}
},
“type”: “n8n-nodes-base.set”,
“typeVersion”: 3.4,
“position”: [
672,
-128
],
“id”: “518124f1-811e-4f35-885e-6ff3c6123558”,
“name”: “Edit Fields”
},
{
“parameters”: {
“jsCode”: “let items = $input.all();\nlet totalBooked = items.length;\nlet bookedSum = 0;\n\nfor (let i=0; i < items.length; i++) {\n bookedSum = bookedSum + items[i].json.orderPrice;\n}\n\nreturn [{ json: {totalBooked, bookedSum} }];”
},
“type”: “n8n-nodes-base.code”,
“typeVersion”: 2,
“position”: [
656,
96
],
“id”: “29642ec0-f9f5-49c3-887b-1bb404d24dca”,
“name”: “Code in JavaScript”
},
{
“parameters”: {
“authentication”: “webhook”,
“content”: “=This week we’ve {{$json[“totalBooked”]}} booked orders with a total value of {{$json[“bookedSum”]}}. My Unique ID: {{ $(‘HTTP Request’).params[“headerParameters”][“parameters”][0][“value”] }}”,
“options”: {}
},
“type”: “n8n-nodes-base.discord”,
“typeVersion”: 2,
“position”: [
864,
96
],
“id”: “7a577297-8b8a-4477-a5f4-8c27445d4ffb”,
“name”: “Discord”,
“webhookId”: “d3451e27-f9c4-4da5-90ca-813e37c28813”,
“credentials”: {
“discordWebhookApi”: {
“id”: “pw6AALHIKOf1jcnO”,
“name”: “Discord Webhook account”
}
}
},
{
“parameters”: {
“rule”: {
“interval”: [
{
“field”: “weeks”,
“triggerAtDay”: [
1
],
“triggerAtHour”: 9
}
]
}
},
“type”: “n8n-nodes-base.scheduleTrigger”,
“typeVersion”: 1.3,
“position”: [
32,
0
],
“id”: “62bee414-4296-4797-a84e-bc7cba07224c”,
“name”: “Schedule Trigger”
}
],
“connections”: {
“HTTP Request”: {
“main”: [
[
{
“node”: “If”,
“type”: “main”,
“index”: 0
}
]
]
},
“If”: {
“main”: [
[
{
“node”: “Edit Fields”,
“type”: “main”,
“index”: 0
}
],
[
{
“node”: “Code in JavaScript”,
“type”: “main”,
“index”: 0
}
]
]
},
“Edit Fields”: {
“main”: [
[
{
“node”: “Create a record”,
“type”: “main”,
“index”: 0
}
]
]
},
“Code in JavaScript”: {
“main”: [
[
{
“node”: “Discord”,
“type”: “main”,
“index”: 0
}
]
]
},
“Schedule Trigger”: {
“main”: [
[
{
“node”: “HTTP Request”,
“type”: “main”,
“index”: 0
}
]
]
}
},
“pinData”: {},
“meta”: {
“templateCredsSetupCompleted”: true,
“instanceId”: “f9c074921e5d594997f09c12157c527ad0a9d5e0695614601a2503db6e5f97f0”
}
}
