Get List of Transactions for Paypoint

GET

Query

transactions

{entry}

curl --request GET \
  --url https://api-sandbox.payabli.com/api/Query/transactions/{entry} \
  --header 'requestToken: <api-key>'

{
  "Summary": {
    "totalRecords": 2,
    "totalAmount": 177.22,
    "totalNetAmount": 177.22,
    "totalPages": 1,
    "pageSize": 20,
    "pageIdentifier": "XXXXXXXXXXXXXXXXXXX"
  },
  "Records": [
    {
      "ParentOrgName": "Payabli",
      "PaypointDbaname": "Sunshine LLC",
      "PaypointLegalname": "Sunshine LLC",
      "PaypointEntryname": "7acda8200",
      "PaymentTransId": "2345667-ddd-fff",
      "GatewayTransId": "string",
      "ExternalProcessorInformation": " ",
      "OrderId": "9876543",
      "Method": "card",
      "BatchNumber": "1234567",
      "PayorId": 55,
      "PaymentData": {
        "MaskedAccount": "411111XXXXXX1111",
        "AccountType": "visa",
        "AccountExp": "0426",
        "HolderName": "Billy J Franks",
        "StoredId": "675b43c1-9867-463c-8dc7-3d6ddb68554b-12812",
        "Initiator": "payor",
        "StoredMethodUsageType": "unscheduled",
        "Sequence": "first",
        "orderDescription": null,
        "accountId": null,
        "SignatureData": null,
        "binData": {
          "binMatchedLength": 6,
          "binCardBrand": "VISA",
          "binCardType": "DEBIT",
          "binCardCategory": "CLASSIC",
          "binCardIssuer": "CONOTOXIA SP. Z O.O",
          "binCardIssuerCountry": "POLAND",
          "binCardIssuerCountryCodeA2": "PL",
          "binCardIssuerCountryNumber": 616
        }
      },
      "TransStatus": 1,
      "PaypointId": 2,
      "TotalAmount": 110.25,
      "NetAmount": 100,
      "FeeAmount": 10.25,
      "SettlementStatus": 0,
      "Operation": "Sale",
      "ResponseData": {
        "response": null,
        "responsetext": "CAPTURED",
        "authcode": "00",
        "transactionid": "TRN_xwCAjQorWAYX1nAhAoHZVfN8iYHbI0",
        "avsresponse": null,
        "avsresponse_text": null,
        "cvvresponse": null,
        "cvvresponse_text": null,
        "orderid": null,
        "type": null,
        "response_code": "100",
        "response_code_text": "Transaction was approved.",
        "emv_auth_response_data": null
      },
      "Source": "vterminal",
      "ScheduleReference": 0,
      "OrgId": 2,
      "RefundId": 0,
      "ReturnedId": 0,
      "TransAdditionalData": null,
      "InvoiceData": {
        "invoiceNumber": "INV-2345",
        "invoiceDate": "10/25/2023",
        "invoiceDueDate": "11/25/2023",
        "invoiceType": 0,
        "invoiceEndDate": "string",
        "invoiceStatus": 0,
        "frequency": "one-time",
        "paymentTerms": "PIA",
        "termsConditions": "string",
        "notes": "string",
        "tax": 2.05,
        "discount": 0,
        "invoiceAmount": 105,
        "freightAmount": 10,
        "dutyAmount": 0,
        "purchaseOrder": "string",
        "firstName": "string",
        "lastName": "string",
        "company": "string",
        "shippingAddress1": "string",
        "shippingAddress2": "string",
        "shippingCity": "string",
        "shippingState": "string",
        "shippingZip": "string",
        "shippingCountry": "string",
        "shippingEmail": "string",
        "shippingPhone": "string",
        "shippingFromZip": "string",
        "summaryCommodityCode": "string",
        "items": [
          {
            "itemProductCode": "string",
            "itemProductName": "product 01",
            "itemDescription": "string",
            "itemCommodityCode": "string",
            "itemUnitOfMeasure": "U",
            "itemCost": 1,
            "itemQty": 1,
            "itemMode": 0,
            "itemCategories": [
              "string"
            ],
            "itemTotalAmount": 0,
            "itemTaxAmount": 0,
            "itemTaxRate": 0
          }
        ],
        "attachments": [
          {
            "ftype": "pdf",
            "filename": "my-doc.pdf",
            "furl": "https://mysite.com/my-doc.pdf",
            "fContent": "TXkgdGVzdCBmaWxlHJ==..."
          }
        ],
        "additionalData": {
          "property1": "string",
          "property2": "string"
        }
      },
      "EntrypageId": 0,
      "TransactionTime": "2019-08-24T14:15:22Z",
      "Customer": {
        "customerId": 34,
        "FirstName": "John",
        "LastName": "Doe",
        "CompanyName": "Sunshine LLC",
        "CustomerNumber": "3456-7645A",
        "BillingAddress1": "1111 street",
        "BillingAddress2": "string",
        "BillingCity": "myCity",
        "BillingState": "CA",
        "BillingZip": "45567",
        "BillingCountry": "US",
        "BillingPhone": "1234567890",
        "BillingEmail": "customer@mail.com",
        "ShippingAddress1": "string",
        "ShippingAddress2": "string",
        "ShippingCity": "string",
        "ShippingState": "string",
        "ShippingZip": "string",
        "ShippingCountry": "string",
        "AdditionalData": {
          "property1": "string",
          "property2": "string"
        },
        "CreatedAt": "2019-08-24T14:15:22Z"
      },
      "CfeeTransactions": [
        {
          "cFeeTransid": "string",
          "transStatus": 0,
          "feeAmount": 0,
          "settlementStatus": 0,
          "operation": "string",
          "responseData": null,
          "refundId": 0,
          "transactionTime": "2019-08-24T14:15:22Z"
        }
      ],
      "TransactionEvents": [
        {
          "transEvent": "Approved",
          "eventData": null,
          "eventTime": "2019-08-24T14:15:22Z"
        }
      ],
      "deviceId": "6c361c7d-674c-44cc-b790-382b75d1xxx",
      "AchSecCode": null,
      "AchHolderType": null
    }
  ]
}

