File organization

File structure in your cloud storage destination is organized to facilitate efficient data management and retrieval.

Different datasets have distinct freshness requirements and refresh intervals, resulting in varying SUCCESS files after completion of their loading processes. Below is a mapping of these SUCCESS files to their corresponding datasets. Use the correct SUCCESS file for each dataset to verify successful loading.

After the coreapi tables listed below have completed loading, the coreapi_SUCCESS file is generated for each run date. These tables adhere to a 12-hour data freshness requirement and maintain a 6-hour refresh interval.



billing	`coupons`	`coreapi_SUCCESS`
billing	`coupons_currency_options`	`coreapi_SUCCESS`
billing	`coupons_metadata`	`coreapi_SUCCESS`
billing	`credit_note_discount_amounts`	`coreapi_SUCCESS`
billing	`credit_note_line_item_discount_amounts`	`coreapi_SUCCESS`
billing	`credit_note_line_item_tax_amounts`	`coreapi_SUCCESS`
billing	`credit_note_line_items`	`coreapi_SUCCESS`
billing	`credit_note_tax_amounts`	`coreapi_SUCCESS`
billing	`credit_notes`	`coreapi_SUCCESS`
billing	`credit_notes_metadata`	`coreapi_SUCCESS`
billing	`discounts`	`coreapi_SUCCESS`
billing	`invoice_custom_fields`	`coreapi_SUCCESS`
billing	`invoice_customer_tax_ids`	`coreapi_SUCCESS`
billing	`invoice_items`	`coreapi_SUCCESS`
billing	`invoice_items_metadata`	`coreapi_SUCCESS`
billing	`invoice_line_item_discount_amounts`	`coreapi_SUCCESS`
billing	`invoice_line_item_tax_amounts`	`coreapi_SUCCESS`
billing	`invoice_line_items`	`coreapi_SUCCESS`
billing	`invoice_payments`	`coreapi_SUCCESS`
billing	`invoice_shipping_cost_taxes`	`coreapi_SUCCESS`
billing	`invoices`	`coreapi_SUCCESS`
billing	`invoices_metadata`	`coreapi_SUCCESS`
billing	`plans`	`coreapi_SUCCESS`
billing	`plans_metadata`	`coreapi_SUCCESS`
billing	`price_tiers`	`coreapi_SUCCESS`
billing	`prices`	`coreapi_SUCCESS`
billing	`prices_currency_options`	`coreapi_SUCCESS`
billing	`prices_metadata`	`coreapi_SUCCESS`
billing	`products`	`coreapi_SUCCESS`
billing	`products_metadata`	`coreapi_SUCCESS`
billing	`promotion_codes`	`coreapi_SUCCESS`
billing	`quotes`	`coreapi_SUCCESS`
billing	`subscription_items`	`coreapi_SUCCESS`
billing	`subscription_items_metadata`	`coreapi_SUCCESS`
billing	`subscription_schedule_phase_add_invoice_items`	`coreapi_SUCCESS`
billing	`subscription_schedule_phase_configuration_items`	`coreapi_SUCCESS`
billing	`subscription_schedule_phases`	`coreapi_SUCCESS`
billing	`subscription_schedule_phases_metadata`	`coreapi_SUCCESS`
billing	`subscription_schedules`	`coreapi_SUCCESS`
billing	`subscription_schedules_metadata`	`coreapi_SUCCESS`
billing	`subscriptions`	`coreapi_SUCCESS`
billing	`subscriptions_metadata`	`coreapi_SUCCESS`
billing	`tax_rates`	`coreapi_SUCCESS`
billing	`tax_rates_metadata`	`coreapi_SUCCESS`
billing	`usage_records`	`coreapi_SUCCESS`
capital	`financing_balances`	`coreapi_SUCCESS`
capital	`financing_offers`	`coreapi_SUCCESS`
capital	`financing_transactions`	`coreapi_SUCCESS`
checkout	`checkout_custom_fields`	`coreapi_SUCCESS`
checkout	`checkout_line_items`	`coreapi_SUCCESS`
checkout	`checkout_sessions`	`coreapi_SUCCESS`
checkout	`payment_links`	`coreapi_SUCCESS`
connect	`accounts`	`coreapi_SUCCESS`
connect	`accounts_metadata`	`coreapi_SUCCESS`
connect-fees	`application_fee_refunds`	`coreapi_SUCCESS`
connect-fees	`application_fee_refunds_metadata`	`coreapi_SUCCESS`
connect-fees	`application_fees`	`coreapi_SUCCESS`
crypto	`crypto_onramp_sessions`	`coreapi_SUCCESS`
customers	`customer_balance_transactions`	`coreapi_SUCCESS`
customers	`customer_balance_transactions_metadata`	`coreapi_SUCCESS`
customers	`customer_cash_balance_transactions`	`coreapi_SUCCESS`
customers	`customer_tax_ids`	`coreapi_SUCCESS`
customers	`customers`	`coreapi_SUCCESS`
customers	`customers_metadata`	`coreapi_SUCCESS`
issuing	`issuing_authorizations`	`coreapi_SUCCESS`
issuing	`issuing_authorizations_metadata`	`coreapi_SUCCESS`
issuing	`issuing_cardholders`	`coreapi_SUCCESS`
issuing	`issuing_cardholders_metadata`	`coreapi_SUCCESS`
issuing	`issuing_cards`	`coreapi_SUCCESS`
issuing	`issuing_cards_metadata`	`coreapi_SUCCESS`
issuing	`issuing_disputes`	`coreapi_SUCCESS`
issuing	`issuing_network_tokens`	`coreapi_SUCCESS`
issuing	`issuing_transactions`	`coreapi_SUCCESS`
issuing	`issuing_transactions_metadata`	`coreapi_SUCCESS`
payments	`balance_transaction_fee_details`	`coreapi_SUCCESS`
payments	`balance_transactions`	`coreapi_SUCCESS`
payments	`charges`	`coreapi_SUCCESS`
payments	`charges_metadata`	`coreapi_SUCCESS`
payments	`disputes`	`coreapi_SUCCESS`
payments	`disputes_enhanced_eligibility`	`coreapi_SUCCESS`
payments	`disputes_metadata`	`coreapi_SUCCESS`
payments	`external_account_bank_accounts`	`coreapi_SUCCESS`
payments	`external_account_cards`	`coreapi_SUCCESS`
payments	`payment_intents`	`coreapi_SUCCESS`
payments	`payment_intents_metadata`	`coreapi_SUCCESS`
payments	`payment_method_details`	`coreapi_SUCCESS`
payments	`payment_methods`	`coreapi_SUCCESS`
payments	`payment_methods_metadata`	`coreapi_SUCCESS`
payments	`payment_reviews`	`coreapi_SUCCESS`
payments	`refunds`	`coreapi_SUCCESS`
payments	`refunds_metadata`	`coreapi_SUCCESS`
payments	`rule_decisions`	`coreapi_SUCCESS`
payments	`setup_attempts`	`coreapi_SUCCESS`
payments	`setup_intents`	`coreapi_SUCCESS`
payments	`setup_intents_metadata`	`coreapi_SUCCESS`
payments	`sources`	`coreapi_SUCCESS`
payments	`sources_metadata`	`coreapi_SUCCESS`
radar	`early_fraud_warnings`	`coreapi_SUCCESS`
tax-reporting	`tax_forms`	`coreapi_SUCCESS`
terminal	`terminal_hardware_order_items`	`coreapi_SUCCESS`
terminal	`terminal_hardware_order_metadata`	`coreapi_SUCCESS`
terminal	`terminal_hardware_order_shipment_tracking`	`coreapi_SUCCESS`
terminal	`terminal_hardware_order_tax_amounts`	`coreapi_SUCCESS`
terminal	`terminal_hardware_orders`	`coreapi_SUCCESS`
transfers	`transfer_reversals`	`coreapi_SUCCESS`
transfers	`transfer_reversals_metadata`	`coreapi_SUCCESS`
transfers	`transfers`	`coreapi_SUCCESS`
transfers	`transfers_metadata`	`coreapi_SUCCESS`
treasury	`treasury_financial_accounts`	`coreapi_SUCCESS`
treasury	`treasury_financial_accounts_metadata`	`coreapi_SUCCESS`
treasury	`treasury_inbound_transfers`	`coreapi_SUCCESS`
treasury	`treasury_inbound_transfers_metadata`	`coreapi_SUCCESS`
treasury	`treasury_outbound_payments`	`coreapi_SUCCESS`
treasury	`treasury_outbound_payments_metadata`	`coreapi_SUCCESS`
treasury	`treasury_outbound_transfers`	`coreapi_SUCCESS`
treasury	`treasury_outbound_transfers_metadata`	`coreapi_SUCCESS`
treasury	`treasury_transaction_entries`	`coreapi_SUCCESS`
treasury	`treasury_transactions`	`coreapi_SUCCESS`

Note

File organization

File structure in your cloud storage destination is organized to facilitate efficient data management and retrieval.