Mashup Container Profile parses JSON incorrectly in some cases

RuiRomano / pbigtwmonitor

MIT License

84 stars 30 forks source link

Mashup Container Profile parses JSON incorrectly in some cases #16

Open filcuk opened 2 days ago

filcuk commented 2 days ago

Applies to/tested on: Gateway Monitor - FromDisk Example:

The quick and dirty workaround for this one was changing the step to:

= Table.AddColumn(#"Expanded Custom", "JsonText", each "[{" & Text.Trim(Text.Replace(Text.Combine(List.Skip(Lines.FromBinary([Content]),7)),"}","}"), ",") & "")

File in question attached (don't believe this contains anything confidential) MashupContainerProfiles.log

Excellent project, by the way; thank you for sharing!

filcuk commented 2 days ago

This appears to be more of a universal fix, at least on the files I've tried:

= Table.AddColumn(#"Expanded Custom", "JsonText", each "[" & Text.AfterDelimiter(Text.Trim(Text.Replace(Text.Combine(List.Skip(Lines.FromBinary([Content]),0)),"}","}"), ",") & "", "["))

Instead of skipping first x rows (inconsistent), get start of json by bracket
Remove the additional comma behind curly brackets (still not a good fix, may be dependent on line breaks/formatting)