By default, this endpoint returns only transactions from the last 60 days. To query transactions outside of this period, include transactionDate filters.

For example, this request parameters filter for transactions between April 01, 2024 and April 09, 2024.

curl --request GET \
  --url https://sandbox.payabli.com/api/Query/transactions/org/1?limitRecord=20&fromRecord=0&transactionDate(ge)=2024-04-01T00:00:00&transactionDate(le)=2024-04-09T23:59:59\
  --header 'requestToken: <api-key>'

You must remove parameters= from the request before you send it, otherwise Payabli will ignore the filters.

Because of a technical limitation, you can’t make a request that includes filters from the API console on this page. The response won’t be filtered. Instead, copy the request, remove parameters= and run the request in a different client.

For example:

—url https://api-sandbox.payabli.com/api/Query/transactions/org/236?parameters=totalAmount(gt)=1000&limitRecord=20

should become:

—url https://api-sandbox.payabli.com/api/Query/transactions/org/236?totalAmount(gt)=1000&limitRecord=20

Authorizations

requestToken

string

header

required

Most endpoints require an organization token. Some endpoints require an application token, and those endpoints are noted.

Path Parameters

entry

string

required

The paypoint's entrypoint identifier. Learn more

Example:

"8cfec329267"

Query Parameters

parameters

object

Collection of field names, conditions, and values used to filter the query.

See Filters and Conditions Reference for more information.

List of field names accepted:

