#ArjunK
dusky sierra
Which data specifically are you trying to get?
wicked void
Payments, Gross volume, New customers , Spend per customer, MRR for now.
from home's dashboard
dusky sierra
That's a lot. I would recommend working on one at a time, starting with the Charges API: https://stripe.com/docs/api/charges
There's also the Balance Transactions API that will have all money movement transactions on the account: https://stripe.com/docs/api/balance_transactions
wicked void
I have used python and pulled out the charges data already
which particular field from charges to use in order to get
dusky sierra
I think if you mouse over the Gross volume info icon, it should give you a definition, yes?
wicked void
Yes, it will but don't know which particular field to use. I used amount field but data doesn't match with dashboard number.
dusky sierra
You may want to use amount_captured instead, and I'm not sure if this goes into the gross calculation, but amount_refunded may be useful too: https://stripe.com/docs/api/charges/object#charge_object-amount_captured
wicked void
Ok I'll try that and let you know.
Oh, I got really close result now, but got around 2.3 % deviation
I compared the data of Jan 23
Now, I am calculating amount_refunded as well
dusky sierra
Hmmm, maybe fees are accounting for that 2.3%?
wicked void
Ok, will check
wicked void
Had to reload the charges data again, taking a lot of time, meanwhile can you please tell me regarding Payments report?
dusky sierra
I'm not sure what you mean. What Payment report (there are many)?
dusky sierra
Pretty sure it's the same API as before. Have you looked through the Charges API reference to try and find those statuses?
wicked void
Yeah, I did, though I used amount(will now use amount_captured) but did not have all the status.
these are the status
dusky sierra
Right, but if you scrolled down a bit, you would see status: https://stripe.com/docs/api/charges/object?lang=dotnet#charge_object-status
We already talked about how to see if a charge is refunded. So that should have what you need
wicked void
Oh, oh you mean , I will not have refunded inside the status but need to calculate it separately, right?
dusky sierra
Correct
bleak sleetBOT
wicked void
But still, pending and uncaptured are not matching. Pending in the api shows some number whereas uncaptured in the dashboard is 0, how would I get this?
Sorry for asking a lot of questions, actually I tried to do on my own but had to struggle a lot before landing here, that's why.
dusky sierra
That part I'm not sure about. I believe "uncaptured" means a payment that was authorized, but not actually charged yet (as mentioned in these docs: https://stripe.com/docs/payments/place-a-hold-on-a-payment-method). If you don't do authorization and capture as 2 separate steps, then it makes sense that "uncaptured" is 0. As for "pending" do you have an example Charge ID I can look at for one of those?
"pending" usually means that there's a charge for a delayed notification payment method like ACH or SEPA (to name only a few)
wicked void
Charge is still loading
Meanwhile charges data loads, can we talk about this?
Though it seems simple as it should be gross vol/tol cust
but while getting the data of customer, I got this view
tulip steeple
Hi 👋
We can't really help with Dashboard related questions here. We are focused on developers coding integrations with Stripe APIs. I would recommend reaching out to Support: https://support.stripe.com/?contact=true
wicked void
Umm it's kind of api problem, I just need table name and the field names to get the report,
tulip steeple
That we wouldn't know
The Dashboard does a lot of custom reporting behind the scenes
You can review the reporting you can access via the API here: https://stripe.com/docs/reports/report-types
wicked void
Does this mean, I can download the data of each custom report?
tulip steeple
You can generate the reports via the API and retrieve them once they are ready to be downloaded
wicked void
I am little confused here, to be frank, I simply want Payments, Gross volume, New customers , Spend per customer, MRR from home's dashboard and I think they are all default reports, I am struggling from couple of days before I landed here. two-shoes has already helped me out regarding first two reports Payments and Gross volume simply by letting me know the table and fields names. Now, just three reports api object and fields that's all what I want to know, it will be all sorted. Please help out on this. Sorry for the inconvenience.
By the way I am new to stripe.
tulip steeple
Two shoes provided APIs that return these objects. These are not table and field names. This data is something you will need to get from our financial reporting and isn't something I can advise on here.
wicked void
umm that'swhat I am confused about, which api to use, by the way I have extracted data using most of the api's , data which I got through api was not matching with dashboard's data that's why I am seeking for the help, Two shoes helped me in this way
tulip steeple
New customers , Spend per customer, MRR
These are the things I don't think you can get via the API. Some of the reporting done on the Stripe Dashboard is custom to the dashboard. The only way to replicate it would be to download the raw data in the Financial Reports (https://stripe.com/docs/reports) and calculate it yourself
wicked void
Oh now I understood. Now, can you please tell me if I can get the custom report's data via reporting api?
tulip steeple
You can review all the data we have available for reporting in our docs as well as how to configure them: https://stripe.com/docs/reports/select-a-report
wicked void
Ok, I have used this api code import stripe
stripe.api_key = "sk_test_ddrFSZe0iD64VHNuHJBigzS2"
stripe.reporting.ReportType.retrieve(
"balance.summary.1",
)
it will provide this
{
"id": "balance.summary.1",
"object": "reporting.report_type",
"data_available_end": 1680782400,
"data_available_start": 1503446400,
"default_columns": [
"category",
"description",
"net_amount",
"currency"
],
"livemode": true,
"name": "Balance summary",
"updated": 1680800615,
"version": 1
}
what does it mean?
does it mean use these columns "default_columns": [
"category",
"description",
"net_amount",
"currency" to get this report?
tulip steeple
That means your report has started running and the parameters returned are the ones that will be used (since you didn't specify anything
Stripe will use webhook events to notify you of when your report is ready to be downloaded: https://stripe.com/docs/reports/api#notification-of-report-run-completion
wicked void
Thank you, I'll try all of these to get the desired data. Thank you to both of you.
tulip steeple
I hope you are able to find everything. you need. If you want to discuss reporting with people who are more knowledgable about how Stripe builds those reports you can reach out to Support: https://support.stripe.com/?contact=true
wicked void
Great!, thanks.
tulip steeple
Happy to help 🙂