Beautify big one line JSON file

Question

I have one big json resulting file, something like this:

{'status': 200, 'result': [{'query': 'AL1 2RJ', 'result': {'postcode': 'AL1 2RJ', 'quality': 1, 'eastings': 514617, 'northings': 206084, 'country': 'England', 'nhs_ha': 'East of England', 'longitude': -0.341337, 'latitude': 51.741753, 'european_electoral_region': 'Eastern', 'prim ...

It goes on and on, what I need, is to have this somehow as a tree.

I've tried with underscore-cli

Then with this command: cat myfile.json | underscore print --color

It Throws me this: Error while parsing STDIN in mode 'lax': None is not defined

Any ideas on how to achieve this?

There's the online jsbeautifier.io and on Linux there's `json_pp` — Pointy, Nov 26 '18 at 15:41
If this is in javascript, there are countless npm modules that achieve this. Google 'prettify json' — Gilad Bar, Nov 26 '18 at 15:42
This is not valid JSON. In JSON string literals are enclosed in double quotes. Also, null values should be denoted with `null` instead of `None`. — blhsing, Nov 26 '18 at 15:44
@Alberto Maurice Meyer has already provided the link for your problem Have a look into it — front_end_dev, Nov 26 '18 at 15:46
Did you accidentally use `str(python_dictionary)` and get that confused with JSON? **Python syntax is not JSON**. Use the `json` module to produce actual JSON. — Martijn Pieters, Nov 26 '18 at 15:46

score 2 · Accepted Answer · answered Nov 26 '18 at 15:45

On python you can select the indentation on json.dumps like this:

import json
print(json.dumps(t,indent=4))

that results in:

{
    "status": 200,
    "result": [
        {
            "query": "AL1 2RJ",
            "result": {
                "postcode": "AL1 2RJ",
                "quality": 1,
                "eastings": 514617,
                "northings": 206084,
                "country": "England",
                "nhs_ha": "East of England",
                "longitude": -0.341337,
                "latitude": 51.741753,
                "european_electoral_region": "Eastern"
            }
        }
    ]
}

Beautify big one line JSON file

1 Answers1