AutomationFlowsData & Sheets › Natuurwaarnemer Erp — Inkoop Verwijderen

Natuurwaarnemer Erp — Inkoop Verwijderen

Natuurwaarnemer ERP — Inkoop verwijderen. Uses mySql, httpRequest. Webhook trigger; 4 nodes.

Webhook trigger★★☆☆☆ complexity4 nodesMySQLHTTP Request
Data & Sheets Trigger: Webhook Nodes: 4 Complexity: ★★☆☆☆ Added:

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 →

Download .json
{
  "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.

Pro

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 →

More Data & Sheets workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

Data & Sheets

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
Data & Sheets

v25.1.3. Uses httpRequest, mySql, n8n-nodes-zohozeptomail. Webhook trigger; 98 nodes.

HTTP Request, MySQL, N8N Nodes Zohozeptomail
Data & Sheets

BP_check2. Uses googleSheets, @n-octo-n/n8n-nodes-json-database, httpRequest, itemLists. Webhook trigger; 95 nodes.

Google Sheets, @N Octo N/N8N Nodes Json Database, HTTP Request +2
Data & Sheets

InsertDB. Uses mySql, httpRequest. Webhook trigger; 29 nodes.

MySQL, HTTP Request
Data & Sheets

N8Nworkflow. Uses stopAndError, httpRequest, mySql. Webhook trigger; 22 nodes.

Stop And Error, HTTP Request, MySQL