Forum Discussion

CR's avatar
CR
Resolver II
6 years ago
Solved

Properly load a JSON file from a folder as source

Hi guys,   I know how to load a JSON file ifself   let Source = Json.Document(File.Contents("\\...\refreshables.json")), #"Converted to Table" = Record.ToTable(Source), Value = #"Con...
Need Help
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    Your first two steps look correct, but the next should be a navigate step.  Do you see something like this at that step?

     

    If so, click on the word "Binary" which should open your file as a JSON type, and then you can use similar steps as your first query from there.

     

    If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

    Regards,

    Pat

v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

Hi CR ,

 

Is your JSON file located in a certain folder?

Do you want to use the 'Folder' connector to import and merge the files of the entire folder?

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

CR's avatar
CR
Resolver II
6 years ago

Hi v-lionel-msft ,

This is indeed  folder and containing about 20 csv files (no issue with them) and one json file (the one I'm talking about).

The load is fine now, it's just that I don't know how to convert the content to a clean table (as explained, I hope, in my last post).

 

Regards,

Camille

  • lbendlin's avatar
    lbendlin
    Super User
    6 years ago

    You're missing the step where you parse the JSON.  (You just imported it as a CSV).

     

    "I don't know how to convert the content to a clean table"

     

    That's not how JSON works.  It represents a hierarchy.  A table has no hierarchy.

     

    You can flatten the JSON in some cases to make it look like a (very inefficent) table, but in most cases you can only grab certain attributes from your JSON for further processing.