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"]).Ux-Language header (in English); with Ux-Language: ru the columns are named in Russian
(see the generate description for details).
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