transactionDate (gt, ge, lt, le, eq, ne)
transId (ne, eq, ct, nct, in, nin)
gatewayTransId (ne, eq, ct, nct)
orderId (ne, eq)
scheduleId (ne, eq)
returnId (ne, eq)
refundId (ne, eq)
idTrans (ne, eq)
orgId (ne, eq)
paypointId (ne, eq)
paypointLegal (ne, eq, ct, nct)
paypointDba (ne, eq, ct, nct)
orgName (ne, eq, ct, nct)
externalPaypointId (ct, nct, eq, ne)
method (in, nin, eq, ne)
totalAmount (gt, ge, lt, le, eq, ne)
netAmount (gt, ge, lt, le, eq, ne)
feeAmount (gt, ge, lt, le, eq, ne)
operation (in, nin, eq, ne)
source (in, nin, eq, ne, ct, nct)
status (in, nin, eq, ne)
settlementStatus (in, nin, eq, ne)
batchNumber (nct, ct)
invoiceNumber (ct, nct)
authCode (ct, nct)
orderDescription (ct, nct)
payaccountLastfour (nct, ct)
payaccountType (ne, eq, in, nin)
payaccountCurrency (ne, eq, in, nin)
customerFirstname (ct, nct, eq, ne)
customerLastname (ct, nct, eq, ne)
customerName (ct, nct)
customerId (eq, ne)
customerNumber (ct, nct, eq, ne)
customerCompanyname (ct, nct, eq, ne)
customerAddress (ct, nct, eq, ne)
customerCity (ct, nct, eq, ne)
customerZip (ct, nct, eq, ne)
customerState (ct, nct, eq, ne)
customerCountry (ct, nct, eq, ne)
customerPhone (ct, nct, eq, ne)
customerEmail (ct, nct, eq, ne)
customerShippingAddress (ct, nct, eq, ne)
customerShippingCity (ct, nct, eq, ne)
customerShippingZip (ct, nct, eq, ne)
customerShippingState (ct, nct, eq, ne)
customerShippingCountry (ct, nct, eq, ne)
deviceId (ct, nct, in, nin, eq, ne)
AchSecCode ( ct, nct, in, nin, eq, ne)
AchHolderType (ct, nct, in, nin, eq, and ne)
additional-xxx (ne, eq, ct, nct) where xxx is the additional field name

List of comparison operators accepted:

eq or empty => equal
gt => greater than
ge => greater or equal
lt => less than
le => less or equal
ne => not equal
ct => contains
nct => not contains
in => inside array
nin => not inside array

limitRecord

integer

default:20

Max number of records to return for the query. Use 0 or negative value to return all records.

Example:

0

fromRecord

integer

default:0

The number of records to skip before starting to collect the result set.

Example:

251

sortBy

string

The field name to use for sorting results. Use desc(field_name) to sort descending by field_name, and use asc(field_name) to sort ascending by field_name.

Example:

"desc(field_name)"

Response

200

application/json

Success

Response payload for queries related to transactions

Summary

object

Records

object[] | null

Records.ParentOrgName

string | null

The name of the parent organization.

Example:

"PropertyManager Pro"

Records.PaypointDbaname

string | null

Paypoint's DBA name.

Example:

"Sunshine Gutters"

Records.PaypointLegalname

string | null

Paypoint's legal name.

Example:

"Sunshine Services, LLC"

Records.PaypointEntryname

string | null

Paypoint's entryname.

Maximum length: 50

Example:

"d193cf9a46"

Records.PaymentTransId

string | null

Unique Transaction ID.

Example:

"226-fe55ec0348e34702bd91b4be198ce7ec"

Records.ConnectorName

string | null

Connector used for transaction.

Example:

"gp"

Records.ExternalProcessorInformation

string | null

Processor information, used for troubleshooting and reporting. This field contains a value when the API key used to make the request has management permissions.

Example:

"[MER_xxxxxxxxxxxxxx]/[NNNNNNNNN]"

Records.GatewayTransId

string | null

Internal identifier used for processing.

Example:

"TRN_xwCAjQorWAYX1nAhAoHZVfN8iYHbI0"

Records.OrderId

string | null

Custom identifier for the transaction.

Maximum length: 250

Example:

"O-5140"

Records.Method

string | null

Payment method used: card, ach, or wallet.

Example:

"ach"

Records.BatchNumber

string | null

Batch number.

Example:

"batch_226_ach_12-30-2023"

Records.BatchAmount

number | null

Batch amount.

Example:

30.22

Records.PayorId

integer

Unique ID for customer linked to the transaction.

Example:

1551

Records.PaymentData

object

Records.PaymentData.MaskedAccount

string | null

Masked card or bank account used in transaction. In the case of Apple Pay, this is a masked DPAN (device primary account number).

Example:

"4XXXXXXXX1111"

Records.PaymentData.AccountType

string | null

Bank account type or card brand.

Example:

"visa"

Records.PaymentData.AccountExp

string | null

Expiration date of card used in transaction.

Example:

"11/29"

Records.PaymentData.AccountZip

string | null

ZIP code for card used in transaction.

