AzureEnterprise.Contents

AzureEnterprise.Contents(url as text,optional query as nullable record) as binary

返回调用为 Azure Enterprise API 提供的 URL 的二进制结果。

示例：

使用 AzureEnterprise.Contents 函数返回特定报表的结果。

使用情况：

    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

输出：

表