Request export

Request an export to start processing in the background.

Recent Requests
Log in to see full request history
TimeStatusUser Agent
Retrieving recent requests…
LoadingLoading…
⚠️

Exports are available exclusively for Enterprise accounts. Non-enterprise accounts will receive a 401 Unauthorized response.

Overview

Use this endpoint to request a new data export. The export runs in the background - you'll receive an email when your file is ready to download.


Conditional Requirements

The required fields depend on the export type you're requesting:

ConditionRequired Fields
object = accountingmonth, currency (must be lowercase, e.g., usd)
object = any other valuedate_from, date_to

Important notes:

  • Currency codes must always be lowercase (e.g., usd, eur, cad - NOT USD)
  • Date range cannot exceed 6 months (except for accounting exports which are per-month)
  • You cannot request multiple exports of the same type simultaneously

Request Body

ParameterTypeRequiredDescription
objectstringYesThe type of data to export (see export types below)
site_idintegerNoLimit export to a specific site

Each export type has additional filters. See the sections below for details.


Export Types

Subscriptions

Get a list of all subscriptions with their plan, status, billing details, and customer information.

Use case: Reconcile your subscriber list with your CRM, or analyze churn by exporting canceled subscriptions.

{
  "object": "subscriptions",
  "date_from": 1704067200,
  "date_to": 1711929600,
  "status": "active",
  "collection_method": "charge_automatically"
}
FilterTypeRequiredDescription
date_fromtimestampYesStart date (Unix timestamp)
date_totimestampYesEnd date (Unix timestamp)
modestringNofull_data (created in range) or modified_data (updated in range)
statusstringNoFilter by: all, active, canceled, past_due, trialing, unpaid, incomplete, incomplete_expired, deleted
collection_methodstringNocharge_automatically or send_invoice
plan_idintegerNoOnly subscriptions for this plan
product_idintegerNoOnly subscriptions for this product

Memberships

Get membership records. Uses the same filters as Subscriptions.

Use case: Export members in a specific plan to send targeted communications or verify access levels.

{
  "object": "memberships",
  "date_from": 1704067200,
  "date_to": 1711929600,
  "status": "active",
  "plan_id": 456
}

Invoices

Get invoice records with line items, totals, and payment status.

Use case: Export paid invoices for quarterly revenue reporting or reconcile with your accounting system.

{
  "object": "invoices",
  "date_from": 1704067200,
  "date_to": 1711929600,
  "status": "paid"
}
FilterTypeRequiredDescription
date_fromtimestampYesStart date (Unix timestamp)
date_totimestampYesEnd date (Unix timestamp)
modestringNofull_data (created in range) or modified_data (updated in range)
statusstringNoFilter by: all, draft, open, paid, past_due, void, uncollectible

Payments

Get payment transaction records.

Use case: Generate a payment report for your finance team, or export all card payments in USD for bank reconciliation.

{
  "object": "payments",
  "date_from": 1704067200,
  "date_to": 1711929600,
  "status": "succeeded",
  "category": "Card",
  "currency": "usd"
}
FilterTypeRequiredDescription
date_fromtimestampYesStart date (Unix timestamp)
date_totimestampYesEnd date (Unix timestamp)
modestringNofull_data (created in range) or modified_data (updated in range)
statusstringNoFilter by: all, succeeded, pending, failed
typestringNoonline or offline
categorystringNoFilter by: all, Card, Check, Wire, Transfer, External, Cash
currencystringNo3-letter currency code, lowercase (e.g., usd, eur)
destinationstringNoFilter by payment destination

Refunds

Get refund records.

Use case: Track refunds for a specific period to analyze return trends or prepare financial reports.

{
  "object": "refunds",
  "date_from": 1704067200,
  "date_to": 1711929600,
  "status": "succeeded",
  "type": "online"
}
FilterTypeRequiredDescription
date_fromtimestampYesStart date (Unix timestamp)
date_totimestampYesEnd date (Unix timestamp)
modestringNofull_data (created in range) or modified_data (updated in range)
statusstringNoFilter by: all, pending, succeeded, failed, canceled
typestringNoonline or offline

