keboola-legacy / json-parser
Keboola JSON to CSV parser
Installs: 1 789
Dependents: 2
Suggesters: 0
Security: 0
Stars: 0
Watchers: 11
Forks: 0
Open Issues: 0
Requires
- php: >=7.4
- keboola/php-csvtable: ^1.1
- keboola/php-utils: ^4.1
- monolog/monolog: ^2.2
Requires (Dev)
- codeclimate/php-test-reporter: dev-master
- phpunit/phpunit: ^5.2
- squizlabs/php_codesniffer: ^2.5
- dev-master
- 3.0.0
- 2.1.0
- 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
- dev-webrouse-COM-596-update-packages
- dev-column-conflicts
This package is auto-updated.
Last update: 2022-05-31 05:50:18 UTC
README
Description
Parse Json strings into CSV files Creates multiple tables from a single JSON, if said JSON contains numbered arrays Uses Keboola\CsvFile for results
Usage
use Keboola\Json\Parser; $parser = Parser::create(new \Monolog\Logger('json-parser')); $file = file_get_contents("some/data.json"); $json = json_decode($file); $parser->process($json); $results = $parser->getCsvFiles(); // array of CsvFile objects
Parser\Json
Analyzes and parses JSON data into n*CSV files.
create(\Monolog\Logger $logger, $struct, $analyzeRows)
- $struct should contain an array with results from previous analyze() calls (called automatically by process())
- $analyzeRows determines, how many rows of data (counting only the "root" level of each Json) will be analyzed [default -1 for infinite]
process($data, $type, $parentId)
- Expects an array of results as the $data parameter
- $type is used for naming the resulting table(s)
- The $parentId may be 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
- Checks whether the data needs to be analyzed, and either analyzes or parses it into
$this->tables[$type]
($type is polished to comply with SAPI naming requirements) - If the data is analyzed, it is stored in Cache and NOT PARSED until $this->getCsvFiles() is called
getCsvFiles()
- returns a list of \Common\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 string, it's stored in a "data" column, otherwise the row should usually be an object, so each of the object's variables will be used as a column name, and it's value analysed:
- if it's a scalar, it'll be saved as a value of that column.
- if it's another object, it'll be parsed recursively to analyzeRow(), with it's variable names prepended by current object's name
- example: "parent": { "child" : "value1" } will result into a "parent_child" column with a string type of "value1"
- if it's an array, it'll be passed to analyze() to create a new table, linked by JSON_parentId