Payment Report

Our paginated payments endpoint is designed to provide an efficient and user-friendly way to retrieve payment data. It offers robust filtering options to ensure you can access the specific information you need quickly and easily.

GET https://sandbox-api.veem.com/veem/v1.2/payments/report

For partners,

GET [https://sandbox-api.veem.com/veem/v1.2/payments/partner-report](https://sandbox-api.veem.com/veem/v1.2/payments/report)

📘

Headers

Three headers are required to use this endpoint.

Required Headers

<


Name Type Required Description
`Authorization` `string` Yes Bearer token (OAuth 2.0) This header holds the bearer token required to use Veem's public API, and **belongs to the owner account**. Failure to use a valid bearer token will result in a 404 (Not Found) status code in the response. An example of a valid header value is as follows: `Bearer c047594b-082c-4da1-be89-08fe3770f4b3` See [Get Access Token section](https://developer.veem.com/docs/oauth#1---get-access-token) to generate your Bearer token
`X-Request-Id` `string` Yes This is a unique string that identifies the current API request, and should follow the UUID format. Reusing this header without changing the value will result in a 409 (Conflict) status code in the response. An example X-request-id is as follows:\ `48855846-628d-4177-b071-80332a116f0a`
`Content-Type` `string` Yes The content type of the request. Must be `application/json`

Parameters:

ParamenterDescriptionMandatory
startDateThe starting date used to filter records. This date corresponds to the creation date of the payment within the Veem system. Only entries from this date onward will be included. The date should follow the ISO 8601 format. The time range for each query is limited to a maximum duration of 1 yearyes
endDateThe ending date used to filter records. This date corresponds to the creation date of the payment within the Veem system. The date should follow the ISO 8601 format. The time range for each query is limited to a maximum duration of 1 yearyes
status

The current status of the payment records to be returned:

Drafted
Sent
PendingAuth
Authorized
InProgress
Complete
Cancelled
Closed

no
pageNumberNumber of page user want to get paymentsno
pageSizeNumber of records per page. If not specified, the default number will be 20no

Parameter examples:

ExampleDescription
GET /veem/v1.2/payments/report**?startDate=2024-11-18&endDate=2024-11-18**Get all payments between for the day 18 November 2024 including the fundingMethodType and fundingMethodId
GET /veem/v1.2/payments/report?startDate=2024-11-18&endDate=2024-11-20&status=approvedGet all payments on the determined date and status approved including the fundingMethodType and fundingMethodId
GET /veem/v1.2/payments/report?startDate=2024-11-18&endDate=2023-11-18&pageNumber=2&pageSize=20Get all payments on the determined date, requiring 20 records per page and getting records for the second page including the fundingMethodType and fundingMethodId
GET /veem/v1.2/payments/partner-report?startDate=2024-11-18&endDate=2023-11-18&pageNumber=2&pageSize=20Get all payments on the determined date, requiring 20 records per page and getting records for the second page including the fundingMethodType and fundingMethodId for both payer and payee if accountId belongs to partner

Example Response

{
    "content": [
        {
            "id": 461353,
            "status": "Complete",
            "payee": {
                "countryCode": "US",
                "payeeAmount": {
                    "number": 580.00,
                    "currency": "USD"
                }
            },
            "payer": {
                "countryCode": "US",
                "payerAmount": {
                    "number": 580.00,
                    "currency": "USD"
                },
              "payerAccountId": 942800,
              "fundingMethodType": "Bank",
              "fundingMethodId": 2910

            },
            "timeCreated": "2024-11-01T07:23:46.983-07:00"
        },
        {
            "id": 461354,
            "status": "Complete",
            "payee": {
                "countryCode": "US",
                "payeeAmount": {
                    "number": 320.00,
                    "currency": "USD"
                }
            },
            "payer": {
                "countryCode": "US",
                "payerAmount": {
                    "number": 320.00,
                    "currency": "USD"
                },
                "payerAccountId": 942800
            },
            "timeCreated": "2024-11-01T07:27:09.416-07:00"
        },
        {
            "id": 461355,
            "status": "Complete",
            "payee": {
                "countryCode": "US",
                "payeeAmount": {
                    "number": 380.00,
                    "currency": "USD"
                }
            },
            "payer": {
                "countryCode": "US",
                "payerAmount": {
                    "number": 380.00,
                    "currency": "USD"
                },
                "payerAccountId": 942800
            },
            "timeCreated": "2024-11-01T07:35:57.535-07:00"
        },
        {
            "id": 461356,
            "status": "Complete",
            "payee": {
                "countryCode": "US",
                "payeeAmount": {
                    "number": 300.00,
                    "currency": "USD"
                }
            },
            "payer": {
                "countryCode": "VN",
                "payerAmount": {
                    "number": 300.00,
                    "currency": "USD"
                },
                "payerAccountId": 942800
            },
            "timeCreated": "2024-11-01T09:56:35.922-07:00"
        },
        {
            "id": 461357,
            "status": "Complete",
            "payee": {
                "countryCode": "US",
                "payeeAmount": {
                    "number": 450.00,
                    "currency": "USD"
                }
            },
            "payer": {
                "countryCode": "VN",
                "payerAmount": {
                    "number": 450.00,
                    "currency": "USD"
                },
                "payerAccountId": 942800
            },
            "timeCreated": "2024-11-01T11:35:28.255-07:00"
        },
        {
            "id": 461358,
            "status": "Complete",
            "payee": {
                "countryCode": "US",
                "payeeAmount": {
                    "number": 880.00,
                    "currency": "USD"
                }
            },
            "payer": {
                "countryCode": "VN",
                "payerAmount": {
                    "number": 880.00,
                    "currency": "USD"
                },
                "payerAccountId": 942800
            },
            "timeCreated": "2024-11-01T11:38:59.633-07:00"
        },
        {
            "id": 461362,
            "status": "Complete",
            "payee": {
                "countryCode": "US",
                "payeeAmount": {
                    "number": 2625.44,
                    "currency": "PHP"
                }
            },
            "payer": {
                "countryCode": "US",
                "payerAmount": {
                    "number": 50.00,
                    "currency": "USD"
                },
                "payerAccountId": 942800
            },
            "timeCreated": "2024-11-01T11:55:49.459-07:00"
        },
        {
            "id": 461363,
            "status": "Drafted",
            "payee": {
                "countryCode": "US",
                "payeeAmount": {
                    "number": 45.05,
                    "currency": "USD"
                }
            },
            "payer": {
                "countryCode": "US",
                "payerAmount": {
                    "number": 2953.10,
                    "currency": "PHP"
                },
                "payerAccountId": 942800
            },
            "timeCreated": "2024-11-01T12:16:10.235-07:00"
        },
        {
            "id": 461364,
            "status": "Drafted",
            "payee": {
                "countryCode": "US",
                "payeeAmount": {
                    "number": 45.05,
                    "currency": "USD"
                }
            },
            "payer": {
                "countryCode": "US",
                "payerAmount": {
                    "number": 2953.10,
                    "currency": "PHP"
                },
                "payerAccountId": 942800
            },
            "timeCreated": "2024-11-01T12:16:20.999-07:00"
        }
    ],
    "numberOfElements": 9,
    "size": 10,
    "number": 0,
    "last": true,
    "first": true,
    "sort": [
        {
            "direction": "ASC",
            "property": "timeCreated"
        }
    ],
    "totalPages": 1,
    "totalElements": 9
}

The following table describes the various payment status values:

StatusDescription
DraftedPayment is in drafted state and requires further updates.
SentThe payment has been sent to the receiver/payee.
PendingAuthThe payment is in pending authorization by Veem.
AuthorizedThe payment has been authorized and is ready for processing. The money will be withdrawn from sender's bank.
InProgressThe payment has been initiated and receiver will be receiving money shortly.
CompleteThe payment is complete and the receiver should have received the money.
CancelledThe payment has been cancelled by the sender/payer.
ClosedThe payment has been closed by Veem by request from the sender, or receiver, or due to an error with the payment.

Validation errors

CodeNumeric CodeDescription
DATE_CAN_NOT_BE_BIGGER_1_YEAR50001106The date range cannot exceed one year
END_DATE_CAN_NOT_BE_EARLIER_THAN_START_DATE50001107End date cannot be earlier than start date
START_DATE_CAN_NOT_BE_IN_THE_FUTURE50001108Start date cannot be in the future