#tovirio-payments
glad bone
@tired stump hi! it depends what information you already are starting with. So can you talk about your overall use case in more depth and what you already have?
tired stump
sure
i need to retrive thi information
the same exact information that i can find inside a payment via web
amount, fee and net
each payment that i recive and is Succeeded
in the The charge object i can't find the fee
glad bone
https://stripe.com/docs/expand/use-cases#stripe-fee-for-payment is how you get the fee for the payment
it's in the BalanceTransaction object, which is linked from the Charge
tired stump
is possible to make one single query like a join to get it inside the charge?
glad bone
yep that's what my first link is about
tired stump
ah lol i didn't see
glad bone
that Expand feature lets you expand other objects when retrieving one, so you can get a Charge object with the BalanceTransaction inside it.
tired stump
can i do something like this?
charges = stripe.Charge.list(
limit=100,
expand=['balance_transaction.data.fee'],
)
glad bone
it's just expand=['data.balance_transaction'] , like the docs say
then you write some code to loop over charges.data and you can read the information you want
glad bone
this is not valid python, just pseudo code, but something like
https://stripe.com/docs/api/pagination/auto?lang=python
for charge in charges.auto_paging_iter():
print(charge.balance_transaction.fee_details.type)