OpenExO

[oblique meteor]

hello, you're using Checkout with PromoCodes, is that right?

and with one time payments or Subscriptions?

[proven sleet]

Yes, and Subscriptions

err I guess it's in the product category as

Coupon

[oblique meteor]

err I guess it's in the product category as
what do you mean?

[proven sleet]

I dont know if that term is interchangeable

on the dashboard I have Coupon codes, and that's what im trying to get

Who used the coupon code on checkout

[oblique meteor]

so here's how you do this

1/ list CheckoutSessions: https://stripe.com/docs/api/checkout/sessions/list
and pass expand: subscription.discount.coupon

that will get you each CheckoutSession and each underlying Subscription and the Discount object on each: https://stripe.com/docs/api/discounts and the Coupon object inside that

give that a shot

[proven sleet]

ok will try now

How do I add expand: subscription.discount.coupon to the URL path?

[oblique meteor]

https://stripe.com/docs/expand#multiple-properties

[proven sleet]

:/ I just don't know how to represent this in our automation software... using Make.com for the marketing team to get this data sent

[oblique meteor]

yeah I'm not sure how to construct it in that tool but look at the curl snippets and work backwards from there: https://stripe.com/docs/api/expanding_objects

keep in mind that expand takes in an array of strings e.g.
expand: ["x.y.z", "a.b.c"]

not sure what syntax looks like in your tool

[proven sleet]

assuming this is the only way to do it huh?

[oblique meteor]

it is among the easiest. Expand is just fetching multiple objects for you within one go

you can manually retrieve the sub, then discount, then coupon in each request

but expand makes it much easier