#vambat
daring panther
Are you trying to list all Charges after a certain date?
olive nimbusBOT
outer vault
I am trying to list all charges for a day - 04/05/2023 (time not included)
Trying to write an API Call to get all charges(transactions) from yesterday to Finance dept.
austere stream
Hi 👋
You can see all the options for listing charges here: https://stripe.com/docs/api/charges/list
I would recommend using the List API if the Search API isn't behaving as you expect
outer vault
Yes. I am trying both, List API call and Search API Call. I am having trouble with "created" parameter. In this case, i converted the today (datetime) to unixtimeseconds
long yesterdaySecs = ((DateTimeOffset)yesterday).ToUnixTimeSeconds();
long todaySecs = ((DateTimeOffset)today).ToUnixTimeSeconds();
var optionsList = new ChargeListOptions
{
Created = new DateRangeOptions
{
GreaterThanOrEqual = yesterdaySecs,
LessThan = todaySecs
}
};
it gives me 100 records from yesterday.
I have 2 issues - one with "created" and second one is limit.
Trying to automate the work to help Finance dept figure out yesterday's transactions so they can be acting on refunds asap
Stripe documentation does not say anything about limit > 100
austere stream
Our hard limit is 100. After that you need to paginate
And with created or other timestamps, make sure you convert your timestamps to UTC
outer vault
IS there a particular reason why Stripe is limiting the # of transactions?
austere stream
we don't limit the number of transactions. we limit the length of the lists of data we return and this has to do with reducing API timeout errors
outer vault
How come in the dashboard, I can get any number of rows using the filter (in the GUI) but not on API Call?
Is there any API Call that can bring back all rows for a day?
outer vault
We normally have few hundred transactions in a day during the peak season. So it is hard to paginate....
austere stream
Paginate your requests
outer vault
Sure. I will try the "Pagination". How about finance report?
austere stream
That is how every merchant who retrieves more than 100 records does it. We also allow programmatic generation and retrieval of Financial reports via the API
You can review that here: https://stripe.com/docs/api/reporting/report_type , with more details of how to set it up here: https://stripe.com/docs/reports/api
outer vault
Thanks a million for your help . I am pasting some lines from the stackoverflow her
here
Had a chat with Stripe staffs through online chat, and found that there is a way to get list of charges based on date range.
Stripe Charges API actually has some argument that are not yet listed in their documentation.
Arguments like created[lte] and created[gte] with Unix timestamp can be used, just like Events API call.
EG: https://api.stripe.com/v1/charges?created[gte]=1362171974&created[lte]=1362517574
I tried this thru postman and did not work.
Let me check the financial reports API and also pagination of the list. Thanks very much for your help. I appreciate it
Just a suggestion. I am new to Stripe. It will be great if there is an option to get a csv file (minimum fields) with one day's transactions ...
austere stream
WE have a number of itemized balance reports (which itemize all things impacting your account balace). E.g. https://stripe.com/docs/reports/report-types#schema-balance-change-from-activity-itemized-2
And using the API you can specify the interval of time you want the report to cover
outer vault
Awesome. I will try to work with this and see what I can do. I appreciate your help