Parsing JSON Files

TIBCO Clarity can parse the source data in a JSON file according to the configured parsing rules.

Data in a JavaScript Object Notation (JSON) file is syntax for storing and exchanging text information.

Procedure

Click Character encoding to specify the encoding method applied to your source file. By default, UTF-8 is selected.

Define how the source file is parsed with the following options:

Option	Description
Store file source (file name, URLs) in each row	Select this option to create a new column that stores the name or URL of the source file.
Preserve empty strings	Select this option to parse empty strings to spaces.
Trim leading & trailing whitespace from strings	Select this option to remove the whitespace at the beginning or end of a string.

In the Click the XML node for the first record you want to load area, click the JSON node from your JSON code to preview the first record you want to load.
Click Next. Preview the source file information and click Done adding to add the source file.
Optional: On the "Get data from" page, select a way to upload another source file. See Uploading Data for more details.