#dieselwurks_api
wild meteorBOT
👋 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/1283891193633046608
📝 Have more to share? Add more details, code, screenshots, videos, etc. below.
haughty shore
frigid geyser
Hello! If you want to start from the Payment Intent ID, you would need to use this endpoint to get the associated Checkout Session: https://docs.stripe.com/api/checkout/sessions/list#list_checkout_sessions-payment_intent
To get the Product and Price information, you need to expand the line_items property when you make that request: https://docs.stripe.com/api/checkout/sessions/object#checkout_session_object-line_items
More info on expansion here: https://docs.stripe.com/api/expanding_objects
haughty shore
data.line_items ?
frigid geyser
If you have a Checkout Session ID, you can retrieve the Checkout Session directly while expanding line_items with this endpoint: https://docs.stripe.com/api/checkout/sessions/retrieve
It would be data.line_items for the list call, yep.
haughty shore
In the cli, how do i specify more than one expansion?
this did not work" :stripe payment_intents list --limit=100 --expand=data.latest_charge,data.line_items
nvm, it seems you call --expand twice
haughty shore
Argh. it's not the intent, it's the session that has the line items.
frigid geyser
Yes.
Oh, yeah, you're trying to list Payment Intents with that command.
The docs I linked to are for listing Checkout Sessions by Payment Intent ID.
haughty shore
ok, thanks I think I have it now.
No wait.
Am I doing this right?
I take money.
Sometimes it's refunded. I store payment_intents in my DB, along with the checkout session id.
I need to verify that a list of people in my classes have paid. I throw out those who were refunded.
Now I need to sum the prices that were paid.
SO it seems start with intent, go to checkout session, get price. Is this the best flow?
I actually have both CSID and PI .
frigid geyser
Well, it sounds like you also have the Checkout Session IDs. If you have those, I recommend starting there and fetching the Checkout Sessions with the other information you need expanded.
frigid geyser
Try retrieveing the Checkout Sessions with both line_items and payment_intent.latest_charge expanded. That will include the line items, the full Payment Intent, and the full latest Charge objects.
haughty shore
But the sessions wouldn't know that the money was refunded. So I need both.
Ah. OK.
frigid geyser
Actually, you probably want to expand payment_intent.latest_charge.refunds so you get all the Refund objects for the Charge as well.
frigid geyser
What's the issue?
haughty shore
Argh it's maddening that you can't search the text of a stripe webpage.
This property cannot be expanded (data.latest_charge).
ha! didn't notice that checkbox.
frigid geyser
Can you share the request ID showing that error so I can take a look? Here's how you can find a request ID: https://support.stripe.com/questions/finding-the-id-for-an-api-request
haughty shore
I'm trying to do what you said:
$sessions = $this->stripe->checkout->sessions->all(['limit' => '100', 'expand' => ['data.latest_charge','data.line_items','data.payment_intent.latest_charge.refunds']]);
I can't quite get the keys right.
For a session.
frigid geyser
There's no latest_charge property on Checkout Sessions.
So remove that first one from the array.
haughty shore
Try retrieveing the Checkout Sessions with both `line_items` and `payment_intent...
This is what I'm trying to do.
frigid geyser
Right.
But you can't expand a property that doesn't exist.
Checkout Sessions do not have a latest_charge property, but Payment Intents do. Checkout Sessions do have a payment_intent property, which points to the associated Payment Intent. That's why you need to expand payment_intent.latest_charge when fetching Checkout Sessions.
You're expanding the payment_intent property on the Checkout Sessions, which do exist, and then on that Payment Intent you're expanding you're expanding the latest_charge property there.
Does that make sense?
Happy to explain another way if it would help!
haughty shore
this worked:
'data.payment_intent.latest_charge','data.payment_intent.latest_charge.refunds','data.line_items'
Ah! ok.
frigid geyser
You only need 'data.payment_intent.latest_charge.refunds','data.line_items'
haughty shore
OK, This should be good. It's slow though. I understand why but I think I should cli this and freeze/thaw the json or I'll get bored.
Thank you!
frigid geyser
It'll be a lot faster if you reduce the limit.
Like if you only grab 5 or 10, for example.
haughty shore
In the end I need them all. Oh hey, can I exclude expired sessions?
frigid geyser
If you need more than 20 or so you should use auto-pagination and keep your limit set to 20 or less: https://docs.stripe.com/api/pagination/auto
When using auto-pagination the limit applies to each individual request, but multiple requests will be made until you have all of them.
haughty shore
If I need to get, say, 300 you're saing it would be faster to get 15x20 rather than 3x100?
frigid geyser
You can get expired Checkout Sessions, yep: https://docs.stripe.com/api/checkout/sessions/list#list_checkout_sessions-status
It will probably be faster, yeah. You should test both approaches if performance matters. It can vary based on factors unique to your account, integration, etc.
haughty shore
The payment_intent in the session is null.
frigid geyser
Can you give me the Checkout Session ID so I can take a look?
haughty shore
Argh this was an early iteration of the software and it's intentionally null. My fault.
frigid geyser
Ah. 🙂
haughty shore
Choosing a random one elsewhere rather than array_pop
frigid geyser
It will be null if the Checkout Session hasn't been paid yet.
It might also be null if the Checkout Session is for a subscription instead of a one-off payment.
haughty shore
Yeah, it's there. Thanks again.