Event Multi Query

The multi_query_ analytics is used to filter and search for events. The request supports pagination. Multiple requests can be executed as part of one request

Parameters

• opcode - multi_query (Required) - Operation code for this analytics
• requests - Map of requests (Required). Key would be used as an identifier in response and value would be any other foxtrot request

Sample Request (With Filter)

The following will execute two queries within one request for two different time periods

{
  "opcode": "multi_query",
  "requests": {
    "Key1": {
      "opcode": "trend",
      "table": "test-app",
      "filters": [
        {
          "field": "_timestamp",
          "operator": "last",
          "duration": "15minutes",
          "currentTime": 1556087411377
        }
      ],
      "field": "eventType",
      "period": "minutes"
    },
    "Key2": {
      "opcode": "trend",
      "table": "test-app",
      "filters": [
        {
          "field": "_timestamp",
          "operator": "last",
          "duration": "15minutes",
          "currentTime": 1556086511377
        }
      ],
      "field": "eventType",
      "period": "minutes"
    }
  }
}

Sample Response

{
  "opcode": "multi_query",
  "responses": {
    "Key1": {
      "opcode": "trend",
      "trends": {
        "E1": [
          {
            "period": 1556087220000,
            "count": 1
          }
        ]
      }
    },
    "Key2": {
      "opcode": "trend",
      "trends": {
        "E3": [
          {
            "period": 1556085600000,
            "count": 196
          },
          {
            "period": 1556085660000,
            "count": 232
          },
          {
            "period": 1556085720000,
            "count": 253
          },
          {
            "period": 1556085780000,
            "count": 181
          },
          {
            "period": 1556085840000,
            "count": 256
          },
          {
            "period": 1556085900000,
            "count": 249
          },
          {
            "period": 1556085960000,
            "count": 244
          },
          {
            "period": 1556086020000,
            "count": 222
          },
          {
            "period": 1556086080000,
            "count": 223
          },
          {
            "period": 1556086140000,
            "count": 243
          },
          {
            "period": 1556086200000,
            "count": 231
          },
          {
            "period": 1556086260000,
            "count": 216
          },
          {
            "period": 1556086320000,
            "count": 232
          },
          {
            "period": 1556086380000,
            "count": 200
          },
          {
            "period": 1556086440000,
            "count": 256
          },
          {
            "period": 1556086500000,
            "count": 52
          }
        ]
      }
    }
  }
}