Data backups

Crassula creates a daily backup of your data. You can download it through the API.

Downloading a backup

GET /api/backups/{date}
  • {date} is the day of the backup in YYYY-MM-DD format, for example 2026-11-01.

  • Authenticate with a master API key, as described in Using Crassula API. Pass it in the Authorization header.

Responses:

  • 302: redirects to the backup file. The link is valid for 2 hours, so download the file right away.

  • 401: the API key is missing or invalid.

  • 403: the key is valid but is not a master key.

  • 404: no backup exists for this date.

  • 422: the date is invalid.

Example:

Bash
curl -L -H "Authorization: <your API key>" \
  "https://client.demo.crassu.la/api/backups/2026-11-01" -o 2026-11-01.zip

Backups are kept for 7 days. A request for an older date returns 404.

The backup for a given date is created at 00:04 UTC on the next day and contains the data as of that moment. For example, the backup for 2026-11-01 appears on 2026-11-02 after 00:04 UTC.

File format

The backup is a ZIP archive named YYYY-MM-DD.zip after the backed-up day. Each table below is a separate gzip-compressed CSV file inside the archive, named after the table: <table name>.csv.gz (for example, account_transaction.csv.gz). Each CSV file starts with a header row of column names; values are comma-separated and quoted where needed.

Most fields with a fixed set of values contain the number shown in brackets. For example, state = 8 means COMPLETED. In transaction_state_transition_event, state_from is -1 (UNDEFINED) for the first event of a transaction.

The following fields contain text values instead: client.risk_level (low, moderate, moderately-high, high, prohibited), account.provider_name, account_provider_number.requisites_type (for example swift, sepa) and issued_card.provider.

What is not included

The daily backup contains the main data: clients, accounts, transactions, cards and price lists. It does not include the data listed below.

Not in the backup

  • KYC files and documents. The files themselves (passport scans, company documents) are kept in file storage, not in the database, so they are not exported. The tables describing them are not included either: identification_request*, document, document_file, client_document.

  • Company structure. company_staff, shareholder_person and shareholder_company (directors and beneficial owners) are not included. Business onboarding applications (business_application, application_*) are not included.

  • Consent to legal documents. legal_document_client_agreement is not included, so the backup does not show who agreed to which version of the terms, and when.

  • Notes and comments. client_note, issue_note, account_transaction_comment.

  • Saved beneficiaries and transfer templates. counterparty, transfer_template.

  • Cards. Only issued_card is included. Card holds (issued_card_hold_transaction), card limits and card products are not.

  • Fee charges. client_fee_charge is not included. Price lists are in the backup, actual fee charges are not.

  • Other. Travel Rule data (travel_rule_transaction*), two-factor authentication methods, referral codes, membership and tags.

  • Administrators. The backup contains administrator_id (in issue, activity_log and transaction approvals), but not the administrator table. These IDs cannot be matched to administrator records.

  • Logs. See the Logs section below.

Data stored by providers

Data that is stored by third-party providers rather than by Crassula is not part of the backup: onboarding questionnaires and verification checks at the identity verification provider (SumSub), card data at the card processor, and statements at the banking providers. Obtain this data directly from the provider.

Banking

Table name

Fields

Description

client

  • id

  • public_id

  • common_name

  • state

    • ACTIVE (0)

    • SUSPENDED (1)

    • BLOCKED (2)

  • state_reason

    • NONE (0)

    • DOCUMENT_EXPIRED (1)

    • THRESHOLD_REACHED (2)

    • FINANCIAL_MONITORING (3)

    • KYC (4)

    • COMPLIANCE (5)

  • verification_level

    • NOT_IDENTIFIED (0)

    • LEVEL_1 (1)

    • LEVEL_2 (2)

    • LEVEL_3 (3)

    • LEVEL_4 (4)

    • LEVEL_5 (5)

  • limit_id

  • subscription_plan_id

  • legal_address_address_line1

  • legal_address_address_line2

  • legal_address_city

  • legal_address_postal_code

  • legal_address_state

  • legal_address_country_code

  • created_at

  • price_list_id

  • risk_level

  • score

  • type

