ArjunK | Stripe Developers | Page 1

hazy birchBOT Apr 7, 2023, 3:56 PM

#

fierce lion Apr 7, 2023, 3:56 PM

#

Hi 👋

What API? Are you using Stripe's Python package?

short widget Apr 7, 2023, 3:57 PM

#

def extract_data(api_data):
data_list = pd.DataFrame()
for item in api_data.auto_paging_iter():
flatten = pd.json_normalize(item, sep="_")
data_list = data_list.append(flatten, sort=True)
return data_list

#

yes, stripe python, above code will extract all the data but I don't need all

#

just need 1000 records

fierce lion Apr 7, 2023, 3:58 PM

#

What API?

#

We have all our endpoints listed here: https://stripe.com/docs/api

#

As well as code snippets in Python for how to retrieve list data

short widget Apr 7, 2023, 3:58 PM

#

stripe charges

#

df_charge = extract_data(stripe.Charge.list(limit=100))

#

I have already used just confused how to get only first 1000 records

fierce lion Apr 7, 2023, 4:03 PM

#

What do you mean by the "first 1000". Our List APIs return newest first records

#

For 1000 you will need to paginate the list response https://stripe.com/docs/api/pagination

short widget Apr 7, 2023, 4:42 PM

#

ok, but websitesite doesn't have example code.

fierce lion Apr 7, 2023, 4:44 PM

#

Pagination is a common topic in API interactions. You should be able to find plenty of examples on the web

#ArjunK