Evaluate Pricing Rule

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": "03 - Evaluate Pricing Rule",
  "active": false,
  "nodes": [
    {
      "id": "pricing-webhook",
      "name": "Pricing Evaluation Request",
      "type": "n8n-nodes-base.webhook",
      "typeVersion": 2,
      "position": [
        0,
        0
      ],
      "parameters": {
        "httpMethod": "POST",
        "path": "revenue-leakage/evaluate/pricing",
        "responseMode": "lastNode"
      }
    },
    {
      "id": "pricing-service",
      "name": "Run Versioned Rule",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4.2,
      "position": [
        260,
        0
      ],
      "parameters": {
        "method": "POST",
        "url": "={{ $env.LEAKAGE_ENGINE_URL + '/v1/evaluate' }}",
        "sendHeaders": true,
        "headerParameters": {
          "parameters": [
            {
              "name": "Authorization",
              "value": "={{ 'Bearer ' + $env.LEAKAGE_ENGINE_TOKEN }}"
            }
          ]
        },
        "sendBody": true,
        "contentType": "raw",
        "rawContentType": "application/json",
        "body": "={{ JSON.stringify({...$json.body, rule: 'outdated_pricing'}) }}"
      }
    },
    {
      "id": "persist-pricing",
      "name": "Persist Deduplicated Finding",
      "type": "n8n-nodes-base.postgres",
      "typeVersion": 2.5,
      "position": [
        520,
        0
      ],
      "parameters": {
        "operation": "executeQuery",
        "query": "SELECT persist_leakage_evaluation($1::jsonb);",
        "options": {
          "queryReplacement": "={{ [JSON.stringify($json)] }}"
        }
      }
    }
  ],
  "connections": {
    "Pricing Evaluation Request": {
      "main": [
        [
          {
            "node": "Run Versioned Rule",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Run Versioned Rule": {
      "main": [
        [
          {
            "node": "Persist Deduplicated Finding",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "77065f65-7ab8-4a03-b7c9-8e038c0d0602",
  "meta": {
    "evidence": "orchestration artifact; pricing logic is owned by the tested Python service"
  },
  "tags": []
}

About this workflow

03 - Evaluate Pricing Rule. Uses httpRequest, postgres. Webhook trigger; 3 nodes.

Source: https://github.com/Etherlabs-dev/revenue_leakage_system/blob/main/n8n-workflows/03-detect-outdated-pricing.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.