Skip to content

Pagination reports API

If you suppose that the requested report might contain a large number of transactions, use the pagination report API.

Request

Send the report request with the additional X-Api-Version: 3 request header and the following parameters:

required
object
A section of report parameters.
date_type
required
string
A date type.

Possible values:
created_at,
paid_at,
settled_at.
from
required
string
A start date of the reporting period in the YYYY-MM-DD hh:mm:ss format, for example 2020-01-01 12:00:00.

For the settled_at date type, set the date in the YYYY-MM-DD format.
to
required
string
An end date of the reporting period in the YYYY-MM-DD hh:mm:ss format, for example 2020-01-01 15:00:00.

For the settled_at date type, set the date in the YYYY-MM-DD format.
status
required
string
A transaction status.

Possible values:
all,
successful,
failed,
pending,
incomplete.
payment_method_type
required
string
A payment method.

Possible values:
credit_card,
alternative.
time_zone
required
string
A timezone name as defined here, for example Europe/London
starting_after
string
Forward pagination parameter. Accepts value last_object_id from the response.
ending_before
string
Reverse pagination parameter. Accepts value first_object_id from the response.
manual_correction_from
string
A start date of the reporting period with manually edited transactions in the YYYY-MM-DD hh:mm:ss format, for example 2020-01-01 12:00:00.
manual_correction_to
string
An end date of the reporting period with manually edited transactions in the YYYY-MM-DD hh:mm:ss format, for example 2020-01-01 15:00:00.
Example of the request
{
  "report_params": {
      "date_type":"created_at",
      "from":"2020-09-11 00:00:00",
      "to":"2020-09-11 23:59:59",
      "status":"successful",
      "payment_method_type":"credit_card",
      "time_zone":"UTC"
  }
}
Response
required
array
An array of transactions for the requested report. The number of elements must be the same as in the count section. Each element represents a transaction entity with its own set of fields depending on the payment type and payment method used in this transaction.
object
A section of the customer's address details.
first_name
string
The customer's first name.
last_name
string
The customer's last name.
country
string
The customer's billing country in ISO 3166-1 Alpha-2 format.
city
string
The customer's billing city.
state
string
The customer's billing state.
zip
string
The customer's billing ZIP or postal code. If country=US, zip format must be NNNNN or NNNNN-NNNN.
address
string
The customer's billing address.
phone
string
The customer's phone number.
birth_date
string
The customer's date of birth in ISO 8601 format YYYY-MM-DD.
object
A section of the customer information.
ip
string
The customer's IP address.
email
string
The customer's email.
object
gateway_id
integer
Gateway ID in the PayCross system.
auth_code
string
An authorization code provided by the acquirer.
bank_code
string
A transaction bank code.
rrn
string
A retrieval reference number. A transaction ID issued by the card processing service.
ref_id
string
A transaction reference ID provided by the acquirer.
message
string
A processing result message provided by the acquirer.
billing_descriptor
string
A billing descriptor assigned to the transaction.
status
string
A status of the processed transaction in the acquiring bank.
object
brand
string
The detected card brand.
product
string
A card product type code.
last_4
string
The last 4 digits of the card.
first_1
string
The first digit of the card.
exp_month
integer (2)
Card expiration month.
exp_year
integer (4)
Card expiration year.
bin
string (6)
6-digit bank identification number (BIN). The first 6 digits of the card number.
bin_8
string (8)
8-digit bank identification number (BIN). The first 8 digits of the card number. The value is returned for Visa, MasterCard, Maestro cards and the corresponding co-branded cards. Otherwise, null is returned.
issuer_country
string (2)
The country of the card issuing bank in ISO 3166-1 Alpha-2 format.
issuer_name
string
The name of the card issuing bank.
token
string
The card token.
object
id
integer
The identifier of the shop in the PayCross system.
uid
string
A UID of the processed transaction.
id
integer
The transaction identifier in the PayCross. This value is used for pagination.
payment_method_type
string
A payment method type used to make the transaction.
status
string
A status of the processed transaction.
message
string
Message with the transaction processing result.
gateway_note
string
The value of the Gateway note field in the gateway settings in PayCross system.
amount
bigInteger
A transaction amount in minimal currency units.
discount_rate
float
Transaction fee, in %.
transaction_rate
float
Fixed transaction fee in the transaction currency, in base currency units.
transaction_fee
float
Total amount of transaction fees, in base currency units.
pay_to_merchant
float
Amount to be paid to the merchant (after deducting acquirer, PayCross commissions, and security deposits) in minimal currency units.
test
boolean
If true, the transaction was a test one.
currency
string
Currency in ISO-4217 format.
description
string
The short description of the order.
tracking_id
string
The identifier of the transaction in the merchant's system.
type
string
A transaction type.
order_id
integer
An identifier of an order related to a transaction. The payment and the corresponding refund transaction will have the same order_id. The authorization and the corresponding capture and void transactions will also have the same order_id.
created_at
string
A time when the transaction was created at in the ISO 8601 format YYYY-MM-DDThh:mm:ss.SSSZ.
paid_at
string
A time when the transaction was successfully completed at in the ISO 8601 format YYYY-MM-DDThh:mm:ss.SSSZ. Set to null if the transaction is incomplete.
settled_at
string
A time when the acquiring bank settled the transaction amount to the merchant's current account in the ISO 8601 format YYYY-MM-DDThh:mm:ss.SSSZ. Set to null if the parameter is not applicable to the transaction.
manually_corrected_at
string
A time when the transaction was manually updated at in the ISO 8601 format YYYY-MM-DDThh:mm:ss.SSSZ. Set to null if the parameter is not applicable to the transaction.
object
A section with 3-D Secure verification results.
eci
string or integer
Electronic Commerce Indicator. Provides information regarding merchant protection level against chargebacks requests by the cardholders or their banks.
pa_status
string
Status of payment authentication in the 3-D Secure protocol.
xid
string
Unique 3-D Secure authentication identifier.
cavv
string
Cardholder Authentication Verification Value (present only if the cardholder has been successfully authenticated).
cavv_algorithm
string
CAVV algorithm used for generating CAVV.
ve_status
string
Verification Enrollment Status which indicates whether the cardholder’s account is enrolled in the 3-D Secure program.
message
string
Message about 3-D Secure authentication status.
status
string
3-D Secure authentication status.
object
A section of detailed information about the transaction.
contract
array
The value used in the request. Possible values: recurring, card_on_file, oneclick, credit.
object
Section of customer browser parameters. Used only for 3DS 2.0.
accept_header
string
Value of Accept request HTTP header sent by the customer's browser.
screen_width
integer
Screen width in pixels. Equals the screen.width parameter in JavaScript.
screen_height
integer
Screen height in pixels. Equals the screen.height parameter in JavaScript.
screen_color_depth
integer
Screen color depth in bits per pixel. Equals the screen.colorDepth parameter in JavaScript. Applicable values are:

