avinash_api

[left kite]

👋 Welcome to your new thread!

⏲️ We'll be here soon! Typically we respond in a few minutes, but sometimes we might take a bit longer if the server is busy or if you have a particularly tricky question.

⏱️ We close idle threads, which makes them read-only. Once a thread is closed it won't be reopened, but you can always start a new thread if you have another question.

🔗 This thread will always be available, even after it's closed. You can find it again using Discord's search, or you can save this link: https://discord.com/channels/841573134531821608/1346820825306894356

📝 Have more to share? Add more details, code, screenshots, videos, etc. below.

[hushed stream]

👋
Where have you set metadata ?

Can you share a sample object Id ?

[frank forge]

pi_3QtobmJLAdhVHE0c0gyFdXKv

[hushed stream]

You are referring to a PaymentIntent, so from the payout you need to get all the related PaymentIntents

in order to get the metadata set on the PaymentIntent level

So you need to list all the balance transaction of that Payout following this guide:
https://docs.stripe.com/payouts/reconciliation#list-balancetransactions

Then you need to get the PaymentIntent of each Charge:
https://docs.stripe.com/api/charges/object#charge_object-payment_intent

You can expand for this

https://docs.stripe.com/api/expanding_objects

https://docs.stripe.com/payouts/reconciliation#expand-resources

[frank forge]

we tried with same way ...see the output

this does not includes metadata

[hushed stream]

Have you had a chance to check all the links I shared with you?

Here you have the list of the balance transaction. You need to expand the data.source.payment_intent (check the guides I shared above 👆 )

[frank forge]

Basically we are trying to get payout details into ERP system for accounting reconcilation and we need all transaction details along with metadata

so far what we have done is - 1. Setup webhook to get payout event creration

2. Read webhook event and call balance transaction api with recieved payout number

but in response we get all required details except metadata

[serene dawn]

what metadata exactly?

you've stored metadata on the PaymentIntents?

[frank forge]

Its Zuora payment reference number which Zuora sends to STRIPE during payment itent process #

[serene dawn]

you can get the list of charges within a payout https://docs.stripe.com/expand/use-cases#charges-in-payout

as explained here https://docs.stripe.com/payouts/reconciliation#expand-resources

to get the metadata