#454 — [Bug]: updating merchants fails with “invalid input for query argument $324: 12000 (expected str, got int)”

Repo: Twill-AI/facade State: closed | Status: done Assignee: Unassigned

Created: 2025-08-01 · Updated: 2025-09-15

Description

Steps to reproduce

  1. In prod open OpenAPI UI and login under aleksandr+001owner@twillpayments.com
  2. Call GET /partner/merchants/force

Expected behavior

Passes

Actual behavior

500

{
  "type": "DataError",
  "message": "invalid input for query argument $324: 12000 (expected str, got int)"
}

logs

2025-08-01 11:22:22.395|ERROR|master|endpoint_helpers:80|GET http://facade.twillai.com/api/v1/partner/merchants/force raised asyncpg.exceptions.DataError: invalid input for query argument $324: 12000 (expected str, got int)
...
  File "/app/app/api/merchants_router.py", line 987, in force_update_merchants
    return await force_update_merchants_and_kpis(user.partner_id)  # type: ignore
           ^^^^^^^^^^^^^^^^

## Notes

_Add implementation notes, blockers, and context here_

## Related

_Add wikilinks to related people, meetings, or other tickets_