Web API

This allows you to query data from third-party APIs and present that data on a dashboard. You can add details of providers to use with the Web API data stream from Settings > Web API > Providers.

See Providers

Adding a Web API tile

1. Add a new tile and in the configuration scope the tile to SquaredUp

2. Choose the + Web API data stream.

3. Enter a name for this data stream. For example, Star Wars People

4. Select a provider from the list. For example, Star Wars.

5. Path Suffix: Choose the API method you want to call. For example, for the Star Wars API you can type people to use the People method.

6. Row Path: Enter the response path of the property you want to turn into rows. For example, for the Star Wars API type results.

7. Click Save.

8. Optionally, you can configure filtering, grouping, sorting etc as normal.

   Configure Data Stream

   Advanced settings for each data stream can be found by clicking Configure next to the data stream name.

   Filtering

   Data shown can be filtered according to whether data in a column equals or does not equal a specified text or numerical value. Dates can be filtered by Before now or After now, for example to show overdue orders. Text matching is case sensitive.

   Group by

   You can group and aggregate data by column.

   For example, you might Group byservice, choose to Aggregate columnamount with Aggregation typeTotal, to show a table of cost per service.

   Which columns are available depends on the data stream you chose.

   Configuring grouping will enable different visualizations to be displayed, such as bar chart and donut. For example, grouping tickets by channel will allow you to show a donut of how many tickets were logged by email vs web form.

   Sorting

   Data can be sorted by column in ascending or descending order. This sets the default sort order, but users can click on a column heading to sort data in a table on the fly.

   Ticking Top and typing a number will show the top n rows of data.

9. You can also add Monitoring or KPIs, as you would for any tile.