Please let me know if we can export quicksight dashboard in json format

Question & Answer
, , ,
1

Please let me know if we can export quicksight dashboard into json format

2

Hello @Deepa.si, welcome to the QuickSight community! Yes, this is possible, and there are 2 primary ways to accomplish this.

You can either use the asset-bundle-export-job function through the CLI to export your QuickSight resources as JSON.

https://docs.aws.amazon.com/cli/latest/reference/quicksight/start-asset-bundle-export-job.html

Another option is to use the DescribeDashboard, DescribeDashbaordDefinition, and DescribeDashboardPermissions through the CLI or boto3 (I use this in python), to query the json for your QuickSight dashboards.

The 2nd method is my preferred, but both can be utilized to accomplish this. I will mark this as a solution, let me know if you have any follow-up questions. Thank you!

3

How can we use second method in AWS console is there any service we can use . Since we are not allowed to use cli on our company.also how can we use second method in json format export . Iam unable to understand. Is there any video u guys can recommend

4

Hello @Deepa.si, unfortunately, this is functionality that is strictly utilized through the QuickSight APIs. There isn’t a simple plug and play option within the console to complete this task. Either utilizing the CLI or the QuickSight SDK with boto3 are the ways that you will be able to convert the dashboard to JSON. The only export options available within the console are to export a sheet as a PDF or a table visual as an Excel or CSV file.

Since this functionality does not exist though, I will tag it as a feature request for the support team. At AWS, our roadmap is driven by our customers. Thank you for your feedback!

1 Like