For AI agents: a documentation index is available at the root level at /llms.txt and /llms-full.txt. Append /llms.txt to any URL for a page-level index, or .md for the markdown version of any page.
Contact us
  • Introduction
    • Get Started
    • Authentication
    • Conventions
    • Filtering with FQL
    • Release Notes
  • API Reference
    • Activities
    • Amenities
    • Applications
    • Buildings
    • Customers
    • Deposits
    • Floor Plans
    • Households
    • Income Limits
    • Leases
    • Listings
    • Maintenance
    • Move Ins
    • Move Outs
    • Properties
    • Prospects
    • Rent Changes
    • Reports
    • Reversals
    • Scheduled Reports
    • Scheduled Transactions
    • Screenings
    • Transactions
    • Turns
    • Units
    • Users
    • Work Orders
  • ILS Integration
  • Data Exports Integration
    • Overview
    • Change Data Capture (CDC)
Contact us
LogoLogo
On this page
  • Overview
  • Architecture
  • Export Delivery Model
  • Folder Structure
  • Example Topic Folders
  • Example Files Per Topic
  • File Formats
  • Typical Integration Flow
  • Getting Started
Data Exports Integration

Data Exports

Was this page helpful?
Previous

Change Data Capture (CDC)

Next
Built with

Overview

Fortress also supports integration through scheduled data exports delivered via SFTP. This is currently the best option for downstream analytics workflows that need bulk data in files instead of API calls.

Upon request, Fortress provisions an SFTP folder for each organization to access its exported data. Refresh cadence varies based on integration needs.

Architecture

The following diagram shows the data export integration flow.

Export Delivery Model

Fortress supports two export delivery modes:

  1. Full load A full snapshot file for a topic (for example, Activities or Work Orders) is delivered.

  2. Change detect (CDC) A full snapshot file is delivered first. After that, additional files include only row-level changes for that topic.

Folder Structure

Exports are organized by organization and topic folder.

{organizationId}/public/exported_activities/LOAD.csv
{organizationId}/public/exported_workorders/LOAD.csv
{organizationId}/public/exported_..../LOAD.csv

Equivalent parquet exports use the same path pattern with .parquet file extension.

Example Topic Folders

Based on a typical organization export location, you may see folders such as:

{organizationId}/public/exported_activities/
{organizationId}/public/exported_affordablecontracts/
{organizationId}/public/exported_amenities/
{organizationId}/public/exported_applications/
{organizationId}/public/exported_applicationstatuschanges/
{organizationId}/public/exported_balances/
{organizationId}/public/exported_buildings/
{organizationId}/public/exported_certificationcustomers/
{organizationId}/public/exported_certificationdocuments/
{organizationId}/public/exported_certificationreviewstatuschanges/
{organizationId}/public/exported_certifications/
{organizationId}/public/exported_customers/
{organizationId}/public/exported_deposits/

Example Files Per Topic

Full-load and CDC files for a topic might look like:

{organizationId}/public/exported_activities/LOAD.csv
{organizationId}/public/exported_activities/20260601-010000000.csv
{organizationId}/public/exported_activities/20260601-020000000.csv
{organizationId}/public/exported_workorders/LOAD.parquet
{organizationId}/public/exported_workorders/20260601-010000000.parquet

In CDC mode, incremental files follow YYYYMMDD-HHMMSSfff ordering.

File Formats

Exports can be delivered in either of the following formats:

  • csv
  • parquet

Typical Integration Flow

  1. Fortress provisions the organization SFTP location.
  2. Consumer reads initial full-load files per topic.
  3. Consumer processes ongoing CDC files for incremental updates.

Getting Started

  1. Contact Fortress to enable Data Exports for your organization.
  2. Confirm required topics and preferred file format (csv or parquet).
  3. Align on refresh cadence and CDC enablement during onboarding.
  4. Implement ingestion using the CDC processing guidance.

See the Change Data Capture (CDC) page in this section for operational details, including operation precedence and row ordering requirements.