Question
There are digital files (e.g., CSV, TSV, XLSX) available in Salesforce in tables, such as the Attachment table. Does Fivetran sync these files?
Environment
Connector: Salesforce
Answer
Only the metadata of the files is synced but not the content itself. The API sends and receives the file attachment data encoded as base64Binary and Fivetran does not sync Base64 fields.
However, if you have an option of exporting these files as CSV or TSV files, you can use one of Fivetran's File connectors to upload this data into your warehouse.