JSONFile Connection

Access level: read, write

JSON (JavaScript Object Notation) is an open standard format that uses human-readable text to transmit data objects consisting of attribute-value pairs. With JSONFile connection, a file in the JSON format can be specified.

With Jedox 24.2, PGP decryption is supported for file-based connections, such as JSON. PGP decryption must be configured in the Cloud Console for your Jedox environment. See Keys and Secrets for more information.

Settings

Type

The following file location types are supported:

File name

Name of the file in JSON format. The syntax of the filename is location-specific.

Encoding

The most common character encodings are UTF-8 (default), ASCII, and latin1 (Windows standard).

A list of all character codes can be found at http://docs.oracle.com/javase/8/docs/technotes/guides/intl/encoding.doc.html
From this list you can also enter manually a character code into the field ‘Encoding’. Note that this connection only supports file encodings as provided by the Java Runtime Environment.

Updated September 27, 2024