Skip to main content
GET
/
v2.01
/
{ClientId}
/
reporting
/
reports
/
{ReportingId}
// GET has no body parameters

{
    "Id": "report_01JVVQFJETHHP9M9S18RN6N8JZ",
    "Tag": "Created using the Mangopay API Postman collection",
    "CreationDate": 1747908544,
    "ReportDate": 1747908545,
    "Status": "GENERATED",
    "ResultCode": "000000",
    "ResultMessage": "Success",
    "DownloadFormat": "CSV",
    "DownloadURL": "https://reporting-sandbox-downloads.mangopay.com/reporting/user-wallet-transactions-b87d078d-ec6a-41aa-8719-4dc86f341e60-user-id-user_m_01JSM1ZG3MAWR272S99ZKE2WSP-wallet-id-wlt_m_01JSM21JYR8CFM43XREZQS1ZXH.csv?Policy=eyJTdGF0ZW1lbnQiOiBbeyJSZXNvdXJjZSI6IioiLCJDb25kaXRpb24iOnsiRGF0ZUxlc3NUaGFuIjp7IkFXUzpFcG9jaFRpbWUiOjE3NTA1NTA0MDB9fX1dfQ__&Signature=TkzN3liwlGu4kLWNWZ2-FRWzwvzYNK2jQAgOmm6MBSl6qiSYOamgGGy~aNCTOWM8sBDgVCveau7W9rqxNajXsJKoVfJbNZYNyDnJlYZt24KMiq0SeBIQ0nLTukr1q-eYOpB7cjVikGetikKNldNUeDYdB3-dqIHUecNpBvRkw9Zoa72cfheznwsrA3XwuHcWpwHdcFHXpz89OD10Fbr75mRKrIqmzb5ecGFRXDjmtBl3UD~iFXyPusDV8UiBAuM6bRinHTenq9Mff4j1~MgTjmSnG7ZSwKsxHG50CJ-G5hhiWtAPgptbwck~2C7Lv7L1Hk1h7u59ZPI0IOh8cXMSKA__&Key-Pair-Id=K16WIKTSLTS2C2",
    "ReportType": "USER_WALLET_TRANSACTIONS",
    "Sort": "CreationDate:DESC",
    "AfterDate": 1740787200,
    "BeforeDate": 1743465599,
    "Filters": {
        "UserId": "user_m_01JSM1ZG3MAWR272S99ZKE2WSP",
        "WalletId": "wlt_m_01JSM21JYR8CFM43XREZQS1ZXH"
    },
    "Columns": [
        {
            "Name": "ClientId",
            "IsDefault": true
        },
        {
            "Name": "TransactionId",
            "IsDefault": true
        },
        {
            "Name": "CreationDate",
            "IsDefault": true
        },
        {
            "Name": "ExecutionDate",
            "IsDefault": true
        },
        {
            "Name": "AuthorId",
            "IsDefault": true
        },
        {
            "Name": "CreditedUserId",
            "IsDefault": true
        },
        {
            "Name": "DebitedFundsAmount",
            "IsDefault": true
        },
        {
            "Name": "DebitedFundsCurrency",
            "IsDefault": true
        },
        {
            "Name": "CreditedFundsAmount",
            "IsDefault": true
        },
        {
            "Name": "CreditedFundsCurrency",
            "IsDefault": true
        },
        {
            "Name": "FeesAmount",
            "IsDefault": true
        },
        {
            "Name": "FeesCurrency",
            "IsDefault": true
        },
        {
            "Name": "Type",
            "IsDefault": true
        },
        {
            "Name": "Nature",
            "IsDefault": true
        },
        {
            "Name": "CreditedWalletId",
            "IsDefault": true
        },
        {
            "Name": "DebitedWalletId",
            "IsDefault": true
        },
        {
            "Name": "BankAccountId",
            "IsDefault": true
        },
        {
            "Name": "PreauthorizationId",
            "IsDefault": true
        },
        {
            "Name": "BankWireRef",
            "IsDefault": true
        },
        {
            "Name": "CardId",
            "IsDefault": true
        },
        {
            "Name": "CardAlias",
            "IsDefault": true
        },
        {
            "Name": "CardType",
            "IsDefault": true
        },
        {
            "Name": "CardCountry",
            "IsDefault": true
        },
        {
            "Name": "CardExpirationDate",
            "IsDefault": true
        },
        {
            "Name": "Culture",
            "IsDefault": true
        },
        {
            "Name": "DeclaredDebitedFundsAmount",
            "IsDefault": true
        },
        {
            "Name": "DeclaredDebitedFundsCurrency",
            "IsDefault": true
        },
        {
            "Name": "DeclaredFeesAmount",
            "IsDefault": true
        },
        {
            "Name": "DeclaredFeesCurrency",
            "IsDefault": true
        },
        {
            "Name": "ExecutionType",
            "IsDefault": true
        },
        {
            "Name": "PaymentType",
            "IsDefault": true
        },
        {
            "Name": "WireReference",
            "IsDefault": true
        }
    ]
}

