3.33. /services/transaction-report

Introduction

Remote transactions report provide an opportunity to get complete information about transactions with their statuses for verification and further analysis.

Remote transactions report is initiated through HTTPS GET request by using URLs and the parameters specified below. Use HMAC-SHA1 for authentication.

API URLs

Integration

Production

https://sandbox.connpay.com/paynet-ui/services/transaction-report

https://gate.connpay.com/paynet-ui/services/transaction-report

Request Parameters

Parameter Name

Mandatory

Description

createdFromDate

Yes

Filters transactions on creation date. Must be in the following format: YYYY-MM-DD HH:MM:SS.

createdToDate

Yes

Filters transactions on creation date. Must be in the following format: YYYY-MM-DD HH:MM:SS.

bankFromDate

No

Filters transactions on date when transaction was uploaded to bank. Must be in the following format: YYYY-MM-DD HH:MM:SS.

bankToDate

No

Filters transactions on date when transaction was uploaded to bank. Must be in the following format: YYYY-MM-DD HH:MM:SS.

transactionTypes

No

Comma-separated list of transaction types to return. If this parameter is omitted, transactions of all types. Following types are recognized: sale, reversal, preauth, capture, cancel, fraud, chargeback, retrieval, dispute, refund.

transactionStatuses

No

Comma-separated list of transaction statuses to return. If this parameter is omitted, transactions in all statuses are returned. Following statuses are recognized: approved, declined, filtered.

endpoints

No

Comma-separated list of endpoint IDs to which returned transactions must belong. If this parameter is omitted, transactions belonging to any endpoint of Connecting Party who makes a request are returned.

Note

There are some restrictions:
* If endpoints parameter is specified and some endpoints in the list do not belong to the Connecting Party who makes a request, or some endpoints from the list do not exist, an error message is returned.
* Period specified by createdFromDate and createdToDate parameters must not exceed 31 days in length.
* Cannot make more than 10 requests per hour to this report.

Response Parameters

Note

The returned report has wellformed CSV format. In accordance with RFC 4180, fields containing line breaks (CRLF, CR, LF), double quotes, and commas are enclosed in double-quotes.

Parameter Name

Description

Value

Txid

Transaction ID in ConnPay, also referred as Order ID.
Type: Int
Length: 10

Created Date

Creation date in the server timezone.
Type: Datetime
Length: -

Created Date (no time)

Creation date in the server timezone, no time.
Type: Datetime
Length: -

Bank Date

Creation date in bank.
Type: Datetime
Length: -

Merchant

Connecting Party’s name.
Type: Varchar
Length: 128

End-Point ID

Endpoint ID.
Type: Int
Length: 10

Project ID

Connecting Party’s project ID.
Type: Int
Length: 10

Project name

Name of the project.
Type: Varchar
Length: 128

Currency

Transaction currency.
Type: Varchar
Length: 3

Site URL

Domain name of the site.
Type: Varchar
Length: 100

Card type

Card type of international payment systems.
Type: Varchar
Length: 32

Ip

IP address.
Type: Varchar
Length: 128

Type

Transaction type.
Type: Varchar
Length: 32

Status

Transaction status.
Type: Varchar
Length: 32

Error Number

Error code.
Type: Int
Length: 10

Error Description

Error Description.
Type: Varchar
Length: 256

Reason code

Reason code (if information is available).
Type: Varchar
Length: 16

Reason

Reason (if information is available).
Type: Varchar
Length: 256

Comment

Comment (if information is available).
Type: Varchar
Length: 256

Amount

Transaction amount.
Type: Decimal
Length: 15,3

Processor ID

Processor / acquirer transaction identification number.
Type: Varchar
Length: 128

Card No

Masked PAN.
Type: Varchar
Length: 20

Name

Card holder name.
Type: Varchar
Length: 128

Routing Number

Routing step ID.
Type: Varchar
Length: 16

Account Number

Connecting Party’s balance identification number.
Type: Varchar
Length: 24

Email

Customer email.
Type: Varchar
Length: 128

Phone

Customer phone number.
Type: Varchar
Length: 128

Address

Address passed by API.
Type: Varchar
Length: 256

Zip

Zip passed by API.
Type: Varchar
Length: 32

City

City passed by API.
Type: Varchar
Length: 128

State

State passed by API.
Type: Varchar
Length: 128

Country

Country passed by API.
Type: Varchar
Length: 128

First name

Customer first name. For transfer transactions: sender first name (if sent), or receiver first name.
Type: Varchar
Length: 128

Last name

Customer last name. For transfer transactions: sender last name (if sent), or receiver last name.
Type: Varchar
Length: 128

Order Description

Payment description passed by API.
Type: Varchar
Length: 256

Merchant OID

ID of transaction on Connecting Party’s side.
Type: Varchar
Length: 256

Auxiliary transaction merchant OID

ID of master transaction in Merchant order ID field, if there are no master transactions, it will be the same as Merchant OID field.
Type: Varchar
Length: 256

Reversal Amount

Refund amount.
Type: Decimal
Length: 15,3

Capture Amount

Transaction confirmation amount after DMS authorization.
Type: Decimal
Length: 15,3

Approval Code

Authorization code.
Type: Varchar
Length: 10

Auth credit code

Auth Credit Code is indicated as auth code when performing AFT and when performing OCT.
Type: Varchar
Length: 10

Auth verification value

