Use “What Stripe's invoice search can and cannot tell you about what you are owed” in Recued. This reads A search index, not the ledger. Stripe's own words: "Don't use search in read-after-write flows where strict consistency is necessary.

How it works 24 steps

Inspect the data fetches, transforms, gates, and output this recipe runs.

Process (24 steps)

◆ invoices_raw recued-core.stripe-billing-invoices.stripe_api.get_invoices_search

Get invoices search stripe api on stripe billing invoices

■ defaults defaults

Apply defaults

■ have_invoices template

Generate text from a template

fail: step.invoices is_empty

■ shown count

Count items in invoices

■ outstanding sum

Sum values in

■ naive_total sum

Sum values in

■ naive_due sum

Sum values in

■ overpaid sum

Sum values in

■ currency_values pluck

Extract currency from each item

■ currencies unique

Remove duplicates from

■ currency_count count

Count items in currencies

■ mixed_currency compare

Check if currency count is greater than 1

■ by_currency_table group_by

Group by currency

■ not_attempted filter

Filter by condition

■ not_attempted_count count

Count items in not attempted

■ drafts filter

Filter by condition

■ draft_count count

Count items in drafts

■ no_due_date filter

Filter by condition

■ no_due_date_count count

Count items in no due date

■ auto_charged filter

Filter by condition

■ auto_charged_count count

Count items in auto charged

■ count_capped compare

Check if total count is at least 10000

■ card to_summary

Format results as a summary card

■ invoice_table to_table

Format results as a data table

▼

Output

summary card

table by_currency_table

table invoice_table

Settings 1 configurable

Configurable at install. Defaults shown — change them anytime in Recued.

query setting = status:"open"