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 locations are supported: Connecting to a Jedox Files Location Connecting to a File System Location Connecting to an FTP Location Connecting to an HTTP location Connecting to an SFTP Location Connecting to a OneDrive Location Connecting to a WebDAV Location Connecting to a WebHDFS Location Connecting to an Azure (Blob Storage and Data Lake) Location
File name	Name of the file in JSON format. The syntax of the filename is location-specific.
Encryption method	For PGP decryption, enter the passkey that was set during key creation. 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).
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 December 18, 2024