Adding a Column by Fetching URLs

Use this function to add a new column by formulating URLs with an existing column.

Procedure

  1. From a column menu, click Edit column > Add column by fetching URLs.
  2. In the New column name field, enter a name for the new column.
  3. In the Throttle delay field, enter a time (in millisecond).
  4. In the Expression field, enter the expression to formulate the URLs for generating the new column values. TIBCO Clarity can fetch JSON files from any web services based on values in a column and create a new column out of it. When you have the JSON information, you can use the parseJson() function to create new columns, transform cell values, or even create new facets for further analysis. For example, if you are interested in the link element of a JSON result returned by fetching URLs from the existing column, use the following expression: value.parseJson()["link"].
  5. Select from the following options to handle errors in a cell:
    • Set to blank: Set the cell to blank.
    • Store error: Store the error in the cell.
  6. Click OK.
Contents
Search Results