{"type":"api","title":"Get Stats Raw Data 27","meta":{"id":"/apps/pubhub/media/sd-wan-api-20-16/58fb893fa751949ea20a40274e9ab219a20e19fa/e77267b5-7b4b-3f93-807c-c6d1c6b41343","info":{"title":"Cisco Catalyst SD-WAN Manager API","description":"The vManage API exposes the functionality of operations maintaining devices and the overlay network","contact":{"email":"vmanage@cisco.com"},"license":{"name":"Commercial License","url":"https://www.cisco.com/c/en/us/solutions/enterprise-networks/sd-wan/index.html"},"version":"2.0.0"},"openapi":"3.0.1","servers":[{"url":"/dataservice"}]},"spec":{"tags":["Troubleshooting Tools - Diagnostics"],"description":"Get stats raw data","operationId":"getStatsRawData_27","parameters":[{"name":"page","in":"query","description":"page number","schema":{"type":"integer","format":"int64"}},{"name":"pageSize","in":"query","description":"page size","schema":{"type":"integer","format":"int64"}},{"name":"sortBy","in":"query","description":"sort by","schema":{"type":"string"}},{"name":"sortOrder","in":"query","description":"sort order","schema":{"type":"string"}}],"requestBody":{"description":"Stats query string","content":{"application/json":{"schema":{"type":"object"},"examples":{"Stats query string":{"description":"Stats query string","value":{"query":{"condition":"AND","rules":[{"value":["172.16.255.11"],"field":"source_local_ip","type":"string","operator":"in"},{"value":["completed"],"field":"status","type":"string","operator":"in"}]},"size":10000}}}}}},"responses":{"200":{"description":"Success","content":{"application/json":{"schema":{"type":"object"},"examples":{"Search result":{"description":"Search result","value":{"header":{"generatedOn":1719824542590,"viewKeys":{"uniqueKey":[],"preferenceKey":"grid-raw_speedtest"},"columns":[{"title":"Time","property":"entry_time","displayFormat":"DD MMM YYYY h:mm:ss A z","inputFormat":"unix-time","dataType":"date"},{"title":"Destination Device","property":"destination_local_ip","dataType":"string"},{"title":"Source Circuit","property":"source_circuit","dataType":"string"},{"title":"Destination Circuit","property":"destination_circuit","dataType":"string"},{"title":"Down Speed (Mbps)","property":"down_speed","dataType":"number"},{"title":"Up Speed (Mbps)","property":"up_speed","dataType":"number"},{"title":"Down Bandwidth (Mbps)","property":"down_bw","display":"formatKbpsToMbps","dataType":"number"},{"title":"Up Bandwidth (Mbps)","property":"up_bw","display":"formatKbpsToMbps","dataType":"number"}],"fields":[{"property":"entry_time","dataType":"date"},{"property":"destination_local_ip","dataType":"string"},{"property":"source_circuit","dataType":"string"},{"property":"destination_circuit","dataType":"string"},{"property":"down_speed","dataType":"number"},{"property":"up_speed","dataType":"number"},{"property":"down_bw","dataType":"number","display":"formatKbpsToMbps"},{"property":"up_bw","dataType":"number","display":"formatKbpsToMbps"},{"property":"session_id","dataType":"string"},{"property":"speedtest_id","dataType":"string"},{"property":"logid","dataType":"number"},{"property":"deviceUUID","dataType":"string"},{"property":"status","dataType":"string"}],"chart":{}},"pageInfo":{"startTime":"1719821609758","endTime":"1719821609758","count":1},"data":[{"entry_time":1719821609758,"up_speed":228,"down_speed":227.71,"up_bw":"NA","down_bw":"NA","destination_ip":"172.16.255.16","destination_local_ip":"172.16.255.16","source_ip":"172.16.255.11","source_local_ip":"172.16.255.11","source_circuit":"","destination_circuit":"--","session_id":"83a52af4-8daf-46e1-9f8c-34ab4225eff5","speedtest_id":"","logid":4,"device_uuid":"C8K-9abc344d-9193-41bb-bc1d-26c834c31d5e","status":"completed","error":"None","tenant":"default","port":"80","source_interface":"Tunnel0","destination_interface":"Tunnel0","source_interface_addr":"100.0.0.1","destination_interface_addr":"100.0.0.6"}]}}}}}},"400":{"description":"Bad Request"},"403":{"description":"Forbidden"},"500":{"description":"Internal Server Error"}},"x-roles-required":"default","__originalOperationId":"getStatsRawData_27","method":"post","path":"/statistics/speedtest"}}