Error Import many JSON from folder

[orghn]

Hi, I have many JSONs in a folder an I need to combine and transform with power query.

The issue is that the JSONs have different date ranges, so when I try to Export all the JSONs from a folder, it gives me an error.

This are 2 sample files:

https://www.dropbox.com/s/ubg8xfa6vuqef8d/out_nuevog1.json?dl=0

https://www.dropbox.com/s/voo3mlycf6ui22w/out_nuevog2.json?dl=0

[lbendlin]

Combining the files is the easy part

let
    Source = Folder.Files("C:\Users\xxx\Downloads"),
    #"Filtered Rows" = Table.SelectRows(Source, each Text.StartsWith([Name], "out_n")),
    #"Removed Other Columns" = Table.SelectColumns(#"Filtered Rows",{"Content", "Name"}),
    #"Added Custom" = Table.AddColumn(#"Removed Other Columns", "Custom", each Record.ToTable(Json.Document([Content],1252))),
    #"Expanded Custom" = Table.ExpandTableColumn(#"Added Custom", "Custom", {"Name", "Value"}, {"Name.1", "Value"})
in
    #"Expanded Custom"

But then you have to decide how to parse the JSON - that is something you need to do before you can continue.