Data Resource - Json
About
A json file is a text file that contains one or several json object.
Type
Tabulify supports the following JSON type:
- json : one JSON object by file
- jsonl: one JSON object by line (ie the Jsonl format)
Attributes
The attributes of a JSON file are:
| Name | Description |
|---|---|
| structure | document - the whole JSON document will be stored in tabular format with 1 column of the json data type properties - the JSON file will be parsed and all first level properties will create several columns in a full tabular format |
| Because a json file is also a text file, it inherits all text attributes | |
| end-of-record | For a JSON file, end of a file (EOF). It expects one JSON object by file For a JSONL file, end of a line (EOL). It expects one JSON object by line |
| column-name | The name of the column in the case of a document structure (Default to json) |
Creation
With the JSON template, you can create a JSON file from tabular data.
How to see the first lines
By default, Tabulify treats one JSON document as one record (line), you would see the whole document.
If you want to see the first text lines of a document, you need to set the type to text.
Example:
tabul data head --type text --limit 3 books_template.json@howto
The first 3 rows of the data resource (books_template.json@howto):
lines
----------------
{
"${group}": {
"${asin}": {