Spojit
Filtering & queries

Filter, query, and merge.
Visually.

Keep only the records that matter, pull a value out of a nested structure, and join data from several sources, all visually, before it reaches the next step. No loops, no code, no guessing.

#1042paid
#1043pending
#1044paid
#1045refunded
#1046paid
filter
#1042
paid
#1044
paid
#1046
paid
3 of 5 records kept
How it works

Narrow data down to what matters

01

Point at a collection

Choose the list or response you want to work with, from any earlier step in the workflow.

02

Add conditions or a query

Build filter conditions and query nested paths visually, with a live count of what matches.

03

Merge or pass it on

Join in data from other sources if you need to, then hand the clean result to the next step.

Capabilities

Everything you need to shape a collection

Filter by conditions

Keep only the records that match, with compound and-or conditions across any field.

Query nested paths

Reach deep into a nested structure to pull out exactly the value the next step needs.

Merge and join sources

Combine data from several steps into one record or list, matched on the keys you choose.

Dedupe

Drop duplicate records by the field that defines uniqueness, so downstream steps stay clean.

Sort and limit

Order a collection and take the top results, the latest, or the first N, without code.

Visual, with a live count

See how many records survive each condition as you build it, so the logic is obvious.

Use cases

Reach for filtering when

Keep matching records

Process only the paid orders, the overdue invoices, or the tickets that need a reply.

Pull a nested field

Extract a single value buried deep in an API response to use in the next action.

Join two responses

Match records from two systems on a shared key into one row for the next step.

Clean a list

Dedupe, sort, and trim a collection down to the records that actually matter.

The difference

Visual queries vs loops in code

Express the shape you want and see what matches, instead of writing and debugging loops.

Filter visually when

  • You need a subset, a lookup, or a join
  • You want to see what matches before it runs
  • Non-engineers need to read and change the logic

Loops in code mean

  • A code step for every filter and join
  • No visibility into what matched until it runs
  • Only the author can safely change it later

Shape your data without code

Start free and filter, query, and merge a collection visually, with a live count. No card needed.