let
Source= Json.Document(File.Contents(Excel.CurrentWorkbook(){[Name="Chemin"]}[Content][Column1]{0})),
items = Source[items],
#"Converted to Table" = Table.FromList(items, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"id", "folderId", "type", "name", "login"}, {"Column1.id", "Column1.folderId", "Column1.type", "Column1.name", "Column1.login"}),
#"Expanded Column1.login" = Table.ExpandRecordColumn(#"Expanded Column1", "Column1.login", {"username"}, {"Column1.login.username"})
in
#"Expanded Column1.login"
let
Source= Json.Document(File.Contents(Excel.CurrentWorkbook(){[Name="Chemin"]}[Content][Column1]{0})),
folders = Source[folders],
#"Converted to Table" = Table.FromList(folders, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"id", "name"}, {"Column1.id", "Column1.name"})
in
#"Expanded Column1"
let
Source= Json.Document(File.Contents(Excel.CurrentWorkbook(){[Name="Chemin"]}[Content][Column1]{0})),
items = Source[items],
#"Converted to Table" = Table.FromList(items, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"id", "login"}, {"Column1.id", "Column1.login"}),
#"Expanded Column1.login" = Table.ExpandRecordColumn(#"Expanded Column1", "Column1.login", {"uris"}, {"Column1.login.uris"}),
#"Expanded Column1.login.uris" = Table.ExpandListColumn(#"Expanded Column1.login", "Column1.login.uris"),
#"Expanded Column1.login.uris1" = Table.ExpandRecordColumn(#"Expanded Column1.login.uris", "Column1.login.uris", {"match", "uri"}, {"Column1.login.uris.match", "Column1.login.uris.uri"})
in
#"Expanded Column1.login.uris1"