Clients

client_metadata_item

  • id

  • client_id

  • category

  • name

  • value

  • created_at

Clients' metadata

client_limit

  • id

  • name

  • description

  • status

    • ACTIVE (0)

    • DISABLED (1)

  • client_type

    • PERSON (0)

    • COMPANY (1)

  • client_verification_level

  • created_at

Limits

client_limit_threshold

  • id

  • limit_id

  • client_id

  • type

    • TRANSACTION_AMOUNT (0)

    • TRANSACTION_COUNT (1)

    • TRANSFER_COUNT (2)

    • FX_TRANSACTION_AMOUNT (3)

  • action_type

    • NOTIFY (0)

    • SUSPEND_CLIENT (1)

    • NONE (2)

  • affects_only_single_transaction

  • amount

  • currency

  • period

    • DAY (1)

    • MONTH (2)

    • WEEK (3)

    • YEAR (4)

  • period_count

  • transfer_direction

    • INCOMING (0)

    • OUTGOING (1)

    • ALL (2)

  • created_at

Limit thresholds

person

  • id

  • first_name

  • last_name

  • language

  • gender

    • UNKNOWN (0)

    • MALE (1)

    • FEMALE (2)

  • nationality

  • birthdate

  • verification_status

    • NOT_VERIFIED (0)

    • EMAIL_VERIFIED (1)

    • PHONE_VERIFIED (2)

    • DOCUMENTS_SUBMITTED (3)

    • IDENTIFIED (4)

  • default_currency

  • email

  • legal_name

  • password_updated_at

  • phone

Clients / persons

person_phone

  • id

  • person_id

  • is_primary

  • status

    • NOT_VERIFIED (0)

    • REQUEST_SENT (1)

    • VERIFIED (2)

  • added_at

  • phone

Persons' phone numbers

person_email

  • id

  • person_id

  • is_primary

  • status

    • NOT_VERIFIED (0)

    • REQUEST_SENT (1)

    • VERIFIED (2)

  • added_at

  • email

Persons' email addresses

company

  • id

  • name

  • verification_status

    • NOT_VERIFIED (0)

    • DOCUMENTS_SUBMITTED (1)

    • IDENTIFIED (2)

  • actual_address_address_line1

  • actual_address_address_line2

  • actual_address_city

  • actual_address_country_code

  • actual_address_postal_code

  • actual_address_state

  • beneficial_owner_ownership_stake

  • beneficial_owner_positions

  • beneficial_owner_type

  • business_type

  • email

  • incorporation_date

  • other_business_type

  • owner_id

  • phone

  • registration_number

  • tax_identification_number

  • url

Clients / companies

account

  • number

  • name

  • type

    • STANDARD (0)

    • FINANCE (1)

    • CRYPTO (2)

  • status

    • NEW (0)

    • ACTIVE (1)

    • SUSPENDED (2)

    • CLOSED (4)

    • AWAITING_PROVIDER_NUMBER (5)

    • WAITING_FOR_APPROVAL (6)

    • REJECTED (7)

    • DECLINED (8)

    • AWAITING_EXTERNAL_LEDGER (9)

    • WAITING_FOR_DOCUMENTS (10)

    • WAITING_FOR_KYC (11)

    • WAITING_FOR_PERSON_KYC (12)

    • PERSON_KYC_IN_PROGRESS (13)

    • WAITING_FOR_COMPANY_KYC (14)

    • COMPANY_KYC_IN_PROGRESS (15)

  • _primary

  • provider_name

  • provider_currency

  • provider_external_id

  • client_id

  • holder_id

  • created_at

  • activated_at

  • provider_number

Accounts

account_metadata_item

  • account_number

  • category

  • name

  • value

  • created_at

Accounts' metadata

account_provider_number

  • id

  • account_number

  • type

    • IBAN (0)

    • ADDRESS (1)

  • number

  • _primary

  • is_active

  • created_at

  • requisites_type

  • currency

  • bank_code

  • bank_account_number

External account numbers

