For AI agents: a documentation index is available at the root level at /llms.txt and /llms-full.txt. Append /llms.txt to any URL for a page-level index, or .md for the markdown version of any page.
AI agentsStatus PageContact sales
HomeGuidesDeveloper ToolsChangelogsCookbooks
HomeGuidesDeveloper ToolsChangelogsCookbooks
    • Payabli developer overview
    • Developer quickstart
    • Developer testing guide
    • Test accounts
  • API
    • Using the API
    • API responses
    • API changelog
          • POSTCreate invoice
          • GETGet invoice
          • PUTUpdate invoice
          • DELDelete invoice
          • GETSend invoice
          • GETGet invoice attachment
          • DELDelete invoice attachment
          • GETGet next invoice number
          • GETList invoices by paypoint
          • GETList invoices by organization
          • GETExport invoices by paypoint
          • GETExport invoices by org
          • GETGet invoice PDF
    • Webhooks
  • Embedded Components
    • Overview
    • EmbeddedMethod UI
    • PayMethod UI
    • VirtualTerminal UI
    • ExpressCheckout UI
    • Changelog
  • Server SDKs
    • Server SDKs overview
  • Other tools
    • Postman collection
    • Payabli MCP
    • Example apps

© 2026 Centavo, Inc. All rights reserved | Centavo (DBA Payabli) is a registered Payment Facilitator of PNC Bank, N.A., Pittsburgh, PA. Payabli is a registered ISO/MSP of Merrick Bank, South Jordan, UT.

PayabliTest Cards & AccountsPay In StatusesPay Out StatusesTrust Center
LogoLogo
AI agentsStatus PageContact sales
APIPay In endpointsInvoices

List invoices by organization

|View as Markdown|Open in Claude|
GET
/Query/invoices/org/:orgId
GET
/api/Query/invoices/org/:orgId
$curl -G https://api-sandbox.payabli.com/api/Query/invoices/org/123 \
>     -H "requestToken: <apiKey>" \
>     -d fromRecord=251 \
>     -d limitRecord=0 \
>     -d sortBy=desc(field_name)
1{
2  "Records": [
3    {
4      "invoiceId": 3674,
5      "customerId": 1323,
6      "paypointId": 10,
7      "invoiceNumber": "QA-1709680125",
8      "invoiceDate": "2025-03-05",
9      "invoiceDueDate": "2025-03-05",
10      "invoiceSentDate": "2025-03-05",
11      "invoiceEndDate": "2025-03-05",
12      "createdAt": "2024-03-05T18:08:45Z",
13      "invoiceStatus": 1,
14      "invoiceType": 0,
15      "frequency": "onetime",
16      "paymentTerms": "NET30",
17      "termsConditions": null,
18      "notes": null,
19      "invoiceAmount": 50,
20      "invoicePaidAmount": 0,
21      "firstName": "Amirah",
22      "lastName": "Tan",
23      "shippingAddress1": "1234 Rainier Ave",
24      "shippingAddress2": "Apt 567",
25      "shippingCity": "Seattle",
26      "shippingState": "WA",
27      "shippingZip": "98101",
28      "shippingFromZip": "",
29      "shippingCountry": "US",
30      "shippingEmail": "amirah.tan@example.com",
31      "shippingPhone": "",
32      "items": [
33        {
34          "itemCost": 50,
35          "itemDescription": "service",
36          "itemProductName": "Internet",
37          "itemQty": 1
38        }
39      ],
40      "Customer": {
41        "AdditionalData": {
42          "key1": "value",
43          "key2": "value",
44          "key3": "value"
45        },
46        "BillingPhone": "1234567890",
47        "customerId": 1323
48      },
49      "paylinkId": "3674-cf15b881-f276-4b69-bdc8-841b2d123XXXXXX",
50      "PaypointLegalname": "Emerald City LLC",
51      "PaypointDbaname": "Emerald City Trading",
52      "PaypointEntryname": "47a30009s",
53      "ParentOrgId": 123,
54      "ParentOrgName": "Emerald Enterprises",
55      "externalPaypointID": "seattletrade01-10",
56      "tax": 0,
57      "discount": 0,
58      "freightAmount": 0,
59      "dutyAmount": 0,
60      "billEvents": [
61        {
62          "description": "Invoice created",
63          "eventTime": "2024-03-05T23:08:45Z",
64          "refData": "00-802fa578504a7af6f3dd890a3802f7ef-61b4bedXXXX1234"
65        }
66      ]
67    }
68  ],
69  "Summary": {
70    "pageIdentifier": "null",
71    "pageSize": 20,
72    "totalAmount": 77.22,
73    "totalNetAmount": 77.22,
74    "totalPages": 2,
75    "totalRecords": 2
76  }
77}

Returns a list of invoices for an org. Use filters to limit results. Include the exportFormat query parameter to return the results as a file instead of a JSON response.

Was this page helpful?
Previous

List invoices by paypoint

Next

Export invoices by paypoint

Authentication

requestTokenstring
API Key authentication via header

Path parameters

orgIdintegerRequired
The numeric identifier for organization, assigned by Payabli.

Query parameters

exportFormatenumOptional
Export format for file downloads. When specified, returns data as a file instead of JSON.
Allowed values:
fromRecordintegerOptionalDefaults to 0
The number of records to skip before starting to collect the result set.
limitRecordintegerOptionalDefaults to 20

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

parametersmap from strings to nullable stringsOptional
Collection of field names, conditions, and values used to filter the query See [Filters and Conditions Reference](/developers/developer-guides/pay-ops-reporting-engine-overview#filters-and-conditions-reference) for help. List of field names accepted: - `invoiceDate` (gt, ge, lt, le, eq, ne) - `dueDate` (gt, ge, lt, le, eq, ne) - `sentDate` (gt, ge, lt, le, eq, ne) - `frequency` (in, nin,ne, eq) - `invoiceType` (eq, ne) - `payTerms` (in, nin, eq, ne) - `paypointId` (ne, eq) - `totalAmount` (gt, ge, lt, le, eq, ne) - `paidAmount` (gt, ge, lt, le, eq, ne) - `status` (in, nin, eq, ne) - `invoiceNumber` (ct, nct, eq, ne) - `purchaseOrder` (ct, nct, eq, ne) - `itemProductCode` (ct, nct) - `itemDescription` (ct, nct) - `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) - `paylinkId` (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 - 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: totalAmount(gt)=20 return all records with totalAmount greater than 20.00
sortBystringOptional

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

Success. Fields marked optional may return null if not set.

Recordslist of objects
Summaryobject

Errors

400
Bad Request Error
401
Unauthorized Error
500
Internal Server Error
503
Service Unavailable Error

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

See Filters and Conditions Reference for help.

List of field names accepted:

  • invoiceDate (gt, ge, lt, le, eq, ne)
  • dueDate (gt, ge, lt, le, eq, ne)
  • sentDate (gt, ge, lt, le, eq, ne)
  • frequency (in, nin,ne, eq)
  • invoiceType (eq, ne)
  • payTerms (in, nin, eq, ne)
  • paypointId (ne, eq)
  • totalAmount (gt, ge, lt, le, eq, ne)
  • paidAmount (gt, ge, lt, le, eq, ne)
  • status (in, nin, eq, ne)
  • invoiceNumber (ct, nct, eq, ne)
  • purchaseOrder (ct, nct, eq, ne)
  • itemProductCode (ct, nct)
  • itemDescription (ct, nct)
  • 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)
  • paylinkId (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
  • 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: totalAmount(gt)=20 return all records with totalAmount greater than 20.00