Export quotes for a specific period

Summary

This article guides you through exporting quotes for a specific period in Chargebee using the API, as there is no direct option available through the user interface. By leveraging the "List all quotes" API with the date[between] parameter, you can filter and retrieve quotes within a defined date range. The API will return a JSON response containing all quotes generated during that time, which can then be converted into a CSV file using tools like Postman or other data conversion platforms.

Description

If you need to export quotes from Chargebee for a specific timeframe, the platform currently does not offer a direct option through the UI. However, this can be achieved easily using Chargebee's API.

API Request Format:

Use the following GET request URL format to retrieve quotes within a specific date range: bash

https://testaccount14-test.chargebee.com/api/v2/quotes?date[between]=[1733027838,1733827038]

1. Set the Date Range:
   • Use the date[between] attribute to define the range.
   • Enter the timestamps in Unix time format.
2. Convert Timestamps:
   • To convert between Unix time and GMT (or vice versa), use an epoch converter tool online.
3. Convert JSON to CSV:
   • Once the API returns the JSON response, use a tool like Postman or an online converter to transform the data into a CSV format for easier analysis or reporting.

By following these steps, you can efficiently export quotes from Chargebee for any specific period using the API.