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 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: 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
I