Customers

Get customer profile records.

Use case: Export new customers for the quarter to import into your marketing automation platform.

{
  "object": "customers",
  "date_from": 1704067200,
  "date_to": 1711929600,
  "mode": "full_data"
}
FilterTypeRequiredDescription
date_fromtimestampYesStart date (Unix timestamp)
date_totimestampYesEnd date (Unix timestamp)
modestringNofull_data (created in range) or modified_data (updated in range)

Customers Metadata

Get custom metadata fields for customers. Uses the same filters as Customers.

Use case: Export custom fields like "company_size" or "industry" for customer segmentation analysis.

{
  "object": "customers_metadata",
  "date_from": 1704067200,
  "date_to": 1711929600
}

Newsletters

Get newsletter subscription records.

Use case: Export newsletter subscribers to sync with your email marketing service like Mailchimp or Klaviyo.

{
  "object": "newsletters",
  "date_from": 1704067200,
  "date_to": 1711929600
}
FilterTypeRequiredDescription
date_fromtimestampYesStart date (Unix timestamp)
date_totimestampYesEnd date (Unix timestamp)
modestringNofull_data (created in range) or modified_data (updated in range)
emailstringNoFilter by specific email address

Addresses

Get customer address records.

Use case: Export shipping addresses for a specific country to analyze your geographic customer distribution.

{
  "object": "addresses",
  "date_from": 1704067200,
  "date_to": 1711929600,
  "country": "US",
  "type": "shipping"
}
FilterTypeRequiredDescription
date_fromtimestampYesStart date (Unix timestamp)
date_totimestampYesEnd date (Unix timestamp)
modestringNofull_data (created in range) or modified_data (updated in range)
countrystringNo2-letter country code (e.g., US, CA)
typestringNoshipping or billing

Balance Transactions

Get customer balance credits and debits.

Use case: Audit all credits applied to customer accounts during a billing period.

{
  "object": "balance_transactions",
  "date_from": 1704067200,
  "date_to": 1711929600,
  "type": "credit"
}
FilterTypeRequiredDescription
date_fromtimestampYesStart date (Unix timestamp)
date_totimestampYesEnd date (Unix timestamp)
modestringNofull_data (created in range) or modified_data (updated in range)
typestringNocredit or debit

Credit Notes

Get credit note records.

Use case: Export credit notes in EUR to reconcile with your European accounting system.

{
  "object": "credit_note",
  "date_from": 1704067200,
  "date_to": 1711929600,
  "currency": "eur"
}
FilterTypeRequiredDescription
date_fromtimestampYesStart date (Unix timestamp)
date_totimestampYesEnd date (Unix timestamp)
modestringNofull_data (created in range) or modified_data (updated in range)
currencystringNo3-letter currency code, lowercase (e.g., usd, eur)
reasonstringNoFilter by credit note reason

Orders

Get e-commerce order records.

Use case: Export fulfilled orders for a specific product to send to your fulfillment warehouse.

{
  "object": "orders",
  "date_from": 1704067200,
  "date_to": 1711929600,
  "status": "fulfilled",
  "product_id": 789
}
FilterTypeRequiredDescription
date_fromtimestampYesStart date (Unix timestamp)
date_totimestampYesEnd date (Unix timestamp)
modestringNofull_data (created in range) or modified_data (updated in range)
statusstringNoFilter by: all, paid, canceled, fulfilled, returned
product_idintegerNoOnly orders for this product
sku_idintegerNoOnly orders for this SKU

Campaign Reports

Get marketing campaign performance data.

Use case: Export performance data for a specific campaign to analyze conversion rates and ROI.

{
  "object": "campaign_reports",
  "date_from": 1704067200,
  "date_to": 1711929600,
  "campaign_key": "summer-sale-2024"
}
FilterTypeRequiredDescription
date_fromtimestampYesStart date (Unix timestamp)
date_totimestampYesEnd date (Unix timestamp)
modestringNofull_data (created in range) or modified_data (updated in range)
idintegerNoSpecific campaign ID
campaign_keystringNoSpecific campaign key

