Skip to main content

Get Product Category

Search for product categories in the HG Insights taxonomy. Free — no credits consumed.

Matching: categoryName and treeContains use case-insensitive LIKE substring matching — NOT fuzzy or semantic. Misspellings return zero results with no warning; use common partial terms (e.g. 'CRM', 'Security', 'Cloud') rather than guessing full names. Both filters can be combined with hasInstalls: true to exclude catalog-only categories with no install signals.

Returns: category_id (Int128 hex), category_code, category_name, category_name_tree (root → leaf), has_category_installs, product_count (direct products only — NOT subtree rollup; intermediate/parent nodes typically show product_count=1 even when their subtree contains thousands of products). Prefer deeper leaf categories (longer category_name_tree) for precise filtering.

Use this when:

  • You need to find the exact category name to pass to company_technographic's categories[] filter. Pass the category_name string — not the category_id. Use hasInstalls: true to limit to categories with real install data.
  • You want to explore the category taxonomy by keyword before building a technographic query.

Do NOT use this when:

  • You want vendor details or a vendor_id — use get_vendor_information.
  • You want product attribute data — use get_product_attribute.
  • You want to browse warehouse table schemas for SQL queries — use hg_catalog (that tool is for data query planning, not product taxonomy).

Do NOT call without at least one filter (categoryName, treeContains, categoryCode, or categoryId). When providing both categoryId and categoryCode, both must match the same record (AND logic) — if in doubt, provide only categoryId. Many intermediate nodes have category_code: null; prefer categoryId for exact lookups.

Parameters

NameTypeRequiredDefaultDescription
categoryNamestring❌ No-Case-insensitive substring match on category_name (LIKE). Activates relevance ranking. Use to search categories by name, e.g. 'CRM', 'Security'.
treeContainsstring❌ No-Case-insensitive substring scanned across every node in category_name_tree (root → leaf). Useful for scoping to a branch, e.g. 'Sales and Marketing' returns all categories under that parent.
categoryCodestring❌ No-Exact match on category_code, e.g. 'SW049'. Note: many intermediate and some top-level categories have a null category_code — if a prior call returned a null code, use categoryId instead.
categoryIdstring❌ No-Exact match on category_id (uppercase 32-char Int128 hex).
hasInstallsboolean❌ No-true = only categories with at least one install signal; false = catalog-only categories. Omit to return all.
sortBystring❌ NorelevanceSort order: 'relevance' (best match first, only meaningful with categoryName or treeContains), 'category_name' (A→Z), 'product_count' (desc).
limitinteger❌ No10Maximum number of category rows to return (1–50).
offsetinteger❌ No0Pagination offset.

Required Integrations

  • hginsights_v2

Use Cases

  • Find the exact category name for a term to use in company_technographic's categories filter
  • Explore all sub-categories under a taxonomy branch (e.g. 'Sales and Marketing')
  • Look up a category by its code to get its full tree path and confirm its name
  • Filter to only categories with real install signals (hasInstalls: true) before a technographic query
  • Disambiguate an ambiguous term (e.g. 'Security' returns multiple nodes) to pick the right leaf

Example Usage

Categories matching 'Cloud' with install data

{
"tool": "get_product_category",
"arguments": {
"categoryName": "Cloud",
"hasInstalls": true,
"sortBy": "product_count",
"limit": 10
}
}

Scope to a taxonomy branch

{
"tool": "get_product_category",
"arguments": {
"treeContains": "Sales and Marketing",
"hasInstalls": true
}
}

Exact lookup by category code

{
"tool": "get_product_category",
"arguments": {
"categoryCode": "SW010"
}
}

company_technographic, get_vendor_information, get_product_attribute, get_product_information, hg_catalog