Appearance

Get Items ​

Endpoint ​

http
GET /unified/accounting/items/{id}
Integrations supported
  • Coupa
  • Microsoft Dynamics 365 Business Central
  • 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 returns the response with unified mappings applied.
  • raw returns the unprocessed, raw response from the remote API.
  • normalized applies the unified mappings and returns the data in a normalized format.
  • stream returns the response as a stream, which is ideal for transmitting large datasets, files, or binary data. Using streaming mode helps to efficiently handle large payloads or real-time data flows without requiring the entire data to be buffered in memory.
  • debug returns the final unified result alongside raw remote fetch information. The response is an envelope containing result (identical to unified mode output) and debug (with requestUrl, requestOptions, data, responseHeaders, and for list operations: nextCursor, isLooping, isEmptyResult, resultCount). debug is null for static responses or when truto_skip_api_call=true.

Defaults to unified.

All possible enum values:
  • unified
  • raw
  • normalized
  • stream
  • debug
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

Response Body ​

id
string
REQUIRED · 

The unique identifier for the item

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

The name of the item

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

The description of the item

Supported in
  • Coupa
  • Oracle Netsuite
  • QuickBooks
  • Xero
  • Zoho Books
status
string

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

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

The quantity of the Item.

Supported in
  • Microsoft Dynamics 365 Business Central
  • Oracle Netsuite
  • QuickBooks
  • Zoho Books
unit_price
number

The unit price of the item

Supported in
  • Coupa
  • Microsoft Dynamics 365 Business Central
  • QuickBooks
  • Xero
  • Zoho Books
purchase_price
number

The purchase price of the item

Supported in
  • Microsoft Dynamics 365 Business Central
  • Oracle Netsuite
  • QuickBooks
  • Xero
  • Zoho Books
purchase_account
string

The ID of the account used to record the purchase of the item

Supported in
  • QuickBooks
  • Xero
  • Zoho Books
sales_account
string

The ID of the account used to record the sale

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

The ID of the account used to record the asset

Supported in
  • Oracle Netsuite
  • QuickBooks
company
string

The ID of the company the item belongs to

References: CompanyInfo → id
Supported in
  • Microsoft Dynamics 365 Business Central
  • Zoho Books
created_at
string · date-time

This represents the date when the item was created

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

This represents the date when the item was updated

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

Raw data returned from the remote API call.