Appearance

List Accounts ​

Endpoint ​

http
GET /unified/accounting/accounts
Integrations supported
  • Coupa
  • FreeAgent
  • Microsoft Dynamics 365 Business Central
  • Oracle Netsuite
  • QuickBooks
  • Wave
  • Xero
  • Zoho Books
Partial response integrations

For partial response integrations, you will need to fetch the individual resource using the "get" endpoint to get the full response object.

  • Xero

Query parameters ​

Refer Specifying query parameters in Truto APIs

integrated_account_id
string · uuid
REQUIRED · 

The ID of the integrated account to use for the request.

Example: 62f44730-dd91-461e-bd6a-aedd9e0ad79d
truto_response_format
string

The format of the response.

  • unified will return the response with unified mappings applied.
  • raw will return the raw response from the remote API.
  • normalized will apply the unified mappings and return the data in a normalized format.

Defaults to unified.

All possible enum values:
  • unified
  • raw
  • normalized
Example: unified
truto_key_by
string

By default the result attribute is an array of objects. This parameter allows you to specify a field in each result objects to use as key, which transforms the result array into an object with the array items keyed by the field. This is useful for when you want to use the result as a lookup table.

Example: id
truto_ignore_limit
boolean

Ignores the limit query parameter.

truto_ignore_remote_data
boolean

Excludes the remote_data attribute from the response.

truto_exclude_fields
array

Array of fields to exclude from the response.

Example: truto_exclude_fields[]=id&truto_exclude_fields[]=name
remote_query
object

Query parameters to pass to the underlying API without any transformations. Refer this guide to see how to structure the query parameters.

Example: remote_query[foo]=bar
created_at
string · date-time

This represents the date when the accounts was created

Supported in
  • QuickBooks
  • Xero
updated_at
string · date-time

This represents the date when the accounts was updated

Supported in
  • QuickBooks
  • Xero
status
string

The status of the account. If no clear mapping exists, then raw value is returned.

All possible enum values:
  • active
  • archived
  • pending
Enum support by integration
  • QuickBooks
    • active
    • archived
  • Xero
    • active
    • archived
Supported in
  • QuickBooks
  • Xero
name
string

The name of the account

Supported in
  • QuickBooks
  • Xero
type
string

The more specific classification of the account

All possible enum values:
  • accounts_payable
  • accounts_receivable
  • accumulated_depreciation
  • advertising_expense
  • asset
  • bad_debt_expense
  • bank
  • cash
  • cost_of_goods_sold
  • credit_card
  • current
  • current_liability
  • depreciation
  • direct_costs
  • distribution_to_shareholders
  • equipment
  • equity
  • expense
  • fees_expense
  • fixed
  • fixed_asset
  • income
  • interest_expense
  • inventory
  • liability
  • long_term_liab
  • long_term_liability
  • maintenance_expense
  • other_asset
  • other_current_asset
  • other_current_liability
  • other_expenses
  • other_income
  • other_liability
  • payg_liability
  • payroll_liability
  • pre_payment
  • rent_expense
  • sales
  • super_annuation_expense
  • super_annuation_liability
  • utilities_expense
  • wages_expense
Enum support by integration
  • Xero
    • bank
    • fixed
    • long_term_liab
    • equity
    • expense
    • current
    • current_liability
    • other_income
    • direct_costs
    • other_expenses
    • income
    • other_asset
    • sales
    • pre_payment
    • liability
    • inventory
    • depreciation
    • wages_expense
    • super_annuation_liability
    • super_annuation_expense
    • payg_liability
Supported in
  • Xero
classification
string

The classification of the account. If no clear mapping exists, then raw value is returned.

All possible enum values:
  • asset
  • bank
  • equity
  • expense
  • liability
  • revenue
Required in
  • Microsoft Dynamics 365 Business Central
Supported in
  • Xero
account_number
string

Represents the bank account number if the account is of type bank account.

Supported in
  • Xero
currency
string

The currency of the account

Supported in
  • Xero

Response Body ​

result
object[]

List of Accounts

id
string
REQUIRED · 

The unique identifier for the account

Supported in
  • Coupa
  • FreeAgent
  • Microsoft Dynamics 365 Business Central
  • Oracle Netsuite
  • QuickBooks
  • Wave
  • Xero
  • Zoho Books
name
string
REQUIRED · 

The name of the account

Supported in
  • Coupa
  • Microsoft Dynamics 365 Business Central
  • Oracle Netsuite
  • QuickBooks
  • Wave
  • Xero
  • Zoho Books
description
string

The description of the account

Supported in
  • FreeAgent
  • Oracle Netsuite
  • Wave
  • Zoho Books
classification
string

The classification of the account. If no clear mapping exists, then raw value is returned.

All possible enum values:
  • asset
  • equity
  • expense
  • liability
  • revenue
  • bank
Supported in
  • Microsoft Dynamics 365 Business Central
  • Oracle Netsuite
  • QuickBooks
  • Wave
  • Xero
  • Zoho Books
type
string

The more specific classification of the account

All possible enum values:
  • fixed_asset
  • long_term_liability
  • equity
  • expense
  • bank
  • current
  • current_liability
  • other_income
  • direct_costs
  • other_expenses
  • income
  • other_asset
  • accounts_receivable
  • accounts_payable
  • credit_card
  • sales
  • pre_payment
  • liability
  • inventory
  • depreciation
  • wages_expense
  • super_annuation_liability
  • super_annuation_expense
  • payg_liability
  • payroll_liability
  • asset
  • equipment
  • accumulated_depreciation
  • distribution_to_shareholders
  • cash
  • interest_expense
  • rent_expense
  • utilities_expense
  • maintenance_expense
  • advertising_expense
  • fees_expense
  • bad_debt_expense
  • cost_of_goods_sold
  • other_liability
  • other_current_liability
  • other_current_asset
Supported in
  • Coupa
  • Microsoft Dynamics 365 Business Central
  • Oracle Netsuite
  • QuickBooks
  • Wave
  • Xero
  • Zoho Books
status
string

The status of the account. If no clear mapping exists, then raw value is returned.

All possible enum values:
  • active
  • archived
  • pending
Supported in
  • Coupa
  • Microsoft Dynamics 365 Business Central
  • Oracle Netsuite
  • QuickBooks
  • Wave
  • Xero
  • Zoho Books
current_balance
number

The current balance of the account

Supported in
  • QuickBooks
  • Wave
  • Zoho Books
currency
string

The currency of the account

Supported in
  • Coupa
  • Microsoft Dynamics 365 Business Central
  • QuickBooks
  • Wave
  • Xero
account_number
string

Represents the bank account number if the account is of type bank account.

Supported in
  • Coupa
  • Microsoft Dynamics 365 Business Central
  • QuickBooks
  • Wave
  • Xero
parent_account
string

The ID of the parent account of the account

Supported in
  • Oracle Netsuite
  • QuickBooks
  • Zoho Books
company
string

The ID of the company the account belongs to

Supported in
  • Microsoft Dynamics 365 Business Central
  • Zoho Books
created_at
string · date-time

This represents the date when the accounts was created

Supported in
  • Coupa
  • QuickBooks
  • Zoho Books
updated_at
string · date-time

This represents the date when the accounts was updated

Supported in
  • Coupa
  • Microsoft Dynamics 365 Business Central
  • QuickBooks
  • Xero
  • Zoho Books
remote_data
object

Raw data returned from the remote API call.

next_cursor
string

The cursor to use for the next page of results. Pass this value as next_cursor in the query parameter in the next request to get the next page of results.