How do I get customer balance transactions?

[BoPeng]

What are you trying to accomplish?

List all balance transactions related to a customer, potentially within a specified time frame.

Potential solutions

Querying BalanceTransaction database is not easy since there is no customer field for this class. This class does have a source, but this is not a ForeignKey so I cannot query by something like source.customer.id = request.user.customer.id. It is possible to check BalanceTransaction.get_source_instance().customer after retrieving all transactions, but that would be very inefficient.

Stripe provides an API for list customer balance transaction, which returns a list of balance transactions. However, using this API means that I will have to query stripe directly, ignoring all BalanceTransactions that are already available locally.

Perhaps dj-stripe can provide a function Customer.list_balance_transactions?

[arnav13081994]

@BoPeng We currently do not support the Customer Balance Transaction model. It may be added in the future but I cannot guarantee that.

[BoPeng]

Thanks for your quick reply. I will use stripe.Customer.list_balance_transactions directly for now.