List all Transactions

GET https://gateway-api.paycertify.com/api/transactions

In order to list all the transactions that have been sent through the gateway, you can use this endpoint. Please note that for every new event that is sent under the same transaction, the transaction’s updated_at field is updated.

Filtering is enabled to this endpoint through query parameter search. So whenever searching for a field, make sure to submit it through the endpoint’s query parameters, for example: https://gateway-api.paycertify.com/api/transactions?search[first_name]=John&search[last_name]=Doe. Filter types are described below:

starts with which matches for records on a SQL LIKE fashion, e.g.: a string “PayC” will match “PayCertify”;
exact comparison which matches for records through exact comparison, case sensitive, e.g.: a string “Paycertify” will NOT match “PayCertify”;
date which matches for records through SQL date, and these fields should be provided on Y-m-d H:i:s format, e.g.: 2025-01-01 17:59:00

Also, this endpoint provides pagination to navigate through record sets. Pagination information can be found on meta response field. The pages always return 50 records at a time. While using reporting capabilities, make sure to monitor rate limits through X-RateLimit-Limit and X-RateLimit-Remaining response headers.

Parameter	Type	Length	Presence	Filter Type
`merchant_transaction_id`	`string`	1-255	Optional	starts with
`card_number`^[1]	`string`	8-19	Optional	starts with
`first_name`	`string`	1-255	Optional	starts with
`last_name`	`string`	1-255	Optional	starts with
`email`	`string`	1-255	Optional	starts with
`mobile_phone`	`string`	11-15	Optional	starts with
`user_id`	`string`	36	Optional	exact comparison
`city`	`string`	1-255	Optional	starts with
`state`	`string`	2	Optional	exact comparison
`zip`	`string`	5	Optional	exact comparison
`shipping_city`	`string`	1-255	Optional	starts with
`shipping_state`	`string`	2	Optional	exact comparison
`shipping_zip`	`string`	5	Optional	exact comparison
`created_at_gte`	`datetime`	19	Optional	date
`created_at_lte`	`datetime`	19	Optional	date
`updated_at_gte`	`datetime`	19	Optional	date
`updated_at_lte`	`datetime`	19	Optional	date

[1] Please note that whenever searching for card numbers, you should only search by the first six digits, fill with 8 asterisks

Parameter	Type	Length	Description	Example
`transactions.*.id`	`uuid`	36	This transaction’s ID	41f00869-d7b3-413e-9476-9ef1a8bc2f28
`transactions.*.merchant_id`	`uuid`	36	The user’s merchant ID	41f00869-d7b3-413e-9476-9ef1a8bc2f28
`transactions.*.user_id`	`uuid`	36	The user’s ID	41f00869-d7b3-413e-9476-9ef1a8bc2f28
`transactions.*.processor_id`	`uuid`	36	The processor’s ID	41f00869-d7b3-413e-9476-9ef1a8bc2f28
`transactions.*.merchant_transaction_id`	`string`	1-255	The merchant assigned identifier	my-order-id-0001
`transactions.*.updated_at`	`datetime`	-	Last time this transaction was updated, on ISO 8601 UTC	2018-02-16T16:33:40+00:00
`trqnsactions.*.created_at`	`datetime`	-	Time that transaction was created, on ISO 8601 UTC	2018-02-16T16:33:40+00:00
`transactions..events..id`	`uuid`	36	This event’s ID	41f00869-d7b3-413e-9476-9ef1a8bc2f28
`transactions..events..success`	`boolean`	-	If the event was a successful event or not	true
`transactions..events..event_type`	`string`	4-10	The type of event being performed	auth, capture, sale, void, refund
`transactions..events..amount`	`number`	0.01-9999999	Total event amount	3.56
`transactions..events..processor_code`	`string`	2-10	The processor response code	00
`transactions..events..processor_message`	`string`	1-255	A human readable message from the processor	APPROVAL V12341
`transactions..events..processor_transaction_id`	`string`	1-255	A processor assigned identifier	00000000143242
`transactions..events..updated_at`	`datetime`	-	Last time this event was updated, on ISO 8601 UTC	2018-02-16T16:33:40+00:00
`transactions..events..created_at`	`datetime`	-	Time that event was created, on ISO 8601 UTC	2018-02-16T16:33:40+00:00
`meta.last_page`	`number`	-	The last page for this query	1
`meta.current_page`	`number`	-	The current page for this query	1
`meta.total`	`number`	-	The total count of records for this page	1

