# Find transactions

Returns a list of transactions based on specific search parameters. In response, you get data about all payments made in your game, even if they were not completed successfully. You can specify not only the transaction period, but also other parameters, e.g., to search for transactions made by a particular user or in a particular payment status. You can get the list in JSON or CSV format.


  NoticeThis 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.

Endpoint: GET /merchants/{merchant_id}/reports/transactions/search.{format}
Version: 2.0
Security: basicAuth

## Path parameters:

  - `merchant_id` (integer, required)
    Merchant ID.

  - `format` (string, required)
    Data format.
    Enum: "json", "csv", "xls"

## Query parameters:

  - `datetime_from` (string)
    Period start.

  - `datetime_to` (string)
    Period end.

  - `project_id` (integer)
    Project ID.

  - `transaction_id` (integer)
    Transaction ID.

  - `type` (string)
    Type of transactions shown in the search results:
    Enum: "all", "transferred", "canceled", "test"

  - `phone` (string)
    Phone number in international format.

  - `user_id` (string)
    Unique user ID in the game stored on your side. Make sure you pass the existing user ID. In case an error occurs, refer to the answers to the FAQs.

  - `user_name` (string)
    Username.

  - `user_custom` (string)
    Custom parameter for user identification.

  - `email` (string)
    User email.

  - `external_id` (string)
    Transaction ID in the game. Has to be unique for each user payment.

  - `order_id` (integer)
    Order ID. You can use it to call the Get order API method.
    Example: 1234

  - `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)
    A transaction status.
    Enum: "created", "processing", "review", "error", "done", "awaitingRefund", "refunded", "canceled", "partiallyRefunded"


## Response 200 fields