younifyd
Menu

Find One

Find a single row in a PostgreSQL table

Use it in a workflow

  1. Add a step and choose the PostgreSQL connector.
  2. Pick the Find One action (under postgres).
  3. Fill in the fields below, then reference the result from later steps as {{findOne.response.data}}.

Fields

tablestringrequired

The name of the PostgreSQL table

schemastring

The PostgreSQL schema the table lives in

filterstringrequired

JSON string containing the query filter (e.g., {"email": "john@example.com"} or {"age": {"$gte": 18}})

columnsstring

Comma-separated column names to return (e.g., name, email)

sortstring

JSON string specifying sort order (e.g., {"createdAt": -1} for descending)

Need more? See the PostgreSQL guide for connection setup and behaviour shared by every action.

Was this page helpful?
Find One — PostgreSQL — Documentation