#dstun - product data
daring bronze
Hello! Just starting a thread for you -- I'll review and respond as soon as I can 🙂
hey there can you share an example request to list and a product you'd expect to be included which is not?
Probably something is filtering it out
burnt radish
Thanks - let me pull this @daring bronze
Still working on this. Sorry for the delay
First screenshot is of the logs from the Stripe API - GET request for Prices table goes through successfully. Second and third screenshot are from making the Stripe API call via Matillion - the results are "zero rows staged" and "no data to display"
We're using Matillion to pull info from Stripe
In contrast, when we make an API call for the Prices table, the prices data comes through along with the associated Product IDs. So the Products definitely should exist somewhere within the database, they're just not coming through in the Products table. An example of a product ID that comes up in the Prices table but doesn't show up in the Products table is the ID prod_IEucbz7YnNykxr.
Does this make sense @daring bronze >
?
daring bronze
I'm looking at your account/requests to see if I can offer any pointers, but likely you'll need to reach out to Matillion for help with this
burnt radish
Okay
daring bronze
Ok, it is what i suspected
you account default API version is from 2017
there is an API change in 2018 which changes the way product type behaves, explained here:
https://stripe.com/docs/upgrades#2018-02-05
so the request as is will need to specify type=service to match the product you shared
but if you don't control the request code, Matillion will need to support that
burnt radish
Thank you - will pass that along to our team
daring bronze
👍
burnt radish
We'll try this and will reach out to Matillion if we need help. If I have any Stripe-related questions, I'll nudge you in this thread. Appreciate the help