How do I model a JSON/XML data source?

During the modelling process, you can convert JSON/XML tree-structured data sources into a tabular format, making the data source easier to visualize. You can quickly populate columns with specific data elements from your tree-structured data source and add context to your data using formulas and properties.

To model a JSON and XML data source:

  1. Click Data Sources in the left navigation bar.
  2. Click on the data source name of the data source you want to model. Use the Format type to identify which data source is tree structured.
  3. Click Create modelled data source.
  4. Name your modelled data source. The default is the original data source name. Both the original data source and the modelled data source will be available in your list of data sources.
  5. Use the + sign to add a column to your modelled data source.
  6. Name your column. This is how it will be referenced when building Klips and PowerMetrics. Each column is automatically named according to the first value in the data selection.
  7. In your tree-structured data source, click the black arrows to show or hide the elements of each data node.
  8. Select the element of data you want to use to populate your column. All elements of data with the same name will populate your column. For example, if you select “type”, all elements of data with the name “type” will populate your column.
  9. To further specify the data assigned to each column, you can use the Selection Options or edit the XPath in your formula bar:
    • Selection Options: When an element of data is selected, you can click the Selection Options link on the right side of the data. Here, you can choose from a list of varied selections to specify the data you want to see in your column. When you click on an option, you can see a preview of what is being selected.
    • XPath: You can use the formula bar to write a specific XPath to ensure that the correct data is being selected for each column. To do this, you select an element of data and edit the XPath by double-clicking on the path in the formula bar or clicking in the formula bar to add your cursor after the path and pressing backspace on your keyboard. Edit your path between the @ and ; symbols in the formula bar.
  10. Add context to the columns by setting the data types, specifying data formats, and writing formulas.
  11. Click Save and Exit to save your model and start building a Klip or a PowerMetric.

Learn more:

Have more questions? Submit a request