Skip to main content
type: QUERY_EXPORT_TYPE_PRODUCT_BILLING_ACCESS_FIND_MANY Exports product access billing records: charge statuses (subscriptions/installments), start dates, end dates and charge retry dates. This is a report type for the query-export/generate method: pass it in the type field, and the fields described below in variables.
The report is built from product accesses (productAccessManageFindMany) with a focus on billing (subscriptions and installments). variables is the access filter and sort (FilterAccessProductInput / SortAccessProductInput), the same structure as in the “School students” report, which also describes the other filter fields (courseIds, groupIds, search, date ranges, etc.). An unknown field or an invalid value is not ignored: the export finishes with status: Failed.

Variables (variables)

object
required
Access filter parameters (billing fields have the billing prefix). Required: to export all records without filtering, pass an empty object {}.
object
Sort parameters. Values: ASC (ascending) or DESC (descending).

Report columns

Billing Access sheet: User ID, Full name, Login method, Phone number, Email, Telegram, Payment ID, Last payment date, Next payment date, Last payment amount, Paid amount, Total amount, Payment percent, Completed payments, Total payments, Renewal count, Renewal period, Course ID, Course name, Tariff ID, Tariff, Payment method, Status.
The Payment percent, Completed payments and Total payments columns appear only with an installment filter (hasProductBillingTypes: ["Installment"]), and Renewal count and Renewal period only with a subscription filter (hasProductBillingTypes: ["Subscription"]).
In XLSX format only, an additional Billing Details sheet is generated with a per-payment breakdown: User ID, Access ID, Billing ID, Number, Payment date, Status, Amount, Invoice ID, Used attempts, Total attempts, Next retry date, Cancel date. Column names are given as they appear without the Ux-Language header (in English); with Ux-Language: ru the columns are named in Russian (see the generate description for details).
The method responds with a generation task that has a uuid. Get the file via fetching the result.

Permission requirements

Requires token authentication and one of the permissions: “School User Management” (SchoolManageUsers) or “Course Student Management” (CourseStudentManage). Without the permission, the generation request succeeds, but the export finishes with status: Failed.

Updated: 2026-09-25 14:33 UTC