Import Data - "ndjson"

I Ain't Afraid of No Code!

[
    [
        "ndjson",
        {
            "sample": 1000,
            "subtable": null,
            "header": [
                "dim_A",
                "dim_B"
            ],
            "mapping": {
                "id": "product_id",
                "created": "metadata.created",
                "title": "metadata.title",
                "modified": "metadata.modified"
            },
            "_comment": null
        }
    ] 
]

param list header: List of fields will be used as header and used in lookup for corresponding key-value pairs.

param int sample: If no header is specified, fields will be discovered by sampling keys from the first N objects.

param str missing: Defines which values are handled as missing.

param dict mapping: Pairs of "target":"source". Sub-nodes can be accessed by node.sub_node. Arrays can be accessed by node[index].