#nishanth-reporting

1 messages · Page 1 of 1 (latest)

prime oxide
#

Creating a new thread as there wasn't much in that thread. We did recommend talking to support, it's not the kind of things we help with on this Discord server

modest ravine
#

I think you misunderstood my requirement

#

I contacted the support but looks like they couldn't provide much help.

prime oxide
#

My understanding was that you were looking for a report that has a certain list of columns that you care about. This isn't really a coding question and it's not something we can help with

modest ravine
#

The above is the example of the file which my colleague downloads from the Stripe portal manually every time. We want to automate this so I am looking for an API which would provide me the above csv(which is downloaded from Stripe portal)

📎 Stripe_Dec_export.csv
prime oxide
#

there's no API that gives you the CSV. You have to write the whole code and reconciliation yourself

modest ravine
#

I believe there would be an API endpoint to fetch the csv ?

prime oxide
#

We have some reports in the API, it's all documented in details here https://stripe.com/docs/reports/api but I don't think yours is one of them
But unfortunately, my team never touches reports, we can not help you with this here and you will need to talk to our support team for help

modest ravine
#

Yeah I searched all the reports in the API docs but didn't find the one I am looking for

#

Is there any other technical team who can help me with this?
Because the support team provided me an API which is not what I am looking for!

prime oxide
#

We can't really write this for you or anything. My point is: if you want a pre-built report you have to use the API I linked above, and none will match what you're after.
So knowing that, the only way to get that kind of information is to write your own code and build your own CSV reports end to end

#

Does that make sense?

modest ravine
#

My point is : when Stripe is providing a pre-built report on its portal that can be downloaded, why is it so that there is no API available for the Developers for the same functionality?

#

Hope you got my point!

prime oxide
#

Because there are numerous exports and we don't want to maintain them all in the API. It's just a decision we made.

#

Do you feel unblocked? I don't want to archive too quickly, but if you are mostly trying to get that CSV in the API, the answer really is that you can't

modest ravine
#

Not unblocked but I'm looking for an alternative as to where to fetch all the required data to build my own csv

prime oxide
modest ravine
#

Okay, there is no destination/ connect_account in the Charge object?

prime oxide
#

there is?

#

the concept of "destination" is split into two concepts: who is the "merchant of record" (on_behalf_of) and "who is receiving funds" (transfer_data[destination])

#

@tidal trellis is taking over for me if you have follow up questions and they can help!

modest ravine
#

okay, could you please keep this thread open so I can ask questions I may get?

tidal trellis
#

👋 sure thing - let me know if you hit any snags 🙂

modest ravine
#

When I try to get a list of all charges, I am always getting exactly 10 records. How do I get all of them?

rustic oxide
#

Hi 👋

modest ravine
#

Hi @rustic oxide

rustic oxide
#

Stripe limits list requests to 10 by default

#

You can specify a limit parameter up to 100.

modest ravine
#

For above 100?

rustic oxide
#

We have a method for auto-paging through responses

modest ravine
#

I mean how do I get the 101th record if there are 500 records in the list

rustic oxide