TRtrackstarhq
erp
Inventory

Get All ERP Inventory Items

Changed on

Returns all Inventory Items for the ERP connection associated with the provided access token.

get/erp/inventory

Request

  • Base URL
    https://production.trackstarhq.com
  • URL
    https://production.trackstarhq.com/erp/inventory
  • Auth
    none required

Query parameters

page_tokenstring nullable
Example:page_token

The page token to use to retrieve the next page of results. If this field is omitted, there are no subsequent pages.

limitinteger
Example:1000

The maximum number of items to return. The default is 1000.

instring[] required

A comma-separated list of resource IDs. If provided, all other query params are ignored.

{
  "in": [
    "_in"
  ]
}
eqstring date-time
neqstring date-time
instring[]

Comma-separated.

ninstring[]

Comma-separated.

gtstring date-time
gtestring date-time
ltstring date-time
ltestring date-time

Use this parameter to retrieve items filtered to a specific date range. For example, to get all items between 2023-03-10 and 2023-03-22, you would send created_date[gte]=2023-03-10T00:00:00Z&created_date[lte]=2023-03-22T00:00:00Z. See the filtering docs for more. The date format must always be YYYY-MM-DDTHH:MM:SSZ. Note: it is much more efficient to use a combination of gte/lte than it is to use gt/lt.

{
  "eq": "2023-03-15T13:45:30Z",
  "neq": "2023-03-15T13:45:30Z",
  "in": [
    "2023-03-15T13:45:30Z"
  ],
  "nin": [
    "2023-03-15T13:45:30Z"
  ],
  "gt": "2023-03-15T13:45:30Z",
  "gte": "2023-03-15T13:45:30Z",
  "lt": "2023-03-15T13:45:30Z",
  "lte": "2023-03-15T13:45:30Z"
}
eqstring date-time
neqstring date-time
instring[]

Comma-separated.

ninstring[]

Comma-separated.

gtstring date-time
gtestring date-time
ltstring date-time
ltestring date-time

Same syntax as created_date.

{
  "eq": "2023-03-15T13:45:30Z",
  "neq": "2023-03-15T13:45:30Z",
  "in": [
    "2023-03-15T13:45:30Z"
  ],
  "nin": [
    "2023-03-15T13:45:30Z"
  ],
  "gt": "2023-03-15T13:45:30Z",
  "gte": "2023-03-15T13:45:30Z",
  "lt": "2023-03-15T13:45:30Z",
  "lte": "2023-03-15T13:45:30Z"
}
eqstring date-time
neqstring date-time
instring[]

Comma-separated.

ninstring[]

Comma-separated.

gtstring date-time
gtestring date-time
ltstring date-time
ltestring date-time

Same syntax as created_date.

{
  "eq": "2023-03-15T13:45:30Z",
  "neq": "2023-03-15T13:45:30Z",
  "in": [
    "2023-03-15T13:45:30Z"
  ],
  "nin": [
    "2023-03-15T13:45:30Z"
  ],
  "gt": "2023-03-15T13:45:30Z",
  "gte": "2023-03-15T13:45:30Z",
  "lt": "2023-03-15T13:45:30Z",
  "lte": "2023-03-15T13:45:30Z"
}
eqstring date-time
neqstring date-time
instring[]

Comma-separated.

ninstring[]

Comma-separated.

gtstring date-time
gtestring date-time
ltstring date-time
ltestring date-time

Same syntax as created_date.

{
  "eq": "2023-03-15T13:45:30Z",
  "neq": "2023-03-15T13:45:30Z",
  "in": [
    "2023-03-15T13:45:30Z"
  ],
  "nin": [
    "2023-03-15T13:45:30Z"
  ],
  "gt": "2023-03-15T13:45:30Z",
  "gte": "2023-03-15T13:45:30Z",
  "lt": "2023-03-15T13:45:30Z",
  "lte": "2023-03-15T13:45:30Z"
}
containsstring[]

Comma-separated.

not_containsstring[]

Comma-separated.

Filter by trackstar tags. Dict-shaped tags should be queried as "key:value" strings. This filter is not indexed. Pair it with an indexed filter (updated_date, created_date, trackstar_updated_date, trackstar_created_date) using eq, gt, gte, lt or lte for faster, fuller pages. See filtering docs.

{
  "contains": [
    "contains"
  ],
  "not_contains": [
    "not_contains"
  ]
}
eqstring
neqstring
instring[]

Comma-separated.

ninstring[]

Comma-separated.

containsstring
not_containsstring
is_nullboolean

Filter by whether the field is null.

The SKU of the inventory item. This filter is not indexed. Pair it with an indexed filter (updated_date, created_date, trackstar_updated_date, trackstar_created_date) using eq, gt, gte, lt or lte for faster, fuller pages. See filtering docs.

{
  "eq": "sku",
  "neq": "neq",
  "in": [
    "_in"
  ],
  "nin": [
    "nin"
  ],
  "contains": "contains",
  "not_contains": "not_contains",
  "is_null": true
}
activeboolean
Example:true

Whether or not the inventory item is active. This filter is not indexed. Pair it with an indexed filter (updated_date, created_date, trackstar_updated_date, trackstar_created_date) using eq, gt, gte, lt or lte for faster, fuller pages. See filtering docs.

Headers

x-trackstar-api-keystring required
Example:<x-trackstar-api-key>

Your organization-level Trackstar API key.

x-trackstar-access-tokenstring required
Example:<x-trackstar-access-token>

Your user's access token for a specific integration (ShipHero, Extensiv, etc).

Response

Successful response

next_tokenstring nullable required

See pagination for more details.

total_countinteger required

The number of items returned.

Example response

{
  "data": [
    {
      "id": "inv_id",
      "created_date": "2022-01-01T00:00:00Z",
      "updated_date": "2022-01-02T05:05:05Z",
      "name": "Apple - Fuji",
      "sku": "10000",
      "upc": "012345678905",
      "active": true,
      "description": "Fuji apple, loose",
      "unit_cost": 1,
      "costing_method": "Standard",
      "stock_unit": "EA",
      "onhand": 42.5,
      "committed": 2.5,
      "available": 40,
      "inventory_by_location_id": {
        "location_id_1": {
          "onhand": 42.5,
          "committed": 2.5,
          "available": 40
        },
        "location_id_2": {
          "onhand": 0,
          "committed": 0,
          "available": 0
        }
      },
      "vendors": [
        {
          "vendor_id": "vendor_1",
          "vendor_name": "Acme Produce Co."
        }
      ],
      "lots": [
        {
          "lot_id": "9821",
          "lot_name": "LOT-20260418-A",
          "onhand": 240,
          "expiration_date": "2026-05-09T00:00:00Z",
          "location_id": "114"
        }
      ],
      "bins": [
        {
          "bin_id": "157",
          "bin_name": "C-03-L3-P2",
          "onhand": 240,
          "location_id": "114",
          "lot_id": "9821"
        }
      ],
      "custom_fields": {
        "custom_field_example": {
          "value": "example_value",
          "type": "string",
          "title": "Example Field"
        }
      },
      "measurements": {
        "length": 1.5,
        "width": 1.5,
        "height": 1.5,
        "unit": "in",
        "weight": 2.5,
        "weight_unit": "lb"
      },
      "external_system_url": "https://example.com/inventoryitem/123",
      "trackstar_tags": [
        "tag1",
        "tag2",
        {
          "tag3": "value3"
        }
      ],
      "additional_fields": {
        "key": "value"
      },
      "trackstar_created_date": "2023-03-15T13:45:30Z",
      "trackstar_updated_date": "2023-03-15T13:45:30Z"
    }
  ],
  "next_token": "next_token",
  "total_count": 1
}

Changes