1 - 1 bit
4 - 4 bits
8 - 8 bits
15 - 15 bits
16 - 16 bits
24 - 24 bits
32 - 32 bits
48 - 48 bits.
window_width
integer
Browser window width in pixels. Equals the document.body.clientWidth parameter in JavaScript.
window_height
integer
Browser window height in pixels. Equals the document.body.clientHeight parameter in JavaScript.
language
string
Language of the navigator. Equals the navigator.language parameter in JavaScript.
java_enabled
boolean
Indicates if the browser is Java-enabled or not. Equals the navigator.javaEnabled() parameter in JavaScript.
user_agent
string
User agent string for the browser. Equals the navigator.userAgent parameter in JavaScript.
time_zone
integer
Time zone difference, in minutes, from the current locale (host system settings) to UTC. Equals the new Date().getTimezoneOffset() parameter in JavaScript.
challenge_window_size
integer
Recommended value for the 3-D Secure check window. Calculated using the values of window_width and window_height parameters. Possible values: 1, 2, 3, 4, 5.
time_zone_name
string
Time zone name. Equals the Intl.DateTimeFormat().resolvedOptions().timeZone parameter in JavaScript.
object
A section with 3-D Secure verification results.
status
string
3-D Secure authentication status.
message
string
Message about 3-D Secure authentication status.
ve_status
string
Verification Enrollment Status which indicates whether the cardholder’s account is enrolled in the 3-D Secure program.
acs_url
string
URL to the Access Control Server form (ACS form) in the card issuer's system to which the customer is redirected to complete 3-D Secure authentication.
pa_req
string
Payer Authentication Request, encoded.
md
string
Unique transaction identifier, used to link the merchant's server and the issuing bank's server.
pa_res_url
string
URL where the issuing bank’s server sends a response to the payment authentication request.
eci
string or integer
Electronic Commerce Indicator. Provides information regarding merchant protection level against chargebacks requests by the cardholders or their banks.
pa_status
string
Status of payment authentication in the 3-D Secure protocol.
xid
string
Unique 3-D Secure authentication identifier.
cavv
string
Cardholder Authentication Verification Value (present only if the cardholder has been successfully authenticated).
cavv_algorithm
string
CAVV algorithm used for generating CAVV.
fail_reason
string
Unencrypted message indicating the reason for 3-D Secure authentication failure.
method_process_url
string
URL for additional check based on the browser data.
creq
string
3-D Secure authentication request, encoded.
object
A section of AVS/CVC verification check.
object
A section of AVS verification check.
result_code
string
The code of AVS verification results.
object
A section of CVC verification check.
result_code
string
The code of CVC verification results.
object
A section of parameters of Smart Routing verification results.
status
string
Smart Routing check status for the transaction.
count
required
integer
A total number of transactions in the requested report.
has_more
required
boolean
true - indicates that there are more transactions which meet the request parameters, but are not included in the response.
false - indicated that all transactions which meet the request parameters are included in the response.
first_object_id
required
string
An ID of the first object returned in the response.
last_object_id
required
string
An ID of the last object returned in the response.
Example of the successful response
{
    "transactions": [
        {
            "billing_address": {
                "first_name": null,
                "last_name": null,
                "address": null,
                "country": null,
                "city": null,
                "zip": null,
                "state": null,
                "phone": null,
                "birth_date": null
            },
            "customer": {
                "ip": "127.0.0.1",
                "email": null
            },
            "payment": {
                "gateway_id": 312,
                "ref_id": null,
                "message": null,
                "status": "incomplete",
                "gateway_name": "Demo",
                "auth_code": null,
                "bank_code": null,
                "rrn": null,
                "billing_descriptor": null
            },
            "credit_card": {
                "holder": "JJJJ",
                "token": "544ffa4a-d16f-4ebb-b390-d997c29858c9",
                "brand": null,
                "last_4": "0000",
                "first_1": "4",
                "bin": "420000",
                "issuer_country": "IT",
                "issuer_name": "INVESTBANK",
                "exp_month": 12,
                "exp_year": 2027,
                "product": "VISA"
            },
            "shop": {
                "id": 1
            },
            "gateway_note": "",
            "uid": "20528-f87e29fa35",
            "id": 28860,
            "payment_method_type": "credit_card",
            "status": "incomplete",
            "message": null,
            "amount": 1000,
            "discount_rate": 0.0,
            "transaction_rate": 0.0,
            "pay_to_merchant": 0.0,
            "transaction_fee": 0.0,
            "test": false,
            "currency": "USD",
            "description": "Test description",
            "tracking_id": null,
            "type": "payment",
            "order_id": 27724,
            "created_at": "2022-01-27T14:07:00Z",
            "paid_at": null,
            "settled_at": null,
            "manually_corrected_at": null,
            "additional_data": {
                "request_id": "cb8ada4d-59cb-49c5-b6c5-3e679dd2c7c7",
                "browser": {
                    "screen_width": 1440,
                    "screen_height": 900,
                    "screen_color_depth": 24,
                    "language": "it",
                    "java_enabled": false,
                    "user_agent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36",
                    "time_zone": -180,
                    "time_zone_name": "Europe/London",
                    "window_height": 666,
                    "window_width": 600,
                    "accept_header": "application/json"
                },
                "vendor": {
                    "name": "CTP",
                    "token": "18b3e6fe3d08edf84bb2fe60c9077c8b898a5bd58f7dc27cd2b286b6b10197d2"
                },
                "tdsecure": {
                    "status": "incomplete",
                    "message": "Authentication Available",
                    "ve_status": "Y",
                    "acs_url": "https://test.pc.com:8443/pareq/15524/003ec8b2-4bef-4036-84ba-f27721c99d86/",
                    "pa_req": "eJxVUtFy2jAQ/BVP3vFJslMwc9GMiRtCZkIpMCXpm7APYxJsIpsW/31PgJtWT7ennb3blXC5tUTJgtKjJY3PVNcmJ6/I7m5e5w8v4U8lF7civp/0B+OXZHajcRbP6UPjL7J1UZVa+sJXCB1kBZtuTdloNOnHaDLVkZQqihCuEPdkJ4mOuoNwaWBp9qTXdDBF5q9bhDPGtDqWjW01iyB0AI/2XW+b5lAPAXZ1r25MXpS5v6bcNPTbtH5a7QHB0RA+N5odXVWz7KnI9OrH03iVzM3z7mE5XY5G38Vb8O1rxrbjOwTHwIzltBJKCan6ngyHoj8UXxDOfTR7t4+WwhfCG71O2eOlgwc3KO6uhUD4t4OctaUybXUUBOyqQ0inQ1USM9jr3xozqlMd9JKFt6ms19iTp8StGvQ2gz6paGOCkBdyHIRPg/eP7gHShpOVQoYseEVuSMEZqtAlegUIjg/Xp+XEzr+Aq/9+xx/mJ7T7",
                    "md": "42877",
                    "pa_res_url": "https://gateway.pay-cross.com/process/20528-f87e29fa35",
                    "eci": null,
                    "pa_status": null,
                    "xid": null,
                    "cavv": null,
                    "cavv_algorithm": null,
                    "fail_reason": null,
                    "method_process_url": null
                },
                "avs_cvc": {
                    "avs_verification": {
                        "result_code": null
                    },
                    "cvc_verification": {
                        "result_code": null
                    }
                }
            },
            "three_d_secure_verification": {
                "eci": null,
                "pa_status": null,
                "xid": null,
                "cavv": null,
                "cavv_algorithm": null,
                "ve_status": "Y",
                "message": "Authentication Available",
                "status": "incomplete"
            }
        },
        {
            "billing_address": {
                "first_name": null,
                "last_name": null,
                "address": null,
                "country": null,
                "city": null,
                "zip": null,
                "state": null,
                "phone": null,
                "birth_date": null
            },
            "customer": {
                "ip": "79.98.55.24",
                "email": null
            },
            "payment": {
                "gateway_id": 312,
                "ref_id": null,
                "message": null,
                "status": "incomplete",
                "gateway_name": "Demo",
                "auth_code": null,
                "bank_code": null,
                "rrn": null,
                "billing_descriptor": null
            },
            "credit_card": {
                "holder": "John Doe",
                "token": "3379480e-4c10-4dbd-83a3-7a14d16baf1f",
                "brand": null,
                "last_4": "0007",
                "first_1": "4",
                "bin": "420000",
                "issuer_country": "IT",
                "issuer_name": "INVESTBANK",
                "exp_month": 1,
                "exp_year": 2027,
                "product": "VISA"
            },
            "shop": {
                "id": 1
            },
            "gateway_note": "",
            "uid": "20529-66a8451797",
            "id": 28861,
            "payment_method_type": "credit_card",
            "status": "incomplete",
            "message": null,
            "amount": 1000,
            "discount_rate": 0.0,
            "transaction_rate": 0.0,
            "pay_to_merchant": 0.0,
            "transaction_fee": 0.0,
            "test": false,
            "currency": "USD",
            "description": "Test description",
            "tracking_id": null,
            "type": "payment",
            "order_id": 27725,
            "created_at": "2022-01-27T14:11:53Z",
            "paid_at": null,
            "settled_at": null,
            "manually_corrected_at": null,
            "additional_data": {
                "request_id": "9e97e8ad-54e6-487f-9bc0-eae0b497f73f",
                "browser": {
                    "screen_width": 1920,
                    "screen_height": 1080,
                    "screen_color_depth": 24,
                    "language": "it",
                    "java_enabled": false,
                    "user_agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:89.0) Gecko/20100101 Firefox/89.0",
                    "time_zone": -180,
                    "time_zone_name": "Europe/London",
                    "window_height": 666,
                    "window_width": 600,
                    "accept_header": "application/json"
                },
                "vendor": {
                    "name": "CTP",
                    "token": "179a4105e3f25b2c0ec3e6daf6135629f2fc4caf66667346ae5aeb776c958b4b"
                },
                "tdsecure": {
                    "status": "incomplete",
                    "message": "Authentication Available",
                    "ve_status": "Y",
                    "acs_url": "https://test.pc.com:8443/pareq/15525/a52d019a-440b-450a-b72c-67b24f02a56c/",
                    "pa_req": "eJxVUl1v4jAQ/CtR34k/AvSCFkvQqOpHgiCQVjwaZy+kVxJwQpv8+7MDoXd+mlmPZnfHhs1eIwZrVGeNAiKsKpmhk6fTu1X4kizDx9l8FUY8jrdeuA3uBCxnMZ4EfKGu8rIQzKUuB9JT46DVXha1AKlO8+eF8Bnjvg/kSuGA+jkQfn+AXApQyAOKHR5lnrq7FkjHQZXnotatMCZAegJn/Sn2dX2sJoR8VIOqllleZO4OM1njt2xdVR4IECsD8jPR8mxRZWybPBVJ0ry+vc2j+M/jg8GL6PNl/b5ZRO/JagrEKiA1doJTzinj9w4bThibjDwgXR3kwc4jGHUpdebbhdnxUoGjbTTrrykF8m8FTNYaC9UK3zNmNwbYHMsCjcLsesOQYqWENwjWzu9SO7VuHE5H3B+Mx/LXcMTu/bEZyGqA/Cz48GQfQNUmWUbZ0BhemW2SmwztTl0XS4BYPbk+rUms+wUG/fc7/gJV8bWH",
                    "md": "42878",
                    "pa_res_url": "https://gateway.pay-cross.com/process/20529-66a8451797",
                    "eci": null,
                    "pa_status": null,
                    "xid": null,
                    "cavv": null,
                    "cavv_algorithm": null,
                    "fail_reason": null,
                    "method_process_url": null
                },
                "avs_cvc": {
                    "avs_verification": {
                        "result_code": null
                    },
                    "cvc_verification": {
                        "result_code": null
                    }
                }
            },
            "three_d_secure_verification": {
                "eci": null,
                "pa_status": null,
                "xid": null,
                "cavv": null,
                "cavv_algorithm": null,
                "ve_status": "Y",
                "message": "Authentication Available",
                "status": "incomplete"
            }
        }
    ],
    "count": 2,
    "has_more": false,
    "first_object_id": 28860,
    "last_object_id": 28861
}

Pagination

If the has_more response parameter value is set to true, there are more transactions that meet the request parameters, but are not included in the response. Use forward and reverse pagination to get a report on all the transactions.

For the forward pagination, send another report request with the same parameters, but add the starting_after parameter and set its value to last_object_id from the response.

For the reverse pagination, send another report request with the same parameters, but add the ending_before parameter and set its value to first_object_id from the response.