> ## Documentation Index
> Fetch the complete documentation index at: https://voucherify-pz-test.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# CSV export with API

> Suggest Edits

Voucherify enables programmable export of [vouchers](/reference/get-voucher), [redemptions](/reference/get-redemption), [publications](/reference/list-publications), [customers](/reference/get-customer), [order](/reference/get-order) and point expirations to a CSV file. Here are four simple steps to achieve it:

1. Trigger the export with [Create Export](/reference/create-export) and store the `id` of [the export object](/reference/get-export) you'll get in the response from Voucherify.

2. [Get](/reference/get-export) the export's status providing the `id` and take a look at the `status` field from the response. If it's still `SCHEDULED`, this means that the export is still in progress and you should ask later.

3. When the status is finally `DONE`, the `result` will store the URL as in the example below:

<CodeGroup>
  ```json Response
  {
    "id": "export_lhZvHKphiMESVdIncRKvoaZh",
    "object": "export",
    "created_at": "2017-02-24T14:03:00.196Z",
    "status": "DONE",
    "channel": "API",
    "exported_object": "voucher",
    "parameters": {
      "fields": [
        "code",
        "voucher_type"
      ],
      "filter": {
        "categories": {
          "conditions": {
            "$in": [
              "postman"
            ]
          }
        }
      }
    },
    "result": {
      "url": "https://download.voucherify.io/v1/exports/export_lhZvHKphiMESVdIncRKvoaZh?token=TOKEN"
    }
  }
  ```
</CodeGroup>

4. To [download the export file](/reference/download-export), use the provided URL together with authentication headers.

## Filters

Voucherify allows you to specify the timeframe for the records you want to retrieve. Thanks to this mechanism, it should be easy to implement a pagination mechanism. See the example of a request body:

<CodeGroup>
  ```json Request
  {
     "exported_object":"redemption",
     "parameters":{
        "order":"-created_at",
        "fields":[
           "id",
           "object",
           "date",
           "voucher_code",
           "customer_id",
           "result"
        ],
        "filters":{
           "junction":"and",
           "created_at":{
              "conditions":{
                 "$after":[
                    "2018-05-30T22:00:00.000Z"
                 ],
                 "$before":[
                    "2018-06-29T22:00:00.000Z"
                 ]
              }
           }
        }
     }
  }
  ```
</CodeGroup>

The export request will result in a single file being generated by the system.

***

* [Table of Contents](#)
* * [Filters](#filters)