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
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
categoryName | string | ❌ No | - | Case-insensitive substring match on category_name (LIKE). Activates relevance ranking. Use to search categories by name, e.g. 'CRM', 'Security'. |
treeContains | string | ❌ 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. |
categoryCode | string | ❌ 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. |
categoryId | string | ❌ No | - | Exact match on category_id (uppercase 32-char Int128 hex). |
hasInstalls | boolean | ❌ No | - | true = only categories with at least one install signal; false = catalog-only categories. Omit to return all. |
sortBy | string | ❌ No | relevance | Sort order: 'relevance' (best match first, only meaningful with categoryName or treeContains), 'category_name' (A→Z), 'product_count' (desc). |
limit | integer | ❌ No | 10 | Maximum number of category rows to return (1–50). |
offset | integer | ❌ No | 0 | Pagination 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"
}
}
Related Tools
company_technographic, get_vendor_information, get_product_attribute, get_product_information, hg_catalog