QMetry: Fetch Cascade Child Values
qmetry_fetch_cascade_child_valuesRetrieve valid child item IDs for a CASCADINGLIST UDF by providing the parent item ID, ensuring correct values before bulk-updating test runs.
Instructions
Fetch the child values of a CASCADINGLIST UDF field for a given parent item ID. Use this before bulk-updating a CASCADINGLIST Test Run UDF to discover valid child item IDs.
Toolset: UDF
Parameters:
projectKey (string): Project key - unique identifier for the project (default: "default")
id (number) required: Numeric ID of the parent cascade list item to fetch child values for. Get this from the 'lookupOptions' returned by 'Fetch Test Run UDF Metadata' for a CASCADINGLIST field — each option has an 'id' field.
isArchReq (boolean): Whether to include archived child items in the response (default: false). (default: false)
Output Description: JSON object with 'parentId' (the input ID), 'parentName' (the parent item's display name), 'children' array (each item has id, name, uniqueLabel, isArchived), and a '_note' explaining how to use the IDs.
Use Cases: 1. Find valid child values for a CASCADINGLIST UDF before bulk-updating test runs 2. List all child options available under a specific parent cascade item 3. Resolve child item ID when user knows the parent but not the child 4. Discover cascade hierarchy for a UDF field before setting it on test executions
Examples:
Fetch child values for parent cascade item with ID 5173534
{
"id": 5173534
}Expected Output: { parentId: 5173534, parentName: "India", children: [{ id: 5173535, name: "i1", uniqueLabel: "i1", isArchived: false }, ...], _note: "Use 'id' from 'children' as the 'child' value in the CASCADINGLIST update." }
Fetch child values including archived items for parent ID 5126498
{
"id": 5126498,
"isArchReq": true
}Expected Output: { parentId: 5126498, parentName: "abc", children: [...], _note: "..." }
Hints: 1. MANDATORY WORKFLOW for CASCADINGLIST bulk update:
Call 'Fetch Test Run UDF Metadata' → get the CASCADINGLIST field's 'fieldID' (projectUserFieldID) and parent item options from 'lookupOptions'.
Call this tool ('Fetch Cascade Child Values') with a parent item 'id' from step 1 → get child item IDs.
Call 'Bulk Update Test Run UDFs' with value: { parent: , child: } and the 'fieldID' from step 1. 2. The parent item IDs are in the 'lookupOptions' map returned by 'Fetch Test Run UDF Metadata'. Each entry under the field's listName contains items with 'id' — use that 'id' as the 'id' parameter here. IMPORTANT: If 'lookupOptions' from Fetch Test Run UDF Metadata is empty for the CASCADINGLIST field, the API did not return parent options. In this case, ask the user to provide the parent item ID from the QMetry UI — do NOT guess. 3. The response 'children' array contains objects with 'id', 'name', 'uniqueLabel', and 'isArchived'. Use 'id' as the 'child' value in the bulk update payload. 4. Set 'isArchReq: true' only if the user explicitly asks to include archived/inactive child options. 5. This endpoint requires 'scope' and 'orgcode' headers — these are injected automatically from the session context when 'Set Project Info' has been called. If you see an authorization error, call 'Set Project Info' first. 6. Do NOT call this tool for STRING, NUMBER, DATETIMEPICKER, LOOKUPLIST, or MULTILOOKUPLIST fields — only CASCADINGLIST (fieldType: 'CASCADINGLIST') fields have a parent-child hierarchy.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| id | Yes | Numeric ID of the parent cascade list item to fetch child values for. Get this from the 'lookupOptions' returned by 'Fetch Test Run UDF Metadata' for a CASCADINGLIST field — each option has an 'id' field. | |
| isArchReq | No | Whether to include archived child items in the response (default: false). | |
| projectKey | No | Project key - unique identifier for the project | default |