SEARCH_DATABASE_RECORD

What it does

SEARCH_DATABASE_RECORD node.

Inputs & outputs

Configuration

No configuration.

Example

How it works

SEARCH_DATABASE_RECORD queries one of your EzFlow database tables. Provide the table name and a filters object of field/value pairs; the node matches records whose data fields equal those values and returns them on a records array. Use it to look up existing rows before deciding what to do next.

Example

Scenario: Find the customer record for an incoming support email before routing it.

1. A trigger supplies the sender's email address.
2. Add a SEARCH_DATABASE_RECORD node. Set table to customers and filters to match on email:

{ "email": "ana@acme.com" }

3. The node returns records. Branch on whether the array is empty (unknown sender) or contains a match (existing customer).

TRIGGER ──► SEARCH_DATABASE_RECORD ──(records)──► IF / branch