Cardholder authentication check values. Indicated only after payment for the order and in case of appropriate permission.
Type: Varchar
Length: 64

Transaction XID

Electronic commercial transaction identifier. Indicated only after payment for the order and in case of appropriate permission.
Type: Varchar
Length: 64

Transaction RRN

RRN - Retrieval Reference Number.
Type: Varchar
Length: 20

Transaction ARN

ARN - Acquirers Reference Number.
Type: Varchar
Length: 64

Card MPI status

A separate tool for checking card participation in 3-D Secure, may be Y / N.
Type: Varchar
Length: 3

Electronic Commerce Indicator

ECI.
Type: Varchar
Length: 3

Is 3DS

A tool for checking if transaction is 3DS-validated, may be True / False.
Type: Varchar
Length: 3

Is enrolled

A tool for checking if transaction is enrolled, may be True / False.
Type: Varchar
Length: 3

Support doc Cb Reason Code

These fields are related to dispute management.
Type: Varchar
Length: 256

Support doc Cb Reason Name

These fields are related to dispute management.
Type: Varchar
Length: 256

Described Services/Merchandise

These fields are related to dispute management.
Type: Varchar
Length: 256

What is not as described

Dispute details.
Type: Varchar
Length: 256

Merchant Response

These fields are related to dispute management.
Type: Text
Length: -

Tried to Resolve with Merchant

These fields are related to dispute management.
Type: Varchar
Length: 256

Last Contact Date

These fields are related to dispute management.
Type: Varchar
Length: 256

Contact Name

These fields are related to dispute management.
Type: Varchar
Length: 256

Contact Method

These fields are related to dispute management.
Type: Varchar
Length: 256

Cb Comments

These fields are related to dispute management.
Type: Text
Length: -

Cb Documents

These fields are related to dispute management.
Type: Text
Length: -

Cb Additional Files

These fields are related to dispute management.
Type: Text
Length: -

Gate ID

Gate ID.
Type: Int
Length: 10

Gate Name

Gate Name.
Type: Varchar
Length: 128

Gate descriptor

Descriptor specified on the gate.
Type: Varchar
Length: 128

Gate method

Gate properties.
Type: Varchar
Length: 255

Gate method 2

Gate properties.
Type: Varchar
Length: 255

Gate business type

Gate properties.
Type: Varchar
Length: 256

Gate MID

Gate MID.
Type: Varchar
Length: 256

View Receipt URL

Parameter responsible for displaying the URL of the receipt.
Type: Varchar
Length: 100

Destination

The parameter passed to the Purpose field.
Type: Varchar
Length: 128

Client commission

Total transaction fee.
Type: Decimal
Length: 15,3

Destination Card No

6 + 4 of destination card.
Type: Varchar
Length: 20

Destination bank

Destination card issuer.
Type: Varchar
Length: 128

Bank name

Issuer of source card.
Type: Varchar
Length: 128

DAPI IMEI

Custom string provided by Connecting Party in initial request, also used as unique device 32 symbol string identifier in DAPI.
Type: Varchar
Length: 32

BIN country code

ISO 3166-1 alpha-2 country code of source card issuer (determined by BIN).
Type: Varchar
Length: 3

BIN country

Country name of source card issuer (determined by BIN).
Type: Varchar
Length: 128

Destination BIN country code

ISO 3166-1 alpha-2 country code of destination card issuer (determined by BIN).
Type: Varchar
Length: 3

Destination BIN country name

Country name of destination card issuer (determined by BIN).
Type: Varchar
Length: 128

Processor

Processor Name.
Type: Varchar
Length: 128

Processor ID

Processor ID.
Type: Int
Length: 10

Processor Error Code

Processor Error Code.
Type: Int
Length: 10

CardRefId

Card reference ID obtained at Card Registration Stage.
Type: Int
Length: 10

Initial tx bank date (Server TZ)

Date received from Bank on Server time zone.
Type: Datetime
Length: -

Initial tx bank date (User TZ)

Date received from Bank on Connecting Party zone.
Type: Datetime
Length: -

Initial tx Amount

The amount received from Connecting Party.
Type: Decimal
Length: 15,3

External merchant identifier

External merchant identifier.
Type: Varchar
Length: 128

Manager rate plan

Manager rate plan name.
Type: Varchar
Length: 128

Bank name attr

Bank name.
Type: Varchar
Length: 128

Bank branch

Bank branch name.
Type: Varchar
Length: 128

Account name

Bank account name.
Type: Varchar
Length: 128

Status change date

Date of status change.
Type: Datetime
Length: -

Manager rate plan id

Manager rate plan id.
Type: Int
Length: 10

Currency for processing

Currency used for transaction.
Type: Varchar
Length: 3

Amount in currency for processing

Amount in currency used for transaction.
Type: Decimal
Length: 15,3

Capture amount in currency for processing

Capture amount in currency used for transaction.
Type: Decimal
Length: 15,3

Reversal amount in currency for processing

Reversal amount in currency used for transaction.
Type: Decimal
Length: 15,3

Currency rate for processing

Currency rate used for transaction.
Type: Decimal
Length: 15,3

Provider currency rate

Name of rate provider for conversion.
Type: Decimal
Length: 15,3

Fee in currency for processing

Fee in currency used for transaction.
Type: Decimal
Length: 15,3

Transaction ID

Internal ID in ConnPay which helps to distinguish several processing attempts within one transaction (Txid).
Type: Varchar
Length: 128

Reseller commission