account_transaction

  • id

  • account_number

  • amount

  • currency

  • type

    • DEPOSIT (0)

    • FEE (1)

    • REFUND (2)

    • TRANSFER (4)

    • SYSTEM_DEPOSIT (5)

    • CURRENCY_CONVERSION (6)

    • RECALL (7)

    • CARD_PURCHASE (8)

    • CARD_WITHDRAWAL (9)

    • CARD_QUASI_CASH (10)

    • CASHBACK (11)

    • INTEREST (12)

    • WITHDRAWAL (13)

    • INTERLEDGER (14)

    • CARD_TOPUP (15)

    • CARD_TRANSFER (16)

    • REFERRAL_BONUS (17)

  • status

    • DRAFT (0)

    • PENDING (1)

    • COMPLETED (2)

    • DECLINED (3)

    • REFUNDED (4)

  • state

    • DRAFT (0)

    • OPENED (1)

    • PROCESSING (2)

    • PENDING (3)

    • CANCELED (4)

    • FAILED (5)

    • DECLINED (6)

    • APPROVED (7)

    • COMPLETED (8)

    • REFUNDED (9)

    • WAITING_FOR_APPROVAL (10)

    • READY_TO_PROCESS (11)

    • CANCEL_PROCESSING (12)

    • REFUND_PROCESSING (13)

    • RECALL_RECEIVED (14)

    • RECALL_PROCESSING (15)

    • RECALL_FAILED (16)

    • QUARANTINE (17)

    • WAITING_FOR_ACTION (18)

    • WAITING_FOR_CHECK (19)

    • WAITING_FOR_FUNDS (20)

    • UNDETERMINED_BENEFICIARY (21)

    • SCHEDULED (22)

    • API_PROCESSING (23)

    • WAITING_FOR_PROCESS (24)

    • WAITING_FOR_DECLINE (25)

    • WAITING_FOR_COMPLETE (26)

    • WAITING_FOR_FAIL (27)

    • INITIATED (28)

    • CHECKED (29)

    • PROCESSING_MANUAL (30)

    • WAITING_FOR_REFUND (31)

    • WAITING_FOR_PROVIDER_APPROVAL (32)

    • PROVIDER_APPROVED (33)

    • HOLD_PROCESS (34)

    • WAITING_FOR_CLIENT_ACTION (35)

    • WAITING_FOR_PROVIDER_CONFIRMATION (36)

  • description

  • bank_details_id

  • beneficiary_type

    • NOT_PROVIDED (0)

    • PERSON (1)

    • COMPANY (2)

  • created_at

  • updated_at

  • reference_transaction_id

  • self_transfer

  • provider

  • settlement_date

  • finalized_at

Transactions

account_transaction_parameter

  • account_transaction_id

  • key

  • value

  • created_at

Transactions' metadata

account_transaction_bank_details

  • id

  • bank_account_number

  • bic (bank code)

  • bank_name

  • bank_country_code

  • bank_address

  • beneficiary_name

  • beneficiary_address

  • beneficiary_city

  • beneficiary_state

  • beneficiary_postal_code

  • beneficiary_country_code

  • remitter_address

  • remitter_city

  • remitter_state

  • remitter_postal_code

  • remitter_country_code

  • bank_code

  • beneficiary_additional_code

  • beneficiary_tax_code

  • correspondent_bank_account_number

  • correspondent_bank_code

  • correspondent_bank_name

  • created_at

  • sort_code

  • ultimate_debtor_name

Beneficiary requisites for outgoing transactions and remitter requisites for incoming transactions

transaction_state_transition_event

  • id

  • transaction_id

  • state_from (same values as account_transaction.state)

  • state_to (same values as account_transaction.state)

  • created_at

  • originator_type

    • USER (0)

    • TRANSACTION (1)

    • SYSTEM (2)

    • DEPRECATED_FLOW (3)

    • CARD (4)

  • originator

  • change_reason

Transaction state change history

account_transaction_approval

  • id

  • transaction_id

  • administrator_id

  • created_at

Administrators' approvals of transactions

