Appearance

Get Transactions ​

Endpoint ​

http
GET /unified/accounting/transactions/{id}
Integrations supported
  • Oracle Netsuite
  • QuickBooks
  • Xero
  • Zoho Books

Path parameters ​

id
string
REQUIRED · 

The ID of the resource.

Example: 23423523

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_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
transaction_type
string

The type of the transaction

All possible enum values:
  • credit_card
  • deposit
  • estimate
  • receive
  • receive_overpayment
  • receive_prepayment
  • refund
  • spend
  • spend_overpayment
  • spend_prepayment
  • transfer
Enum support by integration
  • QuickBooks
    • refund
    • deposit
    • estimate
    • transfer
    • credit_card
  • Xero
    • transfer
Required in
  • QuickBooks
  • Xero

Response Body ​

id
string
REQUIRED · 

The unique identifier for transactions

Supported in
  • Oracle Netsuite
  • QuickBooks
  • Xero
  • Zoho Books
number
string

The number of the transaction

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

The type of the transaction

All possible enum values:
  • refund
  • deposit
  • estimate
  • transfer
  • credit_card
  • spend
  • receive
  • receive_overpayment
  • receive_prepayment
  • spend_overpayment
  • spend_prepayment
Supported in
  • Oracle Netsuite
  • Xero
  • Zoho Books
transaction_date
string · date-time

The date upon which the transaction occurred

Supported in
  • Oracle Netsuite
  • QuickBooks
  • Xero
  • Zoho Books
account
string

The account which receives the transaction

Supported in
  • Oracle Netsuite
  • QuickBooks
  • Xero
  • Zoho Books
account_from
string

The account which initiates the transaction

Supported in
  • QuickBooks
  • Xero
contact
string

The contact to whom the transaction relates to

Supported in
  • Oracle Netsuite
  • QuickBooks
  • Xero
  • Zoho Books
total_amount
string

The total amount of the transaction

Supported in
  • Oracle Netsuite
  • QuickBooks
  • Xero
  • Zoho Books
currency
string

The currency of the transaction

Supported in
  • Oracle Netsuite
  • QuickBooks
  • Xero
  • Zoho Books
exchange_rate
string

The exchange rate of the transaction

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

The company the transaction belongs to

Supported in
  • Zoho Books
line_items
object[]
Supported in
  • Oracle Netsuite
  • QuickBooks
  • Xero
  • Zoho Books
id
string

The unique identifier for line item

name
string

The name of the line item

description
string

The description of the line item

item
string

The ID of the item

account
string

The ID of the account

quantity
number

The quantity of the line item

unit_price
number

The unit price of the line item

tax_rate
string

The ID of the tax rate

total_line_amount
number

The total line amount of the line item.

type
string

The type of the line item

tracking_categories
object[]

Tracking categories of the line item

id
string

The ID of the tracking category

name
string

The name of the tracking category

option
string

The option of the tracking category

currency
string

The currency of the line item

exchange_rate
number

The exchange rate of the currency for the line item

tracking_categories
object[]

Tracking categories of the transaction

Supported in
  • QuickBooks
  • Xero
id
string
REQUIRED · 

The unique identifier for tracking categories

name
string

The name of the tracking category

created_at
string · date-time

This represents the date when the transaction was created

Supported in
  • Oracle Netsuite
  • QuickBooks
  • Xero
  • Zoho Books
updated_at
string · date-time

This represents the date when the transaction was updated

Supported in
  • Oracle Netsuite
  • QuickBooks
  • Xero
remote_data
object

Raw data returned from the remote API call.