Importing & Transforming OTbase Data

Importing OTbase Data

Now that we have configured Infinity with our OTbase credentials and the OTbase address, we can begin importing data from OTbase. To achieve this, execute follow the following steps.

1. Select Dashboards from lefthand menu, then New Dashboard.
2. Select Add a new panel.
3. Dashboard type (top right) should be Table.

1. Under the Query Tab, select the data source we created in the previous section (See: Adding a Data Source).
2. The type should be set to JSON and enter the full URL of the dataset you wish to query. For example:  https://10.0.0.101/ot-base/api/v1/devices?locationid=frk
3. Next, click on the Transform tab

Applying Transformations

For the next steps, we will extract (parse) out the fields we would like to

1. Add transformation > Extract Fields type
2. Source = context (or column of your choice that requires expansion)
   • Format = JSON
   • Replace all fields = False
   • Repeat for each column as needed
3. Add Transformation type Organize Fields if desired to clean up the table. This let's you reorder, rename, and hide columns while preserving the data for reference in other dashboards.
4. If you want to remove a column all together, use the remove columns transformation type.

Note: Grafana transformations are chronological so the order of the operations matter.