Parsing JSON Files

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

1. Click Character encoding to specify the encoding method applied to your source file.
   By default, UTF-8 is selected.
2. Define how the source file is parsed with the following options:

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

3. 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.
4. Click Next. Preview the source file information.
5. Optional: On the "Get data from" page, select a way to upload another source file.
   See Uploading Data for more details.
6. Click Done adding.

Copyright © Cloud Software Group, Inc. All Rights Reserved.