Why Is There a One-Day Delay for Connected Accounts Data in the ACCOUNTS Table?

Question

Why is there a one-day delay for Connected Accounts data in the ACCOUNTS table?

Environment

Connector: Stripe

Answer

Stripe's API doesn't provide real-time updates for all events related to connected accounts, meaning we can't incrementally sync data for these accounts. When you set the Sync Connected Accounts toggle to ON in the connector setup form, we fully re-import ACCOUNTS table data daily to ensure we capture all available data. Therefore, there may be a delay of up to 24 hours for connected accounts data to appear in the ACCOUNTS table.