2026-03-26 - Nested Folder FileDrop and BOM Detection Fix¶
Release¶
AgileData.io - Files Landing Where They Should: Nested Folder and BOM Fixes
Two file processing issues have been resolved that were affecting reliable data ingestion through FileDrop.
The first fix addresses files dropped into nested folders—the folder path structure is now correctly preserved and passed through to the FileDrop rule, so files land in the right place based on their folder location. Previously, folder names were being stripped from nested file paths, breaking the routing logic.
The second fix detects Byte Order Mark (BOM) characters in files before they’re sent to BigQuery. BOM characters are invisible markers sometimes added by spreadsheet tools like Excel. When present, BigQuery couldn’t correctly parse the header row, causing imports to fail or load data into the wrong columns.
What was happening:
Files in nested folders were losing their path information, causing incorrect rule matching
BOM characters in CSV files were preventing BigQuery from reading column headers correctly
What was fixed:
Folder names are now preserved for nested file paths in FileDrop rules
BOM detection added before BigQuery processing to ensure clean header parsing
What this means for you:
Files dropped into organised folder structures are routed correctly to the right rules
CSV files exported from Excel and other tools import reliably without header errors
More consistent and dependable data ingestion through FileDrop
Last Refreshed¶
Doc Refreshed: 2026-03-26