Copy tables as JSON objects

[wheelercj]

Stardown's latest commits already support copying tables as 2D JSON arrays, but sometimes it might be more helpful to copy tables as JSON objects instead.

However, there are several formats possible. I'm not sure which one(s) to add support for yet and would like feedback from others.

1. For the table below, which of the following JSON format(s) should Stardown be able to create?

a	b	c
d	e	f
g	h	i

• {"a": ["d", "g"], "b": ["e", "h"], "c": ["f", "i"]} (columns)
• {"a": ["b", "c"], "d": ["e", "f"], "g": ["h", "i"]} (rows)
• other

2. What JSON options should appear in the right-click menu?

• Only Copy JSON of table, which creates a 2D array unless the table has a header row (created with <th> elements) and/or a header column, in which case the option creates an object. If there is both a header row and a header column, the header row is used as the property names.
• Both Copy JSON arrays of table and Copy JSON object of table. The object option looks for a header row or header column for the property names, preferring a header row and using the top row if there are no <th> elements.
• All of Copy JSON arrays of table, Copy JSON columns object of table, and Copy JSON rows object of table. Whether there are <th> elements does not matter.
• other

Note that some tables have cells that span multiple rows, such as this one: HTML table advanced features and accessibility - Learn web development | MDN. That table also has multiple header rows and multiple header columns.

3. JSON objects must not have duplicate property names, so some duplicate table cells will need to be made unique somehow. When Stardown is about to create a duplicate property name, should it just append (1), or whatever the next unique number is, to its contents?

For example:

a	a	a	b
c	d	e	f

{"a": ["c"], "a (1)": ["d"], "a (2)": ["e"], "b": ["f"]}

4. Note that since JSON property names must be strings, some data that normally would not be quoted will need to be quoted. For example:

59	true
35	false
11	true	orange

{"59": [35, 11], "true": [false, true], "null": [null, "orange"]}

related

• RFC 8259: The JavaScript Object Notation (JSON) Data Interchange Format
• Copy tables as JSON arrays #97

[wheelercj]

We decided to use one simple format for all JSON output.

a	b	c
d	e	f
g	h	i

[{"a": ["b", "c"]}, {"d": ["e", "f"]}, {"g": ["h", "i"]}]

This will replace the current array of arrays format and be the only format for JSON output for the time being. It solves the problem of duplicate property names without changing any property names and makes the data easy to work with in the way it is most commonly used: iterating through the elements in each row. A new setting will be added to the options page: "Empty table cells are converted to ___ in JSON" (a text input field that defaults to null).

More JSON format options may be added in the future.