GET
/
Export
/
bills
/
{format}
/
{entry}

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

​
format
enum<string>
required

Format for the export, either XLSX or CSV.

Available options:
csv,
xlsx
​
entry
string
required

The paypoint's entrypoint identifier. Learn more

Query Parameters

​
columnsExport
string

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

  • BillNumber
  • BillDate
  • DueDate
  • NetAmount
  • Status
  • BatchNumber
  • AccountingField1
  • AccountingField2
  • VendorNumber
  • LocationCode
  • Name1
  • Name2
  • Address1
  • Address2
  • City
  • State
  • Zip
  • Country
  • PaypointDbaname
  • PaypointLegalname
  • ParentOrgName
  • PaymentMethod
  • PaymentId
  • externalPaypointID
  • LotNumber
​
parameters
object

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

See Filters and Conditions Reference for help.

List of field names accepted:

  • status (in, nin, eq, ne)
  • billNumber (ct, nct, eq, ne)
  • billDate (gt, ge, lt, le, eq, ne)
  • billDueDate (gt, ge, lt, le, eq, ne)
  • vendorNumber (ct, nct, eq, ne)
  • vendorName (ct, nct, eq, ne)
  • ein (ct, nct, eq, ne)
  • paymentMethod (ct, nct, eq, ne)
  • paymentId (ct, nct, eq, ne)
  • paymentgroup (ct, nct, eq, ne)
  • totalAmount (gt, ge, lt, le, eq, ne)
  • paypointLegal (ne, eq, ct, nct)
  • paypointDba (ne, eq, ct, nct)
  • orgName (ne, eq, ct, nct)

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: totalAmount(gt)=20 return all records with totalAmount greater than 20.00

Response

200 - application/json

The returned file includes the data exported. For the bills export, the file includes these headers:

  • BillNumber
  • BillDate
  • BillDueDate
  • Amount
  • Status
  • BatchNumber
  • AccountingField1
  • AccountingField2
  • VendorNumber
  • LocationCode
  • VendorName1
  • VendorName2
  • VendorAddress1
  • VendorAddress2
  • VendorCity
  • VendorState
  • VendorZip
  • VendorCountry
  • PaypointDbaName
  • PaypointLegalName
  • ParentOrgName
  • PaymentMethod
  • PaymentId
  • externalPaypointID
  • LotNumber

Was this page helpful?

Export vendors for an organizationExport list of bills for organization