Using the Investigate view

The API Monitoring Investigate view displays pivot tables of metrics and attributes for all API traffic, to help you compare activity for different metrics.

To access the Investigate view, follow the steps in Accessing API Monitoring and select Investigate.

Select investigate view.

The figure below shows the UI with Investigate selected.

API Monitoring investigate view

By default, the Investigate view displays three tables:

  • Fault Code by Time
  • Fault Code by Status Code
  • Fault Source by Proxy

As in the Timeline view, you can select any combination of tables from the Graphs menu to display. All other options in the Investigate view are the same as in the Timeline view.

Each cell in a table shows the number of responses for a subset of the data. As an example, take a look at the first three columns of the Fault Code by Time table.

Fault code by time table.

The first cell in row 1 shows the number of responses (444) with fault code steps.json2xml.SourceUnavailable that were returned from 18:18 - 18:24, on the selected date.

The first cell in row 2 shows the numbers of responses (64) during the same time interval for which the fault code was not set for some reason.

To learn about this particular fault code, see JSON to XML policy runtime error troubleshooting.

Taking a closer look at the data for a cell

You can get a more granular view of the data for an individual table cell by simply clicking the the cell. This displays the distributions of the cell data by several different attributes.

To see an example of this, first select Region in the Graphs menu to display the table shown below.

Region by time table.

In the data for this example, there is just one region, us-central1. If there were data for other regions, you would see additional rows in the table.

Now, click the first cell in the table.

Click first cell in region by time table.

This displays several tables in the right-hand pane of the Investigate view. The first table is shown below.

Distribution tables

The top of the pane displays the conditions that specify the cell data, in this case the region and time interval.

Below that, the table "Distribution by Fault Code" displays the number of responses for each fault code in the data. In this example, there are just two fault code values:

Fault code Count
steps.json2xml.SourceUnavailable 432
not set 64

Note the counts for the fault codes add up to 496, the total count in the cell.

As another example, scroll down in the right-hand pane until you reach the table labeled "Distribution by Status Code," as shown below.

Distribution tables

In this case, there are two status codes in the data:

  • 500: 432
  • 200: 64
Status code Count
500 432
200 64

Again, the counts add up to 496.

Using the Investigate view to diagnose an issue

You can use the Investigate view to diagnose API issues For example, suppose you receive an alert that indicates that the 5xx error rate exceeds the specified threshold. To investigate this issue, you might perform the following tasks in the Investigate view:

  1. View the FAULT CODE BY TIME table to view the fault code activity over the last hour.
  2. View the FAULT CODE BY STATUS CODE table to identify specific HTTP status codes associated with the fault codes whose counts have increased over the last hour, as identified in the previous step.
  3. View the FAULT CODE BY PROXY matrix to identify the API proxies that are triggering the fault codes identified in the previous step.
  4. Set up an alert to further assist with diagnosing the issue.