let Source = Json.Document(Web.Contents("https://platform-test.citysourced.net/powerbi/servicerequests.ashx")), Results = Source[Results], #"Converted to Table" = Table.FromList(Results, Splitter.SplitByNothing(), null, null, ExtraValues.Error), #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"Id", "IdAsString", "DateCreated", "DateCreatedDateOnly", "DateReported", "DateUpdated", "DateClosed", "ApiVersion", "AppVersion", "AppType", "CustomerId", "AuthorId", "AuthorName", "AuthorIsAnonymous", "CreatedById", "MobileDeviceId", "ExternalAppId", "AssignedUserId", "IntegrationId", "DuplicateId", "DeviceId", "DeviceType", "DeviceModel", "RequestType", "RequestTypeId", "Description", "ImageUrl", "UrlImageXSmall", "UrlImageXLarge", "Latitude", "Longitude", "Geocoding", "GeocodedAddress", "UserEnteredAddress", "ApproximateAddress", "FormattedAddress", "InitialBoundaryName", "LatLngGeoPoint", "LocaleType", "StatusType", "IsDuplicate", "IsClosed", "TimeToCloseInMin", "HasBeenEscalated", "IsEscalated", "DateEscalated", "HasBeenProcessed", "IsPrivate", "IsTest", "IsDisabled", "TotalAttachments", "TotalMedias", "TotalComments", "TotalVotes", "KeyValuePairs", "ReportItems", "ReportItemIds", "Boundaries", "CSATScore"}, {"Column1.Id", "Column1.IdAsString", "Column1.DateCreated", "Column1.DateCreatedDateOnly", "Column1.DateReported", "Column1.DateUpdated", "Column1.DateClosed", "Column1.ApiVersion", "Column1.AppVersion", "Column1.AppType", "Column1.CustomerId", "Column1.AuthorId", "Column1.AuthorName", "Column1.AuthorIsAnonymous", "Column1.CreatedById", "Column1.MobileDeviceId", "Column1.ExternalAppId", "Column1.AssignedUserId", "Column1.IntegrationId", "Column1.DuplicateId", "Column1.DeviceId", "Column1.DeviceType", "Column1.DeviceModel", "Column1.RequestType", "Column1.RequestTypeId", "Column1.Description", "Column1.ImageUrl", "Column1.UrlImageXSmall", "Column1.UrlImageXLarge", "Column1.Latitude", "Column1.Longitude", "Column1.Geocoding", "Column1.GeocodedAddress", "Column1.UserEnteredAddress", "Column1.ApproximateAddress", "Column1.FormattedAddress", "Column1.InitialBoundaryName", "Column1.LatLngGeoPoint", "Column1.LocaleType", "Column1.StatusType", "Column1.IsDuplicate", "Column1.IsClosed", "Column1.TimeToCloseInMin", "Column1.HasBeenEscalated", "Column1.IsEscalated", "Column1.DateEscalated", "Column1.HasBeenProcessed", "Column1.IsPrivate", "Column1.IsTest", "Column1.IsDisabled", "Column1.TotalAttachments", "Column1.TotalMedias", "Column1.TotalComments", "Column1.TotalVotes", "Column1.KeyValuePairs", "Column1.ReportItems", "Column1.ReportItemIds", "Column1.Boundaries", "Column1.CSATScore"}) in #"Expanded Column1"