#chrisSurf
teal sorrel
unkempt falcon
Hi there
compact geode
Hello!
unkempt falcon
Hmm Stitch is a third party here, correct?
compact geode
yes
unkempt falcon
And how are you exporting your Stripe data to them exactly?
compact geode
I can provide a list of all they tables they support if that's helpful.
unkempt falcon
Nah not really. Overall this is probably going to be something you have to talk to Stitch about
But maybe I can help if you give me a bit more details
compact geode
They have a integration, that we we just toggle on. From there we select which tables to ingest.
unkempt falcon
Ah okay then yeah, since they are a third party then they control how they are retrieving this data from your account.
They can certainly list PaymentMethods on your account if you give them access to do so.
But overall just depends on how they are going about getting this data
Which only they will know
compact geode
Hmm, so if I understand you, the tables they present to us are not necessarily directly corresponding to they way Stripe stores the data. So its not a table to table translation.
unkempt falcon
That is probably true. But really I can't say unfortunately
Like I would assume they do have tables for each of our objects
But no way to know
compact geode
Are we able to access all of those objects via the API?
unkempt falcon
Mostly, yes. All the major ones you can List. You can check our API Ref and click on each object on the left and then see what we support. For instance here is the PaymentMethod object: https://stripe.com/docs/api/payment_methods
And you can see we support listing PaymentMethods by a Customer: https://stripe.com/docs/api/payment_methods/customer_list
Some things you would need to combine... like for the above you would need to List Customers and then loop over them and List PaymentMethods for each Customer to get all PaymentMethods stored on the account
compact geode
When I export the customer table, I see CardId values prefixed with both card_ and pm_. In our lake all customers where cardId is prefixed with pm_ have no card data, this is still in the Customers table.
Is the Card Data joined in to the Customers table when exported directly from Stripe?
unkempt falcon
card_xxx are our legacy Card objects. pm_xxx are our newer PaymentMethod object which wrap Card objects
Not crazy to see both overall
Can't tell you about the data being joined as once again that is dependent on how it is retrieved/exported
compact geode
Ok, it seems like we'll have to coordinate with Stitch or manage the connection manually.
unkempt falcon
Yeah I'd recommend reaching out to Stitch to get a better understanding of how they are handling this data
I'm really limited in how I can help here since I don't know their set up
compact geode
They've confirmed that they do not support PaymentMethod data yet.
compact geode
Thanks so much for the insight
unkempt falcon
Sure