> This is Payabli documentation. For a complete page index, fetch https://docs.payabli.com/llms.txt — append .md to any page URL for lightweight markdown. For section-level indexes, query parameters, and other AI-optimized access methods, see https://docs.payabli.com/ai-agents.md # List transactions for org GET https://api-sandbox.payabli.com/api/Query/transactions/org/{orgId} Retrieve a list of transactions for an organization. Use filters to limit results. Include the `exportFormat` query parameter to return the results as a file instead of a JSON response. By default, this endpoint returns only transactions from the last 60 days. To query transactions outside of this period, include `transactionDate` filters. These request parameters filter for transactions between April 1, 2024 and April 9, 2024. ```bash curl -X GET "https://api-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" \ -H 'requestToken: ' ``` Reference: https://docs.payabli.com/developers/api-reference/query/get-list-of-transactions-for-an-organization ## Servers - `https://api-sandbox.payabli.com/api` (Sandbox, default) - `https://api.payabli.com/api` (Production) ## Request ### Path parameters - `orgId` (integer, required) — The numeric identifier for organization, assigned by Payabli. ### Query parameters - `exportFormat` (enum, optional) — Export format for file downloads. When specified, returns data as a file instead of JSON. - Allowed values: `csv`, `xlsx` - `fromRecord` (integer, optional, default: 0) — The number of records to skip before starting to collect the result set. - `limitRecord` (integer, optional, default: 20) — Max number of records to return for the query. Use `0` or negative value to return all records. - `parameters` (map from string to string, optional) — Collection of field names, conditions, and values used to filter the query. **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](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](https://api-sandbox.payabli.com/api/Query/transactions/org/236?totalAmount\(gt\)=1000\&limitRecord=20) See [Filters and Conditions Reference](/developers/developer-guides/pay-ops-reporting-engine-overview#filters-and-conditions-reference) for more information. **Accepted field names:** * `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) * `rejectId` (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) * `binCardType` (eq, ne, in, nin). Filters by card type for card transactions. Accepts `CREDIT`, `DEBIT`, or `PREPAID`. Case-insensitive. * `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 related to customer data * 'invoiceAdditional-xxx' (ne, eq, ct, nct) where xxx is the additional field name related to invoice data **Accepted comparison operators:** * `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 - `sortBy` (string, optional) — 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`. ## Response ### 200 Success - `Records` (list of object, optional) - `splitCount` (integer, required) — Number of split funding instructions associated with the transaction. Returns `0` when the transaction has no splits. - `TransactionTime` (datetime, required, nullable) — Transaction date and time, in UTC. - `AchHolderType` (enum, optional, default: personal) — The bank's accountholder type: personal or business. - Allowed values: `personal`, `business` - `AchSecCode` (string, optional) — Standard Entry Class (SEC) code is 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. - **BOC** (Back Office Conversion) — Used to convert paper checks received in-person at a point-of-sale or staffed payment location into electronic ACH debits. Required for Remote Deposit Capture (RDC) transactions. Only supports consumer checks; business, government, and mailed checks aren't eligible. - `BatchAmount` (double, optional) — Batch amount. - `BatchNumber` (string, optional) — A unique identifier for the batch. This is generated by Payabli when the batch is created, and follows this format: `paypointId + "_" + serviceName + "_" + batchDate:yyyyMMdd + "_" + Guid.NewGuid()`. Payabli generates the GUID to ensure that the batch number is unique. For example, in this batch number: `123_card_20251008_3f2504e0-4f89-11d3-9a0c-0305e82c3301`, the paypointID is `123`, the service is `card`, the batch date is `2025-10-08`, and the GUID is `3f2504e0-4f89-11d3-9a0c-0305e82c3301`. - `CfeeTransactions` (list of object, optional) — Service Fee or sub-charge transaction associated to the main transaction. - `cFeeTransid` (string, optional) - `feeAmount` (double, optional) - `operation` (string, optional) - `refundId` (long, optional) - `responseData` (map from string to any, optional) - `settlementStatus` (integer, optional) - `transactionTime` (datetime, optional) — Timestamp when transaction was submitted, in UTC. - `transStatus` (integer, optional) - `ConnectorName` (string, optional) — Connector used for transaction. - `Customer` (object, optional) - `Identifiers` (list of any, optional) — Array of field names to be used as identifiers. - `FirstName` (string, optional) — Customer/Payor first name. - `LastName` (string, optional) — Customer/Payor last name. - `CompanyName` (string, optional) — Customer's company name. - `BillingAddress1` (string, optional) — Customer's billing address. - `BillingAddress2` (string, optional) — Additional line for Customer's billing address. - `BillingCity` (string, optional) — Customer's billing city. - `BillingState` (string, optional) — Customer's billing state. Must be 2-letter state code for address in US. - `BillingZip` (string, optional) — Customer's billing ZIP code. - `BillingCountry` (string, optional) — Customer's billing country. - `BillingPhone` (string, optional) — Customer's phone number. - `BillingEmail` (string, optional) — Customer's email address. - `CustomerNumber` (string, optional) — User-provided unique identifier for the customer. This is typically the customer ID from your own system. - `ShippingAddress1` (string, optional) — The shipping address. - `ShippingAddress2` (string, optional) — Additional line for shipping address. - `ShippingCity` (string, optional) — Shipping city. - `ShippingState` (string, optional) — Shipping state or province. - `ShippingZip` (string, optional) — Shipping ZIP code. For Pay In functions, this field supports 5-digit and 9-digit ZIP codes and alphanumeric Canadian postal codes. For example: `37615-1234` or `37615`. - `ShippingCountry` (string, optional) — Shipping address country. - `customerId` (long, optional) — The Payabli-generated unique ID for the customer. - `customerStatus` (integer, optional) — Customer Status. Possible values: - `-99` Deleted - `0` Inactive - `1` Active - `85` Locked (typically due to multiple failed login attempts) - `AdditionalData` (map from string to string, optional) — Custom dictionary of key:value pairs. You can use this field to store any data related to the object or for your system. If you are using [custom identifiers](/developers/developer-guides/entities-customers), pass those in this object. Max length for a value is 100 characters. ```json { "additionalData": { "key1": "value1", "key2": "value2", "key3": "value3" } } ``` - `DeviceId` (string, optional) — Identifier of registered cloud device used in the transaction. - `EntrypageId` (long, optional) — If applicable, the internal reference ID to the payment page associated with the transaction. - `ExternalProcessorInformation` (string, optional) — Information from the external processor about the transaction. - `FeeAmount` (double, optional) — Service fee or sub-charge applied. - `GatewayTransId` (string, optional) — Internal identifier used for processing. - `invoiceData` (object, optional) - `AdditionalData` (map from string to string, optional) — Custom dictionary of key:value pairs. You can use this field to store any data related to the object or for your system. If you are using [custom identifiers](/developers/developer-guides/entities-customers), pass those in this object. Max length for a value is 100 characters. ```json { "additionalData": { "key1": "value1", "key2": "value2", "key3": "value3" } } ``` - `attachments` (list of object, optional) — Array of `fileContent` objects with attached documents. Max upload size is 30 MB. - `fContent` (string, optional) — Content of file, Base64-encoded. Ignored if `furl` is specified. Max upload size is 30 MB. - `filename` (string, optional) — The name of the attached file. - `ftype` (enum, optional) — The MIME type of the file (if content is provided). - Allowed values: `pdf`, `doc`, `docx`, `jpg`, `jpeg`, `png`, `gif`, `txt` - `furl` (string, optional) — Optional URL provided to show or download the file remotely. - `company` (string, optional) — Company name of the recipient of the invoice. - `discount` (double, optional) — Discount applied to the invoice. - `dutyAmount` (double, optional) — Duty amount. - `firstName` (string, optional) — First name of the recipient of the invoice. - `freightAmount` (double, optional) — Freight/shipping amount. - `frequency` (enum, optional) — Frequency of scheduled invoice. - Allowed values: `onetime`, `weekly`, `every2weeks`, `every6months`, `monthly`, `every3months`, `annually`, `firstofmonth`, `fifteenthofmonth`, `endofmonth` - `invoiceAmount` (double, optional) — The invoice amount. - `invoiceDate` (date, optional) — Invoice date in any of the accepted formats: YYYY-MM-DD, MM/DD/YYYY. - `invoiceDueDate` (date, optional) — Invoice due date in one of the accepted formats: YYYY-MM-DD, MM/DD/YYYY. - `invoiceEndDate` (date, optional) — Indicate the date to finish a scheduled invoice cycle (`invoiceType`` = 1) in any of the accepted formats: YYYY-MM-DD, MM/DD/YYYY. - `invoiceNumber` (string, optional) — Invoice number. Identifies the invoice under a paypoint. - `invoiceStatus` (integer, optional) — Invoice status code. - `invoiceType` (integer, optional) — Invoice type. Value `0` is for single/one-time invoices, `1` for scheduled invoices. - `items` (list of object, optional) — Array of line items included in the invoice. - `itemCategories` (list of string, optional) — Array of tags classifying item or product. - `itemCommodityCode` (string, optional) — Item or product commodity code. Max length of 250 characters. - `itemCost` (double, optional) — Item or product price per unit. - `itemDescription` (string, optional) — Item or product description. Max length of 250 characters. - `itemMode` (integer, optional) — Internal class of item or product: value `0` is only for invoices, `1` for bills, and `2` is common for both. Required on invoice line items — invoice creation fails with `Invalid item data` if it's omitted. - `itemProductCode` (string, optional) — Item or product code. Max length of 250 characters. - `itemProductName` (string, optional) — Item or product name. Max length of 250 characters. - `itemQty` (integer, optional) — Quantity of item or product. - `itemTaxAmount` (double, optional) — Tax amount applied to item or product. - `itemTaxRate` (double, optional) — Tax rate applied to item or product. - `itemTotalAmount` (double, optional) — Per-line total for this item (unit cost times quantity). Distinct from the invoice's overall total, `invoiceAmount`. Required on invoice line items. - `itemUnitOfMeasure` (string, optional) — Unit of measurement. Max length of 100 characters. - `lastName` (string, optional) — Last name of the recipient of the invoice. - `notes` (string, optional) — Notes included in the invoice. - `paymentTerms` (enum, optional) — Payment terms for invoice. If no terms are defined, then response data for this field defaults to `NET30`. Mirrors the values in [`Terms`](#schema-terms). - Allowed values: `PIA`, `CIA`, `UR`, `NET10`, `NET20`, `NET30`, `NET45`, `NET60`, `NET90`, `EOM`, `MFI`, `5MFI`, `10MFI`, `15MFI`, `20MFI`, `2/10NET30`, `UF`, `10UF`, `20UF`, `25UF`, `50UF` - `purchaseOrder` (string, optional) — Purchase order number. - `shippingAddress1` (string, optional) — The shipping address. - `shippingAddress2` (string, optional) — Additional line for shipping address. - `shippingCity` (string, optional) — Shipping city. - `shippingCountry` (string, optional) — Shipping address country. - `shippingEmail` (string, optional) — Shipping recipient's contact email address. - `shippingFromZip` (string, optional) — Sender shipping ZIP code. - `shippingPhone` (string, optional) — Recipient phone number. - `shippingState` (string, optional) — Shipping state or province. - `shippingZip` (string, optional) — Shipping ZIP code. For Pay In functions, this field supports 5-digit and 9-digit ZIP codes and alphanumeric Canadian postal codes. For example: `37615-1234` or `37615`. - `summaryCommodityCode` (string, optional) — Commodity code. - `tax` (double, optional) — Tax rate in percent applied to the invoice. - `termsConditions` (string, optional) — Custom terms and conditions included in the invoice. - `Method` (string, optional) — Payment method used: card, ach, or wallet. - `NetAmount` (double, optional) — Net amount paid. - `Operation` (string, optional) — The transaction's operation. - `OrderId` (string, optional) — Custom identifier for the transaction. - `OrgId` (long, optional) — ID of immediate parent organization. - `ParentOrgName` (string, optional) — The name of the parent organization. - `PaymentData` (object, optional) - `AccountExp` (string, optional) — Expiration date of card used in transaction. - `accountId` (string, optional) — Custom identifier for payment connector. - `AccountType` (string, optional) — Bank account type or card brand. - `AccountZip` (string, optional) — ZIP code for card used in transaction. - `binData` (object, optional) — 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. - `binMatchedLength` (string, optional) — The number of characters from the beginning of the card number that were matched against a Bank Identification Number (BIN) or the Card Range table. - `binCardBrand` (string, optional) — The card brand. For example, Visa, Mastercard, American Express, Discover. - `binCardType` (string, optional) — The type of card: `Credit` or `Debit`. Case can vary between processors, so compare this value case-insensitively. - `binCardCategory` (string, optional) — The category of the card, which indicates the card product. For example: Standard, Gold, Platinum, etc. The binCardCategory for prepaid cards is marked `PREPAID`. - `binCardIssuer` (string, optional) — The name of the financial institution that issued the card. - `binCardIssuerCountry` (string, optional) — The issuing financial institution's country name. - `binCardIssuerCountryCodeA2` (string, optional) — The issuing financial institution's two-character ISO country code. See [this resource](https://www.iso.org/obp/ui/#search) for a list of codes. - `binCardIssuerCountryNumber` (string, optional) — The issuing financial institution's ISO standard numeric country code. See [this resource](https://www.iso.org/obp/ui/#search) for a list of codes. - `binCardIsRegulated` (string, optional) — Indicates whether the card is regulated. - `binCardUseCategory` (string, optional) — The use category classification for the card. - `binCardIssuerCountryCodeA3` (string, optional) — The issuing financial institution's three-character ISO country code. See [this resource](https://www.iso.org/obp/ui/#search) for a list of codes. - `HolderName` (string, optional) — The cardholder name. - `Initiator` (string, optional) — The transaction's initiator. Indicates who initiated the transaction. - `MaskedAccount` (string, optional) — Masked card or bank account used in transaction. In the case of Apple Pay, this is a masked DPAN (device primary account number). - `orderDescription` (string, optional) — Text description of the transaction. - `paymentDetails` (object, optional) — Details about the payment. - `totalAmount` (double, required) — Total amount to be charged. If a service fee is sent, then this amount should include the service fee." - `categories` (list of object, optional) — Array of payment categories/line items describing the amount to be paid. **Note**: These categories are for information only and aren't validated against the total amount provided. - `amount` (double, required) — Price/cost per unit of item or category. - `label` (string, required) — Name of item or category. - `description` (string, optional) — Description of item or category - `qty` (integer, optional, default: 1) — Quantity of item or category - `checkImage` (map from string to any, optional) — Object containing image of paper check. - `checkNumber` (string, optional) — A check number to be used in the ach transaction. **Required** for payment method = 'check'. - `currency` (string, optional) — The currency for the transaction, `USD` or `CAD`. If your paypoint is configured for CAD, you must send the `CAD` value in this field, otherwise it defaults to USD, which will cause the transaction to fail. - `serviceFee` (double, optional) — 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. - `splitFunding` (list of object, optional) — Split funding instructions for the transaction. See [Split a Transaction](/developers/developer-guides/money-in-split-funding) for more. - `accountId` (string, optional) — The accountId for the account the split should be sent to. - `amount` (double, optional) — Amount from the transaction to send to this recipient. - `description` (string, optional) — A description for the split. - `recipientEntryPoint` (string, optional) — The entrypoint the split should be sent to. - `checkUniqueId` (string, optional) — Unique identifier for a processed check image. Required for RDC (Remote Deposit Capture) transactions where `achCode` is `BOC`. Use the `id` value from the [check processing](/developers/api-reference/moneyin/check-capture) response. - `Sequence` (string, optional) — 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](/guides/pay-in-transactions-cit-mit-overview) for more information. - `SignatureData` (string, optional) - `StoredId` (string, optional) — Identifier of stored payment method used in transaction. - `StoredMethodUsageType` (string, optional) — **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`: One-time or otherwise not pre-scheduled. - `subscription`: Subscription payments. For example, monthly rental fees or ongoing service subscriptions. - `recurring`: Recurring payments per a set plan. For example, splitting an HOA special assessment over 6 monthly payments. See [Understanding CIT and MIT Indicators](/guides/pay-in-transactions-cit-mit-overview) for more information. - `PaymentTransId` (string, optional) — Unique Transaction ID. - `PayorId` (long, optional) — Unique ID for the customer linked to the transaction. This is the same value as the `customerId` used when creating or referencing a customer. - `PaypointDbaname` (string, optional) — Paypoint's DBA name. - `PaypointEntryname` (string, optional) — Paypoint's entryname. - `PaypointId` (long, optional) — InternalId for paypoint. - `PaypointLegalname` (string, optional) — Paypoint's legal name. - `PendingFeeAmount` (double, optional) — The difference between the configured pass-through fee and the fee amount sent in the request. When transferring 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](/guides/pay-in-payor-fees-overview#fee-configuration) to learn more about pass-through fee settings. - `RefundId` (long, optional) — Identifier of refund transaction linked to this payment. - `ResponseData` (object, optional) — The transaction's response data. - `authcode` (string, optional) — Authorization code for the transaction. - `avsresponse` (string, optional) — Text code describing the result for address validation (applies only for card transactions). - `avsresponse_text` (string, optional) — Text code describing the result for address validation (applies only for card transactions). - `cvvresponse` (string, optional) — Text code describing the result for CVV validation (applies only for card transactions). - `cvvresponse_text` (string, optional) — Text code describing the result for CVV validation (applies only for card transactions). - `emv_auth_response_data` (string, optional) — EMV authorization response data, applicable for card transactions. - `orderid` (string, optional) — Custom identifier for the transaction. - `response` (string, optional) — Response text for operation: 'Success' or 'Declined'. - `response_code` (string, optional) — Internal result code processing the transaction. Value 1 indicates successful operation, values 2 and 3 indicate errors. - `response_code_text` (string, optional) — Text describing the result. If resultCode = 1, will return 'Approved' or a general success message. If resultCode = 2 or 3, will contain the cause of the decline. - `responsetext` (string, optional) — Text describing the result. If resultCode = 1, will return 'Approved' or a general success message. If resultCode = 2 or 3, will contain the cause of the decline. - `resultCode` (string, optional) — Unified result code for the transaction. See [Pay In unified response codes](/guides/pay-in-unified-response-codes-reference) for more information. - `resultCodeText` (string, optional) — Description of the result code. See [Pay In unified response codes](/guides/pay-in-unified-response-codes-reference) for more information. - `transactionid` (string, optional) — The transaction identifier in Payabli. - `type` (string, optional) — Type of transaction or operation. - `ReturnedId` (long, optional) — Identifier of return/chargeback transaction linked to this payment. - `ScheduleReference` (long, optional) — Reference to the subscription that originated the transaction. - `SettlementStatus` (integer, optional) — Settlement status for transaction. See [the docs](/developers/references/money-in-statuses#payment-funding-status) for a full reference. - `Source` (string, optional) — Custom identifier to indicate the transaction or request source. - `splitFundingInstructions` (list of object, optional) — Split funding instructions for the transaction. The total amount of the splits must match the total amount of the transaction. - `accountId` (string, optional) — The accountId for the account the split should be sent to. - `amount` (double, optional) — Amount from the transaction to send to this recipient. - `description` (string, optional) — A description for the split. - `recipientEntryPoint` (string, optional) — The entrypoint the split should be sent to. - `TotalAmount` (double, optional) — Transaction total amount (including service fee or sub-charge) - `TransactionEvents` (list of object, optional) — Events associated with this transaction. - `TransEvent` (string, optional) — Event descriptor. See [TransEvent Reference](/guides/pay-in-transevents-reference) for more details. - `EventData` (map from string to any or string, optional) — Any data associated to the event received from processor. Contents vary by event type. - `EventTime` (datetime, optional) — Date and time of event. - `TransAdditionalData` (any, optional) - `TransStatus` (integer, optional) — Status of transaction. See [the docs](/developers/references/money-in-statuses#money-in-transaction-status) for a full reference. - `Summary` (object, optional) - `pageIdentifier` (string, optional) — Auxiliary validation used internally by payment pages and components. - `pageSize` (integer, optional) — Number of records on each response page. - `totalAmount` (double, optional) — Total amount for the records. - `totalNetAmount` (double, optional) — Total net amount for the records. - `totalPages` (integer, optional) — Total number of records in response. - `totalRecords` (integer, optional) — Total number of records in response. ## Examples ### Example **Response** ```json { "Records": [ { "splitCount": 1, "TransactionTime": "2025-10-19T00:00:00Z", "AchHolderType": "personal", "AchSecCode": "AchSecCode", "BatchAmount": 30.22, "BatchNumber": "batch_226_ach_12-30-2023", "CfeeTransactions": [ { "transactionTime": "2024-01-15T09:30:00Z" } ], "ConnectorName": "gp", "DeviceId": "499585-389fj484-3jcj8hj3", "EntrypageId": 0, "ExternalProcessorInformation": "[MER_xxxxxxxxxxxxxx]/[NNNNNNNNN]", "FeeAmount": 1, "GatewayTransId": "TRN_xwCAjQorWAYX1nAhAoHZVfN8iYHbI0", "Method": "ach", "NetAmount": 3762.87, "Operation": "Sale", "OrderId": "O-5140", "OrgId": 123, "ParentOrgName": "PropertyManager Pro", "PaymentData": { "orderDescription": "Monthly subscription", "paymentDetails": { "totalAmount": 100 } }, "PaymentTransId": "226-fe55ec0348e34702bd91b4be198ce7ec", "PayorId": 1551, "PaypointDbaname": "Sunshine Gutters", "PaypointEntryname": "d193cf9a46", "PaypointId": 3040, "PaypointLegalname": "Sunshine Services, LLC", "PendingFeeAmount": 2, "RefundId": 0, "ResponseData": { "authcode": " ", "avsresponse": " ", "avsresponse_text": "", "cvvresponse": " ", "cvvresponse_text": " ", "emv_auth_response_data": " ", "orderid": null, "response": "Success", "response_code": "100", "response_code_text": "Transaction was approved.", "responsetext": "CAPTURED", "resultCode": "A0000", "resultCodeText": "Approved", "transactionid": "TRN_xwCAjQorWAYX1nAhAoHZVfN8iYHbI0" }, "ReturnedId": 0, "ScheduleReference": 0, "SettlementStatus": 2, "Source": "api", "splitFundingInstructions": [ {} ], "TotalAmount": 30.22, "TransactionEvents": [ {} ], "TransAdditionalData": { "key": "value" }, "TransStatus": 1 } ], "Summary": { "pageIdentifier": "null", "pageSize": 20, "totalAmount": 77.22, "totalNetAmount": 77.22, "totalPages": 2, "totalRecords": 2 } } ``` **SDK Code** ```typescript Example import { PayabliClient } from "@payabli/sdk-node"; async function main() { const client = new PayabliClient(); await client.query.listTransactionsOrg(123, { fromRecord: 251, limitRecord: 0, sortBy: "desc(field_name)", }); } main(); ``` ```python Example from payabli import payabli client = payabli() client.query.list_transactions_org( org_id=123, from_record=251, limit_record=0, sort_by="desc(field_name)", ) ``` ```java Example package com.example.usage; import io.github.payabli.api.PayabliApiClient; import io.github.payabli.api.resources.query.requests.ListTransactionsOrgRequest; public class Example { public static void main(String[] args) { PayabliApiClient client = PayabliApiClient .builder() .build(); client.query().listTransactionsOrg( 123, ListTransactionsOrgRequest .builder() .fromRecord(251) .limitRecord(0) .sortBy("desc(field_name)") .build() ); } } ``` ```ruby Example require "payabli" client = Payabli::Client.new client.query.list_transactions_org( org_id: 123, from_record: 251, limit_record: 0, sort_by: "desc(field_name)" ) ``` ```csharp Example using PayabliApi; using System.Threading.Tasks; namespace Usage; public class Example { public async Task Do() { var client = new PayabliApiClient(); await client.Query.ListTransactionsOrgAsync( 123, new ListTransactionsOrgRequest { FromRecord = 251, LimitRecord = 0, SortBy = "desc(field_name)" } ); } } ``` ```go Example package example import ( context "context" payabli "github.com/payabli/sdk-go" client "github.com/payabli/sdk-go/client" ) func do() { client := client.NewClient() request := &payabli.ListTransactionsOrgRequest{ FromRecord: payabli.Int( 251, ), LimitRecord: payabli.Int( 0, ), SortBy: payabli.String( "desc(field_name)", ), } client.Query.ListTransactionsOrg( context.TODO(), 123, request, ) } ``` ```php Example query->listTransactionsOrg( 123, new ListTransactionsOrgRequest([ 'fromRecord' => 251, 'limitRecord' => 0, 'sortBy' => 'desc(field_name)', ]), ); ``` ```swift Example import Foundation let request = NSMutableURLRequest(url: NSURL(string: "https://api-sandbox.payabli.com/api/Query/transactions/org/123?fromRecord=251&limitRecord=0&sortBy=desc%28field_name%29")! as URL, cachePolicy: .useProtocolCachePolicy, timeoutInterval: 10.0) request.httpMethod = "GET" let session = URLSession.shared let dataTask = session.dataTask(with: request as URLRequest, completionHandler: { (data, response, error) -> Void in if (error != nil) { print(error as Any) } else { let httpResponse = response as? HTTPURLResponse print(httpResponse) } }) dataTask.resume() ``` ### Card reject query **Response** ```json { "Records": [ { "splitCount": 1, "TransactionTime": "2026-03-02T18:56:23.109188", "ConnectorName": "GP", "Customer": { "FirstName": "Blaise", "LastName": "Pascal", "CompanyName": "Pensees LLC", "BillingAddress1": "49912 Aufengrupt Pointe", "BillingAddress2": "apt 6", "BillingCity": "South Litzy", "BillingState": "FL", "BillingZip": "33000", "BillingCountry": "US", "BillingPhone": "+18955791994", "BillingEmail": "blaise.pascal@gmail.com", "CustomerNumber": "C-90010", "customerId": 4440, "customerStatus": 1 }, "FeeAmount": 0, "Method": "card", "NetAmount": -6.79, "Operation": "Reject", "OrgId": 123, "ParentOrgName": "RealistRoofing", "PaymentData": { "AccountExp": "12/29", "binData": { "binMatchedLength": "9", "binCardBrand": "MASTERCARD", "binCardType": "CREDIT", "binCardCategory": "MIXED PRODUCT", "binCardIssuer": "ALLIED IRISH BANKS, PLC", "binCardIssuerCountry": "IRELAND", "binCardIsRegulated": "False", "binCardUseCategory": "PERSONAL" }, "HolderName": "RENEE DESCARTES", "MaskedAccount": "5XXXXXXXXXXX4415", "orderDescription": "Invoice 2034", "paymentDetails": { "totalAmount": 6.79, "currency": "USD", "serviceFee": 0 } }, "PaymentTransId": "399-8e7e5fc7-f483-43cc-9e78-d8a36ac857bf", "PayorId": 155974, "PaypointDbaname": "Eagle-Pointe", "PaypointEntryname": "entry399", "PaypointId": 3040, "PaypointLegalname": "Eagle-Pointe", "SettlementStatus": 0, "Source": "api", "splitFundingInstructions": [ {} ], "TotalAmount": -6.79, "TransactionEvents": [ { "TransEvent": "Created", "EventData": "Card Reject - CTDR Id: 1379241", "EventTime": "2026-03-02T18:56:23.352035" } ], "TransStatus": -4 } ], "Summary": { "pageSize": 1, "totalAmount": -79.48, "totalNetAmount": -74.41, "totalPages": 14, "totalRecords": 14 } } ``` **SDK Code** ```typescript Card reject query import { PayabliClient } from "@payabli/sdk-node"; async function main() { const client = new PayabliClient(); await client.query.listTransactionsOrg(123, { limitRecord: 1, parameters: { "operation(eq)": "Reject", }, }); } main(); ``` ```python Card reject query from payabli import payabli client = payabli() client.query.list_transactions_org( org_id=123, limit_record=1, parameters={ "operation(eq)": "Reject" }, ) ``` ```java Card reject query package com.example.usage; import io.github.payabli.api.PayabliApiClient; import io.github.payabli.api.resources.query.requests.ListTransactionsOrgRequest; import java.util.HashMap; import java.util.Optional; public class Example { public static void main(String[] args) { PayabliApiClient client = PayabliApiClient .builder() .build(); client.query().listTransactionsOrg( 123, ListTransactionsOrgRequest .builder() .limitRecord(1) .parameters( new HashMap>() {{ put("operation(eq)", Optional.of("Reject")); }} ) .build() ); } } ``` ```ruby Card reject query require "payabli" client = Payabli::Client.new client.query.list_transactions_org( org_id: 123, limit_record: 1, parameters: { "operation(eq)" => "Reject" } ) ``` ```csharp Card reject query using PayabliApi; using System.Threading.Tasks; using System.Collections.Generic; namespace Usage; public class Example { public async Task Do() { var client = new PayabliApiClient(); await client.Query.ListTransactionsOrgAsync( 123, new ListTransactionsOrgRequest { LimitRecord = 1, Parameters = new Dictionary(){ ["operation(eq)"] = "Reject", } } ); } } ``` ```go Card reject query package example import ( context "context" payabli "github.com/payabli/sdk-go" client "github.com/payabli/sdk-go/client" ) func do() { client := client.NewClient() request := &payabli.ListTransactionsOrgRequest{ LimitRecord: payabli.Int( 1, ), Parameters: map[string]*string{ "operation(eq)": payabli.String( "Reject", ), }, } client.Query.ListTransactionsOrg( context.TODO(), 123, request, ) } ``` ```php Card reject query query->listTransactionsOrg( 123, new ListTransactionsOrgRequest([ 'limitRecord' => 1, 'parameters' => [ 'operation(eq)' => 'Reject', ], ]), ); ``` ```swift Card reject query import Foundation let request = NSMutableURLRequest(url: NSURL(string: "https://api-sandbox.payabli.com/api/Query/transactions/org/123?limitRecord=1¶meters=%7B%22operation%28eq%29%22%3A%22Reject%22%7D")! as URL, cachePolicy: .useProtocolCachePolicy, timeoutInterval: 10.0) request.httpMethod = "GET" let session = URLSession.shared let dataTask = session.dataTask(with: request as URLRequest, completionHandler: { (data, response, error) -> Void in if (error != nil) { print(error as Any) } else { let httpResponse = response as? HTTPURLResponse print(httpResponse) } }) dataTask.resume() ```