AzureEnterprise.Contents

AzureEnterprise.Contents
Enter the URL of the Azure Enterprise REST API endpoint associated with your enrollment
function (url as text, optional query as nullable record) as binary
Description
Returns the binary results of the call to the url provided for the Azure Enterprise API.
Category
Accessing data
Examples
Using the AzureEnterprise.Contents function to return the results of a specific report.
        let
            report = Table.FromColumns({Lines.FromBinary(Binary.Buffer(AzureEnterprise.Contents("https://ea.azure.com/rest/12345/usage-report", [month="2014-04", type="summary", fmt="Csv"])),null,null,1252)}),
            skips = Table.Skip(report, 2),
            split =  Table.SplitColumn(skips, "Column1", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv)),
            promoted = Table.PromoteHeaders(split)
        in
            promoted
Table

Azure Enterprise

AzureEnterprise.Tables

Last modified 4yr ago