Reseller transaction fee.
Type: Decimal
Length: 15,3

Manager commission

Manager transaction fee.
Type: Decimal
Length: 15,3

Dealer commission

Dealer transaction fee.
Type: Decimal
Length: 15,3

Processor commission

Processor transaction fee.
Type: Decimal
Length: 15,3

Card expiration date

Expiration date for source card.
Type: Varchar
Length: 10

Destination card expiration date

Expiration date for destination card.
Type: Varchar
Length: 10

Last routing type

Last routing type used in balancing for this transaction.
Type: Varchar
Length: 128

Last routing value

Last routing value used in balancing for this transaction.
Type: Varchar
Length: 128

IPs region

Region of Connecting Party relative to card BIN region. For MasterCard possible values are: Domestic, European (EEA), European (SEPA NON EEA), European (NON SEPA NON EEA), Interregional (Inter-European), Interregional. For Visa possible values are: Domestic, European (EEA), European (Non-EEA GB, GI), European (Non-EEA CH), European (Non-EEA AD, MC, SM, VA), Interregional (Non-EEA IL, TR), Interregional. If BIN country cannot be determined, processor region value will be: Unknown.
Type: Varchar
Length: 128

Processor region

Card BIN region. Possible values are: EU, NON EU. If BIN country cannot be determined, processor region value will be: Unknown.
Type: Varchar
Length: 128

Manager ID

Manager ID.
Type: Int
Length: 10

Manager name

Manager name.
Type: Varchar
Length: 128

Creation time

Transaction creation time in the system.
Type: Datetime
Length: -

Customer level

Customer level in CMS.
Type: Varchar
Length: 128

Customer IP address country

Customer country identified by IP.
Type: Varchar
Length: 2
For Faster Payments System (СБП) integration

Parameter Name

Description

Value

SBP Source Account Number

Sender’s bank account
Type: Varchar
Length: 24

SBP Source Phone

Sender’s phone
Type: Varchar
Length: 128

SBP Source Bank ID

Sender’s bank ID in the NSPK
Type: Varchar
Length: 128

SBP Source Name

Sender’s full name
Type: Varchar
Length: 128

SBP Source Address

Sender’s address
Type: Varchar
Length: 256

SBP Destination Phone

Receiver’s phone
Type: Varchar
Length: 128

SBP Destination Bank ID

Receiver’s bank ID
Type: Varchar
Length: 128

SBP Destination Account Number

Receiver’s bank account
Type: Varchar
Length: 24

SBP Destination Name

Receiver’s full name
Type: Varchar
Length: 128

SBP Destination Address

Receiver’s address
Type: Varchar
Length: 256

SBP Reversal Phone

Receiver’s phone
Type: Varchar
Length: 128

SBP Reversal Bank ID

Receiver’s bank ID
Type: Varchar
Length: 128

SBP Reversal Account Number

Receiver’s bank account
Type: Varchar
Length: 24

SBP Reversal Name

Receiver’s full name
Type: Varchar
Length: 128

SBP Reversal Address

Receiver’s address
Type: Varchar
Length: 256

Note

The order of parameters in transaction report might change in future releases. New parameters might be added. Please implement response handling based on parameters names, not parameters order.

Request Example

