keboola / json-parser
Keboola JSON to CSV parser
Installs: 9 538
Dependents: 3
Suggesters: 0
Security: 0
Stars: 6
Watchers: 19
Forks: 6
Open Issues: 2
Requires
- php: ^8.1
- ext-json: *
- keboola/php-csvtable: ~2.1.0
- keboola/php-temp: ^2.0
- keboola/php-utils: ^4.1
- monolog/monolog: ^2.2
Requires (Dev)
- keboola/coding-standard: >=9.0
- php-parallel-lint/php-parallel-lint: ^1.2
- phpstan/phpstan: ^1.0
- phpunit/phpunit: ^9.0
- dev-master
- 4.0.0
- 3.0.0
- 2.1.0
- 2.0.1
- 2.0.0
- 1.1.0
- 1.0.13
- 1.0.12
- 1.0.11
- 1.0.10
- 1.0.9
- 1.0.8
- 1.0.7
- 1.0.6
- 1.0.5
- 1.0.4
- 1.0.3
- 1.0.2
- 1.0.1
- 1.0.0
- 0.2.4
- 0.2.3
- 0.2.2
- 0.2.1
- 0.2.0
- 0.1.24
- 0.1.23
- 0.1.22
- 0.1.21
- 0.1.20
- 0.1.19
- 0.1.18
- 0.1.17
- 0.1.16
- 0.1.15
- 0.1.14
- 0.1.13
- 0.1.12
- 0.1.11
- 0.1.10
- 0.1.9
- 0.1.8
- 0.1.7
- 0.1.6
- 0.1.5
- 0.1.4
- 0.1.3
- 0.1.2
- 0.1.1
- 0.1.0
- dev-ujovlado-license-and-readme
This package is auto-updated.
Last update: 2024-10-30 12:40:55 UTC
README
Description
Parses JSON strings into CSV files. Creates multiple tables from a single JSON. Uses Keboola\CsvFile for results. The root of the JSON must be an array. JSON parser is part of Generic Extractor (see also end-user documentation).
Usage
use Keboola\Json\Parser; $parser = new Parser(new Analyzer(new NullLogger(), new Structure())); $file = file_get_contents("some/data.json"); $json = json_decode($file); $parser->process($json); $results = $parser->getCsvFiles(); // array of CsvFile objects
\Keboola\Json\Analyzer
Analyzes JSON data for JSON parser.
__construct(\Psr\Log\LoggerInterface $logger, \Keboola\Json\Structure $structure, $nestedArraysAsJson, $strict)
- $logger - a logger, use
NullLogger
if no logger is used. - $structure - a representation of JSON structure .
- $nestedArraysAsJson - if true, then nested arrays will be encoded as JSON strings. If false (default), the conversion will fail.
- $strict - if true, then JSON node data types will be checked more strictly (int, string, ...).
\Keboola\Json\Parser
Parses JSON data into CSV files.
__construct($analyzer, $definitions = [])
- $definitions - optional array with results from previous process.
- $analyzer - instance of analyzer class.
process($data, $type, $parentId)
- $data - array of objects retrieved from JSON data.
- $type - is used for naming the resulting table(s).
- $parentId - either a string, which will be saved in a JSON_parentId column, or an array with "column_name" => "value", which will name the column(s) by array key provided.
- If the data is analyzed, it is stored in Cache and NOT PARSED until the
getCsvFiles()
method is called.
getCsvFiles()
- returns a list of \Keboola\CsvTable\Table objects with parse results
Parse characteristics
The analyze function loops through each row of an array (generally an array of results) and passes
the row into analyzeRow()
method. If the row only contains a scalar, it's stored in a "data"
column. If the row is an object, each of the object's variables will be used as a column
name, and its values are analyzed:
- if it is a scalar, it'll be saved as a value of that column.
- if it is an array, it'll be passed to
analyze()
to create a new table, linked by a generatedJSON_parentId
column - if it is another object, it'll be parsed recursively to
analyzeRow()
, with its variable names prepended by current objects' name, e.g.:
"parent": {
"child" : "value1"
}
will result in a parent_child
column with a string type of "value1".