JacobB-metadata

[blissful ore]

But I don't have the subscription ID on the charge

And some of the charges, which in theory should all have the same external ID we place on the subscription, don't have that reference, so I can't join the charges directly to my external records

What's the right join path between a charge and a subscription?

[chilly helm]

When you retrieve the charge you can expand payment_intent.invoice.subscription - this will expand the full subscription object tied to that charge

[blissful ore]

So, can we recap the foreign key/parent-child relationships real quick?

subscriptions create invoices, which create payment intents, which create charges?

Or is that not the right flow?

[chilly helm]

Yup, that's the right flow!

[blissful ore]

I'm going at this through SQL (synced stripe using fivetran to our warehouse), so it's a bit different, but I think that will work

Thanks for confirming!

[chilly helm]

👍