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
comScore API returned an error. Some reports may require special parameters. You can call these manually using the 'fullUrlString' ...
Failed to install dependency '{1}' to '{2}'.{0}Make sure '{3}' is accessible and contains the package '{1}' compatible with ...
let report = Table.FromColumns({Lines.FromBinary(Binary.Buffer(AzureEnterprise.Contents("https://ea.azure.com/rest/12345/usage-report", ...
let Source = AzureEnterprise.Tables("http://ea.azure.com/rest/12345"), Contents = Source{[Key="Contents"]}[Data in Contents ...
Makes a call to the MailChimp API and returns the resulting dataset as a table. Automatically pages through all results. ...
Makes a call to the Marketo REST API endpoint at url /rest/v1/activities.json. All activities in list activityIds that have ...
Makes a call to the Smartsheet 2.0 REST API at the specified endpoint and transforms the data element returned into a table. ...