Snapshot export api for paginated report

Question & Answer
,
1

Hi Experts,
Can we leverage snapshot export api for paginated reports and if yes how do i get visual ids for the paginated report visual.

2

Hello Syed,

Yes. you could leverage Snapshot export API for PDF or CSV as output format. when it comes to visual id’s if i am not mistaken it would be dashboard or sheet id.

May be for your reference see - Deliver Amazon QuickSight paginated reports to non-QuickSight users | AWS Business Intelligence Blog

Hope this helps.

Cheers,
Deep

3

Hi @Deep ,
I used this APIs for normal interactive dashboard excel extract to s3 but not sure if it can be used for paginated reports where i dont see any visual ids.
Do i need to consider entire sheet for paginated report?

4

Hello Syed,

Yes the entire sheet if i am not mistaken since the data returned in the paginated report is a static snapshot and you would not get id’s of visuals embossed in it.

Additional reference info:

Hope this helps.

Cheers,
Deep

1 Like
5

Hi @syed_imran,

You can get the visual ID by selecting “Embed visual” in the visual menu and expanding “IDs for developers”.

image
image480Ă—1210 74.9 KB

6

Thanks @David_Wong ,I was looking for Paginated reports not the interactive reports.

7

Thanks @Deep will try the solution proposed and update.

8

@syed_imran,

I tested it with paginated reports and it works. For PDF, you have to do an entire sheet and can’t select individual visuals. For Excel, you can do multiple visuals of one sheet. For CSV, you have to specify only one visual.

You can use DescribeDashboardDefinition to get the visual ID.

1 Like