Xsolla-logo

Get transactionsServer-sideAdmin

get/merchants/{merchant_id}/reports/transactions/registry.{format}

Returns the list of detailed information about successful and canceled transactions for a specified period. In response, you get information about payments, including data on fees, taxes, as well as order and user. You can get the list in JSON or CSV format. You can use this API call to perform financial reconciliation.

Notice

This API call does not contain the project_id path parameter, so you need to use the API key that is valid in all the company’s projects to set up authorization.

SecuritybasicAuth
Request
path Parameters
merchant_id
required
integer

Merchant ID.

format
required
string

Data format.

Enum: "json" "csv" "xls"
query Parameters
datetime_from
required
string <datetime>

Period start in the YYYY-MM-DD format. Not required if the limit parameter is passed.

Example: datetime_from=2023-02-08
datetime_to
required
string <datetime>

Period end in the YYYY-MM-DD format. Not required if the limit parameter is passed. The difference between datetime_from and datetime_to cannot be more than 92 days.

Example: datetime_to=2023-03-08
in_transfer_currency
required
integer

Converts all financial data to the payout currency (the pay-in currency is used by default).

show_total
required
boolean

Adds totals to the report.

merchant_of_records
string or null

Merchant of Record. Can be xsolla, merchant, or not specified. If merchant, returns transactions made via the partner’s gateways. If xsolla, returns transactions made not via the partner’s gateways. If not specified, returns all transactions.

Enum: Description
merchant

Returns transactions made via the partner’s gateways.

xsolla

Returns transactions made not via the partner’s gateways.

project_id
integer

Project ID.

show_dry_run
boolean

Whether to include test transactions.

transfer_id
integer

Payout ID.

report_id
integer

Financial report ID.

offset
integer

Number of the element from which the list is generated (the count starts from 0).

limit
integer

Limit for the number of displayed transactions on the page. If this parameter is passed, you don’t need to pass the datetime_from and datetime_to parameters.

status
string

Transaction status.

Enum: "done" "canceled" "error"
Responses
200

The list of transactions was successfully returned.

Request samples
Response samples
application/json
[
  • {
    }
]