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

AttributesDescription
id
string

Unique export ID.

object
string

The type of object being represented. This object stores information about the export.

Available values: export
created_at
string

Timestamp representing the date and time when the export was scheduled in ISO 8601 format.

status
string

Status of the export. Informs you whether the export has already been completed, i.e. indicates whether the file containing the exported data has been generated.

Available values: SCHEDULED, IN_PROGRESS, DONE, ERROR
channel
string

The channel through which the export was triggered.

result
object, null

Contains the URL of the CSV file.

AttributesDescription
url
string

URL of the CSV file location. It contains the token used for authorization in the Download export method.

user_id
string, null

Identifies the specific user who initiated the export through the Voucherify Dashboard; returned when the channel value is WEBSITE.

Export Vouchers

AttributesDescription
exported_object
string

The type of object to be exported.

Available values: voucher
parameters
object
AttributesDescription
order

How the export is filtered, where the dash - preceding a sorting option means sorting in a descending order.

Export Voucher Order
fields
array

Array of strings containing the data in the export. These fields define the headers in the CSV file.

Array of Export Voucher Fields
filters

Filter conditions.

Export Voucher Filters

Export Redemptions

AttributesDescription
exported_object
string

The type of object to be exported.

Available values: redemption
parameters
object

List of available fields and filters that can be exported with an order along with the sorting order of the returned data.

AttributesDescription
order

How the export is filtered, where the dash - preceding a sorting option means sorting in a descending order.

Export Redemption Order
fields
array

Array of strings containing the data in the export. These fields define the headers in the CSV file.

Array of Export Redemption Fields
filters

Filter conditions.

Export Redemption Filters

Export Customers

AttributesDescription
exported_object
string

The type of object to be exported.

Available values: customer
parameters
object

List of available fields and filters that can be exported with an order along with the sorting order of the returned data.

AttributesDescription
order

How the export is filtered, where the dash - preceding a sorting option means sorting in a descending order.

Export Customer Order
fields
array

Array of strings containing the data in the export. These fields define the headers in the CSV file.

Array of Export Customer Fields
filters

Filter conditions.

Export Customer Filters

Export Publications

AttributesDescription
exported_object
string

The type of object to be exported.

Available values: publication
parameters
object

List of available fields and filters that can be exported with an order along with the sorting order of the returned data.

AttributesDescription
order

How the export is filtered, where the dash - preceding a sorting option means sorting in a descending order.

Export Publication Order
fields
array

Array of strings containing the data in the export. These fields define the headers in the CSV file.

Array of Export Publication Fields
filters

Filter conditions.

Export Publication Filters

Export Orders

AttributesDescription
exported_object
string

The type of object to be exported.

Available values: order
parameters
object

List of available fields and filters that can be exported with an order along with the sorting order of the returned data.

AttributesDescription
order

How the export is filtered, where the dash - preceding a sorting option means sorting in a descending order.

Export Order Order
fields
array

Array of strings containing the data in the export. These fields define the headers in the CSV file.

Array of Export Order Fields
filters

Filter conditions.

Export Order Filters

Export Points Expirations

AttributesDescription
exported_object
string

The type of object to be exported.

Available values: points_expiration
parameters
object

List of available fields and filters that can be exported with an order along with the sorting order of the returned data.

AttributesDescription
order

How the export is filtered, where the dash - preceding a sorting option means sorting in a descending order.

Export Points Expiration Order
fields
array

Array of strings containing the data in the export. These fields define the headers in the CSV file.

Array of Export Points Expiration Fields
filters

Filter conditions.

Export Points Expiration Filters

Export Vouchers Transactions

AttributesDescription
exported_object
string

The type of object to be exported.

Available values: voucher_transactions
parameters
object

List of available fields and filters that can be exported with an order along with the sorting order of the returned data.

AttributesDescription
order

How the export is filtered, where the dash - preceding a sorting option means sorting in a descending order.

Export Voucher Transactions Order
fields
array

Array of strings containing the data in the export. These fields define the headers in the CSV file.

Array of Export Voucher Transactions Fields
filters

Filter conditions.

Export Voucher Transactions Filters

Export Voucher Order

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

Export Voucher Fields

Available values: code, voucher_type, value, 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_unit_type, discount_unit_effect, customer_source_id

Export Voucher Filters

AttributesDescription
junction

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.

Junction
created_atSee: Field Conditions
updated_atSee: Field Conditions
created_dateSee: Field Conditions
activeSee: Field Conditions
redemption_statusSee: Field Conditions
start_dateSee: Field Conditions
expiration_dateSee: Field Conditions
validity_day_of_weekSee: Field Conditions
codeSee: Field Conditions
categoriesSee: Field Conditions
vouchersSee: Field Conditions
holder_idSee: Field Conditions
is_referral_codeSee: Field Conditions
published_for_customer_idSee: Field Conditions
validity_timeframeSee: Field Conditions
category_idsSee: Field Conditions
[propertyName]See: Field Conditions

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_amount, gift_amount, loyalty_points, result, failure_code, failure_message, metadata

