Skip to main content

JSON to HTML Table Representation

Project description

Python wrapper to convert JSON into a human readable HTML Table representation.

Latest Version Downloads Build

Features

  • User friendly tablular fomat, easy to read and share.
  • If value of the key is array of objects and all the keys are same(value of the key is a dict of list), the module will club by default. Eg.
input = {
        "sampleData": [{
                "a":1, "b":2, "c":3
        }, {
                "a":5, "b":6, "c":7
        }]
}

will create only one row combining the results. This feature can be turned off by explicitly passing an argument ``clubbing = False``.
  • Generated table can be provided some attributes explicitly. Eg. giving an id, class or any data-* attribute.
  • Python 3 compatible

Live Demo

Click here for the online demo.

List of valid arguments

json2html.convert - The module’s convert method accepts the following arguments:

Argument Description
json a valid JSON; This can either be a string in valid JSON format or a python object that is either dict-like or list-like at the top level.
table_attributes e.g. pass id=”info-table” or class=”bootstrap-class”/data-* to apply these attributes to the generated table
clubbing turn on[default]/off clubbing of list with same keys of a dict / Array of objects with same key
encode turn on/off[default] encoding of result to escaped html, compatible with any browser
escape turn on[default]/off escaping of html tags in text nodes (prevents XSS attacks in case you pass untrusted data to json2html)

Installation

$ pip install json2html

Or, Download [here](https://github.com/softvar/json2html/releases) and run python setup.py install after changing directory to /json2html

Example Usage

Example 1: Basic usage

from json2html import *
input = {
        "name": "json2html",
        "description": "Converts JSON to HTML tabular representation"
}
json2html.convert(json = input)

Output:

<table border="1"><tr><th>name</th><td>json2html</td></tr><tr><th>description</th><td>converts JSON to HTML tabular representation</td></tr></table>
name json2html
description Converts JSON to HTML tabular representation

Example 2: Setting custom attributes to table

from json2html import *
input = {
        "name": "json2html",
        "description": "Converts JSON to HTML tabular representation"
}
json2html.convert(json = input, table_attributes="id=\"info-table\" class=\"table table-bordered table-hover\"")

Output:

<table id="info-table" class="table table-bordered table-hover"><tr><th>name</th><td>json2html</td></tr><tr><th>description</th><td>Converts JSON to HTML tabular representation</td></tr></table>

Example 3: Clubbing same keys of: Array of Objects

from json2html import *
input = {
        "sample": [{
                "a":1, "b":2, "c":3
        }, {
                "a":5, "b":6, "c":7
        }]
}
json2html.convert(json = input)

Output:

<table border="1"><tr><th>sample</th><td><table border="1"><tr><th>a</th><th>c</th><th>b</th></tr><tr><td>1</td><td>3</td><td>2</td></tr><tr><td>5</td><td>7</td><td>6</td></tr></table></td></tr></table>
a c b
1 3 2
5 7 6

Example 4: Each row for different key(s) of: Array of Objects

from json2html import *
input = {
        "sample": [{
                "a":1, "b":2, "c":3
        }, {
                "1a1":5, "1b1":6, "c":7
        }]
}
json2html.convert(json = input)

Output:

<table border="1"><tr><th>sample</th><td><ul><li><table border="1"><tr><th>a</th><td>1</td></tr><tr><th>c</th><td>3</td></tr><tr><th>b</th><td>2</td></tr></table></li><li><table border="1"><tr><th>1b1</th><td>6</td></tr><tr><th>c</th><td>7</td></tr><tr><th>1a1</th><td>5</td></tr></table></li></ul></td></tr></table>

Example 5: [Source: json.org/example]

from json2html import *

input = {
        "glossary": {
                "title": "example glossary",
                "GlossDiv": {
                        "title": "S",
                        "GlossList": {
                                "GlossEntry": {
                                        "ID": "SGML",
                                        "SortAs": "SGML",
                                        "GlossTerm": "Standard Generalized Markup Language",
                                        "Acronym": "SGML",
                                        "Abbrev": "ISO 8879:1986",
                                        "GlossDef": {
                                                "para": "A meta-markup language, used to create markup languages such as DocBook.",
                                                "GlossSeeAlso": ["GML", "XML"]
                                        },
                                        "GlossSee": "markup"
                                }
                        }
                }
        }
}

json2html.convert(json = input)

Output:

<table border="1"><tr><th>glossary</th><td><table border="1"><tr><th>GlossDiv</th><td><table border="1"><tr><th>GlossList</th><td><table border="1"><tr><th>GlossEntry</th><td><table border="1"><tr><th>GlossDef</th><td><table border="1"><tr><th>GlossSeeAlso</th><td><ul><li>GML</li><li>XML</li></ul></td></tr><tr><th>para</th><td>A meta-markup language, used to create markup languages such as DocBook.</td></tr></table></td></tr><tr><th>GlossSee</th><td>markup</td></tr><tr><th>Acronym</th><td>SGML</td></tr><tr><th>GlossTerm</th><td>Standard Generalized Markup Language</td></tr><tr><th>Abbrev</th><td>ISO 8879:1986</td></tr><tr><th>SortAs</th><td>SGML</td></tr><tr><th>ID</th><td>SGML</td></tr></table></td></tr></table></td></tr><tr><th>title</th><td>S</td></tr></table></td></tr><tr><th>title</th><td>example glossary</td></tr></table></td></tr></table>

Tests

cd test/
python run_tests.py

Tested with Python 2.6, 2.7 3.4, and 3.5.

Contributors

  1. Michel Mueller: [@muellermichel](https://github.com/muellermichel)
    • Added support for clubbing Array of Objects with same keys, more readable format.
    • Added support for adding custom table_attributes.
    • Convert now accepts unicode and bytestrings for the keyword argument “json”.
    • Output now should always appear in the same order as input.
    • Now supports JSON Lists (at top level), including clubbing.
    • Now supports empty inputs and positional arguments for convert.
    • Python 3 support ; Added integration tests for Python 2.6, 3.4 and 3.5 such that support doesn’t break.
    • Can now also do the proper encoding for you (disabled by default to not break backwards compatibility).
    • Can now handle non-JSON objects on a best-effort principle.
    • Now by default escapes html in text nodes to prevent XSS attacks.
  2. Daniel Lekic: [@lekic](https://github.com/lekic)
    • Fixed issue with one-item lists not rendering correctly.
    • General code cleanup, fixed all naming conventions and coding standards to adhere to PEP8 conventions.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Filename, size & hash SHA256 hash help File type Python version Upload date
json2html-1.2.1.tar.gz (6.7 kB) Copy SHA256 hash SHA256 Source None Jul 12, 2017

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN SignalFx SignalFx Supporter DigiCert DigiCert EV certificate StatusPage StatusPage Status page