Connection to JSON File

image_pdfimage_print

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

Main settings:

Location

The location of the file with following options:

  • File system
  • URL
  • Report Designer

File name

File System location:

  • A filename with an absolute path on the file system of the server, e.g. C:\Users\xyz\Sample.json
  • A filename with relative path to the “data” directory of the Jedox Integrator Installation (default: .\tomcat\webapps\etlserver\data\files).
    Example: …\samples\sampleBiker.json
  • A file residing on a network drive (see instructions in article accessing networkfiles), e.g. //net1/Sample.json

URL location*:

Report Designer:

  • A filename with path in the Report Designer, e.g.  //Default/Public Files/sample.json
    Note: in case of access to a remote Report Designer, the following syntax is used:
    <remote_ip>:<port>//<path>
    Example: 12.34.56.78:80//Default/Public Files/sample.json

Advanced settings:

Encoding

The most prevalent 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/6/docs/technotes/guides/intl/encoding.doc.html.
From this list you can also manually enter a character code into the field ‘Encoding’.

SSL Mode

Off: SSL is not used. For Report Designer files, this option has to be used if Jedox Web uses HTTP protocol.

Trust: The SSL certificate is imported to the keystore if not yet available. For Report Designer files, this option has to be used at least once if Jedox Web uses HTTPS protocol in order to import the certificate.

Verify: The SSL certificate is verified. For Report Designer files, this option should be used if Jedox Web uses HTTPS protocol and the certificate is already imported.
Note: if the certificate has not been imported correctly, the following error message occurs: “Unable to find valid certification path to requested target”.

*If location is URL, there are 2 additional fields for HTTP Basic Authentication:

Username

The username for HTTP Basic authentication

Password

The password for HTTP Basic authentication

image_pdfimage_print
Was this post helpful?
NoYes (No Ratings Yet)
Loading...