Example:

"90210"

Records.PaymentData.HolderName

string | null

Account holder name for the method.

Example:

"Chad Mercia"

Records.PaymentData.orderDescription

string | null

Text description of the transaction.

Maximum length: 250

Example:

"Depost for materials for 123 Walnut St"

Records.PaymentData.StoredId

string | null

Identifier of stored payment method used in transaction.

Example:

"1ec55af9-7b5a-4ff0-81ed-c12d2f95e135-4440"

Records.PaymentData.Initiator

string | null

default:merchant

Strongly recommended The cardholder-initiated transaction (CIT) or merchant-initiated transaction (MIT) indicator for the transaction. If you don't specify a value, Payabli defaults to merchant.

Available values:

payor: For cardholder-initiated transactions
merchant: For merchant-initiated transactions

See Understanding CIT and MIT Indicators for more information.

Example:

"payor"

Records.PaymentData.StoredMethodUsageType

string | null

default:unscheduled

Strongly recommended The usage type for the stored method, used for merchant-initiated transactions (MIT). If you don't specify a value, Payabli defaults to unscheduled.

Available values:

unscheduled: This type is used for transactions that are one-time or otherwise not pre-scheduled.
subscription: This type is used for subscription payments. For example, monthly rental fees or ongoing service subscriptions.
recurring: This type is used for recurring payments that occur per a set plan. For example, splitting an HOA special assessment over 6 monthly payments.

See Understanding CIT and MIT Indicators for more information.

Example:

"subscription"

Records.PaymentData.Sequence

string | null

The order of the transaction for cardholder-initiated transaction (CIT) and merchant-initiated transaction (MIT) purposes. This field is automatically detected and populated by Payabli.

Available values:

first: The first use of the payment method. This is almost always a cardholder-initiated transaction.
subsequent: For merchant-initiated transactions after the first use of the payment method.

See Understanding CIT and MIT Indicators for more information.

Example:

"subsequent"

Records.PaymentData.accountId

string | null

Custom identifier for payment connector.

Maximum length: 250

Records.PaymentData.SignatureData

string | null

Example:

null

Records.PaymentData.binData

object

Object containing information related to the card. This object is null unless the payment method is card. If the payment method is Apple Pay, the binData will be related to the DPAN (device primary account number), not the card connected to Apple Pay.

Records.PaymentData.paymentDetails

object

Details about the payment.

Records.PaymentData.paymentDetails.totalAmount

number

required

Total amount to be charged. If a service fee is sent, then this amount should include the service fee."

Example:

100

Records.PaymentData.paymentDetails.serviceFee

number | null

Service fee to be deducted from the total amount. This amount must be a number, percentages aren't accepted. If you are using a percentage-based fee schedule, you must calculate the value manually.

Example:

0

Records.PaymentData.paymentDetails.currency

string | null

Currency code ISO-4217. If not code is provided the currency in the paypoint setting is taken. Default is USD.

Example:

"USD"

Records.PaymentData.paymentDetails.checkNumber

string | null

A check number to be used in the ach transaction. Required for payment method = 'check'.

Example:

"107"

Records.PaymentData.paymentDetails.checkImage

object | null

Object containing image of paper check.

Records.PaymentData.paymentDetails.categories

object[] | null

Array of payment categories/line items describing the amount to be paid Note: These categories are for information only and are not validated against the total amount provided.

Records.PaymentData.paymentDetails.splitFunding

object[] | null

Split funding instructions for the transaction. See Split a Transaction for more.

Records.TransStatus

integer

Status of transaction. See the docs for a full reference.

Example:

1

Records.PaypointId

integer

InternalId for paypoint.

Example:

226

Records.TotalAmount

number

Transaction total amount (including service fee or sub-charge)

Example:

30.22

Records.NetAmount

number | null

Net amount paid.

Example:

3762.87

Records.FeeAmount

number

Service fee or sub-charge applied.

Example:

1

Records.SettlementStatus

integer

Settlement status for transaction. See the docs for a full reference.

Example:

2

Records.Operation

string | null

The transaction's operation.

Example:

"Sale"

Records.ResponseData

object

The transaction's response data.

Records.Source

string | null

Custom identifier to indicate the transaction or request source.

Maximum length: 100

