This connector is used to read JSON files from local file system.

Connection configuration

No connection is required by this connector

Test case configuration

Test case configuration

NameMandatoryDefaultDescription
pathyesPath to the JSON file
linesnoFalseWhether to treat the file as line-delimited JSON (one JSON object per line)
nrowsnoNoneNumber of rows of file to read. Useful for reading pieces of large files
encodingno"utf-8"Encoding to use for UTF when reading/writing

Example

Example JSON:
  source:
    type: json
    lines: True
    encoding: "utf-8"
    path: data/json/employees.json

expected: type: csv infer: True delimiter: ";" encoding: "utf-8" engine: "python" path: data/employeesbefore2000.csv