SparkPost.GetList

Updated on

SparkPost.GetList is a Power Query M function that can be used to call any of the “Lists” endpoints offered by the SparkPost API v1.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

SparkPost.GetList( Path as text ) as table

Description

This function can be used to call any of the “Lists” endpoints offered by the SparkPost API v1. When making calls to the SparkPost API using this function, keep in mind that the SparkPost API has a strict API rate limit. If you see a 429 status code being returned from the SparkPost server you have hit the rate limit and will need to wait a few moments before making more calls.

Examples

Returns a table with a single column populated with data from one of the SparkPost API v1 “Lists” endpoints ( see SparkPost documentation for details ).

// Output: Json.Document
Source = SparkPost.GetList( "metrics/campaigns" )

Other functions related to SparkPost.GetList are:

Contribute » | Contributors: Rick de Groot