#stripeuser_96421
sinful coral
eternal lichen
the API returns JSON and you could write code to convert that into any format you other systems might need. Depends on the specific use case.
wheat moth
How does report run works ? can it be used for this usecase?
I want the complete data at once in a file format
eternal lichen
it works as described in https://stripe.com/docs/reports/api ; you call the API to ask for a certain report with certain columns, when the report is ready we send you a webhook and you can then download the results of report (which is a CSV).
eternal lichen
depends what you mean
there are specific reports of different types, and each type has certain columns it can return
it's all described in details in the docs linked above e.g. https://stripe.com/docs/reports/report-types#report-types
wheat moth
suppose I want all the balance transaction created today
so, can we generate all the fields which a balance-transaction api returns?
eternal lichen
well take a step back, why do you want that and what would you do with that information
the point of the report API is to give you reports that solve higher level problems
if you just wanted the list of todays BTs, that's just a simple API call on /v1/balance_transactions.
But likely what you want is something more like https://stripe.com/docs/reports/report-types#schema-balance-change-from-activity-itemized-1 , which can then be used by your accounts team etc, right?
wheat moth
okay, already explained in the previous thread which got closed . I am using APIGEE to call the balance transaction api and since it return huge data and in paginated form, I don't want to call it multiple times and want to get the records in a file which I can fetch from apigee easily.
eternal lichen
I don't know what Apigee is sorry.
wheat moth
you can think of an integration layer
eternal lichen
, I don't want to call it multiple times
I mean you have to, that's how our API works, you get 100 items at a time, and then make more requests to get the rest of the data
wheat moth
forget about apigee
eternal lichen
that's just how it works
wheat moth
yes but if the data is huge let's say 30K , I have to make 300 calls .
eternal lichen
so? 300 calls is nothing really
Ultimately in your integration layer you either call the /v1/balance_transactions API and paginate all relevant results(our SDK libraries abstract that for you with helper functions); or you can look at the available reports and see if they give you the information you need, and integrate with those. Not sure what else I can say.