🔎
Get One Row
vault.getThe VaultVaultLike Read from Vault, but for when you want one row: the first one that matches. Its columns become sparks directly — {{row.coins}} instead of {{result.0.coins}}. Filter with = ≠ > < ≥ ≤, contains or starts with.
When to use this
- →Use the Missing path to welcome people who don't have a row yet
- →Need every matching row? That's Read from Vault
On the canvas
This is what Get One Row looks like when you place it on your flow. Each field below is something you configure in the inspector panel.
🔎Vault
Get One Row
vault.gettablerequired
Pick a table…
filterColumn
Every row
filterOp
select…
filterValue
e.g. {{input.user.id}}
asrequired
row
found
missing
Config fields
| Field | Type | Req | What it does |
|---|---|---|---|
tablePick a table… | text | yes | Table 🗄️ |
filterColumnEvery row | text | — | Only rows where… 🔍 |
filterOp | select | — | Is… |
filterValuee.g. {{input.user.id}} | text | — | This value |
asrow | text | yes | Save it as ✨ |
Output ports
foundA row matched
missingNothing matched — great for first-timers
📐
In TypeScript, this would be…
Not something you need to write — just a look at what Kitcord does for you.
TypeScript
const row = await db.get(
"SELECT * FROM wallets WHERE user_id = ? LIMIT 1",
[userId],
);
// {{row.coins}} — Found ✓, or Missing ∅ when row is undefinedRelated pieces
More Vault pieces