Accounting

Get a complete monthly accounting package. Unlike other exports, this produces a ZIP file with 11 CSV reports.

Use case: Close your monthly books by exporting all revenue, payments, and adjustments for January 2024 in USD.

{
  "object": "accounting",
  "month": "2024-01-01",
  "currency": "usd"
}
FilterTypeRequiredDescription
monthdateYesMonth to export (format: YYYY-MM-DD, e.g., 2024-01-01 for January 2024)
currencystringYes3-letter currency code, lowercase (e.g., usd, eur)

What's in the ZIP file:

  • subscription_revenue.csv - Revenue from subscription invoices
  • order_revenue.csv - Revenue from e-commerce orders
  • recognized_revenue.csv - Revenue recognized over time
  • recognized_revenue_issue_based.csv - Issue-based recognized revenue
  • recognized_revenue_order_based.csv - Order-based recognized revenue
  • payments_received.csv - All payments received
  • applied_balance.csv - Customer balance applications
  • refunds_made.csv - All refunds issued
  • uncollectible.csv - Invoices marked as uncollectible
  • voided.csv - Voided invoices
  • credit_notes.csv - Credit notes issued

Note: You can only export accounting data for past or current months, starting from the month of your first invoice.


Date Range Limits

  • Maximum range: You can export up to 6 months of data at a time
  • Accounting exports: One month at a time

Understanding the Mode Parameter

The mode parameter determines which records are included:

ModeWhat It Does
full_dataReturns records created within the date range (default)
modified_dataReturns records updated within the date range

Use modified_data when you want to capture changes to existing records. For example, if a subscription was created in January but updated in March, using modified_data with a March date range will include that subscription.


Common Errors

What HappenedWhy
"Nothing to export"No records match your filters. Try a wider date range or fewer filters.
"Invalid date range"Date range exceeds 6 months. Request a smaller time period.
"Export in progress"You already have an export of this type running. Wait for it to complete.
Query Params
int32
required

The unique identifier of the site associated with your account.

Body Params
string
required

Type of the object being exported. Allowed values can be retrieved through the List Exports endpoint

date-time
required

Start date on which the data for the export is needed. This is based on the relevant object's created_at date.

date-time
required

End date on which the data for the export is needed. This is based on the relevant object's created_at date.

string
enum
Defaults to full_data

Specifies whether a full or modified data extract is needed. Use full_data to extract all data within the given date range based on the created_at attribute of the object, or modified_data to extract based on the updated_at attribute.

Allowed:
date
required

Date on which the data for the export is needed. This is based on the relevant object's date. Applicable to the following Exports: (accounting).

string

Currency used for financial transactions. Applicable to the following Exports: (payments, credit_notes, accounting).

string

Status relevant to the applicable object. Applicable to the following Exports: (subscriptions, memberships, invoices, payments, refunds, orders).

int32

Object ID relevant to the applicable objects. Applicable to the following Exports: (campaign_reports).

int32

Product ID relevant to the applicable objects. Applicable to the following Exports: (subscriptions, memberships, orders).

int32

Plan ID relevant to the applicable objects. Applicable to the following Exports: (subscriptions, memberships).

int32

SKU ID relevant to the applicable objects. Applicable to the following Exports: (orders).

string

Payment collection option relevant to the applicable objects. Applicable to the following Exports: (subscriptions, memberships).

string

Object type relevant to the applicable objects. Applicable to the following Exports: (payments, refunds, addresses, balance_transactions).

string

Object category relevant to the applicable objects. Applicable to the following Exports: (payments)

string

Object destination relevant to the applicable objects. Applicable to the following Exports: (payments)

string

Object reason relevant to the applicable objects. Applicable to the following Exports: (credit_notes)

string

Country ISO-2 codes relevant to applicable objects. Applicable to the following Exports: (addresses)

string

Campaign key relevant to the applicable objects. Applicable to the following Exports: (campaign_reports).

Headers
string
required
Defaults to Bearer eyJ***
Responses

Language
Credentials
LoadingLoading…
Response
Click Try It! to start a request and see the response here! Or choose an example:
application/json