Attach a file to a Row

Jen K.

Hello, I am unsure what this is and how to get it in order to attach a file to a row in Smartsheet. Can someone please help? Examples would be great. Thank you!

jmyzk_cloudsmart_jp

Hi @Jen K.

Here is the code using Smartsheet Pyhond SDK.

import smartsheet


# Initialize the Smartsheet client with your API token

smartsheet_client = smartsheet.Smartsheet('YOUR_ACCESS_TOKEN')


# Specify the sheet ID and file path (replace these with your actual values)

sheet_id = 1234567890123456  # Replace with your actual sheet ID

file_path = "path_to_your_image_file/smartsheet-logo.png"  # Replace with your actual file path
#example
#path = "/content/smartsheet-logo-mark-collaboration-blue-square.jpg"

#path = "C:/My Drive/2 -3 logo/Smartsheet - Logo Horizontal/smartsheet-logo-horizontal-380x128.png"




# Get the sheet

sheet = smartsheet_client.Sheets.get_sheet(sheet_id)


# Loop through each row in the sheet and attach the PNG file


for row in sheet.rows:

    updated_attachment = smartsheet_client.Attachments.attach_file_to_row(

        sheet_id,       # sheet_id

        row.id,         # row_id

        ('smartsheet-logo.png',

         open(path, 'rb'),

         'image/png')   # Correct MIME type for PNG file

    )

To install the Smartsheet Python SDK, you need to run the following command in your terminal or command prompt:

pip install smartsheet-python-sdk

Jen K.

Hi @jmyzk_cloudsmart_jp,

Thank you very much for your help. I'll give that a try. I was trying to use the URL version, and had some confusion on the binary portion. How do I translate that if I'm using a URL? Thank you