GET /paynet-ui/services/transaction-report?createdFromDate=2023-01-01%2000%3A00%3A00&createdToDate=2023-02-30%2000%3A00%3A00&oauth_consumer_key=logic&oauth_nonce=3gbXZFl3uAn&oauth_signature_method=HMAC-SHA1&oauth_timestamp=1690546956&oauth_version=1.0 HTTP/1.1
Host: sandbox.doc2.com
User-Agent: curl/7.88.1
Accept: */*
Authorization: OAuth realm="",oauth_version="1.0",oauth_consumer_key="logic",oauth_timestamp="1690546956",oauth_nonce="3gbXZFl3uAn",oauth_signature_method="HMAC-SHA1",oauth_signature="G46r4h99dwB9opEYSfUsgHlJeGg%3D"
Connection: close

Success Response Example

Txid;Created Date (Server TZ);Created Date (User TZ);Created Date (Server TZ, no time);Bank Date (Server TZ);Bank Date (User TZ);Merchant;End-Point ID;Project ID;Project Name;Currency;Site URL;Card type;Ip;Type;Status;Error Number;Error Description;Reason code;Reason;Comment;Amount;Processor tx ID;Card No;Name;Routing Number;Account Number;Email;Phone;Address;Zip;City;State;Country;First Name;Last Name;Order Description;Merchant OID;Auxiliary transaction merchant OID;Reversal Amount;Capture amount;Approval Code;Auth Credit Code;Auth Verification Value;Transaction XID;Transaction RRN;Transaction ARN;Card MPI Status;Electronic Commerce Indicator;Is 3D;Is Enrolled;Support doc Cb reason code;Support doc Cb reason;Described services/merchandise;What is not as described;Merchant response;Tried to resolve with merchant;Last contact date;Contact name;Contact method;Cb Comments;Cb Documents;Cb additional files;Gate ID;Gate Name;Gate Descriptor;Gate Method;Gate Method 2;Gate Business type;Gate MID;View Receipt URL;Destination;Client commission;Destination Card No;Destination bank name;Bank name;DAPI IMEI;BIN country code;BIN country;Destination BIN country code;Destination BIN country;Processor;Processor Error Code;CardRefId;Initial tx bank date (Server TZ);Initial tx bank date (User TZ);Initial tx Amount;External merchant identifier;Manager rate plan;Bank name attr;Bank branch;Account name;Status change date;Manager rate plan id;Currency for processing;Amount in currency for processing;Capture amount in currency for processing;Reversal amount in currency for processing;Currency rate for processing;Provider currency rate;Fee in currency for processing;Transaction id;Reseller commission;Manager commission;Dealer commission;Processor commission;Card expiration date;Destination card expirationDate;Last routing type;Last routing value;IPs region;Processor region;Manager ID;Manager name;Creation time;Customer level
1810032;2023-05-01T17:38:43.00;2023-05-01T17:38:43.00;01.05.2023;;;Demo merchant A;7829;2251;Test Rub Project;RUB;;MasterCard;85.132.102.1;sale;filtered;10137;Billing country blacklisted for merchant;;;;100.000;;555544XXXXXX1111;TEST HOLDER;;;j***b@brown.demo;8***01122;Red*** 1;***;***;;RUS;Jacob;Brown;Test payment;ylT2sut-hqXHxTFspRVUd9Uvcsg;ylT2sut-hqXHxTFspRVUd9Uvcsg;;;;;;;;;;;No;;;;;;;;;;;;;;3197;Test RUB;DEMO2;;;;;https://sandbox.connpay.com/paynet/view-receipt/7829/b6123559-fc64-32fd-9c91-af49a92aa2b9;purpose?;0.000;;;NATIONAL BANK OF RAS AL-KHAIMAH (RAKBANK);;AE;United Arab Emirates;;;Test processor;;;2023-05-01T17:38:43.00;2023-05-01T17:38:43.00;100.000;;zrt;;;;2023-05-01T17:38:43.00;398;RUB;100.000;;;;;;1537212;0.000;0.000;0.000;0.000;203604;;route by Source Credit Card Issuer Country;OTHERS;Unknown;Unknown;76;test_manager;;
1812039;2023-05-04T19:11:29.00;2023-05-04T19:11:29.00;04.05.2023;;;Demo merchant A;6655;1712;Demo Ams EUR;EUR;;Visa;34.129.65.121;preauth;declined;1015;SECURE_3D_TIMEOUT;;;;5.000;;444455XXXXXX1111;TEST HOLDER;;;a***v@example.com;+3***12233;Wes***HX;***;Ams***en;;NLD;Firstname;Lastname;Test payment;902B4FF5;902B4FF5;;;;;;;3,1244E+11;;;;Yes;;;;;;;;;;;;;;2470;A VISA CC Ams EUR;DEMO1;;;;test1;https://sandbox.connpay.com/paynet/view-receipt/6655/a4b048ad-47ce-33ed-af73-68c7646cee0c;;0.000;;;UNKNOWN;;US;United States;;;Test processor;timeout;;2023-05-04T19:11:29.00;2023-05-04T19:11:29.00;5.000;;2% cyprus;;;;2023-05-04T19:11:29.00;582;USD;5.500;;;1.099663612901000;1.099663612901000;;1539210;0.000;0.000;0.000;0.000;202401;;route by Customer Loyalty;OTHERS;Unknown;Unknown;76;test_manager;;
1812040;2023-05-04T19:11:29.00;2023-05-04T19:11:29.00;04.05.2023;;;Demo merchant A;6655;1712;Demo Ams EUR;EUR;;Visa;34.129.65.121;preauth;declined;1015;SECURE_3D_TIMEOUT;;;;5.000;;444455XXXXXX1111;TEST HOLDER;;;a***v@example.com;+3***12233;Wes***HX;***;Ams***en;;NLD;Firstname;Lastname;Test payment;902B4FF5;902B4FF5;;;;;;;3,12424E+11;;;;Yes;;;;;;;;;;;;;;2470;A VISA CC Ams EUR;DEMO1;;;;test1;https://sandbox.connpay.com/paynet/view-receipt/6655/270932f6-6687-3127-a32a-2baa6eb1b3f6;;0.000;;;UNKNOWN;;US;United States;;;Test processor;timeout;;2023-05-04T19:11:29.00;2023-05-04T19:11:29.00;5.000;;2% cyprus;;;;2023-05-04T19:11:29.00;582;USD;5.500;;;1.099663612901000;1.099663612901000;;1539211;0.000;0.000;0.000;0.000;202401;;route by Customer Loyalty;OTHERS;Unknown;Unknown;76;test_manager;;
1812037;2023-05-04T19:11:30.00;2023-05-04T19:11:30.00;04.05.2023;;;Demo merchant A;6655;1712;Demo Ams EUR;EUR;;Visa;34.129.65.121;sale;declined;1015;SECURE_3D_TIMEOUT;;;;5.000;;444455XXXXXX1111;TEST HOLDER;;;a***v@example.com;+3***12233;Wes***HX;***;Ams***en;;NLD;Firstname;Lastname;Rebill order description;902B4FF5;902B4FF5;;;;;;;3,12425E+11;;;;Yes;;;;;;;;;;;;;;2470;A VISA CC Ams EUR;DEMO1;;;;test1;https://sandbox.connpay.com/paynet/view-receipt/6655/711a99be-e32f-3abe-9740-e4bda0c2d372;;0.000;;;UNKNOWN;;US;United States;;;Test processor;timeout;;2023-05-04T19:11:30.00;2023-05-04T19:11:30.00;5.000;;2% cyprus;;;;2023-05-04T19:11:30.00;582;USD;5.500;;;1.099663612901000;1.099663612901000;;1539212;0.000;0.000;0.000;0.000;202401;;route by Customer Loyalty;OTHERS;Unknown;Unknown;76;test_manager;;
1812038;2023-05-04T19:11:30.00;2023-05-04T19:11:30.00;04.05.2023;;;Demo merchant A;6655;1712;Demo Ams EUR;EUR;;Visa;34.129.65.121;sale;declined;1015;SECURE_3D_TIMEOUT;;;;5.000;;444455XXXXXX1111;TEST HOLDER;;;a***v@example.com;+3***12233;Wes***HX;***;Ams***en;;NLD;Firstname;Lastname;Rebill order description;902B4FF5;902B4FF5;;;;;;;3,12454E+11;;;;Yes;;;;;;;;;;;;;;2470;A VISA CC Ams EUR;DEMO1;;;;test1;https://sandbox.connpay.com/paynet/view-receipt/6655/52e5301a-55a7-3939-9f9c-6a0114e32c15;;0.000;;;UNKNOWN;;US;United States;;;Test processor;timeout;;2023-05-04T19:11:30.00;2023-05-04T19:11:30.00;5.000;;2% cyprus;;;;2023-05-04T19:11:30.00;582;USD;5.500;;;1.099663612901000;1.099663612901000;;1539213;0.000;0.000;0.000;0.000;202401;;route by Customer Loyalty;OTHERS;Unknown;Unknown;76;test_manager;;
1812041;2023-05-04T19:16:26.00;2023-05-04T19:16:26.00;04.05.2023;;;Demo merchant A;6655;1712;Demo Ams EUR;EUR;;Visa;65.153.12.213;sale;declined;1015;SECURE_3D_TIMEOUT;;;;10.420;;444455XXXXXX1111;TEST HOLDER;;;j***h@gmail.com;1***82043;Wes***HX;***;Ams***en;;NLD;Firstname;Lastname;Test Order Description;902B4FF5;902B4FF5;;;;;;;3,1243E+11;;;;Yes;;;;;;;;;;;;;;2470;A VISA CC Ams EUR;DEMO1;;;;test1;https://sandbox.connpay.com/paynet/view-receipt/6655/06636793-308d-33eb-8a21-77f92b00cd5d;;0.000;;;UNKNOWN;;US;United States;;;Test processor;timeout;190926;2023-05-04T19:16:26.00;2023-05-04T19:16:26.00;10.420;;2% cyprus;;;;2023-05-04T19:16:26.00;582;USD;11.460;;;1.099663612901000;1.099663612901000;;1539214;0.000;0.000;0.000;0.000;202401;;route by Customer Loyalty;OTHERS;Unknown;Unknown;76;test_manager;;
1812042;2023-05-04T19:16:26.00;2023-05-04T19:16:26.00;04.05.2023;;;Demo merchant A;6655;1712;Demo Ams EUR;EUR;;Visa;65.153.12.213;sale;declined;1015;SECURE_3D_TIMEOUT;;;;10.420;;444455XXXXXX1111;TEST HOLDER;;;j***h@gmail.com;1***82043;Wes***HX;***;Ams***en;;NLD;Firstname;Lastname;Test Order Description;902B4FF5;902B4FF5;;;;;;;3,12453E+11;;;;Yes;;;;;;;;;;;;;;2470;A VISA CC Ams EUR;DEMO1;;;;test1;https://sandbox.connpay.com/paynet/view-receipt/6655/d9a800f3-d915-3099-a769-01f9fcb7d356;;0.000;;;UNKNOWN;;US;United States;;;Test processor;timeout;;2023-05-04T19:16:26.00;2023-05-04T19:16:26.00;10.420;;2% cyprus;;;;2023-05-04T19:16:26.00;582;USD;11.460;;;1.099663612901000;1.099663612901000;;1539215;0.000;0.000;0.000;0.000;202401;;route by Customer Loyalty;OTHERS;Unknown;Unknown;76;test_manager;;
1812688;2023-05-05T17:18:52.00;2023-05-05T17:18:52.00;05.05.2023;;;Demo merchant A;6655;1712;Demo Ams EUR;EUR;;Visa;89.147.253.161;transfer;filtered;10204;Customer data validation failed (firstname, lastname, cardholder, email, phone);;;;10.420;;421070XXXXXX5721;John Doe;;;;;;;;;;;;Your order description;1;1;;;;;;;;;;;No;;;;;;;;;;;;;;2470;A VISA CC Ams EUR;DEMO1;;;;test1;https://sandbox.connpay.com/paynet/view-receipt/6655/402efad3-7e4a-3497-8bd4-792a11074f7f;;0.000;423261XXXXXX1636;JPMORGAN CHASE BANK N.A.;DEMIRBANK OJSC;;AZ;Azerbaijan;US;United States;Test processor;;190924;2023-05-05T17:18:52.00;2023-05-05T17:18:52.00;10.420;;2% cyprus;;;;2023-05-05T17:18:52.00;582;EUR;10.420;;;;;;1539816;0.000;0.000;0.000;0.000;209912;;route by Customer Loyalty;NEW FOR MERCHANT;Unknown;Unknown;76;test_manager;;
1817526;2023-05-16T16:15:13.00;2023-05-16T16:15:13.00;16.05.2023;;;Demo merchant A;6655;1712;Demo Ams EUR;EUR;;Visa;85.132.52.251;sale;approved;;;;;;100.000;PNTEST-1817526;444455XXXXXX1111;TEST HOLDER;;;a***v@example.com;+3***12233;Wes***HX;***;Ams***en;;NLD;Firstname;Lastname;Test payment;test;1817525;100.000;;504362;502894;;;3,1367E+11;179416949;;;Yes;;;;;;;;;;;;;;2470;A VISA CC Ams EUR;DEMO1;;;;test1;https://sandbox.connpay.com/paynet/view-receipt/6655/fdf7267b-876b-36b8-84a7-2fea7a3685e4;;2.200;;;UNKNOWN;;US;United States;;;Test processor;;;2023-05-16T16:15:13.00;2023-05-16T16:15:13.00;100.000;;2% cyprus;;;;2023-05-16T16:16:11.00;582;USD;108.740;;;1.087320537745000;1.087320537745000;;1544050;0.000;2.200;0.000;1.000;202701;;route by Customer Loyalty;OTHERS;Unknown;Unknown;76;test_manager;;
1817526;2023-05-16T16:15:16.00;2023-05-16T16:15:16.00;16.05.2023;;;Demo merchant A;6655;1712;Demo Ams EUR;EUR;;Visa;85.132.52.251;reversal;approved;;;;;Auto-return;100.000;1,68424E+12;444455XXXXXX1111;TEST HOLDER;;;a***v@example.com;+3***12233;Wes***HX;***;Ams***en;;NLD;Firstname;Lastname;Test payment;test;1817525;100.000;;504362;502894;;;3,13665E+11;179416949;;;Yes;;;;;;;;;;;;;;2470;A VISA CC Ams EUR;DEMO1;;;;test1;https://sandbox.connpay.com/paynet/view-receipt/6655/fdf7267b-876b-36b8-84a7-2fea7a3685e4;;0.000;;;UNKNOWN;;US;United States;;;Test processor;;;2023-05-16T16:15:13.00;2023-05-16T16:15:13.00;100.000;;2% cyprus;;;;2023-05-16T16:16:11.00;582;USD;108.740;;;1.087320537745000;1.087320537745000;;1544051;0.000;0.000;0.000;0.000;202701;;route by Customer Loyalty;OTHERS;Unknown;Unknown;76;test_manager;;
1817526;2023-05-16T16:16:11.00;2023-05-16T16:16:11.00;16.05.2023;2023-05-16T00:00:00.00;2023-05-16T00:00:00.00;Demo merchant A;6655;1712;Demo Ams EUR;EUR;;Visa;85.132.52.251;chargeback;approved;;;11,1;Card Recovery Bulletin;manual;100.000;1,68424E+12;444455XXXXXX1111;TEST HOLDER;;;a***v@example.com;+3***12233;Wes***HX;***;Ams***en;;NLD;Firstname;Lastname;Test payment;test;1817525;100.000;;504362;502894;;;3,13665E+11;179416949;;;Yes;;;;;;;;;;;;;;2470;A VISA CC Ams EUR;DEMO1;;;;test1;https://sandbox.connpay.com/paynet/view-receipt/6655/fdf7267b-876b-36b8-84a7-2fea7a3685e4;;0.000;;;UNKNOWN;;US;United States;;;Test processor;;;2023-05-16T16:15:13.00;2023-05-16T16:15:13.00;100.000;;2% cyprus;;;;2023-05-16T16:16:11.00;582;USD;108.740;;;1.087320537745000;1.087320537745000;;1544053;0.000;0.000;0.000;0.000;202701;;route by Customer Loyalty;OTHERS;Unknown;Unknown;76;test_manager;;
1817507;2023-05-16T16:17:24.00;2023-05-16T16:17:24.00;16.05.2023;;;Demo merchant A;9068;1712;Demo Ams EUR;EUR;;Any;85.132.52.251;sale;declined;920084;Request failed: Timer expired. User not paid. Request failed: Timer expired. User not paid.;;;;100.000;;999999XXXXXX9999;Unknown holder;;;a***v@example.com;+3***12233;Wes***HX;***;Ams***en;;NLD;Firstname;Lastname;Test payment;test;1817503;;;;;;;;;;;No;;;;;;;;;;;;;;4441;Test demo EUR;DEMO3;;;;;https://sandbox.connpay.com/paynet/view-receipt/9068/7f44aae1-10fe-3f05-8271-d94f539fdf6a;;0.000;;;;;;;;;Test processor;920084;;2023-05-16T16:17:24.00;2023-05-16T16:17:24.00;100.000;;2% cyprus;;;;2023-05-16T16:17:24.00;582;EUR;100.000;;;;;;1544054;0.000;0.000;0.000;0.000;202412;;route by Source Credit Card Type;ANY_CREDIT_CARD;Unknown;Unknown;76;test_manager;;
1817527;2023-05-16T16:28:20.00;2023-05-16T16:28:20.00;16.05.2023;;;Demo merchant A;9068;1712;Demo Ams EUR;EUR;;Any;85.132.52.251;sale;declined;920084;Request failed: Timer expired. User not paid. Request failed: Timer expired. User not paid.;;;;100.000;;999999XXXXXX9999;Unknown holder;;;a***v@example.com;+3***12233;Wes***HX;***;Ams***en;;NLD;Firstname;Lastname;Test payment;test;1817525;;;;;;;;;;;No;;;;;;;;;;;;;;4441;Test demo EUR;DEMO3;;;;;https://sandbox.connpay.com/paynet/view-receipt/9068/33e28fb1-6443-30a1-bac2-d5d1648e38cd;;0.000;;;;;;;;;Test processor;920084;;2023-05-16T16:28:20.00;2023-05-16T16:28:20.00;100.000;;2% cyprus;;;;2023-05-16T16:28:20.00;582;EUR;100.000;;;;;;1544078;0.000;0.000;0.000;0.000;202412;;route by Source Credit Card Type;ANY_CREDIT_CARD;Unknown;Unknown;76;test_manager;;
1824084;2023-05-26T14:44:38.00;2023-05-26T14:44:38.00;26.05.2023;;;Demo merchant A;6655;1712;Demo Ams EUR;EUR;;BANK WIRE;85.132.52.251;transfer;approved;;;;;;55.550;1,6851E+12;;Test full name;7812013775;4,096E+19;j***h@gmail.com;7***29876;;;;;;;;Test payment;inv9157586;inv9157586;;;829695;;;;;;;;No;;;;;;;;;;;;;;2471;B MC CC Ams EUR;AMSTERDAM;;;;;https://sandbox.connpay.com/paynet/view-receipt/6655/43b0c106-0f10-307a-99f8-b3df4823337d;;0.000;;;;;;;;;Test processor;;;2023-05-26T14:44:38.00;2023-05-26T14:44:38.00;55.550;;2% cyprus;;;;2023-05-26T14:44:38.00;582;USD;59.580;;;1.072435511772000;1.072435511772000;;1549073;0.000;0.000;0.000;0.000;0;;route by Purpose;OTHERS;Unknown;Unknown;76;test_manager;2023-05-26T14:44:12.00;
1824082;2023-05-26T15:31:23.00;2023-05-26T15:31:23.00;26.05.2023;;;Demo merchant A;6655;1712;Demo Ams EUR;EUR;;BANK WIRE;85.132.52.251;transfer;declined;1015;SECURE_3D_TIMEOUT;;;;55.550;;;Test ful name;7812013775;4,096E+19;j***h@gmail.com;7***29876;;;;;;;;Test payment;inv9157586;inv9157586;;;;;;;3,14622E+11;;;;Yes;;;;;;;;;;;;;;2471;B MC CC Ams EUR;AMSTERDAM;;;;;https://sandbox.connpay.com/paynet/view-receipt/6655/e5b22b51-c51a-37e3-be9c-3ea581ccf583;;0.000;;;;;;;;;Test processor;timeout;;2023-05-26T15:31:23.00;2023-05-26T15:31:23.00;55.550;;2% cyprus;;;;2023-05-26T15:31:23.00;582;USD;59.580;;;1.072435511772000;1.072435511772000;;1549088;0.000;0.000;0.000;0.000;0;;route by Purpose;OTHERS;Unknown;Unknown;76;test_manager;2023-05-26T14:42:49.00;
1824083;2023-05-26T15:31:23.00;2023-05-26T15:31:23.00;26.05.2023;;;Demo merchant A;6655;1712;Demo Ams EUR;EUR;;BANK WIRE;85.132.52.251;transfer;declined;1015;SECURE_3D_TIMEOUT;;;;500.000;;;Test;7812013775;4,096E+19;j***h@gmail.com;7***29876;;;;;;;;;34T43R77N;34T43R77N;;;;;;;3,14692E+11;;;;Yes;;;;;;;;;;;;;;2471;B MC CC Ams EUR;AMSTERDAM;;;;;https://sandbox.connpay.com/paynet/view-receipt/6655/b580d3c7-8ff1-3cb3-8292-87486edd18c0;;0.000;;;;;;;;;Test processor;timeout;;2023-05-26T15:31:23.00;2023-05-26T15:31:23.00;500.000;;2% cyprus;;;;2023-05-26T15:31:23.00;582;USD;536.220;;;1.072435511772000;1.072435511772000;;1549089;0.000;0.000;0.000;0.000;0;;route by Purpose;OTHERS;Unknown;Unknown;76;test_manager;2023-05-26T14:44:10.00;
1824985;2023-05-29T14:45:00.00;2023-05-29T14:45:00.00;29.05.2023;;;Demo merchant A;6655;1712;Demo Ams EUR;EUR;;Visa;188.253.224.81;sale;approved;;;;;;100.000;PNTEST-1824985;444455XXXXXX1111;TEST HOLDER;;;a***v@example.com;+3***12233;Wes***HX;***;Ams***en;;NLD;Firstname;Lastname;Test payment;test;1824984;;;115524;407275;;;3,1496E+11;647547344;;;Yes;;;;;;;;;;;;;;2470;A VISA CC Ams EUR;DEMO1;;;;test1;https://sandbox.connpay.com/paynet/view-receipt/6655/3317093d-b5b3-3d09-aa9b-28e1c80166d8;;2.200;;;UNKNOWN;;US;United States;;;Test processor;;;2023-05-29T14:45:00.00;2023-05-29T14:45:00.00;100.000;;2% cyprus;;;;2023-05-29T15:07:30.00;582;USD;107.320;;;1.072435511772000;1.072435511772000;;1550036;0.000;2.200;0.000;1.000;202701;;route by Customer Loyalty;OTHERS;Unknown;Unknown;76;test_manager;2023-05-29T14:40:11.00;
1824987;2023-05-29T14:56:48.00;2023-05-29T14:56:48.00;29.05.2023;;;Demo merchant A;9068;1712;Demo Ams EUR;EUR;;Any;188.253.224.81;sale;declined;920084;Request failed: Timer expired. User not paid. Request failed: Timer expired. User not paid.;;;;100.000;;999999XXXXXX9999;Unknown holder;;;a***v@example.com;+3***12233;Wes***HX;***;Ams***en;;NLD;Firstname;Lastname;Test payment;test;1824984;;;;;;;;;;;No;;;;;;;;;;;;;;4441;Test demo EUR;DEMO3;;;;;https://sandbox.connpay.com/paynet/view-receipt/9068/e626abe4-52eb-3a25-ae93-19de6ca44023;;0.000;;;;;;;;;Test processor;920084;;2023-05-29T14:56:48.00;2023-05-29T14:56:48.00;100.000;;2% cyprus;;;;2023-05-29T14:56:48.00;582;EUR;100.000;;;;;;1550041;0.000;0.000;0.000;0.000;202412;;route by Source Credit Card Type;ANY_CREDIT_CARD;Unknown;Unknown;76;test_manager;2023-05-29T14:41:45.00;
1824985;2023-05-29T15:07:30.00;2023-05-29T15:07:30.00;29.05.2023;2023-05-29T00:00:00.00;2023-05-29T00:00:00.00;Demo merchant A;6655;1712;Demo Ams EUR;EUR;;Visa;188.253.224.81;retrieval;approved;;;;;manual;100.000;PNTEST-1824985;444455XXXXXX1111;TEST HOLDER;;;a***v@example.com;+3***12233;Wes***HX;***;Ams***en;;NLD;Firstname;Lastname;Test payment;test;1824984;;;115524;407275;;;3,1496E+11;647547344;;;Yes;;;;;;;;;;;;;;2470;A VISA CC Ams EUR;DEMO1;;;;test1;https://sandbox.connpay.com/paynet/view-receipt/6655/3317093d-b5b3-3d09-aa9b-28e1c80166d8;;0.000;;;UNKNOWN;;US;United States;;;Test processor;;;2023-05-29T14:45:00.00;2023-05-29T14:45:00.00;100.000;;2% cyprus;;;;2023-05-29T15:07:30.00;582;USD;107.320;;;1.073134088104000;1.073134088104000;;1550043;0.000;0.000;0.000;0.000;202701;;route by Customer Loyalty;OTHERS;Unknown;Unknown;76;test_manager;2023-05-29T14:40:11.00;
1826965;2023-05-31T16:42:20.00;2023-05-31T16:42:20.00;31.05.2023;;;Demo merchant A;6655;1712;Demo Ams EUR;EUR;;Visa;188.253.237.101;sale;approved;;;;;;100.000;PNTEST-1826965;444455XXXXXX1111;TEST HOLDER;;;a***v@example.com;+3***12233;Wes***HX;***;Ams***en;;NLD;Firstname;Lastname;Test payment;test;1826964;;;432862;200594;;;3,15182E+11;302446749;;;Yes;;;;;;;;;;;;;;2470;A VISA CC Ams EUR;DEMO1;;;;test1;https://sandbox.connpay.com/paynet/view-receipt/6655/861f0fd1-9f2e-3acf-9a05-b7f8c927eae3;;2.200;;;UNKNOWN;;US;United States;;;Test processor;;;2023-05-31T16:42:20.00;2023-05-31T16:42:20.00;100.000;;2% cyprus;;;;2023-05-31T16:42:20.00;582;USD;107.220;;;1.072140012909000;1.072140012909000;;1551928;0.000;2.200;0.000;1.000;202601;;route by Customer Loyalty;OTHERS;Unknown;Unknown;76;test_manager;2023-05-31T16:37:25.00;
1826966;2023-05-31T16:53:50.00;2023-05-31T16:53:50.00;31.05.2023;;;Demo merchant A;9068;1712;Demo Ams EUR;EUR;;Any;188.253.237.101;sale;declined;920084;Request failed: Timer expired. User not paid. Request failed: Timer expired. User not paid.;;;;100.000;;999999XXXXXX9999;Unknown holder;;;a***v@example.com;+3***12233;Wes***HX;***;Ams***en;;NLD;Firstname;Lastname;Test payment;test;1826964;;;;;;;;;;;No;;;;;;;;;;;;;;4441;Test demo EUR;DEMO3;;;;;https://sandbox.connpay.com/paynet/view-receipt/9068/4e6c1674-aeb1-3d5e-bbe4-0af9c37fd95d;;0.000;;;;;;;;;Test processor;920084;;2023-05-31T16:53:50.00;2023-05-31T16:53:50.00;100.000;;2% cyprus;;;;2023-05-31T16:53:50.00;582;EUR;100.000;;;;;;1551934;0.000;0.000;0.000;0.000;202412;;route by Source Credit Card Type;ANY_CREDIT_CARD;Unknown;Unknown;76;test_manager;2023-05-31T16:38:47.00;

Fail Response Example

HTTP/1.1 403
Server: server
Date: Fri, 28 Jul 2023 12:44:12 GMT
Content-Type: text/html
Content-Length: 735
Connection: close


...
<body>
    <p>Access is denied</p>
</body>

Postman Collection

Request Builder

HTTP method
URL
parameters
version
consumer key
consumer secret
timestamp

nonce

signature method

normalized parameters
signature base string
signature
authorization header