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 →
{
"updatedAt": "2026-06-06T16:16:09.964Z",
"createdAt": "2026-06-06T12:20:21.133Z",
"id": "Eu7F6ubxphQNObzc",
"name": "Natuurwaarnemer ERP \u2014 Inkoop verwijderen",
"description": null,
"active": true,
"isArchived": false,
"nodes": [
{
"id": "webhook",
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"typeVersion": 1.1,
"position": [
200,
300
],
"parameters": {
"path": "inkoop-verwijderen",
"httpMethod": "POST",
"responseMode": "responseNode",
"options": {}
}
},
{
"id": "mysql_inkoop_delete",
"name": "MySQL: Inkoop delete",
"type": "n8n-nodes-base.mySql",
"typeVersion": 2.4,
"position": [
400,
300
],
"credentials": {
"mySql": {
"name": "<your credential>"
}
},
"parameters": {
"operation": "executeQuery",
"query": "DELETE FROM expenses WHERE id={{ $json.body.inkoop_id }}"
}
},
{
"id": "http:_ha_terugkoppel",
"name": "HTTP: HA terugkoppeling",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
600,
300
],
"parameters": {
"method": "POST",
"url": "http://192.168.2.17:8123/api/services/input_text/set_value",
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "<redacted-credential>"
},
{
"name": "Content-Type",
"value": "application/json"
}
]
},
"sendBody": true,
"contentType": "raw",
"rawContentType": "application/json",
"body": "{\"entity_id\":\"input_text.erp_status\",\"value\":\"inkoop_beheer|verwijderd|Inkoop verwijderd\"}"
}
},
{
"id": "respond",
"name": "Respond",
"type": "n8n-nodes-base.respondToWebhook",
"typeVersion": 1.1,
"position": [
800,
300
],
"parameters": {
"respondWith": "text",
"responseBody": "ok",
"options": {}
}
}
],
"connections": {
"Webhook": {
"main": [
[
{
"node": "MySQL: Inkoop delete",
"type": "main",
"index": 0
}
]
]
},
"MySQL: Inkoop delete": {
"main": [
[
{
"node": "HTTP: HA terugkoppeling",
"type": "main",
"index": 0
}
]
]
},
"HTTP: HA terugkoppeling": {
"main": [
[
{
"node": "Respond",
"type": "main",
"index": 0
}
]
]
}
},
"settings": {
"executionOrder": "v1",
"callerPolicy": "workflowsFromSameOwner",
"availableInMCP": false
},
"staticData": null,
"meta": null,
"versionId": "7546d1e7-8a7c-4e9b-8e6b-a7240cc5c48e",
"activeVersionId": "7546d1e7-8a7c-4e9b-8e6b-a7240cc5c48e",
"versionCounter": 12,
"triggerCount": 1,
"shared": [
{
"updatedAt": "2026-06-06T12:20:21.139Z",
"createdAt": "2026-06-06T12:20:21.139Z",
"role": "workflow:owner",
"workflowId": "Eu7F6ubxphQNObzc",
"projectId": "m5RFSl9CcHUdb8CB",
"project": {
"updatedAt": "2026-04-21T19:10:08.086Z",
"createdAt": "2026-04-21T18:59:53.063Z",
"id": "m5RFSl9CcHUdb8CB",
"name": "Ruud Hogenberg <info@natuurwaarnemer.nl>",
"type": "personal",
"icon": null,
"description": null,
"creatorId": "4e4dfe16-eb75-4c88-ac33-b7c362667bc3"
}
}
],
"tags": [],
"activeVersion": {
"updatedAt": "2026-06-06T12:43:46.953Z",
"createdAt": "2026-06-06T12:43:46.953Z",
"versionId": "7546d1e7-8a7c-4e9b-8e6b-a7240cc5c48e",
"workflowId": "Eu7F6ubxphQNObzc",
"nodes": [
{
"id": "webhook",
"name": "Webhook",
"webhookId": "085763ff-334a-4538-84af-e14a96a15a6b",
"type": "n8n-nodes-base.webhook",
"typeVersion": 1.1,
"position": [
200,
300
],
"parameters": {
"path": "inkoop-verwijderen",
"httpMethod": "POST",
"responseMode": "responseNode",
"options": {}
}
},
{
"id": "mysql_inkoop_delete",
"name": "MySQL: Inkoop delete",
"type": "n8n-nodes-base.mySql",
"typeVersion": 2.4,
"position": [
400,
300
],
"credentials": {
"mySql": {
"id": "AdVYD86SBj0ZYuto",
"name": "MySQL \u2014 erp"
}
},
"parameters": {
"operation": "executeQuery",
"query": "DELETE FROM expenses WHERE id={{ $json.body.inkoop_id }}"
}
},
{
"id": "http:_ha_terugkoppel",
"name": "HTTP: HA terugkoppeling",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
600,
300
],
"parameters": {
"method": "POST",
"url": "http://192.168.2.17:8123/api/services/input_text/set_value",
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "<redacted-credential>"
},
{
"name": "Content-Type",
"value": "application/json"
}
]
},
"sendBody": true,
"contentType": "raw",
"rawContentType": "application/json",
"body": "{\"entity_id\":\"input_text.erp_status\",\"value\":\"inkoop_beheer|verwijderd|Inkoop verwijderd\"}"
}
},
{
"id": "respond",
"name": "Respond",
"type": "n8n-nodes-base.respondToWebhook",
"typeVersion": 1.1,
"position": [
800,
300
],
"parameters": {
"respondWith": "text",
"responseBody": "ok",
"options": {}
}
}
],
"connections": {
"Webhook": {
"main": [
[
{
"node": "MySQL: Inkoop delete",
"type": "main",
"index": 0
}
]
]
},
"MySQL: Inkoop delete": {
"main": [
[
{
"node": "HTTP: HA terugkoppeling",
"type": "main",
"index": 0
}
]
]
},
"HTTP: HA terugkoppeling": {
"main": [
[
{
"node": "Respond",
"type": "main",
"index": 0
}
]
]
}
},
"authors": "Ruud Hogenberg",
"name": null,
"description": null,
"autosaved": false,
"workflowPublishHistory": [
{
"createdAt": "2026-06-06T12:43:47.062Z",
"id": 202,
"workflowId": "Eu7F6ubxphQNObzc",
"versionId": "7546d1e7-8a7c-4e9b-8e6b-a7240cc5c48e",
"event": "activated",
"userId": "4e4dfe16-eb75-4c88-ac33-b7c362667bc3"
},
{
"createdAt": "2026-06-06T16:16:10.109Z",
"id": 236,
"workflowId": "Eu7F6ubxphQNObzc",
"versionId": "7546d1e7-8a7c-4e9b-8e6b-a7240cc5c48e",
"event": "activated",
"userId": "4e4dfe16-eb75-4c88-ac33-b7c362667bc3"
},
{
"createdAt": "2026-06-06T12:43:47.028Z",
"id": 201,
"workflowId": "Eu7F6ubxphQNObzc",
"versionId": "7546d1e7-8a7c-4e9b-8e6b-a7240cc5c48e",
"event": "deactivated",
"userId": "4e4dfe16-eb75-4c88-ac33-b7c362667bc3"
},
{
"createdAt": "2026-06-06T16:16:10.041Z",
"id": 235,
"workflowId": "Eu7F6ubxphQNObzc",
"versionId": "7546d1e7-8a7c-4e9b-8e6b-a7240cc5c48e",
"event": "deactivated",
"userId": "4e4dfe16-eb75-4c88-ac33-b7c362667bc3"
}
]
}
}
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.
mySql
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Natuurwaarnemer ERP — Inkoop verwijderen. Uses mySql, httpRequest. Webhook trigger; 4 nodes.
Source: https://github.com/natuurwaarnemer/Boekhouden-in-HA/blob/0c3c42a80c3b9d7662c1fa47d01f7082b74097c3/n8n/inkoop_verwijderen.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.
v25.1.3. Uses httpRequest, mySql, n8n-nodes-zohozeptomail. Webhook trigger; 98 nodes.
BP_check2. Uses googleSheets, @n-octo-n/n8n-nodes-json-database, httpRequest, itemLists. Webhook trigger; 95 nodes.
N8Nworkflow. Uses stopAndError, httpRequest, mySql. Webhook trigger; 22 nodes.