topic Re: How to export the list of all Custom Dashboards in the controller into a format like JSON or XML? in Splunk AppDynamics

How to export the list of all Custom Dashboards in the controller into a format like JSON or XML?

Amartya_Jha — Thu, 19 Nov 2020 15:48:27 GMT

Is there a way you can export Dashboards in any format like JSON or XML?

^ Edited by @Ryan.Paredez to include the location of the original comment.

Note: This comment was split off into its own post from this original post: How to export the list of all Custom Dashboards in the controller into a file?

Re: How to export the list of all Custom Dashboards in the controller into a format like JSON or XML?

Nawaz_Ali_Moha1 — Wed, 02 Dec 2020 07:26:24 GMT

Hello Amartya,

If you export the custom dashboards from "Dashboards & Reports", I see that the dashboard by default is being exported as .json file. I have attached a gif recording of the same.

Re: How to export the list of all Custom Dashboards in the controller into a format like JSON or XML?

Vishwanath_Nair — Mon, 15 Mar 2021 09:22:58 GMT

Is there a way to export all the dashboards at once via command line ?

We would like to set up an automated way of exporting all custom dashboards at regular intervals.

Re: How to export the list of all Custom Dashboards in the controller into a format like JSON or XML?

Morelz — Mon, 15 Mar 2021 12:34:35 GMT

Hi There

You can create a simple script to query all the dashboard ID's

https://<controller URL>/controller/restui/dashboards/getPermissionsForDashboards

Then just loop through the dashboard id's, example below GET Query

https://<controller URL>/controller/CustomDashboardImportExportServlet?dashboardId=1234

We used a Python script to do this task, for regular backups of teh dashboards into JSON backups format

Ciao

Re: How to export the list of all Custom Dashboards in the controller into a format like JSON or XML?

Vishwanath_Nair — Fri, 19 Mar 2021 03:31:56 GMT

Thanks for the tip @Mario.Morelli .

I tried a simple curl test to the url https://<controller URL>/controller/restui/dashboards/getPermissionsForDashboards and I got an error.

curl --user xxxxxx@xxxxx:xxxx https://appdynamics_controller:8181/controller/restui/dashboards/getPermissionsForDashboards

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Unauthorized</title>
</head>
<body>
HTTP Error 401 Unauthorized
<p/>
This request requires HTTP authentication
</body>
</html>

Is this expected ? HTTP is blocked in our environment, so cant test that. Also, we are going through a LB.

Re: How to export the list of all Custom Dashboards in the controller into a format like JSON or XML?

Morelz — Fri, 19 Mar 2021 09:25:42 GMT

Hi Vishwanath

My Apologies, I gave you the incorrect details, please find below method to query it:)

1) Get the JESSIONID and X-CSRF-TOKEN with user having permissions

curl -i --user <USERNAME>@<Account>:<PASSWORD> https://<Controller-URL>/controller/auth?action=login

2) Run the following CURL call with JESSIONID and X-CSRF-TOKEN from step 1?

curl -i -H "X-CSRF-TOKEN:<TOKEN FROM ABOVE>" -H "Cookie: JSESSIONID=<JSESSION ID FROM ABOVE>; X-CSRF-TOKEN=<TOKEN>;" -H "Content-Type: application/json" -H "Accept: application/json" https://<Controller URL>/controller/restui/dashboards/getAllDashboardsByType/false

Example below
curl -i -H "Cookie:JSESSIONID=9b81672143e228e4eb73fdea89a9;" -H "X-CSRF-TOKEN:6fece457az197155a8f68320cfa781eaeb88991b" -H "Content-Type: application/json" -H "Accept: application/json" https://<controller url>/controller/restui/dashboards/getAllDashboardsByType/false"

This will output all dashboards, with one of the attributes being the Dashboard ID, which you can then use in the last query

https://<controller url>/controller/CustomDashboardImportExportServlet?dashboardId=<dashboard ID>

Ciao

Re: How to export the list of all Custom Dashboards in the controller into a format like JSON or XML?

Vishwanath_Nair — Tue, 23 Mar 2021 03:27:29 GMT

Thanks a lot! Much appreciated.

Re: How to export the list of all Custom Dashboards in the controller into a format like JSON or XML?

Maximiliano_Sal — Mon, 01 Jul 2024 20:25:31 GMT

Hi! Now that global logon has been implemented, how can you take the value of the cookie needed? I only can get it manually, but need to programmatically obtain it; however, cannot do it requesting login with basic auth anymore.

Re: How to export the list of all Custom Dashboards in the controller into a format like JSON or XML?

iamryan — Mon, 08 Jul 2024 16:27:09 GMT

Hi @Maximiliano.Salibe,

It looks like since this was an older thread, the other members did not chime in. Since it has been a few days, did you happen to find a solution or anything you can share?

If you still need help with this, you can contact Cisco AppDynamics Support. https://www.appdynamics.com/support

Re: How to export the list of all Custom Dashboards in the controller into a format like JSON or XML?

Morelz — Wed, 10 Jul 2024 07:26:14 GMT

Hi Maximiliano

What issue are you having with basic auth? We are still able to use it without any issues.

But either way, bets practice is to rather create an API Key and use that to do what you need to do, that is the suggested and best practice way.

If you are not sure on how to use the API Key method, just DM me, I can share a sample python script for you to get started

Ciao

Re: How to export the list of all Custom Dashboards in the controller into a format like JSON or XML?

Maximiliano_Sal — Wed, 10 Jul 2024 20:34:53 GMT

Hi Mario, thanks for your response.

This is what I get when requesting login.

Re: How to export the list of all Custom Dashboards in the controller into a format like JSON or XML?

iamryan — Tue, 16 Jul 2024 15:25:21 GMT

Hi @Mario.Morelli,

Are you able to jump back in here and help out @Maximiliano.Salibe?