subscription_plan

  • id

  • label

  • description

  • type

  • value

  • period

    • MONTHLY (0)

    • YEARLY (1)

  • _default

  • _order

Subscription plans (not used; period is always 0)

client_price_list

  • id

  • status

    • DRAFT (0)

    • PROCESSING (1)

    • PUBLISHED (2)

    • DISABLED (3)

    • DELETED (4)

  • name

  • _default

  • client_type

    • PERSON (0)

    • COMPANY (1)

  • created_at

  • source_price_list_id

  • updated_at

  • published_at

  • external_fee_enabled

  • subscription_plan_id

Price lists

client_fee

  • id

  • price_list_id

  • name

  • status

    • ACTIVE (0)

    • DISABLED (1)

  • type

    • For transfer fees

      • OUTGOING_TRANSFER (0)

      • DEPOSIT (1)

      • SYSTEM_DEPOSIT (2)

      • INCOMING_TRANSFER (4)

      • CURRENCY_CONVERSION (5)

    • For recurring fees

      • SERVICE (0)

      • ADDITIONAL_ACCOUNT (1)

      • ANNUAL_BALANCE (2)

      • UNAUTHORIZED_NEGATIVE_BALANCE (3)

      • PLASTIC_CARD_FEE (4)

      • VIRTUAL_CARD_FEE (5)

    • For card issuing fees

      • ISSUING (0)

      • REISSUING (1)

      • EXTRA_REISSUING (2)

      • ADDITIONAL_ISSUING (3)

      • BLOCK_LOST_STOLEN (4)

      • PAYMENT_PURCHASE (5)

      • DOMESTIC_ATM_CASH_WITHDRAWAL (6)

      • INTERNATIONAL_ATM_CASH_WITHDRAWAL (7)

      • MANUAL_CASH_WITHDRAWAL (8)

      • YEARLY_SERVICE (9)

      • SMS_NOTIFICATIONS (10)

      • INSUFFICIENT_FUNDS_AUTHORIZATION (11)

      • CURRENCY_CONVERSION (12)

      • OCT (13)

      • BALANCE_INQUIRY_IN_3RD_INTERFACES (14)

      • ACCOUNT_STATEMENT_ON_EMAIL (15)

      • CONVERSION_TO_PLASTIC (16)

      • TOP_UP (17)

      • SHIPPING (18)

      • TRANSFER_TO_ACCOUNT (19)

      • SERVICE_CHARGE (20)

    • For change verification level fees

      • UPGRADE (0)

      • DOWNGRADE (1)

  • payment_method

    • ANY_PAYMENT_METHOD (0)

    • INTERNAL (1)

    • SWIFT (2)

    • SEPA (3)

    • BETWEEN_ACCOUNTS (4)

    • CARD (5)

    • SEPA_URGENT (6)

    • LOCAL (7)

    • CRYPTO (8)

    • TARGET2 (9)

  • currency

  • percent

  • fixed_amount

  • amount_min

  • amount_max

  • amount_range_from

  • amount_range_to

  • valid_from

  • valid_to

  • discriminator

    • TRANSFER (0)

    • RECURRING (1)

    • ISSUED_CARD (2)

    • FX_MARKUP (3)

    • CHANGE_VERIFICATION_LEVEL (4)

  • period

    • DAILY (0)

    • WEEKLY (1)

    • MONTHLY (2)

    • YEARLY (3)

  • card_scheme

  • card_type

  • beneficiary_type

  • account_provider

  • from_currency

  • to_currency

  • transfer_provider

  • verification_level

  • active_status

    • DISABLED (0)

    • SCHEDULED (1)

  • created_at

  • updated_at

Price list fees

