All Products
Search
Document Center

QueryExceptionHistory

Last Updated: Jan 15, 2021

QueryExceptionHistory

Description

Queries historical abnormal data generated within a specific time period.

Method

GET

URI

/openapi/instances/{instanceId}/sync-reports/exception-history

Request parameters

Parameter

Type

Description

Remarks

startTime

Long

The start time. The value must be accurate to the second.

Required

endTime

Long

The end time. The value must be accurate to the second.

Required

type

String

The type of a single table.

Required. Valid values: item, behavior, and user.

Response parameters

Parameter

Type

Description

RequestId

String

The ID of the request.

Result

Map

The result that is returned.

Sample requests

GET /openapi/instances/airec-cn-xxxxx/sync-reports/exception-history?startTime=xxx&endTime=xxx&dataType=item

Sample responses

  • dataType = behavior

    {
    "RequestId": "16B78383-2803-4964-9605-37B30C073B0E",
    "Result": {
        "Total": {
          "ErrorCount": 221934,
          "StartTime": "1566489600",
          "ErrorPercent": 0.6839260400616333,
          "EndTime": "1566658800",
          "TotalCount": 324500
        },
        "Detail": [
          {
            "ErrorCount": 31500,
            "StartTime": 1566507600,
            "ErrorPercent": 1,
            "EndTime": 1566511200,
            "TotalCount": 31500
          },
          {
            "ErrorCount": 15000,
            "StartTime": 1566486000,
            "ErrorPercent": 1,
            "EndTime": 1566489600,
            "TotalCount": 15000
          },
            ...
          ]
    }
    }
  • dataType = item

    {
    "RequestId": "16B78383-2803-4964-9605-37B30C073B0E",
    "Result": {
        "Total": {
              "DeleteCount": 36,
              "UpdateCount": 6978,
                  "AddCount": 29,
              "ErrorCount": 6978,
              "StartTime": "1566489600",
              "ErrorPercent": 0.9907709782763027,
              "EndTime": "1566658800",
              "TotalCount": 7043
         },
        "Detail": [
          {
              "ErrorCount": 0,
              "StartTime": 1566504000,
              "ErrorPercent": 0,
              "EndTime": 1566507600,
              "TotalCount": 0
          },
          {
              "ErrorCount": 0,
              "StartTime": 1566500400,
              "ErrorPercent": 0,
              "EndTime": 1566504000,
              "TotalCount": 0
          },
    
            ...
          ]
    }
    }
  • dataType = user

    {
    "RequestId": "16B78383-2803-4964-9605-37B30C073B0E",
    "Result": {
        "Total": {
            "DeleteCount": 0,
            "Addcount": 0,
            "UpdateCount": 1100184,
            "ErrorCount": 1100184,
            "StartTime": "1566489600",
            "ErrorPercent": 1,
            "EndTime": "1566658800",
            "TotalCount": 1100184
          },
        "Detail": [
            {
              "ErrorCount": 0,
              "StartTime": 1566489600,
              "ErrorPercent": 0,
              "EndTime": 1566493200,
              "TotalCount": 0
            },
            {
              "ErrorCount": 0,
              "StartTime": 1566507600,
              "ErrorPercent": 0,
              "EndTime": 1566511200,
              "TotalCount": 0
            },   
            ...
          ]
    }
    }