curl --request GET \
  --url 'https://gateway-api.paycertify.com/api/transactions?search[first_name]=John&search[last_name]=Doe' \
  --header 'Authorization: Bearer EE9DC8DB823EF153186B9B3F2702DE378ACC2254' \
  --header 'Cache-Control: no-cache'

Responds with:

{
    "transactions": [
        {
            "id": "3410596f-d596-42d4-9811-41d43868e984",
            "merchant_id": "455a1c64-385b-41b2-a56f-34bf6c5c5335",
            "user_id": "6e064bf5-0e18-466b-811b-f967e8d73b9f",
            "processor_id": "30ff7682-6ec7-48f3-8d7a-62319a9c3c59",
            "merchant_transaction_id": "my-order-id-0001",
            "card_number": "411111******1111",
            "card_brand": "visa",
            "card_expiry_month": "01",
            "card_expiry_year": "2021",
            "first_name": "John",
            "last_name": "Doe",
            "street_address_1": "59 N Santa Cruz Avenue",
            "street_address_2": "Suite M",
            "city": "Los Gatos",
            "state": "CA",
            "country": "US",
            "zip": "95030",
            "email": "[email protected]",
            "mobile_phone": "+11231231234",
            "updated_at": "2018-02-16T16:33:40+00:00",
            "created_at": "2018-02-16T16:33:39+00:00",
            "events": [
                {
                    "id": "84a8ab86-ee0e-47d4-8686-4e42fa58355e",
                    "success": true,
                    "threeds_response": null,
                    "avs_response": null,
                    "event_type": "sale",
                    "amount": "1.00",
                    "ip_address": "127.0.0.1",
                    "processor_code": "00",
                    "processor_message": "APPROVAL TAS656 ",
                    "processor_transaction_id": "000000000252616",
                    "processor_threeds_response": null,
                    "processor_avs_response": "0",
                    "updated_at": "2018-02-16T16:33:40+00:00",
                    "created_at": "2018-02-16T16:33:39+00:00"
                }
            ]
        },
        {
            "id": "93174e5d-79dd-4fa5-b817-ac366c37e524",
            "merchant_id": "455a1c64-385b-41b2-a56f-34bf6c5c5335",
            "user_id": "6e064bf5-0e18-466b-811b-f967e8d73b9f",
            "processor_id": "30ff7682-6ec7-48f3-8d7a-62319a9c3c59",
            "merchant_transaction_id": "my-order-id-0001",
            "card_number": "411111******1111",
            "card_brand": "visa",
            "card_expiry_month": "01",
            "card_expiry_year": "2021",
            "first_name": "John",
            "last_name": "Doe",
            "street_address_1": "59 N Santa Cruz Avenue",
            "street_address_2": "Suite M",
            "city": "Los Gatos",
            "state": "CA",
            "country": "US",
            "zip": "95030",
            "email": "[email protected]",
            "mobile_phone": "+11231231234",
            "updated_at": "2018-02-16T16:33:32+00:00",
            "created_at": "2018-02-16T16:33:29+00:00",
            "events": [
                {
                    "id": "8525c0c9-f05f-4199-9646-e413728c57a0",
                    "success": false,
                    "threeds_response": null,
                    "avs_response": null,
                    "event_type": "sale",
                    "amount": "1.00",
                    "ip_address": "127.0.0.1",
                    "processor_code": "N7",
                    "processor_message": "CVV2 MISMATCH   ",
                    "processor_transaction_id": "000000000252613",
                    "processor_threeds_response": null,
                    "processor_avs_response": "0",
                    "updated_at": "2018-02-16T16:33:32+00:00",
                    "created_at": "2018-02-16T16:33:29+00:00"
                }
            ]
        }
    ],
    "meta": {
        "last_page": 1,
        "current_page": 1,
        "total": 2
    }
}