Get list of transactions

get

https://gateway.stage.bill.com/connect/v3/spend/transactions

Get a list of transaction objects. By default, you get 20 results on one page of results. Set max in your request to get up to 50 results on one page.

In the response, you get information about transactions, reversals, and refunds.

Transaction: For a transaction, transactionType is set as AUTHORIZATION or DECLINE. The field is set as CLEAR after BILL has moved money from the funding account.
Reversal: For a reversal (cancel before funds are settled), transactionType is set as AUTHORIZATION and amount is a negative value.
Refund: For a refund (cancel after funds are settled), transactionType is set as CLEAR and amount is a negative value.

Note: Only parent transactions are available in the response.

Query Params

max

int64 | null

1 to 50

Maximum number of results

string | null

Next page of results.

When a list has multiple pages, the nextPage and prevPage values in the response enable you to navigate between the pages of results. Set this field as the nextPage value for navigation.

string | null

Previous page of results. Set this field as the prevPage value for navigation.

sort

string | null

Field name and sort order. You can set only one sort field.

The format is sort={field}:{sort_order}.

The sortable fields are:

amount
merchantName
occurredTime

filters

string | null

Field name, operator, and value. You can set multiple filters.

The format is filters={field_01}:{op}:{value},{field_02}:{op}:{value}.

Example: filters=cardId:eq:MyCardID,userId:in:"123,456"

The filterable fields are:

cardId - List of string IDs or UUIDs. Operators: eq, in.
merchantName - String. Operators: eq.
userId - List of string IDs or UUIDs. Operators: eq, in.
budgetId - List of string IDs or UUIDs. Operators: eq, in.
fees - Number with 2 decimal places. Operators: lte, gte.
transactionIds - List of string IDs or UUIDs. Operators: eq, in.
customFieldIds - List of string IDs or UUIDs. Operators: eq, in.
customFieldValueIds - List of string IDs or UUIDs. Operators: eq, in. Note: Use customFieldIds and customFieldValueIds to filter transactions based on custom fields. Use the showCustomFieldIds query parameter to control which custom fields are shown for each transaction.
receiptStatus - VALIDATED, NOT_VALIDATED, ATTACHED, MISSING, NOT_REQUIRED, NOT_ATTACHED. Operators: eq, ne, in, nin.
type - CLEAR, DECLINE, AUTHORIZATION, OTHER. Operators: eq, ne, in, nin.
occurredTime - DateTime. Operators: lte, gte.
authorizedTime - DateTime. Operators: lte, gte.
updatedTime - DateTime. Operators: lte, gte.
isLocked - true or false. Operators: eq.
complete - true or false. Operators: eq.
amount - Number with 2 decimal places. Operators: lte, gte.
isReviewed - true or false. Operators: eq.
syncStatus - PENDING, SYNCED, ERROR, MANUAL_SYNCED, NOT_SYNCED. Operators: eq, ne, in, nin.

showCustomFieldIds

string | null

List of BILL-generated IDs of custom fields to be displayed for each transaction. Set the IDs as comma-separated values. By default, all the custom fields are displayed for all transactions.

NOTE: Use customFieldIds and customFieldValueIds to filter transactions based on custom fields.

includeReceipts

boolean | null

Set as true to include transaction receipts in the response. By default, receipts are not included in the response.

Headers

apiToken

string | null

Access token for Spend & Expense API authentication

Responses

200Get list of transactions response

4XXList of errors.

5XXList of errors.