Docs

Log in to read the version of docs relevant to your site, or use the dropdown versions

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.

Was this article helpful?