Is there any way to Automate to upload files from local to the specific row in smartsheet in bulk?

Hi,

I tried to write a python code to upload files from local to rows in smartsheet in bulk. The is executed without any output.

Could someone please help me on it to.

Python Code:

import requests
import os


base_url = "https://api.smartsheet.com/2.0"
access_token = "Your_api_token"
sheet_id = "1234567"  # Replace with your sheet ID
attach_url = base_url + '/sheets/{sheet_id}/rows/{row_id}

row_attachments={'file_path':'row_id',
      'file_path_1':'row_id_1',
      'file_path_2':'row_id_2',
.......
}


def upload_attachment(row_id, file_path):
    url = attach_url.format(sheet_id=sheet_id,row_id=row_id)
    headers = {
        "Authorization": f"Bearer {access_token}",
    "Content-Type":"application/octet-stream",
        "Content-Disposition": f"attachment; filename=\'os.path.basename(file_path)\'"
    }

    files ={'file': open(file_path,'rb')}

    response= requests.post(url, headers=headers, files=files)

    if response.status_code == 200:
        print("Attachment uploaded successfully to row", row_id)
    else:
        print(f"Failed to upload attachment to row", row_id)
        print(response.text)

Find more posts tagged with

Accepted answers

All comments

Lee Joramo

I don't have time to dig into this and provide a detailed answer. I will suggest that instead of python's requests module, you should use the Smartsheet Python SDK, it takes care of many issues for you, including dealing with rate-limits and retries.

There are times you may need to go beyond the SDK, and directly use requests , but I have found this to be rare

rye

Hi @Lee Joramo

I have tried using Smartsheet Python SDK as well . But I could see same that code is executed without any output.

Python Code:

import os
from smartsheet import Smartsheet
from smartsheet.models import Sheet, Row, Column, Cell

access_token = 'Your_Token_Access'

# Initialize smartsheet
ss_client= Smartsheet(access_token)

sheet_id = 'Your_Sheet_ID'
column_id = 'Your Column ID'

files_and_rows={'file_path':'row_id',
      'File path 1':'Row_1',
      'File path 2':'Row_2'
}

#Function to upload files to smartsheet
def upload_files_to_smartsheet(files_and_rows, sheet_id, column_id):
    #Open the sheet
    sheet = ss_client.sheets.get_sheet(sheet_id)
    
   #Iterate over files and rows
    for file_path, row_id in files_and_rows:
        #Create a new row
        new_row = Row()
        new_row.cells.append(Cell(column_id, value = os.path.basename(file_path)))

        #Attach the file to row
        response = ss_client.Attachments.attach_file_to_row(sheet_id, row_id,file_path,new_row.cells[0])

        if response and response.message:
            print(f"File {file_path} uploaded successfully to row {row_id}")
        else:
            print(f"Failed to upload files")

Lee Joramo

@rye I will try to give this a review later today. However, I will note that you included what appears to be a real API token. You will want to reset that ASAP. (We have all done this sort of thing.)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.