Hello,
I passed my Level 1 quize with workflow it self but not getting updated,
below are the details and workflow i built which is also correct.{
“nodes”: [
{
“parameters”: {
“url”: “https://internal.users.n8n.cloud/webhook/custom-erp”,
“authentication”: “genericCredentialType”,
“genericAuthType”: “httpHeaderAuth”,
“sendHeaders”: true,
“headerParameters”: {
“parameters”: [
{
“name”: “unique_id”,
“value”: “4d259ec5241587a0d2820670fc048f0d”
}
]
},
“options”: {}
},
“type”: “n8n-nodes-base.httpRequest”,
“typeVersion”: 4.2,
“position”: [
-240,
20
],
“id”: “69e1091a-e24d-48d9-8702-50dab08d6083”,
“name”: “HTTP Request”,
“credentials”: {
“httpHeaderAuth”: {
“id”: “hs3qfOdbzvhXK4Qy”,
“name”: “Header Auth account”
}
}
},
{
“parameters”: {
“authentication”: “airtableOAuth2Api”,
“operation”: “create”,
“base”: {
“__rl”: true,
“value”: “appKJqEtEZJXlMTTI”,
“mode”: “list”,
“cachedResultName”: “Untitled Base”,
“cachedResultUrl”: “https://airtable.com/appKJqEtEZJXlMTTI”
},
“table”: {
“__rl”: true,
“value”: “tbll4wChQaibKlo9M”,
“mode”: “list”,
“cachedResultName”: “Orders”,
“cachedResultUrl”: “https://airtable.com/appKJqEtEZJXlMTTI/tbll4wChQaibKlo9M”
},
“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”: “CustomerID”,
“displayName”: “CustomerID”,
“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
},
{
“id”: “orderPrice”,
“displayName”: “orderPrice”,
“required”: false,
“defaultMatch”: false,
“canBeUsedToMatch”: true,
“display”: true,
“type”: “number”,
“readOnly”: false,
“removed”: false
},
{
“id”: “orderStatus”,
“displayName”: “orderStatus”,
“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”: [
420,
-80
],
“id”: “fd8502a7-b52a-4a43-bdb0-4a85e04693e8”,
“name”: “Airtable”,
“credentials”: {
“airtableOAuth2Api”: {
“id”: “nqJWwcye8BLT1KP6”,
“name”: “Airtable Personal Access Token account 4”
}
}
},
{
“parameters”: {
“conditions”: {
“options”: {
“caseSensitive”: true,
“leftValue”: “”,
“typeValidation”: “strict”,
“version”: 2
},
“conditions”: [
{
“id”: “526cb30c-0f90-4f66-8f98-b64ceb2e52f2”,
“leftValue”: “={{ $json.orderStatus }}”,
“rightValue”: “processing”,
“operator”: {
“type”: “string”,
“operation”: “equals”
}
},
{
“id”: “dc15989b-6938-4fc8-87e4-7230fa4d96d9”,
“leftValue”: “={{ $json.employeeName }}”,
“rightValue”: “Mario”,
“operator”: {
“type”: “string”,
“operation”: “equals”,
“name”: “filter.operator.equals”
}
}
],
“combinator”: “and”
},
“options”: {}
},
“type”: “n8n-nodes-base.if”,
“typeVersion”: 2.2,
“position”: [
-20,
20
],
“id”: “a185134c-1296-4f61-93b9-c6c932f0e1d6”,
“name”: “If”
},
{
“parameters”: {
“assignments”: {
“assignments”: [
{
“id”: “20d37948-763a-4d7b-b725-e65f3802af03”,
“name”: “orderID”,
“value”: “={{ $json.orderID }}”,
“type”: “number”
},
{
“id”: “9df108a7-6b13-42ab-a6dd-9ca582ba8b49”,
“name”: “employeeName”,
“value”: “={{ $json.employeeName }}”,
“type”: “string”
}
]
},
“options”: {}
},
“type”: “n8n-nodes-base.set”,
“typeVersion”: 3.4,
“position”: [
200,
-80
],
“id”: “8c21d468-b74e-4699-b26d-1b157d7e78c1”,
“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”: [
200,
120
],
“id”: “d0f307e2-be76-46ee-9bd3-d8bb927089f9”,
“name”: “Code”
},
{
“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”: [
420,
120
],
“id”: “c63be640-d32a-4851-bcaf-44c00d533491”,
“name”: “Discord”,
“webhookId”: “eff0b651-f0be-4cae-8f18-7d831385be3c”,
“credentials”: {
“discordWebhookApi”: {
“id”: “7esHyFZqdJ3Pa40N”,
“name”: “Discord Webhook account”
}
}
},
{
“parameters”: {
“rule”: {
“interval”: [
{
“field”: “weeks”,
“triggerAtDay”: [
1
],
“triggerAtHour”: 9
}
]
}
},
“type”: “n8n-nodes-base.scheduleTrigger”,
“typeVersion”: 1.2,
“position”: [
-460,
20
],
“id”: “e1351346-af1d-47cd-af18-5d3bea87be7d”,
“name”: “Schedule Trigger”
}
],
“connections”: {
“HTTP Request”: {
“main”: [
[
{
“node”: “If”,
“type”: “main”,
“index”: 0
}
]
]
},
“If”: {
“main”: [
[
{
“node”: “Edit Fields”,
“type”: “main”,
“index”: 0
}
],
[
{
“node”: “Code”,
“type”: “main”,
“index”: 0
}
]
]
},
“Edit Fields”: {
“main”: [
[
{
“node”: “Airtable”,
“type”: “main”,
“index”: 0
}
]
]
},
“Code”: {
“main”: [
[
{
“node”: “Discord”,
“type”: “main”,
“index”: 0
}
]
]
},
“Schedule Trigger”: {
“main”: [
[
{
“node”: “HTTP Request”,
“type”: “main”,
“index”: 0
}
]
]
}
},
“pinData”: {},
“meta”: {
“templateCredsSetupCompleted”: true,
“instanceId”: “56618ac74fc1653fa13a004decd583a5fc421e12ac60e59c391259dc6bd565ce”
}
}
