#vaulk_api
upbeat talonBOT
👋 Welcome to your new thread!
⏲️ We'll be here soon! Typically we respond in a few minutes, but sometimes we might take a bit longer if the server is busy or if you have a particularly tricky question.
⏱️ We close idle threads, which makes them read-only. Once a thread is closed it won't be reopened, but you can always start a new thread if you have another question.
🔗 This thread will always be available, even after it's closed. You can find it again using Discord's search, or you can save this link: https://discord.com/channels/841573134531821608/1421179239780188301
📝 Have more to share? Add more details, code, screenshots, videos, etc. below.
gloomy jungle
I can see that it is grabbing everything else that I want, just not enough charges, so I am thinking I am not querying the right place
I want to essentially get all of the information that I would get from the balance summary sheet
cyan plinth
👋 looking into this for you. One moment will I look over the request you provided
gloomy jungle
The request I provided is successful
I could provide all the other ~11 that grab the rest
I want to utilize the API and grab all of the charges that show on the balance summary report without using the report api, as that times out my lambda often
The way I am doing it misses 500 charges that appear on the summary report
cyan plinth
We don't log get request responses. Do you have an example response you could share here of what you see when you make that request.
Do you have an example charge object that you've identified on the summary report that isn't showing in the balance transactions list
gloomy jungle
I guess its less about the response, as I am sure its correct
I am getting a response and utilizing pagination to loop over all of the charges it can find using that method
That is all good
But I am confused as to why the balance summary report shows 1768 charges and when I use that query, which I assume you can see only gives me 1268
cyan plinth
I'm mostly trying to identify a charge you were able to identify in you balance summary summary but not the list of balance transactions so I can dig into the discrepancy.
gloomy jungle
The query looks like this
{
"created": {
"gte": "1754006400",
"lte": "1756684799"
},
"expand": {
"0": "data.source",
"1": "data.source.charge"
},
"limit": "100",
"starting_after": "txn_3RrNONHrg8ins5Af1Uhe6W71",
"type": "charge"
}
Sure Ill grab that
cyan plinth
That's actually the challenge here is we don't log get request responses, so I can't actually see the outcome of req_LQnbwvRERARtxz just the request itself. Which looks fine.
gloomy jungle
Yeah I am getting a valid response
It is one of these 3 transactions, I can narrow it down further if needed
txn_3Rr6uAHrg8ins5Af1ll3Ftl3
txn_3Rr8rIHrg8ins5Af1Zg9KQvh
txn_3Rr8uNHrg8ins5Af1uYoNnP7
Well one of those 3 isn't being captured
That''s fun
LOL
rigid steeple
gloomy jungle
Let me change what is being captured and I can certainly figure out which is missing
upbeat talonBOT
gloomy jungle
Just saving txn IDs now so I can cross reference those
untold tangle
👋 stepping in as mossy needs to step away
Let me know if I can help but it sounds like you are tracking down examples that aren't appearing when you list Balance Transactions?
gloomy jungle
Ok currently we have been utilizing the reports API to generate the changes from activity balance summary report and this worked awesome. What didn't work awesome is that sometimes generating this report took longer than the lambda was allowed to be open.
So I am trying to retrieve the same data by querying the balance transaction api directly
Most of the data lines up but I am not getting 500 charges that appear on the report but not when I query directly for charges
untold tangle
Gotcha yeah if you provide examples of those Charges then I could look at why that might be happening. Otherwise you could always just retry the Reports API with a smaller timeframe if it times out.
gloomy jungle
The reports API can be really fast but I assume that at certain times of the day the Q is just longer
and regardless of when we set the lambda it will time out
untold tangle
Okay well yeah if you can provide Charge examples I could look and try to help.
untold tangle
Gotcha that looks to be a Link Charge so it is actually of type: 'payment'
A little confusing that there is a type: 'charge' and type: 'payment'
But if you List for both types then you should see those Balance Transactions appear.
untold tangle
Yes, the payment method type basically just determines the difference here.
gloomy jungle
Are there any others I should be aware of as well?
or would they just be charge and payment
untold tangle
You can see the full list here: https://docs.stripe.com/api/balance_transactions/object#balance_transaction_object-type but if you omit type the it will include all types.
In terms of Balance Transactions related to charging customers, those two are the only ones, if you don't care about things like refunds.