harsh_api | Stripe Developers | Page 1

valid spireBOT Dec 20, 2024, 9:24 AM

#

👋 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/1319596290828664884

📝 Have more to share? Add more details, code, screenshots, videos, etc. below.

#

shut raptor Dec 20, 2024, 9:25 AM

#

👋
I invite you to walk through this guide in order to check all available reports via Stripe APIs:
https://docs.stripe.com/reports

#

https://docs.stripe.com/reports/balance

dry lava Dec 20, 2024, 9:35 AM

#

okay i will try it.

dry lava Dec 20, 2024, 9:56 AM

#

i did not get report as my expectetion

shut raptor Dec 20, 2024, 9:58 AM

#

Great! Happy to help!

dry lava Dec 20, 2024, 10:09 AM

#

yes

#

I want to create same as stripe balance sammary report using api
https://dashboard.stripe.com/test/reports/balance?startDate=2024-12-16&endDate=2024-12-17&currency=usd&templateType=merchant&timezone=Etc%2FUTC

with all details and also i want metadata in this list

shut raptor Dec 20, 2024, 10:12 AM

#

Metadata should be included in the report API.

#

https://docs.stripe.com/reports/balance#schema-balance-change-from-activity-itemized-3

dry lava Dec 20, 2024, 10:19 AM

#

above as you given link working "stripe/stripe-php": "^10.0",

valid spireBOT Dec 20, 2024, 10:25 AM

#

wet lily Dec 20, 2024, 10:30 AM

#

hi! I'm taking over this thread.

#

what's your question?

dry lava Dec 20, 2024, 10:53 AM

#

I want to create same as stripe balance sammary report using api
https://dashboard.stripe.com/test/reports/balance?startDate=2024-12-16&endDate=2024-12-17&currency=usd&templateType=merchant&timezone=Etc%2FUTC

i have use this api $response = \Stripe\BalanceTransaction::all($params);
but i get differense in balance sammary report and api report , few amount count is missing.
i thing, is there any bug in stripe balance sammary report or in API \Stripe\BalanceTransaction::all($params);

$response = \Stripe\BalanceTransaction::all($params);
$all_transactions = array_merge($all_transactions, $response->data);

            $has_more = $response->has_more;
            if ($has_more) {
                $starting_after = end($response->data)->id;
            }

Stripe Login | Sign in to the Stripe Dashboard

Sign in to the Stripe Dashboard to manage business payments and operations in your account. Manage payments and refunds, respond to disputes and more.

wet lily Dec 20, 2024, 10:55 AM

#

I want to create same as stripe balance sammary report
why not directly use the balance summary report?

dry lava Dec 20, 2024, 11:08 AM

#

base on mata-data i need to my project platform wise separate data.

wet lily Dec 20, 2024, 11:13 AM

#

I don't understand, sorry.

#

can you explain with more details the issue?

dry lava Dec 20, 2024, 11:18 AM

#

in my stripe account, i do get transactions for my multiple platforms.
from that based on meta-data I need to create platform wise separate balance summary report.

wet lily Dec 20, 2024, 11:52 AM

#

I don't really understand your use case. but if you need to retrieve all balance transaction, then you have to use this endpoint: https://docs.stripe.com/api/balance_transactions/list

dry lava Dec 20, 2024, 11:55 AM

#

yes, already I use that endpoint. but i did not get right data.

#

its miss match with stripe balance summary report.

wet lily Dec 20, 2024, 11:58 AM

#

can you clarify exactly what is the issue with this endpoint? which data is "not right"?

valid spireBOT Dec 20, 2024, 11:59 AM

#

dry lava Dec 20, 2024, 12:09 PM

#

yes

#

in stripe
https://dashboard.stripe.com/test/reports/balance?startDate=2024-12-16&endDate=2024-12-17&currency=usd&templateType=merchant&timezone=Etc%2FUTC
base on filter bellow data get.
Charges:309 (count 7 )
Fees:11.07
Refunds:-2300 (count 8 )
transfer:-660.19 (count 17 )
Total:-2655.19

use this endpoint: https://docs.stripe.com/api/balance_transactions/list
bellow data I get with same date.
\Stripe\BalanceTransaction::all($params);

Charges:304 (count 5 )
Fees:10.32
Refunds:-2299 (count 7 )
transfer:-660.19 (count 17)
Total:-2655.19

tropic snow Dec 20, 2024, 12:19 PM

#

Hi! I'm taking over from my colleague. Please, give me a moment to catch up.

