Export list of transactions for an org

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

Format for the export, either XLSX or CSV.

The numeric identifier for organization, assigned by Payabli.

Optional parameter for mapping source column names to custom export column names. The format is sourceColumn:exportColumn,sourceColumn2:exportColumn2. Supported columns are:

• PaymentTransId
• transactionid
• OrderId
• Method
• CompanyName
• FirstName
• LastName
• CustomerNumber
• BillingAddress1
• BillingAddress2
• BillingCity
• BillingCountry
• BillingEmail
• BillingPhone
• BillingState
• BillingZip
• GatewayTransId
• ShippingAddress1
• ShippingAddress2
• ShippingCity
• ShippingState
• ShippingZip
• ShippingCountry
• TransStatus
• PaypointId
• TotalAmount
• NetAmount
• SettlementStatus
• FeeAmount
• Operation
• Source
• OrgId
• TransactionTime
• EntrypageId
• ScheduleReference
• MaskedAccount
• AccountType
• ParentOrgName
• PaypointDbaname
• PaypointLegalname
• externalPaypointID
• BatchNumber
• BatchAmount
• invoiceNumber
• orderDescription
• accountId
• ConnectorName
• serviceFee
• PendingFeeAmount
• RiskFlagged
• RiskFlaggedOn
• RiskAction
• RiskActionCode
• RiskStatus
• RiskReason
• DeviceId

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

See Filters and Conditions Reference for help.

List of field names accepted:

• transactionDate (gt, ge, lt, le, eq, ne)
• transId (ne, eq, ct, nct)
• gatewayTransId (ne, eq, ct, nct)
• orderId (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)
• 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)
• status (in, nin, eq, ne)
• settlementStatus (in, nin, eq, ne)
• batchNumber (nct, ct)
• payaccountLastfour (nct, ct)
• payaccountType (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)
• additional-xxx (ne, eq, ct, nct) where xxx is the additional field name

List of comparison accepted - enclosed between parentheses:

• 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

List of parameters accepted:

• limitRecord : max number of records for query (default="20", "0" or negative value for all)
• fromRecord : initial record in query

Example: netAmount(gt)=20 return all records with netAmount greater than 20.00