Xsolla-logo

Find transactions

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

Gets a list of transactions based on specific search parameters. You can get the list in JSON, CSV, or XLS format within 5 to 10 minutes after executing the request.

SecuritybasicAuth
Request
path Parameters
merchant_id
required
integer

Merchant ID.

format
required
string

Data format.

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

Period start.

datetime_to
string <datetime>

Period end.

project_id
integer

Project ID.

transaction_id
integer

Transaction ID.

type
string

Type of transactions shown in the search results:

Enum: Description
all

All transactions.

transferred

Successful transactions excluding test transactions.

canceled

Canceled transactions excluding test transactions.

test

Test transactions.

phone
string

Phone number in international format.

user_id
string

User ID.

user_name
string

Username.

user_custom
string

Custom parameter for user identification.

email
string <= 100 characters

User email.

external_id
string

Transaction ID in the game. Has to be unique for each user payment.

offset
integer

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

limit
integer

Limit for the number of elements on the page.

status
string

Additional transaction status.

Enum: "created" "processing" "done" "canceled" "error" "review" "refunded" "awaitingRefund"
Responses
200

OK.

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