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 tableDescription
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" )Related functions
Other functions related to SparkPost.GetList are:
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy