Create Item - RootFi

Integrations Roadmap

Data Coverage Tool

General

Overview

Server Side SDKs

Typescript SDK

Core API

Companies
Invite Links
Sync
Passthrough
Real Time
Webhooks

Unified API

Accounting
- Accounts
- Bank Accounts
- Bank Transactions
- Bills
- Bill Payments
- Bill Credit Notes
- Contacts
- Company Info
- Currencies
- Documents
- Expenses
- Invoice Credit Notes
- Invoices
- Invoice Payments
- Items
  - Overview
  - Overview
  - GET
    Get All Items
  - POST
    Get Items
  - POST
    Create Item
  - POST
    Create Items
  - PUT
    Update an Item
- Journal Entries
- Purchase Orders
- Sales Orders
- Goods Receipt Notes
- Projects
- Tax Rates
- Tracking Categories
- Balance Sheet
- Cash Flow Statements
- Income Statements
Payments
Ecommerce
CRM

POST

accounting

items

curl --request POST \
  --url https://api.rootfi.dev/v3/accounting/items \
  --header 'Content-Type: application/json' \
  --header 'api_key: <api-key>' \
  --data '{
  "company_id": 1,
  "data": [
    {
      "name": "Rootfi Test Item",
      "description": "Rootfi Test Item",
      "type": "INVENTORY",
      "code": "1234567890",
      "quantity_on_hand": 0,
      "bill_item": {
        "account_id": "123456",
        "unit_price": 100
      },
      "invoice_item": {
        "account_id": "123456",
        "unit_price": 100
      }
    }
  ]
}'

{
  "data": {
    "rootfi_id": 32302,
    "rootfi_deleted_at": null,
    "rootfi_created_at": "2024-01-24T11:12:00.315Z",
    "rootfi_updated_at": "2024-01-24T11:12:00.000Z",
    "rootfi_company_id": 1109,
    "platform_id": "123456_1",
    "platform_unique_id": "123456",
    "name": "Brian Vega",
    "description": null,
    "updated_at": "2023-12-08T00:00:00.000Z",
    "status": "ACTIVE",
    "bill_item": {
      "tax_id": "123456",
      "account_id": "123456",
      "unit_price": 123.45,
      "description": "Test Item"
    },
    "code": "9837",
    "invoice_item": {
      "tax_id": "123456",
      "account_id": "123456",
      "unit_price": 123.45,
      "description": "Test Item"
    },
    "is_bill_item": true,
    "is_invoice_item": true,
    "type": "INVENTORY",
    "quantity_on_hand": 10
  }
}

The Items Data Model is designed to simplify the management and retrieval of item-related information across various accounting platforms.

Additional Required Fields

To successfully create an item, certain fields must be included in the raw_data object of the request body. The required fields are as follows:

Integration	Field	Description
NETSUITE	taxschedule	The ID of the tax schedule associated with the item.
MS_DYNAMICS_365_FO	ProductNumber	The product number of the item.
MYOB_BUSINESS	asset_account_id	The ID of the asset account associated with the item.
QOYOD	product_unit_type_id	The ID of the product unit type associated with the item.
QOYOD	category_id	The ID of the category associated with the item.
QOYOD	track_quantity	Whether the item should track quantity.
QOYOD	tax_id	The ID of the tax associated with the item.

curl --request POST \
  --url https://api.rootfi.dev/v3/accounting/items \
  --header 'Content-Type: application/json' \
  --header 'api_key: <api-key>' \
  --data '{
  "company_id": 1,
  "data": [
    {
      "name": "Rootfi Test Item",
      "description": "Rootfi Test Item",
      "type": "INVENTORY",
      "code": "1234567890",
      "quantity_on_hand": 0,
      "bill_item": {
        "account_id": "123456",
        "unit_price": 100
      },
      "invoice_item": {
        "account_id": "123456",
        "unit_price": 100
      }
    }
  ]
}'

Authorizations

api_key

string

header

required

Body

application/json

company_id

integer

required

The ID of the company in the accounting platform

data

object[]

required

The data of the items endpoint

run_async

boolean | null

Run the request asynchronously

Response

200

application/json

data

object

List of items

data.rootfi_id

number

required

The unique ID we assign for that data's information

data.rootfi_created_at

string

required

The date at which RootFi first synced this data

data.rootfi_updated_at

string

required

The latest date at which RootFi updated this data

data.rootfi_company_id

number

required

The ID of the company in the accounting platform

data.platform_id

string

required

An unique custom RootFi ID made from platform's unique_id.

data.rootfi_deleted_at

string | null

The date at which the data was deleted in the accounting platform

data.platform_unique_id

string | null

The ID of the data in the accounting platform.

data.raw_data

object | null

A JSON containing fields that you can directly get from the accounting platform.

data.data_hash

string | null

The hash of the data

data.name

string | null

Name of the item

data.description

string | null

Description of the item

data.status

enum<string>

Status of the item. Values are ACTIVE, ARCHIVED, UNKNOWN

Available options:

ACTIVE,

ARCHIVED,

UNKNOWN

data.type

enum<string>

Type of the item. Values are INVENTORY, NON_INVENTORY, SERVICE, UNKNOWN

Available options:

INVENTORY,

NON_INVENTORY,

SERVICE,

UNKNOWN

data.code

string | null

Reference code of the item

data.quantity_on_hand

integer | null

Quantity on hand

data.is_bill_item

boolean | null

Check if there are details (bill_item) of this item getting purchased

data.bill_item

object

Item details of this item getting purchased

data.is_invoice_item

boolean | null

Check if there are details (invoice_item) of this item getting sold

data.invoice_item

object

Item details of this item getting sold

data.updated_at

string | null

The date the item was last updated

sync_id

string | null

The sync id of the request

Get Items Create Items

curl --request POST \
  --url https://api.rootfi.dev/v3/accounting/items \
  --header 'Content-Type: application/json' \
  --header 'api_key: <api-key>' \
  --data '{
  "company_id": 1,
  "data": [
    {
      "name": "Rootfi Test Item",
      "description": "Rootfi Test Item",
      "type": "INVENTORY",
      "code": "1234567890",
      "quantity_on_hand": 0,
      "bill_item": {
        "account_id": "123456",
        "unit_price": 100
      },
      "invoice_item": {
        "account_id": "123456",
        "unit_price": 100
      }
    }
  ]
}'

{
  "data": {
    "rootfi_id": 32302,
    "rootfi_deleted_at": null,
    "rootfi_created_at": "2024-01-24T11:12:00.315Z",
    "rootfi_updated_at": "2024-01-24T11:12:00.000Z",
    "rootfi_company_id": 1109,
    "platform_id": "123456_1",
    "platform_unique_id": "123456",
    "name": "Brian Vega",
    "description": null,
    "updated_at": "2023-12-08T00:00:00.000Z",
    "status": "ACTIVE",
    "bill_item": {
      "tax_id": "123456",
      "account_id": "123456",
      "unit_price": 123.45,
      "description": "Test Item"
    },
    "code": "9837",
    "invoice_item": {
      "tax_id": "123456",
      "account_id": "123456",
      "unit_price": 123.45,
      "description": "Test Item"
    },
    "is_bill_item": true,
    "is_invoice_item": true,
    "type": "INVENTORY",
    "quantity_on_hand": 10
  }
}

General

Server Side SDKs

Core API

Unified API

​Additional Required Fields

Authorizations

Body

Response

Additional Required Fields