Download DNAC reports using API

[TomVr]

Hi,

My customer needs a daily client detail report in JSON format. So I went to DNAC, configured the report, scheduled it, and configured a webhook notification for the report. Every time the report runs, my webhook receiver gets notified with status updates (In Queue -> In Progress -> Success). So after being notified about a successful report run, I want my software to go and fetch the report from DNAC and send it to my customer, right? But how? There does not seem to be an API call for fetching a report, and the webhook notification only includes a URL to the GUI report download page, no REST API endpoint or file location.

So, I thought instead of using a webhook notification, I configure the DNAC report with the email attachment delivery option. But as it turns out, that option is only available for PDF reports.

As an alternative approach I could go and try to create a similar client detail report myself using data I read from the intent API. To get client detail data I can use the /dna/intent/api/v1/client-detail endpoint, but it can only get data from a particular client identified by MAC address, not from all clients. So that means making separate API calls for each and every client in my network. Besides the obvious performance and scaling issues in this approach, the next question that arises is: how do I even obtain a list of all client mac addresses in my network?

What is the best way to go about this? Do I overlook a more straightforward approach?

[Tomas de Leon · Accepted solution]

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
API -- REPORTS: CLIENT REPORT - CLIENT DETAIL_JSON_FORMAT
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+

Goals:

Use the REST API to Get the Results of a Client DETAIL Report

* Get the list of Reports
* Get the Results from an existing Report

REPORTS -- Get List of Reports
------------------------------
GET
{{PROTOCOL}}://{{DNAC.IP.ADDRESS}}/api/dnacaap/v1/daas/core/data-set


REPORTS -- GET Report Results using {{reportId}} & {{executionId}}
------------------------------------------------------------------
{{PROTOCOL}}://{{DNAC.IP.ADDRESS}}/api/dnacaap/v1/daas/core/content/data-set/{{reportId}}/{{executionId}}

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

For Example:
------------

REPORTS -- Get List of Reports
-------------------------------
GET
{{PROTOCOL}}://{{DNAC.IP.ADDRESS}}/api/dnacaap/v1/daas/core/data-set

