Stripe.Contents is a Power Query M function that makes calls to the Stripe API, optionally limiting the number of API calls made. It returns the most recent data first and can return all data if no page limit is specified.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Stripe.Contents( method as text, optional query as nullable record, optional pageLimit as nullable number, ) as table
Makes a call to the Stripe API at https://api.stripe.com/v1/
method, with optional record
query passed as additional parameters and optional
pageLimit as a limit on the number of API requests. Most recent data is returned first. If
pageLimit is not specified, all data is returned. Stripe Version 2015-10-16 is used.
Returns all charges data
// Output: A table with all charges data for the current Stripe account Stripe.Contents( "charges" )
Returns one page of charges data
// Output: A table with the most recent charges data for the current Stripe account Stripe.Contents( "charges", , 1 )
Other functions related to Stripe.Contents are: