Skip to main content

List BILL Bills

GET 
/api/billcom/bills

List the bills mirrored from a BILL.com organization — both bills pushed from SKU.io and bills discovered in BILL — with the SKU.io bill or purchase invoice each one is linked to.

Not yet available to API tokens

This endpoint currently requires session authentication; Personal Access Token scope support is in progress.

Authentication: Requires Bearer token.

Required: integration_instance_id — the BILL.com instance to read. An unknown ID returns 404.

Search: filter[search] matches the bill ID (exact, numeric values only), invoice number, BILL bill ID and the BILL vendor name. Restrict it with search_columns (id, invoice_number, billcom_id, vendor_name) and force exact matching with search_strict_columns.

Filters: each column below can be filtered with filter[{column}.{operator}]=value (a bare filter[{column}]=value is an implicit is), or combined into an AND/OR tree passed as filter_groups — base64-encoded JSON shaped like {"conjunction":"and","children":[{"type":"condition","condition":{"column":"…","operator":"is","value":"…"}}]}. A column/operator pair that is not listed returns HTTP 400.

Filterable columns: payment_status, origin, invoice_number, billcom_id, vendor_name, linked (value true or false) — text; id, amount, paid_amount — numeric; invoice_date, due_date — date (Y-m-d).

Operators: text columns accept contains, does_not_contain, is, is_not, is_one_of, is_not_one_of, starts_with, does_not_start_with, ends_with, does_not_end_with, is_empty, is_not_empty; numeric columns accept is, is_not, is_one_of, is_not_one_of, greater_than, less_than, greater_than_or_equal, less_than_or_equal, between, is_empty, is_not_empty; date and date-time columns accept is, is_not, before, after, on_or_before, on_or_after, between, is_empty, is_not_empty, today, yesterday, tomorrow.

Sorting: sort, prefix with - for descending. Default -id. Allowed: id, invoice_number, invoice_date, due_date, amount, paid_amount, payment_status, origin, vendor_name.

Pagination: page, per_page (default 10).

Response fields: vendor_name is the BILL vendor name (null when the vendor has not been synced). link_type_label is Bill or Purchase Invoice; link_id, link_reference (the invoice number of the linked document) and link_route (its path in the SKU.io app) identify it. All four are null for an unlinked bill. view_in_bill_url opens the bill in BILL.com.

Request​

Responses​

OK

Response Headers
    Content-Type