Hi @jmbenedetto — thanks for sharing your use case, it sounds like a great one!
Just to clarify: was your automation flow intended to read the contents of the uploaded CSV file and then use it to create records in another table (like a movement log)? If so — we’d love to hear how you were planning to do that, since Bika.ai currently doesn’t support parsing attachments directly in automations.
That said, if your current issue is about accessing the uploaded file’s URL in automation — we’ve got a workaround for that: Construct File URL Using a Script.
Bika.ai doesn’t yet support using file URLs directly as variables, but you can extract the file path and construct the full URL like this:
fileURL = "https://s1.bika.ai/" + file_info["path"]
Here’s a real example from our AI Batch Image Recognition template:
fileData = <%= JSON.stringify(_item.cells.fldPmeTR63BaQVDjwc7ILVxM.data) %>
IMAGE_MIME_TYPES = {'image/jpeg', 'image/png', 'image/webp'}
if len(fileData) == 1:
file_info = fileData[0]
mime_type = file_info.get("mimeType", "").lower()
if (mime_type in IMAGE_MIME_TYPES):
fileURL = "https://s1.bika.ai/" + file_info["path"]
else:
fileURL = "File is not a supported image format: " + mime_type
else:
fileURL = "Expected exactly 1 file, got " + str(len(fileData))
To get this working:
- Use the Run Script action.
- Use / to call the file field’s raw value(<%= JSON.stringify(_item.cells.fldPmeTR63BaQVDjwc7ILVxM.data) %>): choose field → attachment → field raw data.
It’s a bit manual for now, but we’re actively working to make this process much smoother in future updates.
Here are a couple of helpful resources you might find useful:
Manual Incremental Import Option:
Import and Export | Bika.ai
Upload Files via API
How to upload files to Bika and update record via API