File Storage

Use File Storage Sync to import file and folder information from your cloud storage platform. It follows a predefined schema that makes storage data the same across systems. Use it to audit where files are, track sizes and types, and build file inventories across your drives.

Current supported sources include:

  • Google Drive
  • Dropbox
  • Box

Available Tables

Each table maps to a well-defined set of fields, so the structure stays the same. 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:

FieldDescription
NameThe file name.
File URLA direct link to the file in the source platform.
File Thumbnail URLA link to the thumbnail of the file, where available.
SizeThe file size.
Mime TypeThe content type of the file.
DescriptionThe file description, where the source provides one.
ChecksumThe content checksum for change detection and verification.

Each File links to its parent Folder.

FS_Folder

Represents folder metadata. Folders organize files into their hierarchy. Key fields include:

FieldDescription
NameThe folder name.
Folder URLA direct link to the folder in the source platform.
SizeThe folder size, where the source provides it.
DescriptionThe folder description, where available.

Each folder links to the Files that it contains and to its parent Folders. This mirrors the source hierarchy.

Metadata Fields

Each synced table in the File Storage category includes a set of metadata fields. These fields track the lifecycle, state, and origin of each record. They show how data flows from the external source into NocoDB. They are important for traceability, debugging, and audit requirements.

App Sync manages these metadata fields automatically. They are read-only.

FieldDescription
RemoteIdThe unique identifier of the record in the external source system.
RemoteCreatedAtThe timestamp when the record was first created in the source.
RemoteUpdatedAtThe timestamp of the most recent update in the source.
RemoteDeletedShows if the record was deleted in the source platform. App Sync uses this especially when the delete behavior is set to Ignore.
RemoteDeletedTimeThe timestamp when the record was deleted in the source, if applicable.
RemoteRawThe raw payload from the provider for that record. Use it for troubleshooting, verification, or advanced integrations.
RemoteNamespaceThe origin drive or account, depending on the provider.
RemoteSyncedAtThe last timestamp when NocoDB synced this record.
SyncConfigIdAn internal reference to the sync configuration for this record.
SyncRunIdThe sync run that last updated this record.
SyncProviderThe external service (Google Drive, Dropbox, or Box) that the record came from.

Good to know

  • File Storage Sync imports metadata about files and folders: names, locations, sizes, and related details. It does not import the file contents.

Availability

  • App Sync is available on NocoDB Cloud (Plus plan and above) and licensed self-hosted deployments (Business plan and above).

Last updated on

Latest product updates?See Changelog
Stay in the loop? Follow us onLinkedInLinkedInYouTubeYouTubeXX