JSON

Database::JSON
Description
Imports data from a JSON file to a recordset. Parse the JSON data to select the path from which to import the data from. Use the "Select the node to import from" view to select the path from which the data will be imported. This must be the path that contains the records that you want to import. The "Legacy Driver" uses the original implementation of the JSON plugin. The "JSONPath Driver" uses the popular Newtonsoft driver and supports the JSONPath query language.

Options
JSON file	The filename to import the JSON data from.
JSON Parser	Use this to browse the JSON data (in a treeview) and select the rootnode that contains the records you want to import.
Import root path	The root of the tree to import.
Save data to recordset	The name of the recordset to which the data must be imported. The recordset will be automatically created with the correct columns (based on the JSON data)..
Table name	Optional tablename used to store the data in the recordset.

Options
JSON file	The filename to import the JSON data from.
FloatParseHandling	Specifies how floating point numbers, e.g. 1.0 and 9.9, are parsed when reading JSON text: Decimal: Floating point numbers are parsed to Decimal Double: Floating point numbers are parsed to Double
JSONPath query	The JSONPath query used to select the required nodes from the JSON file.
Save data to recordset	The name of the recordset to which the data must be imported. The recordset will be automatically created with the correct columns (based on the JSON data)..
Table name	Optional tablename used to store the data in the recordset.

SetConnect

JSON

Documentation