Export list of chargebacks and returned transactions for an organization

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:

• Id
• PaymentTransId
• OrderId
• Method
• CompanyName
• FirstName
• LastName
• CustomerNumber
• BillingAddress1
• BillingAddress2
• BillingCity
• BillingCountry
• BillingEmail
• BillingPhone
• BillingState
• BillingZip
• NetAmount
• ReferenceNumber
• Status
• CaseNumber
• ReasonCode
• Reason
• TransactionTime
• MaskedAccount
• AccountType
• ChargebackDate
• PaypointLegalname
• PaypointDbaname
• ParentOrgName
• ScheduleReference
• externalPaypointID
• accountId
• ReplyByDate

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

See Filters and Conditions Reference for help.

List of field names accepted:

• chargebackDate (gt, ge, lt, le, eq, ne)
• transId (ne, eq, ct, nct)
• method (in, nin, eq, ne)
• netAmount (gt, ge, lt, le, eq, ne)
• reasonCode (in, nin, eq, ne)
• reason (ct, nct, eq, ne)
• caseNumber (ct, nct, eq, ne)
• status (in, nin, eq, ne)
• accountType (in, nin, eq, ne)
• 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)
• orgId (eq) mandatory when entry=org
• paypointId (ne, eq)
• paypointLegal (ne, eq, ct, nct)
• paypointDba (ne, eq, ct, nct)
• orgName (ne, eq, ct, nct)
• 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 separated by "|"
• nin => not inside array separated by "|"

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