Example:

"api"

Records.ScheduleReference

integer | null

Reference to the subscription that originated the transaction.

Example:

0

Records.OrgId

integer | null

ID of immediate parent organization.

Example:

123

Records.RefundId

integer | null

Identifier of refund transaction linked to this payment.

Example:

0

Records.ReturnedId

integer | null

Identifier of return/chargeback transaction linked to this payment.

Example:

0

Records.TransAdditionalData

any

Not currently in use.

Records.InvoiceData

object

Records.InvoiceData.invoiceNumber

string | null

Invoice number. Identifies the invoice under a paypoint.

Maximum length: 250

Example:

"INV-2345"

Records.InvoiceData.invoiceDate

string | null

Invoice date in any of the accepted formats: YYYY-MM-DD, MM/DD/YYYY.

Example:

"2024-07-01"

Records.InvoiceData.invoiceDueDate

string | null

Invoice due date in one of the accepted formats: YYYY-MM-DD, MM/DD/YYYY.

Example:

"2024-07-01"

Records.InvoiceData.invoiceType

integer | null

Type of invoice. Only 0 for one-time invoices is currently supported.

Example:

0

Records.InvoiceData.invoiceEndDate

string | null

Indicate the date to finish a scheduled invoice cycle (`invoiceType`` = 1) in any of the accepted formats: YYYY-MM-DD, MM/DD/YYYY.

Example:

"2024-07-01"

Records.InvoiceData.invoiceStatus

enum<integer> | null

Status for invoice.

The accepted status values are:

0 draft
1 active
2 partially paid
4 paid/complete
99 cancelled

Available options:

0,

1,

2,

4,

99

Example:

1

Records.InvoiceData.frequency

enum<string> | null

Frequency of scheduled invoice.

Available options:

one-time,

weekly,

every2weeks,

every6months,

monthly,

every3months,

annually

Example:

"monthly"

Records.InvoiceData.paymentTerms

enum<string> | null

Payment terms for invoice. If no terms are defined, then reponse data for this field defaults to N30.

Available options:

PIA,

CIA,

UR,

NET10,

NET20,

NET30,

NET45,

NET60,

NET90,

EOM,

MFI,

5MFI,

10MFI,

15MFI,

20MFI,

2/10NET30,

UF,

10UF,

20UF,

25UF,

50UF

Example:

"PIA"

Records.InvoiceData.termsConditions

string | null

Custom terms and conditions included in the invoice.

Example:

"Must be paid before work scheduled."

Records.InvoiceData.notes

string | null

Notes included in the invoice.

Example:

"Example notes."

Records.InvoiceData.tax

number | null

Tax rate in percent applied to the invoice.

Example:

2.05

Records.InvoiceData.discount

number | null

Discount applied to the invoice.

Example:

10

Records.InvoiceData.invoiceAmount

number | null

Invoice total amount.

Example:

105

Records.InvoiceData.freightAmount

number | null

Freight/shipping amount.

Example:

10

Records.InvoiceData.dutyAmount

number | null

Duty amount.

Example:

0

Records.InvoiceData.purchaseOrder

string | null

Purchase order number.

Example:

"PO-345"

Records.InvoiceData.firstName

string | null

First name of the recipient of the invoice.

Example:

"Chad"

Records.InvoiceData.lastName

string | null

Last name of the recipient of the invoice.

Example:

"Mercia"

Records.InvoiceData.company

string | null

Company name of the recipient of the invoice.

Example:

"ACME, INC"

Records.InvoiceData.shippingAddress1

string | null

The shipping address.

Maximum length: 250

Example:

"123 Walnut St"

Records.InvoiceData.shippingAddress2

string | null

Additional line for shipping address.

Maximum length: 100

Example:

"STE 900"

Records.InvoiceData.shippingCity

string | null

Shipping city.

Maximum length: 250

Example:

"Johnson City"

Records.InvoiceData.shippingState

string | null

Shipping state or province.

Example:

"TN"

Records.InvoiceData.shippingZip

string | null

Shipping ZIP code.

Maximum length: 50

Example:

"37619"

Records.InvoiceData.shippingCountry

string | null

Shipping address country.

Example:

"US"

Records.InvoiceData.shippingEmail

string | null

Shipping recipient's contact email address.

Maximum length: 320

Example:

"example@email.com"

Records.InvoiceData.shippingPhone

string | null

Recipient phone number.

Example:

"5555555555"

Records.InvoiceData.shippingFromZip

string | null

Sender shipping ZIP code.

Example:

"30040"

Records.InvoiceData.summaryCommodityCode

string | null

Commodity code.

Example:

"501718"

Records.InvoiceData.items

object[] | null

Array of line items included in the invoice.

Records.InvoiceData.attachments

object | null

Array of fileContent objects with attached documents. Max upload size is 30 MB.

Records.InvoiceData.AdditionalData

string | null

Custom dictionary of key:value pairs. You can use this field to store any data related to the object or for your system. Example usage:

{
  "additionalData": {
    "key1": "value1",
    "key2": "value2",
    "key3": "value3"
  }
}

Example:

{
  "key1": "value1",
  "key2": "value2",
  "key3": "value3"
}

Records.EntrypageId

integer

If applicable, the internal reference ID to the payment page capturing the payment.

Example:

0

Records.TransactionTime

string | null

Transaction date and time, in UTC.

Example:

"2025-10-19T00:00:00"

Records.Customer

object

Records.Customer.CustomerId

integer | null

The Payabli-generated unique ID for the customer.

Example:

4440

Records.Customer.FirstName

string | null

Customer/Payor first name.

Example:

"John"

Records.Customer.LastName

string | null

Customer/Payor last name.

Example:

"Doe"

Records.Customer.CompanyName

string | null

Customer's company name.

Example:

"Sunshine LLC"

Records.Customer.CustomerNumber

string | null

User-provided unique identifier for the customer. This is typically the customer ID from your own system.

Maximum length: 250

Example:

"3456-7645A"

Records.Customer.BillingAddress1

string | null

Customer's billing address.

Example:

"1111 West 1st Street"

Records.Customer.BillingAddress2

string | null

Additional line for Customer's billing address.

Example:

"Suite 200"

Records.Customer.BillingCity

string | null

Customer's billing city.

Example:

"Miami"

Records.Customer.BillingState

string | null

Customer's billing state. Must be 2-letter state code for address in US.

Example:

"FL"

Records.Customer.BillingZip

string | null

Customer's billing ZIP code.

Example:

"45567"

Records.Customer.BillingCountry

string | null

Customer's billing country.

Example:

"US"

Records.Customer.BillingPhone

string | null

Customer's phone number.

Example:

"5555555555"

Records.Customer.BillingEmail

string | null

Customer's email address.

Maximum length: 320

Example:

"example@email.com"

Records.Customer.ShippingAddress1

string | null

The shipping address.

Maximum length: 250

Example:

"123 Walnut St"

Records.Customer.ShippingAddress2

string | null

Additional line for shipping address.

Maximum length: 100

Example:

"STE 900"

Records.Customer.ShippingCity

string | null

Shipping city.

Maximum length: 250

Example:

"Johnson City"

Records.Customer.ShippingState

string | null

Shipping state or province.

Example:

"TN"

Records.Customer.ShippingZip

string | null

Shipping ZIP code.

Maximum length: 50

Example:

"37619"

Records.Customer.ShippingCountry

string | null

Shipping address country.

Example:

"US"

Records.Customer.AdditionalData

string | null

Custom dictionary of key:value pairs. You can use this field to store any data related to the object or for your system. Example usage:

{
  "additionalData": {
    "key1": "value1",
    "key2": "value2",
    "key3": "value3"
  }
}

Example:

{
  "key1": "value1",
  "key2": "value2",
  "key3": "value3"
}

Records.Customer.CreatedAt

string

Timestamp of when record was created, in UTC.

Example:

"2022-07-01 15:00:01"

Records.Customer.customerId

integer | null

The Payabli-generated unique ID for the customer.

Example:

4440

Records.Customer.customerStatus

integer | null

Customer Status. Possible values:

-99 Deleted
0 Inactive
1 Active
85 Locked (typically due to multiple failed login attempts)

Example:

1

Records.Customer.Identifiers

any[] | null

Array of field names to be used as identifiers.

Example:

[
  "\\\"firstname\\\"",
  "\\\"lastname\\\"",
  "\\\"email\\\"",
  "\\\"customId\\\""
]

Records.CfeeTransactions

object[] | null

Service Fee or sub-charge transaction associated to the main transaction.

Records.splitFundingInstructions

object[] | null

Split funding instructions for the transaction. The total amount of the splits must match the total amount of the transaction.

Records.TransactionEvents

object[] | null

Events associated with this transaction.

Records.PendingFeeAmount

number | null

The difference between the configured pass-through fee and the fee amount sent in the request. When transfering funds, Payabli uses this field to deduct the fee difference and transfer the correct amount to the merchant.

When a paypoint is set up to absorb fees, and the pass-through fee sent with the request is less than the configured amount, the difference must be covered by the merchant. See Fee Configuration to learn more about pass-through fee settings.

Example:

2

Records.DeviceId

string | null

Identifier of registered cloud device used in the transaction.

Example:

"6c361c7d-674c-44cc-b790-382b75d1xxx"

Records.AchSecCode

string

Standard Entry Class (SEC) code is a a three letter code that describes how an ACH payment was authorized. Supported values are:

PPD (Prearranged Payment and Deposit) - Used for credits or debits where an accountholder authorizes a company to initiate either a single or recurring transaction to their personal bank account. Common examples include direct deposit of payroll, mortgage payments, or utility bills. This is the default value for subscription payments.
WEB (Internet-Initiated/Mobile Entry) - Used for debit entries when authorization is obtained from an accountholder via the internet or a wireless network. Common examples are online bill payments, ecommerce purchases, and mobile app payments where the consumer enters their banking information online.
TEL (Telephone-Initiated Entry) - Used for one-time debit entries where authorization is obtained from a consumer via telephone. Common examples are phone-based purchases or bill payments where the consumer provides their banking information over the phone.
CCD (Corporate Credit or Debit) - Used for fund transfers between business accounts. This code is specifically for business-to-business transactions. Common examples include vendor payments and other business-to-business payments.

Records.AchHolderType

enum<string> | null

default:personal

The bank's accountholder type: personal or business.

Available options:

personal,

business

Was this page helpful?

Delete Notification

Get List of Transactions for Organization

curl --request GET \
  --url https://api-sandbox.payabli.com/api/Query/transactions/{entry} \
  --header 'requestToken: <api-key>'

{
  "Summary": {
    "totalRecords": 2,
    "totalAmount": 177.22,
    "totalNetAmount": 177.22,
    "totalPages": 1,
    "pageSize": 20,
    "pageIdentifier": "XXXXXXXXXXXXXXXXXXX"
  },
  "Records": [
    {
      "ParentOrgName": "Payabli",
      "PaypointDbaname": "Sunshine LLC",
      "PaypointLegalname": "Sunshine LLC",
      "PaypointEntryname": "7acda8200",
      "PaymentTransId": "2345667-ddd-fff",
      "GatewayTransId": "string",
      "ExternalProcessorInformation": " ",
      "OrderId": "9876543",
      "Method": "card",
      "BatchNumber": "1234567",
      "PayorId": 55,
      "PaymentData": {
        "MaskedAccount": "411111XXXXXX1111",
        "AccountType": "visa",
        "AccountExp": "0426",
        "HolderName": "Billy J Franks",
        "StoredId": "675b43c1-9867-463c-8dc7-3d6ddb68554b-12812",
        "Initiator": "payor",
        "StoredMethodUsageType": "unscheduled",
        "Sequence": "first",
        "orderDescription": null,
        "accountId": null,
        "SignatureData": null,
        "binData": {
          "binMatchedLength": 6,
          "binCardBrand": "VISA",
          "binCardType": "DEBIT",
          "binCardCategory": "CLASSIC",
          "binCardIssuer": "CONOTOXIA SP. Z O.O",
          "binCardIssuerCountry": "POLAND",
          "binCardIssuerCountryCodeA2": "PL",
          "binCardIssuerCountryNumber": 616
        }
      },
      "TransStatus": 1,
      "PaypointId": 2,
      "TotalAmount": 110.25,
      "NetAmount": 100,
      "FeeAmount": 10.25,
      "SettlementStatus": 0,
      "Operation": "Sale",
      "ResponseData": {
        "response": null,
        "responsetext": "CAPTURED",
        "authcode": "00",
        "transactionid": "TRN_xwCAjQorWAYX1nAhAoHZVfN8iYHbI0",
        "avsresponse": null,
        "avsresponse_text": null,
        "cvvresponse": null,
        "cvvresponse_text": null,
        "orderid": null,
        "type": null,
        "response_code": "100",
        "response_code_text": "Transaction was approved.",
        "emv_auth_response_data": null
      },
      "Source": "vterminal",
      "ScheduleReference": 0,
      "OrgId": 2,
      "RefundId": 0,
      "ReturnedId": 0,
      "TransAdditionalData": null,
      "InvoiceData": {
        "invoiceNumber": "INV-2345",
        "invoiceDate": "10/25/2023",
        "invoiceDueDate": "11/25/2023",
        "invoiceType": 0,
        "invoiceEndDate": "string",
        "invoiceStatus": 0,
        "frequency": "one-time",
        "paymentTerms": "PIA",
        "termsConditions": "string",
        "notes": "string",
        "tax": 2.05,
        "discount": 0,
        "invoiceAmount": 105,
        "freightAmount": 10,
        "dutyAmount": 0,
        "purchaseOrder": "string",
        "firstName": "string",
        "lastName": "string",
        "company": "string",
        "shippingAddress1": "string",
        "shippingAddress2": "string",
        "shippingCity": "string",
        "shippingState": "string",
        "shippingZip": "string",
        "shippingCountry": "string",
        "shippingEmail": "string",
        "shippingPhone": "string",
        "shippingFromZip": "string",
        "summaryCommodityCode": "string",
        "items": [
          {
            "itemProductCode": "string",
            "itemProductName": "product 01",
            "itemDescription": "string",
            "itemCommodityCode": "string",
            "itemUnitOfMeasure": "U",
            "itemCost": 1,
            "itemQty": 1,
            "itemMode": 0,
            "itemCategories": [
              "string"
            ],
            "itemTotalAmount": 0,
            "itemTaxAmount": 0,
            "itemTaxRate": 0
          }
        ],
        "attachments": [
          {
            "ftype": "pdf",
            "filename": "my-doc.pdf",
            "furl": "https://mysite.com/my-doc.pdf",
            "fContent": "TXkgdGVzdCBmaWxlHJ==..."
          }
        ],
        "additionalData": {
          "property1": "string",
          "property2": "string"
        }
      },
      "EntrypageId": 0,
      "TransactionTime": "2019-08-24T14:15:22Z",
      "Customer": {
        "customerId": 34,
        "FirstName": "John",
        "LastName": "Doe",
        "CompanyName": "Sunshine LLC",
        "CustomerNumber": "3456-7645A",
        "BillingAddress1": "1111 street",
        "BillingAddress2": "string",
        "BillingCity": "myCity",
        "BillingState": "CA",
        "BillingZip": "45567",
        "BillingCountry": "US",
        "BillingPhone": "1234567890",
        "BillingEmail": "customer@mail.com",
        "ShippingAddress1": "string",
        "ShippingAddress2": "string",
        "ShippingCity": "string",
        "ShippingState": "string",
        "ShippingZip": "string",
        "ShippingCountry": "string",
        "AdditionalData": {
          "property1": "string",
          "property2": "string"
        },
        "CreatedAt": "2019-08-24T14:15:22Z"
      },
      "CfeeTransactions": [
        {
          "cFeeTransid": "string",
          "transStatus": 0,
          "feeAmount": 0,
          "settlementStatus": 0,
          "operation": "string",
          "responseData": null,
          "refundId": 0,
          "transactionTime": "2019-08-24T14:15:22Z"
        }
      ],
      "TransactionEvents": [
        {
          "transEvent": "Approved",
          "eventData": null,
          "eventTime": "2019-08-24T14:15:22Z"
        }
      ],
      "deviceId": "6c361c7d-674c-44cc-b790-382b75d1xxx",
      "AchSecCode": null,
      "AchHolderType": null
    }
  ]
}

API Basics

Pay In Endpoints

Pay Out Endpoints

Pay Ops Endpoints

Object Models

Get List of Transactions for Paypoint

Authorizations

Path Parameters

Query Parameters

Response