Help

Unable to upload PDF files to Airtable using Python

210 1
cancel
Showing results for 
Search instead for 
Did you mean: 
HarryAndy99
4 - Data Explorer
4 - Data Explorer
I'M TRYING TO UPLOAD PDF FILES TO AN AIRTABLE BASE USING PYTHON, BUT I'M FACING ISSUES WITH THE PROCESS. I'VE TRIED MULTIPLE PYTHON LIBRARIES, BUT NONE OF THEM SEEM TO WORK CORRECTLY FOR MY USE CASE.
 
Here's the code I've been using (replace with your latest code snippet):
 
import os
import glob
from airtable import Airtable
 
# Configure Airtable connection
airtable = Airtable('base_id', 'Table 8', api_key='api_key')
 
# Path to the folder containing PDFs
pdf_folder = r"C:\Users\camip\Desktop\_adjuntos_prueba"
 
# Get a list of PDF files in the folder
pdf_files = glob.glob(os.path.join(pdf_folder, "*.pdf"))
 
for pdf_file in pdf_files:
try:
# Get the name of the PDF file
pdf_name = os.path.basename(pdf_file)
 
# Extract the number from the file name by removing the extension and converting to int
pdf_number = int(os.path.splitext(pdf_name)[0])
 
# Get all records from Airtable
records = airtable.get_all(view='Grid view')
 
# Find records where the name contains the number from the PDF file name
matching_records = [record for record in records if str(pdf_number) in record['fields'].get('Name', '')]
 
if matching_records:
# If a matching record is found, upload the PDF
record = matching_records[0]['fields']
 
# Check if there is already an attachment
attachments = record.get('Archivos adjuntos', [])
if attachments:
print(f"PDF {pdf_name} already has an attachment. Not uploaded.")
else:
# Upload the PDF file
airtable.update(matching_records[0]['id'], {'Archivos adjuntos': [{'url': f'attachment://{pdf_name}'}]})
print(f"PDF {pdf_name} uploaded to record {record['Name']}")
else:
print(f"No matching record found for {pdf_name}")
 
except Exception as e:
print(f"Error processing file {pdf_name}: {str(e)}")
 
When I run this code, it appears to iterate through each PDF file in the specified folder and attempt to upload it to the corresponding record in Airtable based on a number in the file name. However, no PDF files are actually being uploaded to Airtable.
 
 
Can someone please guide me on what I might be doing wrong or suggest a better approach to achieve this task? I'd appreciate any help or insights into resolving this issue.
 
Please let me know if you need any additional information or clarification regarding my problem.
1 Reply 1

When using code to upload files to Airtable attachment fields, the file must be hosted at a publicly available url. This means that you cannot directly upload files from the local computer or from a blob. You must first move the file to a service that will provide a public url for the file. Then you can use that public url to upload the file to Airtable.