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.

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

Settings

Type The following file locations are supported:

File name Name of the file in JSON format. The syntax of the filename is location-specific.
Decryption method Decryption method is only relevant when extracting data from an encrypted file.

For PGP decryption, enter the passphrase that was set during key creation. The key will be a private / secret key. See Keys and Secrets for details.

Directory connections will only work if the same passphrase can be used for all files (either the files use keys without passphrase, or the keys for the files have the same passphrase).

Encryption method

For PGP encryption, a public key ID is required; this can be obtained from the "name" column in the Keys & Secrets section of the Cloud Console.

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 June 25, 2025