I've been trying to create reports via the API so I can automate some data retrieval. However, I've attempted to do this by using:
Each returning "Http Error Code:500" with not much else to go on.
I'm assuming my error is because of some fault in my payload. I've copied the JSON request body from https://developer.cisco.com/docs/dna-center/#!create-or-schedule-a-report after filling in all the details in the form and adjusting the valuee/schedule where needed. I have also tested sending my payload as-is or as json.dumps(payload) with the request.
url = f"https://{dnaURL}:443/dna/intent/api/v1/data/reports"
payload = '''{
"tags": [],
"deliveries": [ {} ],
"name": "API Test - Client Report",
"schedule": {
"type": "SCHEDULE_LATER",
"timeZoneId": "Europe/Brussels",
"scheduledServiceId": "b826f162-5115-49cd-9267-1f81b423178c",
"dateTime": 1696949730
},
"view": {
"fieldGroups": [
{
"fieldGroupDisplayName": "Client Details",
"fieldGroupName": "client_details",
"fields": [
{
"displayName": "MAC Address",
"name": "macAddress"
},
{
"displayName": "Connected Device Name",
"name": "connectedDeviceName"
},
{
"displayName": "Band",
"name": "frequency"
},
{
"displayName": "Last Location",
"name": "site"
},
{
"displayName": "SSID",
"name": "ssid"
}
]
}
],
"filters": [
{
"value": [
{
"value": "sample-global-site-id",
"displayValue": "Global"
}
],
"displayName": "Location",
"name": "Location",
"type": "MULTI_SELECT_TREE"
},
{
"value": [
{
"value": "Wireless",
"displayValue": "Wireless"
}
],
"type": "SINGLE_SELECT_ARRAY",
"name": "DeviceType",
"displayName": "Device Type"
},
{
"value": [
{
"value": "SSID_one",
"displayValue": "SSID_one"
},
{
"value": "SSID_two",
"displayValue": "SSID_two"
}
],
"type": "MULTI_SELECT",
"displayName": "SSID",
"name": "SSID"
},
{
"value": [
{
"value": "2.4",
"displayValue": "2.4"
},
{
"value": "5",
"displayValue": "5"
}
],
"type": "MULTI_SELECT",
"displayName": "Band",
"name": "Band"
},
{
"value": {
"timeRangeOption": "CUSTOM",
"startDateTime": 1696834800000,
"endDateTime": 1696863660000,
"timeZoneId": "Europe/Brussels"
},
"type": "TIME_RANGE",
"name": "TimeRange",
"displayName": "Time Range"
}
],
"format": {
"formatType": "JSON",
"name": "JSON"
},
"name": "Client Detail",
"viewId": "e8e66b17-4aeb-4857-af81-f472023bb05e"
},
"dataCategory": "Client",
"viewGroupId": "d7afe5c9-4941-4251-8bf5-0fb643e90847",
"viewGroupVersion": "2.0.0"
}'''
headers = {
"Content-Type": "application/json",
"Accept": "application/json",
'x-auth-token':X_AUTH_TOKEN
}
# Attempt HTTP request
r = requests.request('POST', url, headers=headers, data = json.dumps(payload), verify=False)
