#sriram_code

1 messages · Page 1 of 1 (latest)

steady zincBOT
#

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

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

Below are links to other discussions we've had with you in the past week in case you want to review that information. If your question is related to one of these previous discussions, please provide a comprehensive summary of the current state and what you need help with now. We help many users simultaneously, so a summary allows us to resolve your issue as soon as possible.

toxic gull
#

hi there, I just want to acknowledge your question. I am attending to other threads but will get to yours soon

ashen relic
#

thank you

toxic gull
#

thanks for waiting. I do want to first share that this is a public channel to help developers that's building integration with Stripe. We generally can't help with troubleshooting SQL queries.
That said, the connected_account_invoices data table does have the account data column based on our schema: https://docs.stripe.com/stripe-data/schema

ashen relic
#

yes, thats correct

#

for some reason though, the 'Husky Mobile' account (the one I mentioned in my message before) is showing up in the 'Connected Accounts' table list. But when I query the invoices, it doesn't come up unless i query it directly.

#

I am not sure what configuration has lead to this behaviour, if you can help in any way, that'd be wonderful.

#

All the other ones which are 'Enabled' are showing up correctly in the 'connected_account_invoices' query table.

toxic gull
#

sorry I am not quite understanding what you meant by " it doesn't come up unless i query it directly." because we can't see our users' Sigma search results,

#

as a start, what invoice belonging to acct_1RH96xG3tSOrGOwB were you looking up?

ashen relic
#

You can ignore the date range or remove it. One example of an invoice i am looking for - in_1RsWSMG3tSOrGOwB8pVZkpBN

📎 message.txt
toxic gull
#

could you provide me an invoice ID that belongs to a connected account that's queryable?

ashen relic
#

yup, one second

#

in_1RuzYFL3aWlYHnb4BDDAXvbU

#

For some reason, even though the previous invoice number is from the query, it says invoice doesn't exist for me. Not sure if its the same for you.

toxic gull
#

do you mean in_1S2k4KL3aWlYHnb4Lgbjmcsy return in your qeury when you look up connected_account_invoices ?

ashen relic
#

yup, thats correct

toxic gull
#

in_1S2k4KL3aWlYHnb4Lgbjmcsy is an invoice for a subscription.

#

but in_1RsWSMG3tSOrGOwB8pVZkpBN is an invoice for a one-time, created because the underlying Checkout Sessions is configured to create the invoice post-payment

ashen relic
#

ok

#

Can you please tell me - why this - https://dashboard.stripe.com/acct_1REFvuLPlbLBJpud/connect/accounts/acct_1RH96xG3tSOrGOwB/invoices/in_1S2CjZG3tSOrGOwBSAXsOUnw - would not show up in my query -

WITH invoice_fees AS (SELECT ci.id                                                     AS invoice_id,
                             SUM(decimalize_amount_no_display(bt.currency, bt.fee, 2)) AS stripe_fee
                      FROM connected_account_invoices ci
                               JOIN connected_account_balance_transactions bt ON ci.id = bt.source_id
                      WHERE bt.reporting_category = 'fee'
                      GROUP BY ci.id)

maybe there's something wrong in my query ?

#

I am sorry that I am taking your time when the problem might be on my side actually.

toxic gull
#

in_1S2CjZG3tSOrGOwBSAXsOUnw is from a one-time payment just like in_1RsWSMG3tSOrGOwB8pVZkpBN. It could be that connected_account_invoices does not capture invoices from one-time payments from Stripe Checkout sessions, but you would need to contact Stripe Support to confirm, or make a feature request

ashen relic
#

Got it.

#

Thank you so much for your help. I'll investigate this further.