RESPONSE: (abbreviated output)
{
"version": "1.0",
"response": [
{
"name": "Client Report - Client Detail_JSON_FORMAT",
"dataCategory": "Client",
.
.
"view": {
"name": "Client Detail",
"description": "This client report view provides detailed information about the list of clients that are seen in the network",
.
.
"executionId": "318a739b-19a0-4486-861c-725770f934c3",
.
.
"reportId": "8e214baf-e3c8-4eb5-b433-9a89d165d71e",
.
.
}




REPORTS -- GET Report Results using {{reportId}} & {{executionId}}
------------------------------------------------------------------
GET
{{PROTOCOL}}://{{DNAC.IP.ADDRESS}}/api/dnacaap/v1/daas/core/content/data-set/{{reportId}}/{{executionId}}

From the GET LIST
-----------------
"name": "Client Report - Client Detail_JSON_FORMAT",
"reportId": "8e214baf-e3c8-4eb5-b433-9a89d165d71e",
"executionId": "318a739b-19a0-4486-861c-725770f934c3",


GET
{{PROTOCOL}}://{{DNAC.IP.ADDRESS}}/api/dnacaap/v1/daas/core/content/data-set/8e214baf-e3c8-4eb5-b433-9a89d165d71e/318a739b-19a0-4486-861c-725770f934c3

RESPONSE:
{"client_details": [{"hostName":"--","username":"blue1","macAddress":"F8:66:F2:23:01:FC","ipv4":"172.16.11.109","ipv6":"--","deviceType":"Wired","connectionStatus":"Connected","averageHealthScore_min":"1","averageHealthScore_max":"10","averageHealthScore_median":"10","usage_sum":"250.09","connectedDeviceName":"V1-FIAB1.dna.local","frequency":"--","rssi_median":"--","snr_median":"--","site":"Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER","lastUpdated":"09 Apr, 02:00:00 PM","apGroup":"--","ssid":"--","vlan":"1021","vnid":"--","onboardingEventTime":"--","assocDoneTimestamp":"--","authDoneTimestamp":"--","aaaServerIp":"--","dhcpDoneTimestamp":"--","maxDhcpDuration_max":"--","dhcpServerIp":"--","linkSpeed":"1000.0","txRate_min":"0.0","txRate_max":"3214.47","txRate_avg":"1849.04","rxRate_min":"0.0","rxRate_max":"3672.53","rxRate_avg":"2403.31","txBytes_sum":"108.96","rxBytes_sum":"141.14","dataRate_median":"--","dot11Protocol":"--"},{"hostName":"V1-JUMPBOX1","username":"green1","macAddress":"50:3E:AA:4E:B4:EB","ipv4":"172.16.113.207","ipv6":"fe80::242c:c4dc:40e9:e18e","deviceType":"Wireless","connectionStatus":"Connected","averageHealthScore_min":"7","averageHealthScore_max":"10","averageHealthScore_median":"10","usage_sum":"379.23","connectedDeviceName":"AP00D7.8FA7.1774","frequency":"5.0","rssi_median":"-48.0","snr_median":"45.0","site":"Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER/Floor 3","lastUpdated":"09 Apr, 02:00:00 PM","apGroup":"Floor3_TYPICAL_d02ec","ssid":"Wolverine","vlan":"0","vnid":"8190","onboardingEventTime":"09 Apr, 01:53:00 PM","assocDoneTimestamp":"06 Apr, 05:51:48 PM","authDoneTimestamp":"09 Apr, 01:53:00 PM","aaaServerIp":"192.168.111.85","dhcpDoneTimestamp":"--","maxDhcpDuration_max":"--","dhcpServerIp":"--","linkSpeed":"--","txRate_min":"0.0","txRate_max":"21505.96","txRate_avg":"11254.4","rxRate_min":"0.0","rxRate_max":"19312.27","rxRate_avg":"10100.07","txBytes_sum":"199.76","rxBytes_sum":"179.47","dataRate_median":"72.0","dot11Protocol":"802.11ac"},{"hostName":"AP1800s.SENSOR.43C0","username":"sensor1","macAddress":"0C:75:BD:0D:64:11","ipv4":"172.16.113.206","ipv6":"fe80::e75:bdff:fe0d:6411","deviceType":"Wireless","connectionStatus":"Connected","averageHealthScore_min":"4","averageHealthScore_max":"10","averageHealthScore_median":"10","usage_sum":"605.52","connectedDeviceName":"APCC16.7EDE.7C08","frequency":"5.0","rssi_median":"-40.0","snr_median":"49.0","site":"Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER/Floor 3","lastUpdated":"09 Apr, 02:00:00 PM","apGroup":"Floor3_TYPICAL_d02ec","ssid":"Wolverine","vlan":"8190","vnid":"8190","onboardingEventTime":"09 Apr, 01:54:19 PM","assocDoneTimestamp":"09 Apr, 01:54:15 PM","authDoneTimestamp":"09 Apr, 01:54:16 PM","aaaServerIp":"192.168.111.85","dhcpDoneTimestamp":"09 Apr, 01:54:19 PM","maxDhcpDuration_max":"3101","dhcpServerIp":"192.168.111.87","linkSpeed":"--","txRate_min":"0.0","txRate_max":"7914.67","txRate_avg":"1610.03","rxRate_min":"0.0","rxRate_max":"144646.4","rxRate_avg":"34514.86","txBytes_sum":"27.42","rxBytes_sum":"578.1","dataRate_median":"130.0","dot11Protocol":"802.11ac"},{"hostName":"AP1800s.SENSOR.4770","username":"sensor2","macAddress":"68:CA:E4:77:82:51","ipv4":"172.16.114.206","ipv6":"fe80::6aca:e4ff:fe77:8251","deviceType":"Wireless","connectionStatus":"Connected","averageHealthScore_min":"1","averageHealthScore_max":"10","averageHealthScore_median":"10","usage_sum":"601.18","connectedDeviceName":"AP00D7.8FA7.1774","frequency":"5.0","rssi_median":"-42.0","snr_median":"47.5","site":"Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER/Floor 3","lastUpdated":"09 Apr, 02:00:00 PM","apGroup":"Floor3_TYPICAL_d02ec","ssid":"Cyclops","vlan":"0","vnid":"8193","onboardingEventTime":"09 Apr, 01:55:28 PM","assocDoneTimestamp":"09 Apr, 01:55:27 PM","authDoneTimestamp":"09 Apr, 01:55:28 PM","aaaServerIp":"192.168.111.85","dhcpDoneTimestamp":"09 Apr, 01:40:17 PM","maxDhcpDuration_max":"3456","dhcpServerIp":"192.168.111.87","linkSpeed":"--","txRate_min":"0.0","txRate_max":"7584.27","txRate_avg":"1231.77","rxRate_min":"0.0","rxRate_max":"147635.47","rxRate_avg":"25849.76","txBytes_sum":"27.74","rxBytes_sum":"573.44","dataRate_median":"173.0","dot11Protocol":"802.11ac"},{"hostName":"--","username":"red1","macAddress":"64:F6:9D:79:95:EC","ipv4":"172.16.12.109","ipv6":"--","deviceType":"Wired","connectionStatus":"Connected","averageHealthScore_min":"10","averageHealthScore_max":"10","averageHealthScore_median":"10","usage_sum":"519.55","connectedDeviceName":"V1-FIAB1.dna.local","frequency":"--","rssi_median":"--","snr_median":"--","site":"Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER","lastUpdated":"09 Apr, 02:00:00 PM","apGroup":"--","ssid":"--","vlan":"1028","vnid":"--","onboardingEventTime":"--","assocDoneTimestamp":"--","authDoneTimestamp":"--","aaaServerIp":"--","dhcpDoneTimestamp":"--","maxDhcpDuration_max":"--","dhcpServerIp":"--","linkSpeed":"1000.0","txRate_min":"0.0","txRate_max":"6293.98","txRate_avg":"4141.15","rxRate_min":"0.0","rxRate_max":"6822.45","rxRate_avg":"4614.43","txBytes_sum":"245.95","rxBytes_sum":"273.6","dataRate_median":"--","dot11Protocol":"--"},{"hostName":"V1-JUMPBOX2","username":"black1","macAddress":"50:3E:AA:4F:00:4D","ipv4":"172.16.114.208","ipv6":"--","deviceType":"Wireless","connectionStatus":"Connected","averageHealthScore_min":"10","averageHealthScore_max":"10","averageHealthScore_median":"10","usage_sum":"320.92","connectedDeviceName":"APCC16.7EDE.7C08","frequency":"5.0","rssi_median":"-50.0","snr_median":"39.75","site":"Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER/Floor 3","lastUpdated":"09 Apr, 02:00:00 PM","apGroup":"Floor3_TYPICAL_d02ec","ssid":"Cyclops","vlan":"0","vnid":"8193","onboardingEventTime":"09 Apr, 01:34:28 PM","assocDoneTimestamp":"06 Apr, 06:02:11 PM","authDoneTimestamp":"09 Apr, 01:34:28 PM","aaaServerIp":"192.168.111.85","dhcpDoneTimestamp":"06 Apr, 06:02:16 PM","maxDhcpDuration_max":"1359","dhcpServerIp":"192.168.111.87","linkSpeed":"--","txRate_min":"0.0","txRate_max":"18615.38","txRate_avg":"13843.64","rxRate_min":"0.0","rxRate_max":"18008.89","rxRate_avg":"13542.88","txBytes_sum":"162.2","rxBytes_sum":"158.72","dataRate_median":"72.0","dot11Protocol":"802.11ac"},{"hostName":"--","username":"--","macAddress":"52:54:DD:BB:59:AF","ipv4":"172.16.11.108","ipv6":"fe80::5054:ddff:febb:59af","deviceType":"Wired","connectionStatus":"Connected","averageHealthScore_min":"10","averageHealthScore_max":"10","averageHealthScore_median":"10","usage_sum":"12.66","connectedDeviceName":"V1-FIAB1.dna.local","frequency":"--","rssi_median":"--","snr_median":"--","site":"Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER","lastUpdated":"09 Apr, 02:00:00 PM","apGroup":"--","ssid":"--","vlan":"1021","vnid":"--","onboardingEventTime":"--","assocDoneTimestamp":"--","authDoneTimestamp":"--","aaaServerIp":"--","dhcpDoneTimestamp":"--","maxDhcpDuration_max":"--","dhcpServerIp":"--","linkSpeed":"1000.0","txRate_min":"0.0","txRate_max":"99.57","txRate_avg":"90.45","rxRate_min":"0.0","rxRate_max":"1270.51","rxRate_avg":"1212.53","txBytes_sum":"0.88","rxBytes_sum":"11.78","dataRate_median":"--","dot11Protocol":"--"},{"hostName":"V1-CLIENT1","username":"blue1","macAddress":"00:E0:4C:29:67:7D","ipv4":"172.16.111.209","ipv6":"--","deviceType":"Wireless","connectionStatus":"Connected","averageHealthScore_min":"1","averageHealthScore_max":"10","averageHealthScore_median":"10","usage_sum":"215.28","connectedDeviceName":"APCC16.7EDE.7C08","frequency":"5.0","rssi_median":"-41.0","snr_median":"49.0","site":"Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER/Floor 3","lastUpdated":"09 Apr, 02:00:00 PM","apGroup":"Floor3_TYPICAL_d02ec","ssid":"Wolverine","vlan":"0","vnid":"8189","onboardingEventTime":"09 Apr, 01:40:05 PM","assocDoneTimestamp":"06 Apr, 05:43:41 PM","authDoneTimestamp":"09 Apr, 01:40:05 PM","aaaServerIp":"192.168.111.85","dhcpDoneTimestamp":"06 Apr, 05:43:43 PM","maxDhcpDuration_max":"2044","dhcpServerIp":"192.168.111.87","linkSpeed":"--","txRate_min":"0.0","txRate_max":"12525.16","txRate_avg":"7618.92","rxRate_min":"0.0","rxRate_max":"11512.62","rxRate_avg":"7077.52","txBytes_sum":"111.59","rxBytes_sum":"103.7","dataRate_median":"87.0","dot11Protocol":"802.11ac"},{"hostName":"--","username":"64-F6-9D-37-97-1E","macAddress":"64:F6:9D:37:97:1E","ipv4":"169.254.107.106","ipv6":"--","deviceType":"Wired","connectionStatus":"Connected","averageHealthScore_min":"1","averageHealthScore_max":"1","averageHealthScore_median":"1","usage_sum":"51.6","connectedDeviceName":"V1-FIAB1.dna.local","frequency":"--","rssi_median":"--","snr_median":"--","site":"Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER","lastUpdated":"09 Apr, 02:00:00 PM","apGroup":"--","ssid":"--","vlan":"1","vnid":"--","onboardingEventTime":"--","assocDoneTimestamp":"--","authDoneTimestamp":"--","aaaServerIp":"--","dhcpDoneTimestamp":"--","maxDhcpDuration_max":"--","dhcpServerIp":"--","linkSpeed":"1000.0","txRate_min":"0.0","txRate_max":"691.56","txRate_avg":"92.33","rxRate_min":"0.0","rxRate_max":"1824.21","rxRate_avg":"783.98","txBytes_sum":"5.44","rxBytes_sum":"46.16","dataRate_median":"--","dot11Protocol":"--"}],"filters": [{"name":"Location","displayName":"Location","values":[]},{"name":"DeviceType","displayName":"Device Type","values":[""]},{"name":"SSID","displayName":"SSID","values":[]},{"name":"Band","displayName":"Band","values":[]},{"name":"startTime","displayName":"Start Time","values":["2021-04-02 14:44:51.189 PM UTC"]},{"name":"endTime","displayName":"End Time","values":["2021-04-09 14:44:51.189 PM UTC"]}]}

{
"client_details": [
{
"aaaServerIp": "--", 
"apGroup": "--", 
"assocDoneTimestamp": "--", 
"authDoneTimestamp": "--", 
"averageHealthScore_max": "10", 
"averageHealthScore_median": "10", 
"averageHealthScore_min": "1", 
"connectedDeviceName": "V1-FIAB1.dna.local", 
"connectionStatus": "Connected", 
"dataRate_median": "--", 
"deviceType": "Wired", 
"dhcpDoneTimestamp": "--", 
"dhcpServerIp": "--", 
"dot11Protocol": "--", 
"frequency": "--", 
"hostName": "--", 
"ipv4": "172.16.11.109", 
"ipv6": "--", 
"lastUpdated": "09 Apr, 02:00:00 PM", 
"linkSpeed": "1000.0", 
"macAddress": "F8:66:F2:23:01:FC", 
"maxDhcpDuration_max": "--", 
"onboardingEventTime": "--", 
"rssi_median": "--", 
"rxBytes_sum": "141.14", 
"rxRate_avg": "2403.31", 
"rxRate_max": "3672.53", 
"rxRate_min": "0.0", 
"site": "Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER", 
"snr_median": "--", 
"ssid": "--", 
"txBytes_sum": "108.96", 
"txRate_avg": "1849.04", 
"txRate_max": "3214.47", 
"txRate_min": "0.0", 
"usage_sum": "250.09", 
"username": "blue1", 
"vlan": "1021", 
"vnid": "--"
}, 
{
"aaaServerIp": "192.168.111.85", 
"apGroup": "Floor3_TYPICAL_d02ec", 
"assocDoneTimestamp": "06 Apr, 05:51:48 PM", 
"authDoneTimestamp": "09 Apr, 01:53:00 PM", 
"averageHealthScore_max": "10", 
"averageHealthScore_median": "10", 
"averageHealthScore_min": "7", 
"connectedDeviceName": "AP00D7.8FA7.1774", 
"connectionStatus": "Connected", 
"dataRate_median": "72.0", 
"deviceType": "Wireless", 
"dhcpDoneTimestamp": "--", 
"dhcpServerIp": "--", 
"dot11Protocol": "802.11ac", 
"frequency": "5.0", 
"hostName": "V1-JUMPBOX1", 
"ipv4": "172.16.113.207", 
"ipv6": "fe80::242c:c4dc:40e9:e18e", 
"lastUpdated": "09 Apr, 02:00:00 PM", 
"linkSpeed": "--", 
"macAddress": "50:3E:AA:4E:B4:EB", 
"maxDhcpDuration_max": "--", 
"onboardingEventTime": "09 Apr, 01:53:00 PM", 
"rssi_median": "-48.0", 
"rxBytes_sum": "179.47", 
"rxRate_avg": "10100.07", 
"rxRate_max": "19312.27", 
"rxRate_min": "0.0", 
"site": "Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER/Floor 3", 
"snr_median": "45.0", 
"ssid": "Wolverine", 
"txBytes_sum": "199.76", 
"txRate_avg": "11254.4", 
"txRate_max": "21505.96", 
"txRate_min": "0.0", 
"usage_sum": "379.23", 
"username": "green1", 
"vlan": "0", 
"vnid": "8190"
}, 
{
"aaaServerIp": "192.168.111.85", 
"apGroup": "Floor3_TYPICAL_d02ec", 
"assocDoneTimestamp": "09 Apr, 01:54:15 PM", 
"authDoneTimestamp": "09 Apr, 01:54:16 PM", 
"averageHealthScore_max": "10", 
"averageHealthScore_median": "10", 
"averageHealthScore_min": "4", 
"connectedDeviceName": "APCC16.7EDE.7C08", 
"connectionStatus": "Connected", 
"dataRate_median": "130.0", 
"deviceType": "Wireless", 
"dhcpDoneTimestamp": "09 Apr, 01:54:19 PM", 
"dhcpServerIp": "192.168.111.87", 
"dot11Protocol": "802.11ac", 
"frequency": "5.0", 
"hostName": "AP1800s.SENSOR.43C0", 
"ipv4": "172.16.113.206", 
"ipv6": "fe80::e75:bdff:fe0d:6411", 
"lastUpdated": "09 Apr, 02:00:00 PM", 
"linkSpeed": "--", 
"macAddress": "0C:75:BD:0D:64:11", 
"maxDhcpDuration_max": "3101", 
"onboardingEventTime": "09 Apr, 01:54:19 PM", 
"rssi_median": "-40.0", 
"rxBytes_sum": "578.1", 
"rxRate_avg": "34514.86", 
"rxRate_max": "144646.4", 
"rxRate_min": "0.0", 
"site": "Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER/Floor 3", 
"snr_median": "49.0", 
"ssid": "Wolverine", 
"txBytes_sum": "27.42", 
"txRate_avg": "1610.03", 
"txRate_max": "7914.67", 
"txRate_min": "0.0", 
"usage_sum": "605.52", 
"username": "sensor1", 
"vlan": "8190", 
"vnid": "8190"
}, 
{
"aaaServerIp": "192.168.111.85", 
"apGroup": "Floor3_TYPICAL_d02ec", 
"assocDoneTimestamp": "09 Apr, 01:55:27 PM", 
"authDoneTimestamp": "09 Apr, 01:55:28 PM", 
"averageHealthScore_max": "10", 
"averageHealthScore_median": "10", 
"averageHealthScore_min": "1", 
"connectedDeviceName": "AP00D7.8FA7.1774", 
"connectionStatus": "Connected", 
"dataRate_median": "173.0", 
"deviceType": "Wireless", 
"dhcpDoneTimestamp": "09 Apr, 01:40:17 PM", 
"dhcpServerIp": "192.168.111.87", 
"dot11Protocol": "802.11ac", 
"frequency": "5.0", 
"hostName": "AP1800s.SENSOR.4770", 
"ipv4": "172.16.114.206", 
"ipv6": "fe80::6aca:e4ff:fe77:8251", 
"lastUpdated": "09 Apr, 02:00:00 PM", 
"linkSpeed": "--", 
"macAddress": "68:CA:E4:77:82:51", 
"maxDhcpDuration_max": "3456", 
"onboardingEventTime": "09 Apr, 01:55:28 PM", 
"rssi_median": "-42.0", 
"rxBytes_sum": "573.44", 
"rxRate_avg": "25849.76", 
"rxRate_max": "147635.47", 
"rxRate_min": "0.0", 
"site": "Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER/Floor 3", 
"snr_median": "47.5", 
"ssid": "Cyclops", 
"txBytes_sum": "27.74", 
"txRate_avg": "1231.77", 
"txRate_max": "7584.27", 
"txRate_min": "0.0", 
"usage_sum": "601.18", 
"username": "sensor2", 
"vlan": "0", 
"vnid": "8193"
}, 
{
"aaaServerIp": "--", 
"apGroup": "--", 
"assocDoneTimestamp": "--", 
"authDoneTimestamp": "--", 
"averageHealthScore_max": "10", 
"averageHealthScore_median": "10", 
"averageHealthScore_min": "10", 
"connectedDeviceName": "V1-FIAB1.dna.local", 
"connectionStatus": "Connected", 
"dataRate_median": "--", 
"deviceType": "Wired", 
"dhcpDoneTimestamp": "--", 
"dhcpServerIp": "--", 
"dot11Protocol": "--", 
"frequency": "--", 
"hostName": "--", 
"ipv4": "172.16.12.109", 
"ipv6": "--", 
"lastUpdated": "09 Apr, 02:00:00 PM", 
"linkSpeed": "1000.0", 
"macAddress": "64:F6:9D:79:95:EC", 
"maxDhcpDuration_max": "--", 
"onboardingEventTime": "--", 
"rssi_median": "--", 
"rxBytes_sum": "273.6", 
"rxRate_avg": "4614.43", 
"rxRate_max": "6822.45", 
"rxRate_min": "0.0", 
"site": "Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER", 
"snr_median": "--", 
"ssid": "--", 
"txBytes_sum": "245.95", 
"txRate_avg": "4141.15", 
"txRate_max": "6293.98", 
"txRate_min": "0.0", 
"usage_sum": "519.55", 
"username": "red1", 
"vlan": "1028", 
"vnid": "--"
}, 
{
"aaaServerIp": "192.168.111.85", 
"apGroup": "Floor3_TYPICAL_d02ec", 
"assocDoneTimestamp": "06 Apr, 06:02:11 PM", 
"authDoneTimestamp": "09 Apr, 01:34:28 PM", 
"averageHealthScore_max": "10", 
"averageHealthScore_median": "10", 
"averageHealthScore_min": "10", 
"connectedDeviceName": "APCC16.7EDE.7C08", 
"connectionStatus": "Connected", 
"dataRate_median": "72.0", 
"deviceType": "Wireless", 
"dhcpDoneTimestamp": "06 Apr, 06:02:16 PM", 
"dhcpServerIp": "192.168.111.87", 
"dot11Protocol": "802.11ac", 
"frequency": "5.0", 
"hostName": "V1-JUMPBOX2", 
"ipv4": "172.16.114.208", 
"ipv6": "--", 
"lastUpdated": "09 Apr, 02:00:00 PM", 
"linkSpeed": "--", 
"macAddress": "50:3E:AA:4F:00:4D", 
"maxDhcpDuration_max": "1359", 
"onboardingEventTime": "09 Apr, 01:34:28 PM", 
"rssi_median": "-50.0", 
"rxBytes_sum": "158.72", 
"rxRate_avg": "13542.88", 
"rxRate_max": "18008.89", 
"rxRate_min": "0.0", 
"site": "Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER/Floor 3", 
"snr_median": "39.75", 
"ssid": "Cyclops", 
"txBytes_sum": "162.2", 
"txRate_avg": "13843.64", 
"txRate_max": "18615.38", 
"txRate_min": "0.0", 
"usage_sum": "320.92", 
"username": "black1", 
"vlan": "0", 
"vnid": "8193"
}, 
{
"aaaServerIp": "--", 
"apGroup": "--", 
"assocDoneTimestamp": "--", 
"authDoneTimestamp": "--", 
"averageHealthScore_max": "10", 
"averageHealthScore_median": "10", 
"averageHealthScore_min": "10", 
"connectedDeviceName": "V1-FIAB1.dna.local", 
"connectionStatus": "Connected", 
"dataRate_median": "--", 
"deviceType": "Wired", 
"dhcpDoneTimestamp": "--", 
"dhcpServerIp": "--", 
"dot11Protocol": "--", 
"frequency": "--", 
"hostName": "--", 
"ipv4": "172.16.11.108", 
"ipv6": "fe80::5054:ddff:febb:59af", 
"lastUpdated": "09 Apr, 02:00:00 PM", 
"linkSpeed": "1000.0", 
"macAddress": "52:54:DD:BB:59:AF", 
"maxDhcpDuration_max": "--", 
"onboardingEventTime": "--", 
"rssi_median": "--", 
"rxBytes_sum": "11.78", 
"rxRate_avg": "1212.53", 
"rxRate_max": "1270.51", 
"rxRate_min": "0.0", 
"site": "Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER", 
"snr_median": "--", 
"ssid": "--", 
"txBytes_sum": "0.88", 
"txRate_avg": "90.45", 
"txRate_max": "99.57", 
"txRate_min": "0.0", 
"usage_sum": "12.66", 
"username": "--", 
"vlan": "1021", 
"vnid": "--"
}, 
{
"aaaServerIp": "192.168.111.85", 
"apGroup": "Floor3_TYPICAL_d02ec", 
"assocDoneTimestamp": "06 Apr, 05:43:41 PM", 
"authDoneTimestamp": "09 Apr, 01:40:05 PM", 
"averageHealthScore_max": "10", 
"averageHealthScore_median": "10", 
"averageHealthScore_min": "1", 
"connectedDeviceName": "APCC16.7EDE.7C08", 
"connectionStatus": "Connected", 
"dataRate_median": "87.0", 
"deviceType": "Wireless", 
"dhcpDoneTimestamp": "06 Apr, 05:43:43 PM", 
"dhcpServerIp": "192.168.111.87", 
"dot11Protocol": "802.11ac", 
"frequency": "5.0", 
"hostName": "V1-CLIENT1", 
"ipv4": "172.16.111.209", 
"ipv6": "--", 
"lastUpdated": "09 Apr, 02:00:00 PM", 
"linkSpeed": "--", 
"macAddress": "00:E0:4C:29:67:7D", 
"maxDhcpDuration_max": "2044", 
"onboardingEventTime": "09 Apr, 01:40:05 PM", 
"rssi_median": "-41.0", 
"rxBytes_sum": "103.7", 
"rxRate_avg": "7077.52", 
"rxRate_max": "11512.62", 
"rxRate_min": "0.0", 
"site": "Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER/Floor 3", 
"snr_median": "49.0", 
"ssid": "Wolverine", 
"txBytes_sum": "111.59", 
"txRate_avg": "7618.92", 
"txRate_max": "12525.16", 
"txRate_min": "0.0", 
"usage_sum": "215.28", 
"username": "blue1", 
"vlan": "0", 
"vnid": "8189"
}, 
{
"aaaServerIp": "--", 
"apGroup": "--", 
"assocDoneTimestamp": "--", 
"authDoneTimestamp": "--", 
"averageHealthScore_max": "1", 
"averageHealthScore_median": "1", 
"averageHealthScore_min": "1", 
"connectedDeviceName": "V1-FIAB1.dna.local", 
"connectionStatus": "Connected", 
"dataRate_median": "--", 
"deviceType": "Wired", 
"dhcpDoneTimestamp": "--", 
"dhcpServerIp": "--", 
"dot11Protocol": "--", 
"frequency": "--", 
"hostName": "--", 
"ipv4": "169.254.107.106", 
"ipv6": "--", 
"lastUpdated": "09 Apr, 02:00:00 PM", 
"linkSpeed": "1000.0", 
"macAddress": "64:F6:9D:37:97:1E", 
"maxDhcpDuration_max": "--", 
"onboardingEventTime": "--", 
"rssi_median": "--", 
"rxBytes_sum": "46.16", 
"rxRate_avg": "783.98", 
"rxRate_max": "1824.21", 
"rxRate_min": "0.0", 
"site": "Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER", 
"snr_median": "--", 
"ssid": "--", 
"txBytes_sum": "5.44", 
"txRate_avg": "92.33", 
"txRate_max": "691.56", 
"txRate_min": "0.0", 
"usage_sum": "51.6", 
"username": "64-F6-9D-37-97-1E", 
"vlan": "1", 
"vnid": "--"
}
], 
"filters": [
{
"displayName": "Location", 
"name": "Location", 
"values": []
}, 
{
"displayName": "Device Type", 
"name": "DeviceType", 
"values": [
""
]
}, 
{
"displayName": "SSID", 
"name": "SSID", 
"values": []
}, 
{
"displayName": "Band", 
"name": "Band", 
"values": []
}, 
{
"displayName": "Start Time", 
"name": "startTime", 
"values": [
"2021-04-02 14:44:51.189 PM UTC"
]
}, 
{
"displayName": "End Time", 
"name": "endTime", 
"values": [
"2021-04-09 14:44:51.189 PM UTC"
]
}
]
}

[TomVr]

Brilliant!! Thank you very much! This is exactly what I was looking for!

[TomVr]

@Tomas de Leon,

Is there any public documentation on the APIs you mentioned here? Or is this Cisco internal? Just wondering for future reference.

[Tomas de Leon]

Intent API

Cisco DNA Center Platform v. 1.2.10
https://pubhub.devnetcloud.com/media/dna-center-api-1210/docs/swagger_dnacp_1210.html#%21/

CIsco DNA Center Platform v. 1.3.0.x
https://developer.cisco.com/docs/dna-center/api/1-3-0-x/

Cisco DNA Center Platform v. 1.3.1.x
https://developer.cisco.com/docs/dna-center/api/1-3-1-x/

Cisco DNA Center Platform v. 1.3.3.x
https://developer.cisco.com/docs/dna-center/#%21cisco-dna-1-3-3-x-api-overview

Cisco DNA Center Platform v. 2.1.2.x
https://developer.cisco.com/docs/dna-center/#%21cisco-dna-2-1-2-x-api-overview

SDK (Python)
https://developer.cisco.com/docs/dna-center/#%21python-sdk-getting-started

Cisco DNA Center Multivendor SDK
https://developer.cisco.com/docs/dna-center/#%21multivendor-sdk-overview/overview

Cisco EN Programmability
https://github.com/cisco-en-programmability

[TomVr]

Which of those should describe the DNACaaP Api?

[Tomas de Leon]

Unfortunately, not all of the APIs are documented or exposed.   But they are adding more and more to the documentation.

The way to discover undocumented APIs is to use your browsers Developer tools and from there you can decipher the API calls and the necessary parameters.

I hope this helps

T.

[TomVr]

Definitely helpful! Thanks Tomas!