​
Path parameters

​
ReportingId
string
required
The unique identifier of the Reporting Service report.

​
Responses

​
Id
string
Max length: 128 characters (see data formats for details)The unique identifier of the object.
​
Tag
string
Max. length: 255 charactersCustom data that you can add to this object.For reports, this parameter can be useful to give the report a name.
​
CreationDate
Unix timestamp
The date and time at which the object was created.
​
ReportDate
Unix timestamp | null
The date and time at which the report was generated.
​
Status
string
Returned values: PENDING, READY_FOR_DOWNLOAD, FAILED, EXPIREDThe status of the report:
  • PENDING – The report is being generated.
  • READY_FOR_DOWNLOAD – The report has been created, and can be downloaded.
  • FAILED – The report cannot be generated.
  • EXPIRED – The report was created, but is no longer available for download (it can be re-run to be downloaded again with fresh data).
​
ResultCode
string
The code indicating the result of the operation. This information is mostly used to handle errors or for filtering purposes.
​
ResultMessage
string
The explanation of the result code.
​
DownloadFormat
string
Returned values: CSVThe format in which the report is going to be downloaded.
​
DownloadURL
string | null
The URL at which the report file can be downloaded when the Status is GENERATED.
​
ReportType
string
Possible values: COLLECTED_FEES, USER_WALLET_TRANSACTIONS, ECHO_INTENT, ECHO_INTENT_ACTION, ECHO_SETTLEMENT, ECHO_SPLIT.The type of the report. Each ReportType has different available Columns and Filters.Useful for all platforms:
  • USER_WALLET_TRANSACTIONS – All successful transactions crediting or debiting user wallets: pay-ins, transfers, conversions, and payouts, as well as refunds of all types and repudiations (from chargebacks).
  • COLLECTED_FEES– Detail of transactions crediting or debiting the fees wallet: successful transactions of all types (pay-ins, transfers, refunds, payouts, etc.) that have a positive or negative fees amount.
Useful for platforms using Echo, Mangopay’s solution for integrations working with third-party PSPs:
  • ECHO_INTENT – Summary of all intents declared during the selected period, detailing the total funds expected to enter the platform’s escrow wallets.
  • ECHO_INTENT_ACTION – Summary of all operations related to intents processed during the selected period, detailing the expected money movements to be escrowed — including payments, refunds, refund reversals, and chargebacks.
  • ECHO_SETTLEMENT – Summary of all settlement files uploaded during the selected period to initiate the reconciliation process, confirming the expected money movements to be escrowed.
  • ECHO_SPLIT – Summary of all splits related to intents during the selected period, detailing the transfer of funds to the declared destination.
