Skip to main content
Any data export schema changes will be captured in the below changelog.

​
Schema management policy

All consumers of Thanx SFTP exports are required to build their integrations to comply with the rules below. New attributes will be added over time as the platform evolves, and your downstream pipelines must tolerate them without manual intervention. If your integration breaks when a new column is added, update your pipeline to handle these additive schema changes — they are expected and will continue.
  • Attribute addition. New attributes will be added as new columns to the right side of each CSV export for SFTP exports. Consumers must parse CSVs by header name, not by column position, and must ignore unknown columns rather than failing.
  • Attribute removal. Attributes are not removed from the schema under normal operations, to prevent breaking existing integrations. If a column must be retired (e.g., for regulatory or security-driven reasons), the column remains present in the schema but will be empty.
  • Attribute update. Attribute data types will not be adjusted. Changes to any calculation will be announced in the changelog below and applied to all exports on the listed date.
Thanx Connex automatically handles schema changes in the downstream source.
​
Improved accuracy of:
  • rewards
    • discount - fixed-price and free-item rewards redeemed in store without an integrated discount now report the configured retail value, less any fixed price the customer pays, instead of 0.00 or blank.
​
Documentation correction. No schema change occurred. The updates below document existing export attributes that were missing from their model pages.
  • campaigns
    • campaign_uid - The unique identifier for this campaign in our APIs.
    • synced_at - Timestamp indicating the last update time for the record.
  • communication-preferences
    • membership_uid - A unique identifier for this membership; does not currently match the identifier used in our APIs.
    • synced_at - Timestamp indicating the last update time for the record.
  • memberships
    • gender - The user’s gender.
    • membership_uid - A unique identifier for this membership; does not currently match the identifier used in our APIs.
    • synced_at - Timestamp indicating the last update time for the record.
  • nps-feedback
    • synced_at - Timestamp indicating the last update time for the record.
  • points-accounts
    • synced_at - Timestamp indicating the last update time for the record.
  • points-transactions
    • synced_at - Timestamp indicating the last update time for the record.
  • programs
    • synced_at - Timestamp indicating the last update time for the record.
  • purchases
    • synced_at - Timestamp indicating the last update time for the record.
  • rewards
    • synced_at - Timestamp indicating the last update time for the record.
Also corrected: loyalty-reward-progress-legacy documented a column named loyalty_reward_progress; the actual exported column is loyalty_reward_current_progress. The reward_uid / purchase_uid / points_transaction_uid / nps_feedback_uid / points_account_uid / program_uid columns were also re-ordered on their respective pages to match where they actually appear in the export output.
​
Improved accuracy of:
  • rewards
    • estimated_cost - more accurate costs for percent-off and fixed-price rewards with integrated redemption.
​
The following attributes will be added:
  • memberships
    • alternate_pos_id - An alternate user identifier sent to certain in-store POS systems when loyalty is applied at the register. Currently only used by the Toast POS integration, where it matches the APPLIED_LOYALTY_ID field on Toast POS reports.
​
The following attributes will be added:
  • rewards
    • redemption_pos_order_id - POS ID of the order with which this reward was redeemed. Set for merchants with in-store POS integrations enabled for rewards that were redeemed in-store.
    • redemption_pos_provider - POS provider for the integrated in-store redemption.
  • purchases
    • pos_id - POS ID of the order. Set for brands using POS check-in loyalty when a purchase is created via an in-store check-in.
    • pos_provider - POS provider of the order. Only present when a purchase is created via an in-store check-in for brands using POS check-in loyalty.
Improved accuracy of:
  • rewards
    • discount - more accurate discount amounts for integrated redemption.