issued_card

  • id

  • mask

  • type

    • VIRTUAL (0)

    • PLASTIC (1)

  • scheme

    • VISA (0)

    • MASTERCARD (1)

  • expiration_month

  • expiration_year

  • card_holder

  • status

    • NEW (0)

    • ERROR (1)

    • REQUESTED (2)

    • READY_FOR_ACTIVATION (3)

    • ACTIVE (4)

    • SUSPENDED (5)

    • SUSPENDED_HOLDER (6)

    • SUSPENDED_PARTNER (7)

    • BLOCKED (8)

    • DECLINED (9)

    • UNKNOWN (10)

    • EXPIRED (11)

    • PREORDERED (12)

    • UNSUSPEND_REQUESTED (13)

    • UNBLOCK_REQUESTED (14)

  • provider

  • provider_card_id

  • created_at

Issued cards

issue

  • id

  • administrator_id

  • entity_id

  • context

    • BUSINESS_APPLICATION (1)

    • IDENTIFICATION_REQUEST (2)

    • PERSON_LEGAL_NAME (3)

    • CARD_CONVERSION_TO_PLASTIC (4)

    • CONNECTOR_TRANSACTION (5)

    • BANK_SWIFT_CODE (6)

    • MISSING_RATE (7)

    • FAILED_FEE_DEBITING (8)

    • FAILED_CARD_TOPUP (9)

    • ACCOUNT_RECONCILIATION_FAILED (10)

    • EXISTING_ACCOUNT_VERIFICATION_FAILED (11)

    • FX_PROVIDER_CREDIT_LIMIT (12)

    • FX_PROVIDER_ORDER_FAILED (13)

    • FX_PROVIDER_ORDER_CHECK (14)

  • status

    • NEW (1)

    • UNDER_REVIEW (2)

    • RETURNED_FOR_UPDATE (3)

    • APPROVED (4)

    • REJECTED (5)

  • created_at

  • updated_at

Issue management

E-commerce

Tables

Table name

Sample field list

Description

merchant

  • id

  • first_name

  • last_name

  • email

  • created_at

  • company

  • enabled

  • locale

Merchants

project

  • id

  • owner_id

  • display_name

  • url

  • default_currency

  • public_key

  • private_key

  • state

  • updated_at

Merchant projects

transaction

  • id

  • project_id

  • merchant_id

  • user_identifier

  • user_display_name

  • price

  • currency

  • status

  • custom_description

  • created_at

  • updated_at

Project transactions

fee

  • id

  • gateway_config_id

  • merchant_id

  • operator_id

  • type

  • percent

  • amount

  • country_code

  • currency

  • from_currency

  • min_amount

  • project_id

  • min_comissioned_amount

  • max_comissioned_amount

Fees

Exchange

Table name

Sample field list

Description

exchange_order

  • id

  • provider_name

  • type

    • MARKET (0)

    • LIMIT (1)

  • side

    • BID (0)

    • ASK (1)

  • status

    • NEW (0)

    • PENDING (1)

    • CANCELED (2)

    • DECLINED (3)

    • SUCCESS (4)

    • ERROR (5)

    • PROCESSING (6)

  • amount

  • from_currency

  • to_currency

  • rate

  • created_at

  • processed_at

  • provider_order_id

Exchange orders

exchange_rate_history

  • id

  • from_currency

  • to_currency

  • rate

  • provider

  • created_at

Exchange rate history

Logs

account_log

  • id

  • account_number

  • type

  • action

  • provider

  • data

  • created_at

  • http_request_log_id

Account logs

account_transaction_log

  • id

  • transaction_id

  • type

  • action

  • provider

  • data

  • created_at

  • http_request_log_id

Transaction logs

issued_card_activity_log

  • id

  • card_id

  • type

  • action

  • provider

  • data

  • request_uid

  • created_at

Issued card logs

activity_log

  • id

  • administrator_id

  • section

  • entity_id

  • label

  • action

  • changes

  • created_at

Administrators' audit log

http_request_log

  • id

  • correlation_id

  • direction

  • http_method

  • initiator

  • initiator_id

  • ip

  • request_body

  • request_headers

  • requested_at

  • responded_at

  • response_body

  • response_headers

  • status_code

  • uri

HTTP request logs

entity_change_log

  • id

  • initiator_id

  • initiator

  • entity_id

  • entity_type

  • entity_description

  • action

  • changes

  • created_at

Record change logs