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
SparkPost.GetList( Path as text ) as table
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.
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: