Data Import » Control » Files » json

json

The json format reads a JSON file where the top level is an array, and the Records are the objects in this array.

JSON files always use the UTF-8 charset.

Options are:

"singleRecord"

If true, treat the input file as a single record instead of an array of multiple records. This is useful for defining REST APIs.

JSON is the preferred input format. Ensure all input files are generated by a real JSON serialiser. JSON files produced through string concatenation will have encoding and escaping problems.

Example control file

"files": {
    "DEFAULT": {
        "read": "json"
    }
}

Example input file

[
    {
        "id": "jbloggs",
        "first": "Joe",
        "last": "Bloggs",
        "email": "joe@example.org"
    },
    {
        "id": "jsmith",
        "first": "Jane",
        "last": "Smith",
        "email": "jane@example.org"
    }
]