Best Of

Hi Genevieve,

Thank you for your reply. For getting attachment names , I have written a python code to get a list of attachment names in sheet to a local CSV file.

Python Code:

import requests
import csv

# Replace with your Smartsheet API token and sheet ID
token = 'Your API access key'
sheet_id = 'Your Sheet ID'
# Get the list of attachments for all rows
url = f'https://api.smartsheet.com/2.0/sheets/{sheet_id}/attachments'
headers = {'Authorization': f'Bearer {token}'}
response = requests.get(url, headers=headers)
attachments_data = response.json()

# List to store attachment names
attachment_names = []

# Loop through attachments and collect names
for attachment in attachments_data['data']:
    attachment_name = attachment.get('name')
    if attachment_name:
        attachment_names.append(attachment_name)

# Write attachment names to the CSV file
csv_file_path = 'Local path to your csv files'
with open(csv_file_path, 'w', newline='') as csvfile:
    writer = csv.writer(csvfile)
    writer.writerow(['Attachment Names'])
    writer.writerows([[name] for name in attachment_names])

print(f"Attachment names saved to {csv_file_path}")