I keep getting this error when I try to get my json file. There is no authentication on the file and your are welcome to try it.
Any hints on how to fix this is appreciated.
let
Source = Json.Document(Web.Contents("https://demo2.fischerkerrn.com/ReportingService/api/config")),
#"Converted to Table" = Table.FromRecords({Source}),
#"Expanded ?xml" = Table.ExpandRecordColumn(#"Converted to Table", "?xml", {"@version", "@encoding"}, {"?xml.@version", "?xml.@encoding"}),
#"Expanded Piccolo" = Table.ExpandRecordColumn(#"Expanded ?xml", "Piccolo", {"@SchemaVersion", "@xmlns:xsi", "@xsi:noNamespaceSchemaLocation", "PiccoloConfig"}, {"Piccolo.@SchemaVersion", "Piccolo.@xmlns:xsi", "Piccolo.@xsi:noNamespaceSchemaLocation", "Piccolo.PiccoloConfig"}),
#"Expanded Piccolo.PiccoloConfig" = Table.ExpandRecordColumn(#"Expanded Piccolo", "Piccolo.PiccoloConfig", {"Settings", "Sites"}, {"Piccolo.PiccoloConfig.Settings", "Piccolo.PiccoloConfig.Sites"}),
#"Expanded Piccolo.PiccoloConfig.Settings" = Table.ExpandRecordColumn(#"Expanded Piccolo.PiccoloConfig", "Piccolo.PiccoloConfig.Settings", {"OrganizationName", "AccountNumbers", "Client", "Forms", "Reports", "CustomPropertyDefinitions", "ResourceCategories", "MeetingRules", "InternalDomains", "AccountingDialogDefinition"}, {"Piccolo.PiccoloConfig.Settings.OrganizationName", "Piccolo.PiccoloConfig.Settings.AccountNumbers", "Piccolo.PiccoloConfig.Settings.Client", "Piccolo.PiccoloConfig.Settings.Forms", "Piccolo.PiccoloConfig.Settings.Reports", "Piccolo.PiccoloConfig.Settings.CustomPropertyDefinitions", "Piccolo.PiccoloConfig.Settings.ResourceCategories", "Piccolo.PiccoloConfig.Settings.MeetingRules", "Piccolo.PiccoloConfig.Settings.InternalDomains", "Piccolo.PiccoloConfig.Settings.AccountingDialogDefinition"}),
#"Expanded Piccolo.PiccoloConfig.Settings.Client" = Table.ExpandRecordColumn(#"Expanded Piccolo.PiccoloConfig.Settings", "Piccolo.PiccoloConfig.Settings.Client", {"SaveAsCustomAppointmentClass", "CustomAppointmentClass", "HandleClasses", "SharedRepository", "TitleGeneration", "UILanguage", "PropertyTagForSiteIdentification"}, {"Piccolo.PiccoloConfig.Settings.Client.SaveAsCustomAppointmentClass", "Piccolo.PiccoloConfig.Settings.Client.CustomAppointmentClass", "Piccolo.PiccoloConfig.Settings.Client.HandleClasses", "Piccolo.PiccoloConfig.Settings.Client.SharedRepository", "Piccolo.PiccoloConfig.Settings.Client.TitleGeneration", "Piccolo.PiccoloConfig.Settings.Client.UILanguage", "Piccolo.PiccoloConfig.Settings.Client.PropertyTagForSiteIdentification"}),
#"Expanded Piccolo.PiccoloConfig.Settings.Client.HandleClasses" = Table.ExpandRecordColumn(#"Expanded Piccolo.PiccoloConfig.Settings.Client", "Piccolo.PiccoloConfig.Settings.Client.HandleClasses", {"ClassName"}, {"Piccolo.PiccoloConfig.Settings.Client.HandleClasses.ClassName"}),
#"Expanded Piccolo.PiccoloConfig.Settings.Client.SharedRepository" = Table.ExpandRecordColumn(#"Expanded Piccolo.PiccoloConfig.Settings.Client.HandleClasses", "Piccolo.PiccoloConfig.Settings.Client.SharedRepository", {"@Type", "@UseSharedRepository", "@Url", "CommonName", "Email", "EntryID", "StoreID", "DomainAccount"}, {"Piccolo.PiccoloConfig.Settings.Client.SharedRepository.@Type", "Piccolo.PiccoloConfig.Settings.Client.SharedRepository.@UseSharedRepository", "Piccolo.PiccoloConfig.Settings.Client.SharedRepository.@Url", "Piccolo.PiccoloConfig.Settings.Client.SharedRepository.CommonName", "Piccolo.PiccoloConfig.Settings.Client.SharedRepository.Email", "Piccolo.PiccoloConfig.Settings.Client.SharedRepository.EntryID", "Piccolo.PiccoloConfig.Settings.Client.SharedRepository.StoreID", "Piccolo.PiccoloConfig.Settings.Client.SharedRepository.DomainAccount"}),
#"Expanded Piccolo.PiccoloConfig.Settings.Client.TitleGeneration" = Table.ExpandRecordColumn(#"Expanded Piccolo.PiccoloConfig.Settings.Client.SharedRepository", "Piccolo.PiccoloConfig.Settings.Client.TitleGeneration", {"@TitleUpdateMethod", "DefaultTitleText"}, {"Piccolo.PiccoloConfig.Settings.Client.TitleGeneration.@TitleUpdateMethod", "Piccolo.PiccoloConfig.Settings.Client.TitleGeneration.DefaultTitleText"}),
#"Expanded Piccolo.PiccoloConfig.Settings.Forms" = Table.ExpandRecordColumn(#"Expanded Piccolo.PiccoloConfig.Settings.Client.TitleGeneration", "Piccolo.PiccoloConfig.Settings.Forms", {"Form"}, {"Piccolo.PiccoloConfig.Settings.Forms.Form"}),
#"Expanded Piccolo.PiccoloConfig.Settings.Forms.Form" = Table.ExpandRecordColumn(#"Expanded Piccolo.PiccoloConfig.Settings.Forms", "Piccolo.PiccoloConfig.Settings.Forms.Form", {"@ClassName", "Stylesheets", "TabPositions"}, {"Piccolo.PiccoloConfig.Settings.Forms.Form.@ClassName", "Piccolo.PiccoloConfig.Settings.Forms.Form.Stylesheets", "Piccolo.PiccoloConfig.Settings.Forms.Form.TabPositions"}),
#"Expanded Piccolo.PiccoloConfig.Settings.Forms.Form.Stylesheets" = Table.ExpandRecordColumn(#"Expanded Piccolo.PiccoloConfig.Settings.Forms.Form", "Piccolo.PiccoloConfig.Settings.Forms.Form.Stylesheets", {"Stylesheet"}, {"Piccolo.PiccoloConfig.Settings.Forms.Form.Stylesheets.Stylesheet"}),
#"Expanded Piccolo.PiccoloConfig.Settings.Forms.Form.Stylesheets.Stylesheet" = Table.ExpandRecordColumn(#"Expanded Piccolo.PiccoloConfig.Settings.Forms.Form.Stylesheets", "Piccolo.PiccoloConfig.Settings.Forms.Form.Stylesheets.Stylesheet", {"@ID", "@Name", "Link"}, {"Piccolo.PiccoloConfig.Settings.Forms.Form.Stylesheets.Stylesheet.@ID", "Piccolo.PiccoloConfig.Settings.Forms.Form.Stylesheets.Stylesheet.@Name", "Piccolo.PiccoloConfig.Settings.Forms.Form.Stylesheets.Stylesheet.Link"}),
#"Expanded Piccolo.PiccoloConfig.Settings.Forms.Form.TabPositions" = Table.ExpandRecordColumn(#"Expanded Piccolo.PiccoloConfig.Settings.Forms.Form.Stylesheets.Stylesheet", "Piccolo.PiccoloConfig.Settings.Forms.Form.TabPositions", {"Tab"}, {"Piccolo.PiccoloConfig.Settings.Forms.Form.TabPositions.Tab"}),
#"Expanded Piccolo.PiccoloConfig.Settings.Forms.Form.TabPositions.Tab" = Table.ExpandRecordColumn(#"Expanded Piccolo.PiccoloConfig.Settings.Forms.Form.TabPositions", "Piccolo.PiccoloConfig.Settings.Forms.Form.TabPositions.Tab", {"@Position", "#text"}, {"Piccolo.PiccoloConfig.Settings.Forms.Form.TabPositions.Tab.@Position", "Piccolo.PiccoloConfig.Settings.Forms.Form.TabPositions.Tab.#text"}),
#"Expanded Piccolo.PiccoloConfig.Settings.Reports" = Table.ExpandRecordColumn(#"Expanded Piccolo.PiccoloConfig.Settings.Forms.Form.TabPositions.Tab", "Piccolo.PiccoloConfig.Settings.Reports", {"Report"}, {"Piccolo.PiccoloConfig.Settings.Reports.Report"}),
#"Expanded Piccolo.PiccoloConfig.Settings.CustomPropertyDefinitions" = Table.ExpandRecordColumn(#"Expanded Piccolo.PiccoloConfig.Settings.Reports", "Piccolo.PiccoloConfig.Settings.CustomPropertyDefinitions", {"Property"}, {"Piccolo.PiccoloConfig.Settings.CustomPropertyDefinitions.Property"}),
#"Expanded Piccolo.PiccoloConfig.Settings.ResourceCategories" = Table.ExpandRecordColumn(#"Expanded Piccolo.PiccoloConfig.Settings.CustomPropertyDefinitions", "Piccolo.PiccoloConfig.Settings.ResourceCategories", {"Category"}, {"Piccolo.PiccoloConfig.Settings.ResourceCategories.Category"}),
#"Expanded Piccolo.PiccoloConfig.Settings.MeetingRules" = Table.ExpandRecordColumn(#"Expanded Piccolo.PiccoloConfig.Settings.ResourceCategories", "Piccolo.PiccoloConfig.Settings.MeetingRules", {"MeetingRule"}, {"Piccolo.PiccoloConfig.Settings.MeetingRules.MeetingRule"}),
#"Expanded Piccolo.PiccoloConfig.Settings.MeetingRules.MeetingRule" = Table.ExpandRecordColumn(#"Expanded Piccolo.PiccoloConfig.Settings.MeetingRules", "Piccolo.PiccoloConfig.Settings.MeetingRules.MeetingRule", {"@ID", "@Name", "@Description", "@Inactive", "@BuiltIn", "XPath", "Messages"}, {"Piccolo.PiccoloConfig.Settings.MeetingRules.MeetingRule.@ID", "Piccolo.PiccoloConfig.Settings.MeetingRules.MeetingRule.@Name", "Piccolo.PiccoloConfig.Settings.MeetingRules.MeetingRule.@Description", "Piccolo.PiccoloConfig.Settings.MeetingRules.MeetingRule.@Inactive", "Piccolo.PiccoloConfig.Settings.MeetingRules.MeetingRule.@BuiltIn", "Piccolo.PiccoloConfig.Settings.MeetingRules.MeetingRule.XPath", "Piccolo.PiccoloConfig.Settings.MeetingRules.MeetingRule.Messages"}),
#"Expanded Piccolo.PiccoloConfig.Settings.MeetingRules.MeetingRule.Messages" = Table.ExpandRecordColumn(#"Expanded Piccolo.PiccoloConfig.Settings.MeetingRules.MeetingRule", "Piccolo.PiccoloConfig.Settings.MeetingRules.MeetingRule.Messages", {"Message"}, {"Piccolo.PiccoloConfig.Settings.MeetingRules.MeetingRule.Messages.Message"}),
#"Expanded Piccolo.PiccoloConfig.Settings.MeetingRules.MeetingRule.Messages.Message" = Table.ExpandRecordColumn(#"Expanded Piccolo.PiccoloConfig.Settings.MeetingRules.MeetingRule.Messages", "Piccolo.PiccoloConfig.Settings.MeetingRules.MeetingRule.Messages.Message", {"@Language", "#text"}, {"Piccolo.PiccoloConfig.Settings.MeetingRules.MeetingRule.Messages.Message.@Language", "Piccolo.PiccoloConfig.Settings.MeetingRules.MeetingRule.Messages.Message.#text"}),
#"Expanded Piccolo.PiccoloConfig.Settings.InternalDomains" = Table.ExpandRecordColumn(#"Expanded Piccolo.PiccoloConfig.Settings.MeetingRules.MeetingRule.Messages.Message", "Piccolo.PiccoloConfig.Settings.InternalDomains", {"@UseForIsExternalEvaluation"}, {"Piccolo.PiccoloConfig.Settings.InternalDomains.@UseForIsExternalEvaluation"}),
#"Expanded Piccolo.PiccoloConfig.Settings.AccountingDialogDefinition" = Table.ExpandRecordColumn(#"Expanded Piccolo.PiccoloConfig.Settings.InternalDomains", "Piccolo.PiccoloConfig.Settings.AccountingDialogDefinition", {"SupportedLanguages", "AccountingFields"}, {"Piccolo.PiccoloConfig.Settings.AccountingDialogDefinition.SupportedLanguages", "Piccolo.PiccoloConfig.Settings.AccountingDialogDefinition.AccountingFields"}),
#"Expanded Piccolo.PiccoloConfig.Settings.AccountingDialogDefinition.SupportedLanguages" = Table.ExpandRecordColumn(#"Expanded Piccolo.PiccoloConfig.Settings.AccountingDialogDefinition", "Piccolo.PiccoloConfig.Settings.AccountingDialogDefinition.SupportedLanguages", {"LangID"}, {"Piccolo.PiccoloConfig.Settings.AccountingDialogDefinition.SupportedLanguages.LangID"}),
#"Expanded Piccolo.PiccoloConfig.Settings.AccountingDialogDefinition.SupportedLanguages.LangID" = Table.ExpandRecordColumn(#"Expanded Piccolo.PiccoloConfig.Settings.AccountingDialogDefinition.SupportedLanguages", "Piccolo.PiccoloConfig.Settings.AccountingDialogDefinition.SupportedLanguages.LangID", {"@Default", "#text"}, {"Piccolo.PiccoloConfig.Settings.AccountingDialogDefinition.SupportedLanguages.LangID.@Default", "Piccolo.PiccoloConfig.Settings.AccountingDialogDefinition.SupportedLanguages.LangID.#text"}),
#"Expanded Piccolo.PiccoloConfig.Settings.AccountingDialogDefinition.AccountingFields" = Table.ExpandRecordColumn(#"Expanded Piccolo.PiccoloConfig.Settings.AccountingDialogDefinition.SupportedLanguages.LangID", "Piccolo.PiccoloConfig.Settings.AccountingDialogDefinition.AccountingFields", {"@ValidationURL", "AccountingField"}, {"Piccolo.PiccoloConfig.Settings.AccountingDialogDefinition.AccountingFields.@ValidationURL", "Piccolo.PiccoloConfig.Settings.AccountingDialogDefinition.AccountingFields.AccountingField"}),
#"Expanded Piccolo.PiccoloConfig.Sites" = Table.ExpandRecordColumn(#"Expanded Piccolo.PiccoloConfig.Settings.AccountingDialogDefinition.AccountingFields", "Piccolo.PiccoloConfig.Sites", {"Site"}, {"Piccolo.PiccoloConfig.Sites.Site"})
in
#"Expanded Piccolo.PiccoloConfig.Sites"
