Signups — validate before they hit the DB

An inbound signup passes two gates: a JSON-Schema contract (bad payloads route to the reject lane instead of crashing the flow) and a business-rule Check. Only clean signups continue.

What’s inside

6 nodes — every type links to its full reference page.

Step	Node	Type
Signup payload	Inject	`input.inject`
Schema contract	Validate JSON Schema	`processing.validate-json-schema`
Visual validator	Visual JSON Schema Validator	`processing.visual-json-schema-validator`
Business rules	Check	`processing.check`
Provision	Console	`utility.console`
Reject lane	Console	`utility.console`

Import it

Studio → Import — paste the JSON below (or the URL /docs/templates/signups-validate-before-they-hit-the-db.json).

Or ask the AI Copilot with the JSON pasted after the phrase:

import this workflow json into a new workflow named "Signups — validate before they hit the DB"

Any credentials the nodes need are ${credential.…} references — add them once in Admin → Credentials and the template picks them up. Nothing secret ships in a template.

The workflow document (flowdrome.workflow.v1, 5 node types)

{
  "schemaVersion": "flowdrome.workflow.v1",
  "id": "",
  "name": "Signups — validate before they hit the DB",
  "version": "0",
  "status": "draft",
  "nodes": [
    {
      "id": "seed",
      "type": "input.inject",
      "label": "Signup payload",
      "category": "trigger",
      "config": {
        "contentType": "application/json",
        "payload": {
          "email": "ada@example.test",
          "plan": "pro",
          "seats": 5
        }
      },
      "position": {
        "x": 0,
        "y": 69
      }
    },
    {
      "id": "contract",
      "type": "processing.validate-json-schema",
      "label": "Schema contract",
      "category": "processing",
      "config": {
        "schema": {
          "type": "object",
          "required": [
            "email",
            "plan"
          ],
          "properties": {
            "email": {
              "type": "string"
            },
            "plan": {
              "type": "string"
            },
            "seats": {
              "type": "number"
            }
          }
        },
        "routeInvalid": true
      },
      "position": {
        "x": 530,
        "y": 69
      }
    },
    {
      "id": "visual",
      "type": "processing.visual-json-schema-validator",
      "label": "Visual validator",
      "category": "processing",
      "config": {
        "schema": {
          "type": "object",
          "properties": {
            "seats": {
              "type": "number"
            }
          }
        },
        "includeInput": true
      },
      "position": {
        "x": 1060,
        "y": 46
      }
    },
    {
      "id": "rules",
      "type": "processing.check",
      "label": "Business rules",
      "category": "processing",
      "config": {
        "mode": "all",
        "checks": [
          {
            "label": "has seats",
            "path": "seats",
            "operator": "greaterThan",
            "value": 0
          }
        ]
      },
      "position": {
        "x": 1590,
        "y": 23
      }
    },
    {
      "id": "ok",
      "type": "utility.console",
      "label": "Provision",
      "category": "utility",
      "config": {
        "message": "✅ provision {{ $json.seats }} seats for {{ $json.email }}"
      },
      "position": {
        "x": 2120,
        "y": 0
      }
    },
    {
      "id": "bad",
      "type": "utility.console",
      "label": "Reject lane",
      "category": "utility",
      "config": {
        "message": "❌ rejected signup: {{ $json }}"
      },
      "position": {
        "x": 2120,
        "y": 178
      }
    }
  ],
  "edges": [
    {
      "id": "e0",
      "sourceNodeId": "seed",
      "sourcePort": "output",
      "targetNodeId": "contract",
      "targetPort": "input"
    },
    {
      "id": "e1",
      "sourceNodeId": "contract",
      "sourcePort": "valid",
      "targetNodeId": "visual",
      "targetPort": "input"
    },
    {
      "id": "e2",
      "sourceNodeId": "contract",
      "sourcePort": "invalid",
      "targetNodeId": "bad",
      "targetPort": "input"
    },
    {
      "id": "e3",
      "sourceNodeId": "visual",
      "sourcePort": "output",
      "targetNodeId": "rules",
      "targetPort": "input"
    },
    {
      "id": "e4",
      "sourceNodeId": "rules",
      "sourcePort": "valid",
      "targetNodeId": "ok",
      "targetPort": "input"
    },
    {
      "id": "e5",
      "sourceNodeId": "rules",
      "sourcePort": "invalid",
      "targetNodeId": "bad",
      "targetPort": "input"
    }
  ],
  "triggers": [
    {
      "id": "t0",
      "nodeId": "seed"
    }
  ],
  "meta": {
    "snippets": [],
    "source": "template-gallery",
    "description": "An inbound signup passes two gates: a JSON-Schema contract (bad payloads route to the reject lane instead of crashing the flow) and a business-rule Check. Only clean signups continue."
  }
}

Generated from the verified demo corpus — this exact document seeds and runs on a fresh Flowdrome. Raw JSON: signups-validate-before-they-hit-the-db.json.