Skip to main content

Backups & Import/Export

RestAPI.com provides comprehensive tools to backup, restore, and migrate your API data through the Developer Portal.

Overview

Access these features via Import & Export in your API:

FeatureDescription
ExportCreate ZIP backups of structure, data, files, and settings
ImportRestore from ZIP archives
TakeoutGenerate SQL scripts for database-level backups
JobsMonitor all background operations

Export

Create on-demand backups of your API.

What Can Be Exported

OptionDescription
StructureCollections, properties, relationships, views, queries, functions
ItemsCollection data records
BlobsUploaded files, images, documents
VFSVirtual file system files (application files)
SettingsAPI configuration key-value pairs
WebAppWeb application configuration
Auth ProvidersOAuth/authentication provider configurations

Export Workflow

  1. Navigate to Import & ExportExport
  2. Select components to include
  3. Enter a secrets passphrase if the export needs to carry secrets
  4. Click Export
  5. Download the ZIP file from Jobs when complete

Secrets Encryption

The passphrase does more than encrypt — it decides whether secrets travel at all. Provide one and your API secrets and authentication provider credentials are included, each encrypted with it. You will need the same passphrase when importing.

No passphrase means no secrets

An export without a passphrase silently leaves secrets out. They are omitted rather than written in the clear, and nothing in the archive marks them as missing.

The gap only shows up at import, when functions fail against absent credentials. If your backup is meant to be restorable on its own, set a passphrase and store it somewhere you will still have it.

Import

Restore data from export archives.

What Can Be Imported

OptionDescription
StructureSchema definitions
ItemsCollection data records
BlobsBinary files
VFSApplication files
PurgeDelete existing data before import

Import Workflow

  1. Navigate to Import & ExportImport
  2. Upload one or more ZIP files
  3. Select components to import
  4. If the export was encrypted, enter the secrets passphrase
  5. Click Import
Purge Mode

The Purge option permanently deletes all existing data before importing. This is destructive and cannot be undone. Use with extreme caution.

Multi-File Import

You can upload and import multiple ZIP archives in a single job. All files are processed together.

Takeout

Generate SQL scripts for complete database backups.

What's Included

OptionDescription
StructureSQL CREATE statements for tables and relationships
DataSQL INSERT statements for all records

What's NOT Included

  • Binary files (blobs)
  • Application files (VFS)

Use Takeout for:

  • Database-level recovery
  • GDPR compliance and data portability
  • SQL-based migrations

Takeout Workflow

  1. Navigate to Import & ExportTakeout
  2. Select structure and/or data
  3. Click Create Takeout
  4. Download SQL file from Jobs

Jobs

All export, import, and takeout operations run as background jobs.

Job Status

StatusDescription
PendingQueued, waiting to start
RunningActively processing
CompletedFinished successfully
FailedError occurred
CancelledCancelled by user

Job Features

  • Progress tracking — Real-time percentage completion
  • Auto-refresh — Optional automatic updates
  • Filtering — Filter by job type (Export, Import, Takeout)
  • Detailed logs — View execution logs with timestamps
  • Download files — Direct download links for completed exports
  • Cancel jobs — Stop pending or running jobs
  • Delete jobs — Remove completed jobs from history

Job Logs

Each job maintains detailed logs with entries categorized as:

  • Info — Normal progress updates
  • Warning — Non-critical issues
  • Error — Problems that may affect results
  • File — Downloadable output files

File Storage

Export and takeout files are stored in secure cloud storage:

  • Format: ZIP archives (Export/Import) or SQL files (Takeout)
  • Access: Time-limited secure download URLs
  • Retention: Files remain available until manually deleted
  • Multiple downloads: Same file can be downloaded multiple times

Use Cases

ScenarioApproach
Full backupExport: Structure + Items + Blobs
Schema onlyExport: Structure only (fast, small)
Environment migrationExport from production → Import to staging
API cloningExport structure → Import to new API
Disaster recoveryRegular exports stored securely
GDPR complianceTakeout for data portability requests
Database backupTakeout for SQL-based recovery
Version controlExport structure for git commits

Best Practices

  • Export regularly — Create periodic backups of critical APIs
  • Always include structure — Schema is essential for complete backups
  • Test restores — Verify backups by importing to a test API
  • Secure storage — Store export files in redundant, secure locations
  • Use passphrases — An export without one carries no secrets at all, so set a passphrase whenever the archive needs to restore on its own
  • Monitor jobs — Check job logs for warnings or errors
  • Clean up old jobs — Delete completed jobs you no longer need