Export Redemption Filters

AttributesDescription
junctionSee: Junction
created_at
object
AttributesDescription
conditions
object

Filters Condition

AttributesDescription
$afterSee: Any
$beforeSee: Any
campaign
object
AttributesDescription
conditions
object

Filters Condition

AttributesDescription
$isSee: Any
customer
object
AttributesDescription
conditions
object

Filters Condition

AttributesDescription
$isSee: Any
voucher
object
AttributesDescription
conditions
object

Filters Condition

AttributesDescription
$isSee: Any
related_object
object
AttributesDescription
conditions
object

Filters Condition

AttributesDescription
$inSee: Any
voucher_codeSee: Field Conditions
related_object_idSee: Field Conditions
related_object_parent_idSee: Field Conditions
parent_redemption_idSee: Field Conditions
failure_codeSee: Field Conditions
resultSee: Field Conditions
objectSee: Field Conditions
customer_idSee: Field Conditions
campaign_nameSee: Field Conditions
user_loginSee: Field Conditions
statusSee: Field Conditions
[propertyName]See: Field Conditions

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

AttributesDescription
junctionSee: Junction
created_at
object
AttributesDescription
conditions
object

Filters Condition

AttributesDescription
$afterSee: Any
$beforeSee: Any
updated_at
object
AttributesDescription
conditions
object

Filters Condition

AttributesDescription
$after
array
$before
array
$is
array
emailSee: Field Conditions
nameSee: Field Conditions
city
object
AttributesDescription
conditions
object

Filters Condition

AttributesDescription
$isSee: Any
phoneSee: Field Conditions
birthdaySee: Field Conditions
source_idSee: Field Conditions
publications.created_atSee: Field Conditions
publications.related_object_idSee: Field Conditions
[propertyName]See: Field Conditions

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

AttributesDescription
junctionSee: Junction
created_at
object
AttributesDescription
conditions
object

Filters Condition

AttributesDescription
$afterSee: Any
$beforeSee: Any
campaign
object
AttributesDescription
conditions
object

Filters Condition

AttributesDescription
$isSee: Any
customer
object
AttributesDescription
conditions
object

Filters Condition

AttributesDescription
$isSee: Any
voucher
object
AttributesDescription
conditions
object

Filters Condition

AttributesDescription
$isSee: Any
failure_codeSee: Field Conditions
resultSee: Field Conditions
customer_idSee: Field Conditions
campaign_nameSee: Field Conditions
voucher_typeSee: Field Conditions
is_referral_codeSee: Field Conditions
parent_object_idSee: Field Conditions
related_object_idSee: Field Conditions
source_idSee: Field Conditions
[propertyName]See: Field Conditions

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

AttributesDescription
junctionSee: Junction
created_at
object
AttributesDescription
conditions
object

Filters Condition

AttributesDescription
$afterSee: Any
$beforeSee: Any
updated_at
object
AttributesDescription
conditions
object

Filters Condition

AttributesDescription
$afterSee: Any
$beforeSee: Any
statusSee: Field Conditions
source_idSee: Field Conditions
amountSee: Field Conditions
total_amountSee: Field Conditions
discount_amountSee: Field Conditions
total_discount_amountSee: Field Conditions
items_discount_amountSee: Field Conditions
[propertyName]See: Field Conditions

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

AttributesDescription
junctionSee: Junction
campaign_idSee: Field Conditions
voucher_idSee: Field Conditions

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

AttributesDescription
junctionSee: Junction
created_atSee: Field Conditions
voucher_idSee: Field Conditions
campaign_idSee: Field Conditions

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

AttributesDescription
conditions

Data filters used to narrow the data records to be returned in the result.

Filters Condition

Any

One of:

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

Filters Condition

AttributesDescription
$inSee: Any
$not_inSee: Any
$isSee: Any
$is_days_agoSee: Any
$is_days_in_futureSee: Any
$is_notSee: Any
$has_valueSee: Any
$is_unknownSee: Any
$containsSee: Any
$not_containSee: Any
$starts_withSee: Any
$ends_withSee: Any
$more_thanSee: Any
$less_thanSee: Any
$more_than_agoSee: Any
$less_than_agoSee: Any
$more_than_futureSee: Any
$less_than_futureSee: Any
$more_than_equalSee: Any
$less_than_equalSee: Any
$afterSee: Any
$beforeSee: Any
$countSee: Any
$count_lessSee: Any
$count_moreSee: Any