Search code examples
pythonsmartsheet-api

How do I download a PDF in portrait layout using the Smartsheet api?


Downloading a Smartsheet as a PDF file is straightforward. Here's my script:

import smartsheet

smartsheet = smartsheet.Smartsheet(token)

sheetId = target_sheet_id
download_directory_path = 'C:\Users\User\Downloads'
paper_size = 'LETTER'

# Download target sheet to specified location as PDF of given size 
smartsheet.Sheets.get_sheet_as_pdf(sheetId, download_directory_path, paper_size)

The problem is that the PDF is in landscape mode and more than one page wide. The Smartsheets I'm trying to download all require portrait mode and fit to one page in order to display properly.

Is there a parameter that I'm missing that would allow me to change the layout to portrait mode and fit to width?

If not, are there any known workarounds?


Solution

  • Unfortunately, you've identified a limitation in the underlying product API. I've added a request to be able specify page layout to our product backlog, but can't make any commitments about priority or schedule.