Type: Feature request Connector: Brex Table / column: expense / receipts

Objective: get receipt attachment status into the warehouse by i) having the Brex connector request receipts from the Expenses API, and ii) exposing a simple has-receipt flag.

Current behavior

• The Brex connector schema lists Expenses.receipts, but it comes through as NULL for every expense.
• All available scopes are enabled on both the Brex and Fivetran sides.
• Brex Developer Support confirmed this isn't a scope issue. No separate receipts scope exists, and receipts are covered by the card expense read access we already have.

Root cause (per Brex)

• The Brex Expenses API only returns receipts when the request includes expand[]=receipts.download_uris.
• It looks like the Fivetran sync doesn't send that parameter, so the column stays empty.
• Brex can't change how the connector calls their API, so they pointed us to Fivetran.

Requested change

1. Add expand[]=receipts.download_uris to the connector's call to GET /v1/expenses so the receipts column populates.
2. Nice to have: a derived has_receipt boolean (or receipt_count) on the expense table. Each expense returns a receipts list, so 1+ items means a receipt is attached and an empty list means none.

Use case

• We don't need the receipt files. We just need a reliable yes/no showing whether a receipt is attached to each expense, for spend compliance reporting.
• The compliance status field won't work for this. It rolls up every policy requirement (memo, receipt, etc.), and an expense can show as complete with no receipt if policy doesn't require one.

Notes

• Receipt download URLs expire 15 minutes after they're created, so the URLs themselves won't stay usable in the warehouse. That's why the boolean / count is the most useful output.
• Brex API docs: https://developer.brex.com/openapi/expenses_api/