{"type":"api","title":"Get Aggregation Data By Query Monitoring Application Aware Routing 3203","meta":{"id":"/apps/pubhub/media/cisco-catalyst-sd-wan-api-guide-20-18/1c4807bcb76af36988ebb37dc2e455b1787a155e/d2f02ba2-fd0d-3a26-bcc5-feafc8f24d17","info":{"title":"Monitoring and Troubleshooting","description":"Includes API operations for the following:\n- Real-time monitoring\n- Accessing statistics APIs and statistics bulk APIs\n- Retrieving device state\n- Managing alarms and events\n","contact":{"email":"vmanage@cisco.com"},"version":"20.18 - 2025-08-15"},"openapi":"3.1.0","servers":[{"url":"/dataservice"}]},"spec":{"tags":["Monitoring - Application Aware Routing"],"description":"Get aggregated data based on input query and filters. The data can be filtered on time and other unique parameters based upon necessity and intended usage","operationId":"getAggregationDataByQuery_MonitoringApplicationAwareRouting_3203","parameters":[{"name":"query","in":"query","schema":{"type":"string"},"example":{"query":{"condition":"AND","rules":[{"value":["24"],"field":"entry_time","type":"date","operator":"last_n_hours"},{"value":["172.16.255.16"],"field":"vdevice_name","type":"string","operator":"in"},{"value":["100"],"field":"loss_percentage","type":"number","operator":"less"}]},"aggregation":{"field":[{"property":"local_color","sequence":1,"order":"asc"}],"metrics":[{"property":"loss_percentage","type":"avg"},{"property":"latency","type":"avg"},{"property":"jitter","type":"avg"}]}}}],"responses":{"200":{"description":"Success","content":{"application/json":{"schema":{"type":"array","items":{"type":"object","properties":{"count":{"type":"integer","format":"int32","example":5},"entry_time":{"type":"string","example":"1674813600000"},"local_color":{"type":"string","example":"3g"},"loss_percentage":{"type":"integer","format":"int32","example":0}},"$$ref":"#/components/schemas/AppRouteAggResp"}},"examples":{"Aggregated search result":{"description":"Aggregated search result","value":"[\n {\n \"count\": 5,\n \"local_color\": \"3g\",\n \"loss_percentage\": 0\n \"jitter\": 0\n \"latency\": 0\n }\n ]"}}}}},"400":{"description":"Bad Request"},"403":{"description":"Forbidden"},"500":{"description":"Internal Server Error"}},"method":"get","path":"/statistics/approute/aggregation"}}