Stripe.Contents

Updated on

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

Syntax

Stripe.Contents(
   method as text,
   optional query as nullable record,
   optional pageLimit as nullable number,
) as table

Description

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.

Examples

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:

BI Gorilla Blog

Contribute » | Contributors: Rick de Groot