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.

Settings

Type

The following file location types 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.

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 March 15, 2024