MBS Retrieve BackupInstall

Summary

Download MBS PostgreSQL backup files via SFTP with optional batching.

Inputs

• host (required) — SFTP server hostname (can use expression from previous node)
• port (required) — SFTP server port (default 22)
• username (required) — SFTP username (can use expression from previous node)
• password (required) — SFTP password (can use expression from previous node)
• companyCode (required) — Company code prefix used to locate the backup folder (e.g., CO655)
• basePath (required) — Base directory on the SFTP server where backup folders are stored
• filePattern — Glob pattern to match files (default: * for all files)
• limit — Batch size: number of files to download (0 = no limit, i.e., all files after offset)
• offset — Number of files to skip before downloading (used for pagination/batching)
• binaryPropertyName (required) — Name of the binary property that will hold each file's data

Output shape

array of items

For each file, an item is returned containing JSON metadata and a binary property with the file contents.

Examples

Example 1: Download the first 10 backup files for company CO655.

Set companyCode=CO655, limit=10, offset=0.

Example 2: Paginate through all files in batches of 20.

Use limit=20 and increment offset by 20 on each iteration.