File Storage

File Storage Sync enables you to import file and folder information from your cloud storage platform. It follows a predefined schema that standardizes storage data across systems, so you can audit what lives where, track sizes and types, and build file inventories across your drives.

Current supported sources include:

• Google Drive
• Dropbox
• Box

Available Tables

Each table is mapped to a well-defined set of fields to maintain a unified structure. App Sync also includes relational fields that connect files to their folders.

FS_File

Represents file metadata from the connected storage platform. Key fields include:

• Name – The file name.
• File URL – Direct link to the file in the source platform.
• File Thumbnail URL – Link to the file's thumbnail, where available.
• Size – File size.
• Mime Type – The file's content type.
• Description – File description, where the source provides one.
• Checksum – Content checksum for change detection and verification.

Each File links to its parent Folder.

FS_Folder

Represents folder metadata, organizing files into their hierarchy. Key fields include:

• Name – The folder name.
• Folder URL – Direct link to the folder in the source platform.
• Size – Folder size, where the source provides it.
• Description – Folder description, where available.

Folders are linked to the Files they contain and to their parent Folders, mirroring the source hierarchy.

Metadata Fields

Each synced table in the File Storage category includes a set of metadata fields that track the lifecycle, state, and origin of every record. These fields provide transparency into how data flows from the external source into NocoDB and play an essential role in traceability, debugging, and audit requirements.

These metadata fields are automatically managed by App Sync and are read-only.

• RemoteId Unique identifier of the record in the external source system.

• RemoteCreatedAt Timestamp of when the record was originally created in the source.

• RemoteUpdatedAt Timestamp of the most recent update made in the source.

• RemoteDeleted Indicates whether the record has been deleted in the source platform. This is used especially when the delete behaviour is set to Ignore.

• RemoteDeletedTime Timestamp of when the record was deleted in the source, if applicable.

• RemoteRaw Stores the raw payload received from the provider for that record. Useful for troubleshooting, verification, or advanced integrations.

• RemoteNamespace Identifies the origin drive or account, depending on the provider.

• RemoteSyncedAt Last timestamp when NocoDB synced this specific record.

• SyncConfigId Internal reference to the sync configuration used for this record.

• SyncRunId Identifies the specific sync execution run that last updated this record.

• SyncProvider Indicates which external service (Google Drive, Dropbox, or Box) the record originated from.