#393 — Facade support type=“merchants” in /widgets/static API

Repo: Twill-AI/facade State: closed | Status: done Assignee: meliascosta, Ahmad1809

Created: 2025-07-15 · Updated: 2025-08-08

Description

Request

Caused by https://github.com/Twill-AI/facade/issues/389

In order to show data in “Merchants” widget in UI we need to add into /widgets/static type="merchants" support. For specific partner it should always set filter by partner ID and for relevant sales representatives it should always set filter by user ID.

Acceptance criteria

  • Required to show columns, default columns, filters/sorting are discussed.
  • “merchant” table indexes are added for required columns.
  • Facade supports type="merchants" in /widgets/static API with relevant filters.

Implementation details:

Default columns: name, business_legal_name, dba_name, created_by_id, mid, processing_status, status, total_payment_volume, risk_category, business_age_years, business_mcc_sic

Available columns: email, fee schedule template (fee_config_id), created at, updated at, status message, cc_avg_transaction_amount, cc_total_monthly_sales, cc_highest_transaction_amount, active_bank_account_last_5, mid, percentage_completed, can_process, year_to_date_settled_amount

We would need to add to it columns around MCA and commission once they would be implemented.

Notes

Add implementation notes, blockers, and context here

Add wikilinks to related people, meetings, or other tickets