DNAC API Create Report keeps returning HTTP 500

[stcoppens]

Hi!

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:

- The built-in developer toolkit

- Postman

- Python scripts

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.

My script in short:

    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)

Could someone give me some advice what I'm doing wrong?

Thanks in advance!

[marce1000]

  - I got some error when using https://jsonlint.com/  , for your input ; you may want to run that too , 

 M.