dry lava Dec 20, 2024, 12:20 PM

#

in stripe
https://dashboard.stripe.com/test/reports/balance?startDate=2024-12-16&endDate=2024-12-17&currency=usd&templateType=merchant&timezone=Etc%2FUTC
base on filter bellow data get.
Charges:309 (count 7 )
Fees:11.07
Refunds:-2300 (count 8 )
transfer:-660.19 (count 17 )
Total:-2655.19

use this endpoint: https://docs.stripe.com/api/balance_transactions/list
bellow data I get with same date.
\Stripe\BalanceTransaction::all($params);

Charges:304 (count 5 )
Fees:10.32
Refunds:-2299 (count 7 )
transfer:-660.19 (count 17)
Total:-2655.19

#

I want to create same as stripe balance sammary report using api
https://dashboard.stripe.com/test/reports/balance?startDate=2024-12-16&endDate=2024-12-17&currency=usd&templateType=merchant&timezone=Etc%2FUTC

i have use this api $response = \Stripe\BalanceTransaction::all($params);
but i get differense in balance sammary report and api report , few amount count is missing.
i thing, is there any bug in stripe balance sammary report or in API \Stripe\BalanceTransaction::all($params);

$response = \Stripe\BalanceTransaction::all($params);
$all_transactions = array_merge($all_transactions, $response->data);

            $has_more = $response->has_more;
            if ($has_more) {
                $starting_after = end($response->data)->id;
            }

tropic snow Dec 20, 2024, 12:22 PM

#

Could you please share the Request ID req_xxx? https://support.stripe.com/questions/finding-the-id-for-an-api-request

dry lava Dec 20, 2024, 12:37 PM

#

i use $response = \Stripe\BalanceTransaction::all($params);

#

date wide data

#

so how to get Request ID req_xxx?

tropic snow Dec 20, 2024, 12:39 PM

#

https://support.stripe.com/questions/finding-the-id-for-an-api-request

dry lava Dec 20, 2024, 12:42 PM

#

req_0vtiFPpBbVEqig

#

req_spDzro0Eguhy3Q

tropic snow Dec 20, 2024, 12:46 PM

#

Due to timezone issues the timeframe in the Dashboard and the API request might be slightly different, which results in more Charges in the Dashboard. But I don't think the data is incorrect in any case.

#

Feel free to compare the IDs you get from each result.

dry lava Dec 20, 2024, 12:47 PM

#

in stripe
https://dashboard.stripe.com/test/reports/balance?startDate=2024-12-16&endDate=2024-12-17&currency=usd&templateType=merchant&timezone=Etc%2FUTC
base on filter bellow data get.
Charges:309 (count 7 )
Fees:11.07
Refunds:-2300 (count 8 )
transfer:-660.19 (count 17 )
Total:-2655.19

use this endpoint: https://docs.stripe.com/api/balance_transactions/list
bellow data I get with same date.
\Stripe\BalanceTransaction::all($params);

Charges:304 (count 5 )
Fees:10.32
Refunds:-2299 (count 7 )
transfer:-660.19 (count 17)
Total:-2655.19

#

ALSO i use UTC timezone.

tropic snow Dec 20, 2024, 12:49 PM

#

created: {
    gte: "1734310800",
    lte: "1734440399",
  },

gte is 2024-12-16 01:00:00 not 00:00

#

And lte is 12:59:59, while in the Dashboard it's probably 23:59

dry lava Dec 20, 2024, 1:01 PM

#

can we get metadata in this use this endpoint: https://docs.stripe.com/api/balance_transactions/list \Stripe\BalanceTransaction::all($params);

tropic snow Dec 20, 2024, 1:03 PM

#

It must include metadata already, is it not the case?

dry lava Dec 20, 2024, 1:05 PM

#

i did not get it

📎 message.txt

tropic snow Dec 20, 2024, 1:15 PM

#

Sorry, Balance Transactions actually don't have metadata: https://docs.stripe.com/api/balance_transactions/object
Are you looking for metadata on Charges? Or PaymentIntents?

dry lava Dec 20, 2024, 1:25 PM

#

Charges, refund and transfer

valid spireBOT Dec 20, 2024, 1:27 PM

#

rich island Dec 20, 2024, 1:29 PM

#

Then you need to expand the source field on the Balance Transaction to get the related field(s)

The Balance Transaction object | Stripe API Reference

Complete reference documentation for the Stripe API. Includes code snippets and examples for our Python, Java, PHP, Node.js, Go, Ruby, and .NET libraries.

#harsh_api