​
Sort
string
The sorting direction of the CreationDate column. By default, the generated report is sorted by ascending creation date.
​
AfterDate
Unix timestamp
Possible values: Any date and time (before the BeforeDate) between the present and 24 months ago.The date and time after which the report’s transaction was created, based on the transaction’s CreationDate.Note: The period between the AfterDate and the BeforeDate cannot exceed 12 months.
​
BeforeDate
Unix timestamp
Possible values: Any date and time (after the AfterDate) between the present and 24 months ago.The date and time before which the report’s transaction was created, based on the transaction’s CreationDate.Note: The period between the AfterDate and the BeforeDate cannot exceed 12 months.
​
Filters
object
The filters sent in the request. Different filters are available for each ReportType.
​
Columns
array (string)
Possible values: The columns listed in the Reports guide, which differ according to the report type.Default values: The default columns listed in the Reports guide, which differ according to the report type.The data columns to be included in the report.
{
    "Id": "report_01JVVQFJETHHP9M9S18RN6N8JZ",
    "Tag": "Created using the Mangopay API Postman collection",
    "CreationDate": 1747908544,
    "ReportDate": 1747908545,
    "Status": "GENERATED",
    "ResultCode": "000000",
    "ResultMessage": "Success",
    "DownloadFormat": "CSV",
    "DownloadURL": "https://reporting-sandbox-downloads.mangopay.com/reporting/user-wallet-transactions-b87d078d-ec6a-41aa-8719-4dc86f341e60-user-id-user_m_01JSM1ZG3MAWR272S99ZKE2WSP-wallet-id-wlt_m_01JSM21JYR8CFM43XREZQS1ZXH.csv?Policy=eyJTdGF0ZW1lbnQiOiBbeyJSZXNvdXJjZSI6IioiLCJDb25kaXRpb24iOnsiRGF0ZUxlc3NUaGFuIjp7IkFXUzpFcG9jaFRpbWUiOjE3NTA1NTA0MDB9fX1dfQ__&Signature=TkzN3liwlGu4kLWNWZ2-FRWzwvzYNK2jQAgOmm6MBSl6qiSYOamgGGy~aNCTOWM8sBDgVCveau7W9rqxNajXsJKoVfJbNZYNyDnJlYZt24KMiq0SeBIQ0nLTukr1q-eYOpB7cjVikGetikKNldNUeDYdB3-dqIHUecNpBvRkw9Zoa72cfheznwsrA3XwuHcWpwHdcFHXpz89OD10Fbr75mRKrIqmzb5ecGFRXDjmtBl3UD~iFXyPusDV8UiBAuM6bRinHTenq9Mff4j1~MgTjmSnG7ZSwKsxHG50CJ-G5hhiWtAPgptbwck~2C7Lv7L1Hk1h7u59ZPI0IOh8cXMSKA__&Key-Pair-Id=K16WIKTSLTS2C2",
    "ReportType": "USER_WALLET_TRANSACTIONS",
    "Sort": "CreationDate:DESC",
    "AfterDate": 1740787200,
    "BeforeDate": 1743465599,
    "Filters": {
        "UserId": "user_m_01JSM1ZG3MAWR272S99ZKE2WSP",
        "WalletId": "wlt_m_01JSM21JYR8CFM43XREZQS1ZXH"
    },
    "Columns": [
        {
            "Name": "ClientId",
            "IsDefault": true
        },
        {
            "Name": "TransactionId",
            "IsDefault": true
        },
        {
            "Name": "CreationDate",
            "IsDefault": true
        },
        {
            "Name": "ExecutionDate",
            "IsDefault": true
        },
        {
            "Name": "AuthorId",
            "IsDefault": true
        },
        {
            "Name": "CreditedUserId",
            "IsDefault": true
        },
        {
            "Name": "DebitedFundsAmount",
            "IsDefault": true
        },
        {
            "Name": "DebitedFundsCurrency",
            "IsDefault": true
        },
        {
            "Name": "CreditedFundsAmount",
            "IsDefault": true
        },
        {
            "Name": "CreditedFundsCurrency",
            "IsDefault": true
        },
        {
            "Name": "FeesAmount",
            "IsDefault": true
        },
        {
            "Name": "FeesCurrency",
            "IsDefault": true
        },
        {
            "Name": "Type",
            "IsDefault": true
        },
        {
            "Name": "Nature",
            "IsDefault": true
        },
        {
            "Name": "CreditedWalletId",
            "IsDefault": true
        },
        {
            "Name": "DebitedWalletId",
            "IsDefault": true
        },
        {
            "Name": "BankAccountId",
            "IsDefault": true
        },
        {
            "Name": "PreauthorizationId",
            "IsDefault": true
        },
        {
            "Name": "BankWireRef",
            "IsDefault": true
        },
        {
            "Name": "CardId",
            "IsDefault": true
        },
        {
            "Name": "CardAlias",
            "IsDefault": true
        },
        {
            "Name": "CardType",
            "IsDefault": true
        },
        {
            "Name": "CardCountry",
            "IsDefault": true
        },
        {
            "Name": "CardExpirationDate",
            "IsDefault": true
        },
        {
            "Name": "Culture",
            "IsDefault": true
        },
        {
            "Name": "DeclaredDebitedFundsAmount",
            "IsDefault": true
        },
        {
            "Name": "DeclaredDebitedFundsCurrency",
            "IsDefault": true
        },
        {
            "Name": "DeclaredFeesAmount",
            "IsDefault": true
        },
        {
            "Name": "DeclaredFeesCurrency",
            "IsDefault": true
        },
        {
            "Name": "ExecutionType",
            "IsDefault": true
        },
        {
            "Name": "PaymentType",
            "IsDefault": true
        },
        {
            "Name": "WireReference",
            "IsDefault": true
        }
    ]
}

// GET has no body parameters