Murali-sigma | Stripe Developers | Page 1

sharp sequoia Aug 4, 2022, 7:03 AM

#

👋 Happy to help

rotund atlas Aug 4, 2022, 7:04 AM

#

Hi River

sharp sequoia Aug 4, 2022, 7:05 AM

#

Sigma doesn't provide API, so it can only be done via dashboard

rotund atlas Aug 4, 2022, 7:05 AM

#

I am working on Stripe connect, Stripe issuing project.

#

I want to show some data on client app.

sharp sequoia Aug 4, 2022, 7:06 AM

#

What data do you want to show?

rotund atlas Aug 4, 2022, 7:07 AM

#

for example : I want to show total number cards that issued per that Stripe custom Connect account.

#

#

https://stripe.com/docs/api/issuing/cards/list

#

this API will only give max 100 records

#

if there are 1000 cards, I need to call API 10 times or else need to use for await approach.

sharp sequoia Aug 4, 2022, 7:11 AM

#

Stripe uses pagination for List Retrieval API and each request only returns 100 objects max: https://stripe.com/docs/api/pagination

#

If you are just going to display total number of the cards, I strongly do not recommend to use List Retrieval API

#

It's recommend to keep track of the card issued in your database

rotund atlas Aug 4, 2022, 7:13 AM

#

But why don't stripe give an option to know how many total records are present in the list

#

Even I keep track in my database, I need to query and get the total count right?

#

Does stripe have a solution from sigma to fill my requirement?

sharp sequoia Aug 4, 2022, 7:17 AM

#

When a card is issued, an issuing card ID (ic_xxx) will be returned, then you save the issuing card ID and its custom account

#

You can then query in your own database on the total amount of the card issued of the specific custom connected account

#

Sigma doesn't have API, so you can't get the data via API

rotund atlas Aug 4, 2022, 7:20 AM

#

sharp sequoia When a card is issued, an issuing card ID (`ic_xxx`) will be returned, then you ...

Got it

rotund atlas Aug 4, 2022, 7:21 AM

#

sharp sequoia Sigma doesn't have API, so you can't get the data via API

#

so are you saying we can not get that sigma reports data that we queried into an web-app to show to end user.

sharp sequoia Aug 4, 2022, 7:26 AM

#

You can get the data via Sigma, but this requires you to sync the data to your data pipeline such as Snowflake or Amazon Redshift, then you read the data from there: https://stripe.com/docs/stripe-data/access-data-in-warehouse

rotund atlas Aug 4, 2022, 8:50 AM

#

Ok thank you river, I will look into this, I will get help if I need anything.

#Murali-sigma