Providers (deprecated)

This allows you to query data from third-party APIs and present that data on a dashboard. If you haven't already added a provider we recommend that you use the new Web API data source instead, see Web API data source

1. Browse to Settings > Web API > Providers and click Add new provider.
2. Enter a name for the provider, for example Star Wars
3. Enter the base URL of the API to be used for requests, for example https://swapi.dev/api
4. Method: Post or Get.
   For example, Get for the Star Wars API.
5. Authentication: None or Basic
   For example, None for the Star Wars API.
6. Headers can be added if required.
   No header information needed for the Star Wars API.
7. Query Parameters can be added if required.
   None are needed for the Star Wars API.
8. Click Save.

1. Add a new data 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

   Filtering

   Data can be filtered according to whether data in a column meets or does not meet specified text or numerical value conditions. Depending on the data you are filtering, available options include: Equals, Not equals, Contains, Doesn't contain, Less than, Greater than, Before now, After now, Is empty, Is not empty.

   Dates can be filtered by Before now or After now (e.g. to show overdue orders). Text matching is case sensitive.

   You are able to add multiple filter conditions. Available options are:

   • AND: All conditions must be satisfied (e.g. Status-Equals-Closed ANDType-Equals-Question).
   • OR: Any condition can be satisfied (e.g. Status-Equals-Pending ORStatus-Equals-Closed).

   Grouping

   You can group and aggregate data by column.

   For example, for AWS cost data you might configure the following settings to display a table or bar chart of cost per label:

   • Group by:label
   • Aggregation type: Total
   • Aggregation column: Amount

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

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

   Bucket by

   If you group by a time column, and further grouping is possible, the Bucket by dropdown appears. Use this field to control how the time data is grouped, for example by hour, day, month etc.

   Aggregation type and column

   Use this dropdown to choose how to summarize your data, for example as a count, average or total.
   For example, you could do the following:

   • When creating a Bar Chart of ticket data you might configure the following settings to show a graph of tickets per day:
     • Group by:Date created
     • Bucketby:Day
     • Aggregation type: Count
   • When creating Bar Chart of Azure Resource Group cost you could configure the following settings:
     • Group by:Timestamp
     • Bucketby:Day
     • Aggregation type:Total
     • Aggregate column: Cost

   Sorting

   The Sort section allows you to select a column to be displayed in Ascending or Descending order. While this sets the default sort order, but you can always click on a column heading to sort data in a table on the fly.

   Enabling the Top toggle allows you to additionally specify the top n rows of data to display.

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