roadkillduke | Stripe Developers | Page 1

calm swanBOT Jun 21, 2023, 9:14 PM

#

shell sorrel Jun 21, 2023, 9:15 PM

#

Hi there

#

Hmmm not sure this field is within Sigma

lost hull Jun 21, 2023, 9:15 PM

#

hi!

shell sorrel Jun 21, 2023, 9:15 PM

#

Let me check

lost hull Jun 21, 2023, 9:15 PM

#

thank you!

#

and if it's not in Sigma, do you know of any report where it might exist? Right now we're having to go into each transaction to manually pull the field, which is tedious and hoping for a better solution

shell sorrel Jun 21, 2023, 9:17 PM

#

Yeah unfortunately we don't have Checkout Session object data or Payment Link data in Sigma.

#

I don't think we have it witihn our Reports API either but let me check on that

lost hull Jun 21, 2023, 9:18 PM

#

ok

#

bummer

shell sorrel Jun 21, 2023, 9:19 PM

#

Yeah overall I'd recommend ingesting this data via webhook into your own database.

#

You will need to use the API to gather this data from past Checkout Sessions though

#

I can put in a feature request to get this added to Sigma

#

I do understand it would be nice to have there

lost hull Jun 21, 2023, 9:20 PM

#

yes please, that would be appreciated

#

so, the only way to get the data is to use a post transaction webhook and store it on our end, then we can report against it, correct?

shell sorrel Jun 21, 2023, 9:21 PM

#

You can List Checkout Sessions via the API to get the data: https://stripe.com/docs/api/checkout/sessions/list

#

But instead of having to do that every time you want it, I'd recommend ingesting it via Webhook as it comes in so that you have it cached already

#

You will want to list Checkout Sessions to ingest the previous data into your database if you do implement a Webhook handler here to collect it going forward

lost hull Jun 21, 2023, 9:22 PM

#

got it, thank you for your help!

#

i'll pass this over to our team

#roadkillduke