FloPay Backend Changelog

v1.7.28 - Client webhook delivery and invoice lookups restored #

Fixes a v1.7.27 regression in which client webhook deliveries stalled as pending, webhook event detail reads failed, and invoice synchronisation errored on canonical invoice lookups.

Version 1.7.27 introduced canonical invoice and transaction resolution for financial records. A raw SQL fragment in that change referenced the query alias in a form PostgreSQL could not resolve, which stopped client webhook deliveries from progressing past pending, broke reading a single webhook event, and made invoice synchronisation fail on canonical lookups. This release corrects the SQL.

What changed

• Client webhook fan-out again writes a delivery row for every configured endpoint and delivers them; deliveries that were stuck in pending are picked up by the outbox retry ladder without a manual replay.
• GET /v1/webhooks/events/{id} and its admin mirror return the event again instead of a server error.
• Invoice synchronisation from provider webhooks, one-time invoice creation and renewal invoice lookups no longer fail on the canonical invoice check.

Developer notes

• Raw SQL fragments that embed a TypeORM alias now quote each identifier segment explicitly via the shared quoteTypeormAliasPath helper instead of relying on TypeORM's property-name rewrite, which does not reach these fragments.
• No schema change and no change to any SDK-facing contract.