Export Object

Export

One of:

Export Voucher, Export Redemption, Export Customers, Export Publication, Export Orders, Export Points Expiration, Export Vouchers Transactions

Export Voucher

All of:

1. Export Base
2. Export Vouchers

Export Redemption

All of:

1. Export Base
2. Export Redemptions

Export Customers

All of:

1. Export Base
2. Export Customers

Export Publication

All of:

1. Export Base
2. Export Publications

Export Orders

All of:

1. Export Base
2. Export Orders

Export Points Expiration

All of:

1. Export Base
2. Export Points Expirations

Export Vouchers Transactions

All of:

1. Export Base
2. Export Vouchers Transactions

Export Base

Export Vouchers

Export Redemptions

Export Customers

Export Publications

Export Orders

Export Points Expirations

Export Vouchers Transactions

Export Voucher Order

Available values: -created_at, created_at, -updated_at, updated_at, -code, code

Export Voucher Fields

Available values: code, voucher_type, value, formula, discount_type, campaign, category, start_date, expiration_date, gift_balance, loyalty_balance, redemption_quantity, redemption_count, active, qr_code, bar_code, metadata, id, is_referral_code, created_at, updated_at, validity_timeframe_interval, validity_timeframe_duration, validity_day_of_week, discount_amount_limit, campaign_id, additional_info, customer_id, discount_effect, discount_unit_type, discount_unit_effect, validation_rules_id, customer_source_id

Export Voucher Filters

Export Redemption Order

Available values: -id, id, -voucher_code, voucher_code, -tracking_id, tracking_id, -customer_id, customer_id, -created_at, created_at

Export Redemption Fields

Available values: id, object, date, voucher_code, campaign, promotion_tier_id, customer_id, customer_source_id, customer_name, tracking_id, order_id, order_amount, gift_amount, loyalty_points, result, failure_code, failure_message, metadata

Export Redemption Filters

Export Customer Order

Available values: -name, name, -id, id, -email, email, -source_id, source_id, -created_at, created_at, -updated_at, updated_at

Export Customer Fields

Available values: name, id, description, email, source_id, created_at, address_city, address_state, address_line_1, address_line_2, address_country, address_postal_code, redemptions_total_redeemed, redemptions_total_failed, redemptions_total_succeeded, redemptions_total_rolled_back, redemptions_total_rollback_failed, redemptions_total_rollback_succeeded, orders_total_amount, orders_total_count, orders_average_amount, orders_last_order_amount, orders_last_order_date, loyalty_points, loyalty_referred_customers, updated_at, phone, birthday, metadata, birthdate

Export Customer Filters

Export Publication Order

Available values: -id, id, -voucher_code, voucher_code, -tracking_id, tracking_id, -customer_id, customer_id, -created_at, created_at, -channel, channel

Export Publication Fields

Available values: voucher_code, customer_id, customer_source_id, date, channel, campaign, is_winner, metadata

Export Publication Filters

Export Order Order

Available values: -created_at, created_at, -updated_at, updated_at, -status, status

Export Order Fields

Available values: id, source_id, created_at, updated_at, status, amount, discount_amount, items_discount_amount, total_discount_amount, total_amount, customer_id, referrer_id, metadata

Export Order Filters

Export Points Expiration Order

Available values: -expires_at, expires_at

Export Points Expiration Fields

Available values: id, campaign_id, voucher_id, points, status, expires_at

Export Points Expiration Filters

Export Voucher Transactions Order

Available values: -created_at, created_at

Export Voucher Transactions Fields

Available values: id, campaign_id, voucher_id, type, source_id, reason, source, balance, amount, related_transaction_id, created_at, details

Export Voucher Transactions Filters

Junction

Logical Operator Between Filters. Filter by conditions set on the junction parameter indicating how the conditions should be accounted for in the query. An AND is an all-inclusive logical operator, meaning the AND operator displays a record if ALL the conditions separated by AND are TRUE, while an OR operator displays a record if ANY of the conditions separated by OR is TRUE.

Available values: and, or

Field Conditions

Any

One of:

1. Array any of: string, number, object
2. string
3. number
4. object

Filters Condition