Returns the folder hierarchy as a tree structure. Optionally includes queries within each folder node. Use rootFolderId to get a subtree starting from a specific folder.
Use the Authorization header with the value 'Bearer ' to authenticate. Partner API Keys have full access; Project API Keys are limited to their project scope. Learn more: https://docs.peaka.com/api-reference/authentication
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"Peaka","colors":{"primary":"#5F62F0","light":"#9EA0F6","dark":"#4547A9"},"logo":{"light":"https://mintcdn.com/peaka/KTMImw3DJs9xEUBv/logo/light.svg?fit=max\u0026auto=format\u0026n=KTMImw3DJs9xEUBv\u0026q=85\u0026s=52dc065c1b2905abbf7573ee7d418d24","dark":"https://mintcdn.com/peaka/KTMImw3DJs9xEUBv/logo/dark.svg?fit=max\u0026auto=format\u0026n=KTMImw3DJs9xEUBv\u0026q=85\u0026s=892325d9142c524be9621683aeaa0729","href":"https://www.peaka.com/"},"favicon":"https://mintcdn.com/peaka/f3Y42yDBmWmxwbQG/favicon.svg?fit=max\u0026auto=format\u0026n=f3Y42yDBmWmxwbQG\u0026q=85\u0026s=9aa5087cad74cf5817aa4d27a7d57b4f","api":{"mdx":{"auth":{"method":"bearer"}}},"navbar":{"links":[{"href":"mailto:support@peaka.com","label":"Support"}],"primary":{"type":"button","label":"Peaka Studio","href":"https://peaka.studio"}},"footer":{"socials":{"twitter":"https://twitter.com/peakacom","github":"https://github.com/peakacom","linkedin":"https://www.linkedin.com/company/peaka"}},"integrations":{"gtm":{"tagId":"GTM-NLBSKN8"}},"styling":{"latex":false},"navigation":{"global":{"anchors":[{"anchor":"Documentation","icon":"book-open-cover","href":"https://docs.peaka.com"},{"anchor":"Community","icon":"discord","href":"https://www.peaka.com/community"},{"anchor":"Blog","icon":"newspaper","href":"https://www.peaka.com/blog"}]},"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"peaka","hasAudioNarration":false,"actualSubdomain":"peaka","customDomains":["docs.peaka.com"],"gitSource":{"type":"github","owner":"peakacom","repo":"docs","deployBranch":"main","contentDirectory":"","isPrivate":false,"mountPath":"","label":""},"chroma":{"liveDeploymentHistoryId":"6a820ff466c3c6b3957773ca","collectionId":"0ebdacb1-6a78-4664-abe7-a8e46465cb0a","schemaVersion":"v3","latestBuiltDeploymentHistoryId":"6a820ff466c3c6b3957773ca"},"entitlements":{"AI_CHAT":{"status":"ENABLED"},"WEB_MCP":{"status":"ENABLED"},"NARRATION":{"status":"ENABLED"}},"buildId":"6a820ff466c3c6b3957773ca:success","clientVersion":"0.0.4006","searchFilterCounts":[{"language":"default","tag":"API Reference","count":141},{"language":"default","tag":"Data -- Metadata","count":22},{"language":"default","tag":"Data -- Internal Tables","count":16},{"language":"default","tag":"Data -- Cache","count":14},{"language":"default","tag":"Data -- Catalogs","count":11},{"language":"default","tag":"Connections","count":9},{"language":"default","tag":"Data -- Query Folders","count":9},{"language":"default","tag":"AI -- AgentV2","count":7},{"language":"default","tag":"Data -- Queries","count":7},{"language":"default","tag":"Data -- Exports","count":5}]},"assistantConfig":{},"basePath":"","hasChatPermissions":true,"hasWebMcpPermissions":true,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-v7-file-tree","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"pause-universal-search-reconcile","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"per-site-search-delta","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-private-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-nav-generations","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"byok-sep-25","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"vite-origin","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-agent-model-picker","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-updated-9-15","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[],"page":{"pagePath":"api-reference/data--query-folders/get-query-folder-tree","slug":"/api-reference/data--query-folders/get-query-folder-tree","pageMetadata":{"openapi":"get /data/projects/{projectId}/queries/folders/tree","title":"Get Query Folder Tree","description":"Returns the folder hierarchy as a tree structure. Optionally includes queries within each folder node. Use rootFolderId to get a subtree starting from a specific folder.","href":"/api-reference/data--query-folders/get-query-folder-tree"},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"Returns the folder hierarchy as a tree structure. Optionally includes queries within each folder node. Use rootFolderId to get a subtree starting from a specific folder.\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const{OptimizedImage}={..._provideComponents(),...props.components};if(!OptimizedImage)_missingMdxReference(`OptimizedImage`,true);return _jsxs(`span`,{style:{display:`flex`,gap:`10px`,flexDirection:`row`,alignItems:`center`},children:[_jsx(OptimizedImage,{src:`https://cdn.peaka.com/badges/partner-api-key-badge.png`}),_jsx(OptimizedImage,{src:`https://cdn.peaka.com/badges/project-api-key-badge.png`})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"openapi":"get /data/projects/{projectId}/queries/folders/tree","title":"Get Query Folder Tree","description":"Returns the folder hierarchy as a tree structure. Optionally includes queries within each folder node. Use rootFolderId to get a subtree starting from a specific folder.","href":"/api-reference/data--query-folders/get-query-folder-tree"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[],"codeExamples":{}},"jsLinks":[],"openApiReferenceData":{"operation":{"tags":["Data -- Query Folders"],"summary":"Get Query Folder Tree","description":"Returns the folder hierarchy as a tree structure. Optionally includes queries within each folder node. Use rootFolderId to get a subtree starting from a specific folder.","operationId":"getQueryFolderTree","parameters":["202f914a-46c7-4d34-8e5a-2f5fd965c39f","eaea8766-f197-467e-a466-e083638dca2d","2e6ebb3b-1de4-4312-9c2d-f89a3a1709a0"],"responses":{"200":"97581304-cc41-4baa-86fb-0f84c8792387"},"x-mint":{"content":"\u003cspan style={{display: \"flex\", gap: \"10px\", flexDirection: \"row\", alignItems: \"center\"}}>\n \u003cimg src=\"https://cdn.peaka.com/badges/partner-api-key-badge.png\"/>\n \u003cimg src=\"https://cdn.peaka.com/badges/project-api-key-badge.png\"/>\n\u003c/span>\n"},"method":"get","type":"path","servers":["181c24df-89f5-4cfe-8f0b-36e17c398120","b93b5877-b3ef-471f-abea-12f7d493129c"],"security":["7a217ce3-af7b-4fac-8a59-cf29d84410c9"],"path":"/data/projects/{projectId}/queries/folders/tree","baseUrlOptions":["https://partner.peaka.studio/api/v1","https://partner.eu.peaka.studio/api/v1"],"title":"Get Query Folder Tree","codeSamples":[],"requiredOnlyExamples":false,"requestExampleType":"generated","responseExampleType":"generated"},"dependencies":{"parameters":{"202f914a-46c7-4d34-8e5a-2f5fd965c39f":{"name":"projectId","in":"path","description":"ID of the Project","required":true,"schema":{"type":"string","isRequired":true,"description":"ID of the Project","uniqueKey":"","typeLabel":"string"},"example":"mtKDhe1U"},"eaea8766-f197-467e-a466-e083638dca2d":{"name":"includeQueries","in":"query","description":"Whether to include queries within each folder node","required":false,"schema":{"type":"boolean","default":false,"isRequired":false,"description":"Whether to include queries within each folder node","uniqueKey":"","typeLabel":"boolean"},"example":true},"2e6ebb3b-1de4-4312-9c2d-f89a3a1709a0":{"name":"rootFolderId","in":"query","description":"ID of the root folder to start the subtree from","required":false,"schema":{"type":"string","isRequired":false,"description":"ID of the root folder to start the subtree from","uniqueKey":"","typeLabel":"string"},"example":"550e8400-e29b-41d4-a716-446655440000"}},"responses":{"97581304-cc41-4baa-86fb-0f84c8792387":{"description":"Folder tree retrieved successfully","content":{"application/json":{"schema":{"type":"object","properties":{"tree":{"type":"array","description":"Root-level nodes of the folder tree","items":{"type":"object","properties":{"id":{"type":"string","description":"Unique identifier of the folder (UUID)","uniqueKey":"tree.items.[INDEX].id","typeLabel":"string"},"name":{"type":"string","description":"Display name of the folder","uniqueKey":"tree.items.[INDEX].name","typeLabel":"string"},"path":{"type":"string","description":"Full path of the folder","uniqueKey":"tree.items.[INDEX].path","typeLabel":"string"},"children":{"type":"array","description":"Child folder nodes","items":{"$circularRef":"ef87589e-91cb-4a24-9125-437dab046a65"},"uniqueKey":"tree.items.[INDEX].children","typeLabel":"array"},"queries":{"type":"array","description":"Queries in this folder (present only when includeQueries=true)","items":{"type":"object","properties":{"id":{"type":"string","description":"The ID of the query.","uniqueKey":"tree.items.[INDEX].queries.items.[INDEX].id","typeLabel":"string"},"displayName":{"type":"string","description":"The display name of the query.","uniqueKey":"tree.items.[INDEX].queries.items.[INDEX].displayName","typeLabel":"string"},"name":{"type":"string","description":"The name of the query used in SQL, e.g. SELECT * FROM \"peaka\".\"query\".\"\u003cname>\". For a MATERIALIZED query the materialized result is queryable as \"peaka\".\"mtquery\".\"\u003cname>\".","uniqueKey":"tree.items.[INDEX].queries.items.[INDEX].name","typeLabel":"string"},"inputQuery":{"type":"string","description":"The SQL query. For a materialized query created from an existing query (via inputQueryRefId), this holds the snapshot of the source query's SQL resolved when the query was created or last updated with the reference.","uniqueKey":"tree.items.[INDEX].queries.items.[INDEX].inputQuery","typeLabel":"string"},"queryType":{"type":"string","description":"The type of the query.","enum":["PLAIN","MATERIALIZED"],"uniqueKey":"tree.items.[INDEX].queries.items.[INDEX].queryType","typeLabel":"enum\u003cstring>"},"schedule":{"oneOf":[{"type":"object","properties":{"type":{"type":"string","description":"Type of schedule.","enum":["interval","cron","none"],"uniqueKey":"tree.items.[INDEX].queries.items.[INDEX].schedule.oneOf.0.type","typeLabel":"enum\u003cstring>"},"cronExpression":{"oneOf":[{"type":"string","description":"UNIX cron expression (minute hour day-of-month month day-of-week), e.g. '0 0 * * *' for every day at midnight. Set only when the schedule type is 'cron'.","example":"0 0 * * *","uniqueKey":"tree.items.[INDEX].queries.items.[INDEX].schedule.oneOf.0.cronExpression.oneOf.0","typeLabel":"string"},{"type":"null","description":"UNIX cron expression (minute hour day-of-month month day-of-week), e.g. '0 0 * * *' for every day at midnight. Set only when the schedule type is 'cron'.","example":"0 0 * * *","uniqueKey":"tree.items.[INDEX].queries.items.[INDEX].schedule.oneOf.0.cronExpression.oneOf.1","typeLabel":"null"}],"uniqueKey":"tree.items.[INDEX].queries.items.[INDEX].schedule.oneOf.0.cronExpression","typeLabel":"string | null"},"repeatDuration":{"oneOf":[{"type":"string","description":"ISO-8601 duration between refreshes, e.g. 'PT6H' (every 6 hours), 'PT12H' (twice daily), 'P1D' (daily). Set only when the schedule type is 'interval'.","example":"PT12H","uniqueKey":"tree.items.[INDEX].queries.items.[INDEX].schedule.oneOf.0.repeatDuration.oneOf.0","typeLabel":"string"},{"type":"null","description":"ISO-8601 duration between refreshes, e.g. 'PT6H' (every 6 hours), 'PT12H' (twice daily), 'P1D' (daily). Set only when the schedule type is 'interval'.","example":"PT12H","uniqueKey":"tree.items.[INDEX].queries.items.[INDEX].schedule.oneOf.0.repeatDuration.oneOf.1","typeLabel":"null"}],"uniqueKey":"tree.items.[INDEX].queries.items.[INDEX].schedule.oneOf.0.repeatDuration","typeLabel":"string | null"},"timezone":{"oneOf":[{"type":"string","description":"IANA timezone used to evaluate the cron expression, e.g. 'UTC' or 'Europe/Istanbul'. Set only when the schedule type is 'cron'.","example":"UTC","uniqueKey":"tree.items.[INDEX].queries.items.[INDEX].schedule.oneOf.0.timezone.oneOf.0","typeLabel":"string"},{"type":"null","description":"IANA timezone used to evaluate the cron expression, e.g. 'UTC' or 'Europe/Istanbul'. Set only when the schedule type is 'cron'.","example":"UTC","uniqueKey":"tree.items.[INDEX].queries.items.[INDEX].schedule.oneOf.0.timezone.oneOf.1","typeLabel":"null"}],"uniqueKey":"tree.items.[INDEX].queries.items.[INDEX].schedule.oneOf.0.timezone","typeLabel":"string | null"}},"description":"Schedule configuration of a materialized query. Provide EITHER an interval schedule (`type=interval` with `repeatDuration`) OR a cron schedule (`type=cron` with `cronExpression` and optional `timezone`). Use `type=none` for no schedule. The fields that do not apply to the chosen type are omitted.","example":{"type":"cron","cronExpression":"0 0 * * *","timezone":"UTC"},"uniqueKey":"tree.items.[INDEX].queries.items.[INDEX].schedule.oneOf.0","typeLabel":"object"},{"type":"null","properties":{"type":{"type":"string","description":"Type of schedule.","enum":["interval","cron","none"]},"cronExpression":{"oneOf":[{"type":"string","description":"UNIX cron expression (minute hour day-of-month month day-of-week), e.g. '0 0 * * *' for every day at midnight. Set only when the schedule type is 'cron'.","example":"0 0 * * *"},{"type":"null","description":"UNIX cron expression (minute hour day-of-month month day-of-week), e.g. '0 0 * * *' for every day at midnight. Set only when the schedule type is 'cron'.","example":"0 0 * * *"}]},"repeatDuration":{"oneOf":[{"type":"string","description":"ISO-8601 duration between refreshes, e.g. 'PT6H' (every 6 hours), 'PT12H' (twice daily), 'P1D' (daily). Set only when the schedule type is 'interval'.","example":"PT12H"},{"type":"null","description":"ISO-8601 duration between refreshes, e.g. 'PT6H' (every 6 hours), 'PT12H' (twice daily), 'P1D' (daily). Set only when the schedule type is 'interval'.","example":"PT12H"}]},"timezone":{"oneOf":[{"type":"string","description":"IANA timezone used to evaluate the cron expression, e.g. 'UTC' or 'Europe/Istanbul'. Set only when the schedule type is 'cron'.","example":"UTC"},{"type":"null","description":"IANA timezone used to evaluate the cron expression, e.g. 'UTC' or 'Europe/Istanbul'. Set only when the schedule type is 'cron'.","example":"UTC"}]}},"description":"Schedule configuration of a materialized query. Provide EITHER an interval schedule (`type=interval` with `repeatDuration`) OR a cron schedule (`type=cron` with `cronExpression` and optional `timezone`). Use `type=none` for no schedule. The fields that do not apply to the chosen type are omitted.","example":{"type":"cron","cronExpression":"0 0 * * *","timezone":"UTC"},"uniqueKey":"tree.items.[INDEX].queries.items.[INDEX].schedule.oneOf.1","typeLabel":"null"}],"uniqueKey":"tree.items.[INDEX].queries.items.[INDEX].schedule","typeLabel":"object | null"},"path":{"oneOf":[{"type":"string","description":"The folder path of the query (e.g. \"/analytics/dashboards\"). Null if not in any folder.","uniqueKey":"tree.items.[INDEX].queries.items.[INDEX].path.oneOf.0","typeLabel":"string"},{"type":"null","description":"The folder path of the query (e.g. \"/analytics/dashboards\"). Null if not in any folder.","uniqueKey":"tree.items.[INDEX].queries.items.[INDEX].path.oneOf.1","typeLabel":"null"}],"uniqueKey":"tree.items.[INDEX].queries.items.[INDEX].path","typeLabel":"string | null"},"folderId":{"oneOf":[{"type":"string","description":"The ID of the folder containing this query. Null if not in any folder.","uniqueKey":"tree.items.[INDEX].queries.items.[INDEX].folderId.oneOf.0","typeLabel":"string"},{"type":"null","description":"The ID of the folder containing this query. Null if not in any folder.","uniqueKey":"tree.items.[INDEX].queries.items.[INDEX].folderId.oneOf.1","typeLabel":"null"}],"uniqueKey":"tree.items.[INDEX].queries.items.[INDEX].folderId","typeLabel":"string | null"}},"description":"A saved query belonging to a project.","uniqueKey":"tree.items.[INDEX].queries.items.[INDEX]","typeLabel":"object"},"uniqueKey":"tree.items.[INDEX].queries","typeLabel":"object[]"}},"description":"A node in the folder tree hierarchy","uniqueKey":"tree.items.[INDEX]","typeLabel":"object"},"uniqueKey":"tree","typeLabel":"object[]"}},"description":"Response containing the folder tree hierarchy","uniqueKey":"","typeLabel":"object"},"example":{"tree":[{"id":"550e8400-e29b-41d4-a716-446655440000","name":"Reports","path":"/Reports","children":[{"id":"550e8400-e29b-41d4-a716-446655440001","name":"Monthly","path":"/Reports/Monthly","children":[],"queries":[]}],"queries":[{"id":"709922802836177297","displayName":"Revenue Report","name":"revenuereport","inputQuery":"SELECT * FROM revenue"}]}]},"examples":{"Example":{"title":"Example","value":{"tree":[{"id":"550e8400-e29b-41d4-a716-446655440000","name":"Reports","path":"/Reports","children":[{"id":"550e8400-e29b-41d4-a716-446655440001","name":"Monthly","path":"/Reports/Monthly","children":[],"queries":[]}],"queries":[{"id":"709922802836177297","displayName":"Revenue Report","name":"revenuereport","inputQuery":"SELECT * FROM revenue"}]}]}}},"exampleType":"examples"}},"exampleType":"examples"}},"security":{"7a217ce3-af7b-4fac-8a59-cf29d84410c9":{"bearerAuth":{"type":"http","description":"Use the Authorization header with the value 'Bearer \u003capiKey>' to authenticate. Partner API Keys have full access; Project API Keys are limited to their project scope. Learn more: https://docs.peaka.com/api-reference/authentication","scheme":"bearer","bearerFormat":"Api Key","scopes":[]}}},"servers":{"181c24df-89f5-4cfe-8f0b-36e17c398120":{"url":"https://partner.peaka.studio/api/v1","description":"Default Server URL (US Zone)"},"b93b5877-b3ef-471f-abea-12f7d493129c":{"url":"https://partner.eu.peaka.studio/api/v1","description":"EU Zone"}},"schemas":{"ef87589e-91cb-4a24-9125-437dab046a65":{"type":"object","properties":{"id":{"type":"string","description":"Unique identifier of the folder (UUID)"},"name":{"type":"string","description":"Display name of the folder"},"path":{"type":"string","description":"Full path of the folder"},"children":{"type":"array","description":"Child folder nodes","items":{"$circularRef":"ef87589e-91cb-4a24-9125-437dab046a65"}},"queries":{"type":"array","description":"Queries in this folder (present only when includeQueries=true)","items":{"type":"object","properties":{"id":{"type":"string","description":"The ID of the query."},"displayName":{"type":"string","description":"The display name of the query."},"name":{"type":"string","description":"The name of the query used in SQL, e.g. SELECT * FROM \"peaka\".\"query\".\"\u003cname>\". For a MATERIALIZED query the materialized result is queryable as \"peaka\".\"mtquery\".\"\u003cname>\"."},"inputQuery":{"type":"string","description":"The SQL query. For a materialized query created from an existing query (via inputQueryRefId), this holds the snapshot of the source query's SQL resolved when the query was created or last updated with the reference."},"queryType":{"type":"string","description":"The type of the query.","enum":["PLAIN","MATERIALIZED"]},"schedule":{"oneOf":[{"type":"object","description":"Schedule configuration of a materialized query. Provide EITHER an interval schedule (`type=interval` with `repeatDuration`) OR a cron schedule (`type=cron` with `cronExpression` and optional `timezone`). Use `type=none` for no schedule. The fields that do not apply to the chosen type are omitted.","example":{"type":"cron","cronExpression":"0 0 * * *","timezone":"UTC"},"properties":{"type":{"type":"string","description":"Type of schedule.","enum":["interval","cron","none"]},"cronExpression":{"oneOf":[{"type":"string","description":"UNIX cron expression (minute hour day-of-month month day-of-week), e.g. '0 0 * * *' for every day at midnight. Set only when the schedule type is 'cron'.","example":"0 0 * * *"},{"type":"null","description":"UNIX cron expression (minute hour day-of-month month day-of-week), e.g. '0 0 * * *' for every day at midnight. Set only when the schedule type is 'cron'.","example":"0 0 * * *"}]},"repeatDuration":{"oneOf":[{"type":"string","description":"ISO-8601 duration between refreshes, e.g. 'PT6H' (every 6 hours), 'PT12H' (twice daily), 'P1D' (daily). Set only when the schedule type is 'interval'.","example":"PT12H"},{"type":"null","description":"ISO-8601 duration between refreshes, e.g. 'PT6H' (every 6 hours), 'PT12H' (twice daily), 'P1D' (daily). Set only when the schedule type is 'interval'.","example":"PT12H"}]},"timezone":{"oneOf":[{"type":"string","description":"IANA timezone used to evaluate the cron expression, e.g. 'UTC' or 'Europe/Istanbul'. Set only when the schedule type is 'cron'.","example":"UTC"},{"type":"null","description":"IANA timezone used to evaluate the cron expression, e.g. 'UTC' or 'Europe/Istanbul'. Set only when the schedule type is 'cron'.","example":"UTC"}]}}},{"type":"null","description":"Schedule configuration of a materialized query. Provide EITHER an interval schedule (`type=interval` with `repeatDuration`) OR a cron schedule (`type=cron` with `cronExpression` and optional `timezone`). Use `type=none` for no schedule. The fields that do not apply to the chosen type are omitted.","example":{"type":"cron","cronExpression":"0 0 * * *","timezone":"UTC"},"properties":{"type":{"type":"string","description":"Type of schedule.","enum":["interval","cron","none"]},"cronExpression":{"oneOf":[{"type":"string","description":"UNIX cron expression (minute hour day-of-month month day-of-week), e.g. '0 0 * * *' for every day at midnight. Set only when the schedule type is 'cron'.","example":"0 0 * * *"},{"type":"null","description":"UNIX cron expression (minute hour day-of-month month day-of-week), e.g. '0 0 * * *' for every day at midnight. Set only when the schedule type is 'cron'.","example":"0 0 * * *"}]},"repeatDuration":{"oneOf":[{"type":"string","description":"ISO-8601 duration between refreshes, e.g. 'PT6H' (every 6 hours), 'PT12H' (twice daily), 'P1D' (daily). Set only when the schedule type is 'interval'.","example":"PT12H"},{"type":"null","description":"ISO-8601 duration between refreshes, e.g. 'PT6H' (every 6 hours), 'PT12H' (twice daily), 'P1D' (daily). Set only when the schedule type is 'interval'.","example":"PT12H"}]},"timezone":{"oneOf":[{"type":"string","description":"IANA timezone used to evaluate the cron expression, e.g. 'UTC' or 'Europe/Istanbul'. Set only when the schedule type is 'cron'.","example":"UTC"},{"type":"null","description":"IANA timezone used to evaluate the cron expression, e.g. 'UTC' or 'Europe/Istanbul'. Set only when the schedule type is 'cron'.","example":"UTC"}]}}}]},"path":{"oneOf":[{"type":"string","description":"The folder path of the query (e.g. \"/analytics/dashboards\"). Null if not in any folder."},{"type":"null","description":"The folder path of the query (e.g. \"/analytics/dashboards\"). Null if not in any folder."}]},"folderId":{"oneOf":[{"type":"string","description":"The ID of the folder containing this query. Null if not in any folder."},{"type":"null","description":"The ID of the folder containing this query. Null if not in any folder."}]}},"description":"A saved query belonging to a project."}}},"description":"A node in the folder tree hierarchy"}},"processedSecurityOptions":[{"schemes":[{"scheme":{"type":"http","description":"Use the Authorization header with the value 'Bearer \u003capiKey>' to authenticate. Partner API Keys have full access; Project API Keys are limited to their project scope. Learn more: https://docs.peaka.com/api-reference/authentication","scheme":"bearer","bearerFormat":"Api Key","scopes":[]},"schema":{"title":"Bearer Auth","type":"string","isRequired":true,"description":"Use the Authorization header with the value 'Bearer \u003capiKey>' to authenticate. Partner API Keys have full access; Project API Keys are limited to their project scope. Learn more: https://docs.peaka.com/api-reference/authentication","format":"bearer","typeLabel":"string\u003cbearer>","deprecated":false},"schemeName":"bearerAuth","name":"Authorization"}],"title":"bearerAuth"}]},"originalFileLocation":"api-reference/peaka-openapi.json"},"subdomain":"peaka","siteName":"Peaka","title":"Get Query Folder Tree - Peaka","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-04-10T15:00:43.945Z","originalFileLocation":"api-reference/data--query-folders/get-query-folder-tree.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"system\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"Returns the folder hierarchy as a tree structure. Optionally includes queries within each folder node. Use rootFolderId to get a subtree starting from a specific folder.\">\u003cmeta data-mint-head name=\"application-name\" content=\"Peaka\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/peaka/Xvkixmw2HjtZz8lo/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/peaka/Xvkixmw2HjtZz8lo/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/peaka/Xvkixmw2HjtZz8lo/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/peaka/Xvkixmw2HjtZz8lo/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/peaka/Xvkixmw2HjtZz8lo/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/peaka/Xvkixmw2HjtZz8lo/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/peaka/Xvkixmw2HjtZz8lo/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/peaka/Xvkixmw2HjtZz8lo/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/peaka/Xvkixmw2HjtZz8lo/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Get Query Folder Tree - Peaka\">\u003cmeta data-mint-head property=\"og:description\" content=\"Returns the folder hierarchy as a tree structure. Optionally includes queries within each folder node. Use rootFolderId to get a subtree starting from a specific folder.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Peaka\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.peaka.com/api-reference/data--query-folders/get-query-folder-tree\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://peaka.mintlify.app/_mintlify/api/og/v2?division=Data+--+Query+Folders\u0026amp;title=Get+Query+Folder+Tree\u0026amp;description=Returns+the+folder+hierarchy+as+a+tree+structure.+Optionally+includes+queries+within+each+folder+node.+Use+rootFolderId+to+get+a+subtree+starting+from+a+specifi\u0026amp;theme=31de81707d28b482cfe06788\u0026amp;signature=7022ae731521c5770c8d36acfdab408c398f081e137a8d7af709111aa285101c\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Get Query Folder Tree - Peaka\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Returns the folder hierarchy as a tree structure. Optionally includes queries within each folder node. Use rootFolderId to get a subtree starting from a specific folder.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://peaka.mintlify.app/_mintlify/api/og/v2?division=Data+--+Query+Folders\u0026amp;title=Get+Query+Folder+Tree\u0026amp;description=Returns+the+folder+hierarchy+as+a+tree+structure.+Optionally+includes+queries+within+each+folder+node.+Use+rootFolderId+to+get+a+subtree+starting+from+a+specifi\u0026amp;theme=31de81707d28b482cfe06788\u0026amp;signature=7022ae731521c5770c8d36acfdab408c398f081e137a8d7af709111aa285101c\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/peaka/Xvkixmw2HjtZz8lo/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Peaka\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#5F62F0\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.peaka.com/api-reference/data--query-folders/get-query-folder-tree\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/api-reference/data--query-folders/get-query-folder-tree.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.peaka.com/#organization\",\"name\":\"Peaka\",\"url\":\"https://docs.peaka.com\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/peaka/KTMImw3DJs9xEUBv/logo/light.svg?fit=max\u0026auto=format\u0026n=KTMImw3DJs9xEUBv\u0026q=85\u0026s=52dc065c1b2905abbf7573ee7d418d24\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.peaka.com#website\",\"name\":\"Peaka\",\"url\":\"https://docs.peaka.com\",\"publisher\":{\"@id\":\"https://docs.peaka.com/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.peaka.com/api-reference/data--query-folders/get-query-folder-tree#webpage\",\"url\":\"https://docs.peaka.com/api-reference/data--query-folders/get-query-folder-tree\",\"name\":\"Get Query Folder Tree\",\"description\":\"Returns the folder hierarchy as a tree structure. Optionally includes queries within each folder node. Use rootFolderId to get a subtree starting from a specific folder.\",\"dateModified\":\"2026-04-10T15:00:43.945Z\",\"isPartOf\":{\"@id\":\"https://docs.peaka.com#website\"},\"breadcrumb\":{\"@id\":\"https://docs.peaka.com/api-reference/data--query-folders/get-query-folder-tree#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.peaka.com/api-reference/data--query-folders/get-query-folder-tree#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Data -- Query Folders\",\"item\":\"https://docs.peaka.com/api-reference/data--query-folders/list-query-folders\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Get Query Folder Tree\",\"item\":\"https://docs.peaka.com/api-reference/data--query-folders/get-query-folder-tree\"}]},{\"@type\":[\"TechArticle\",\"APIReference\"],\"@id\":\"https://docs.peaka.com/api-reference/data--query-folders/get-query-folder-tree#apireference\",\"headline\":\"Get Query Folder Tree\",\"name\":\"Get Query Folder Tree\",\"description\":\"Returns the folder hierarchy as a tree structure. Optionally includes queries within each folder node. Use rootFolderId to get a subtree starting from a specific folder.\",\"url\":\"https://docs.peaka.com/api-reference/data--query-folders/get-query-folder-tree\",\"mainEntityOfPage\":{\"@id\":\"https://docs.peaka.com/api-reference/data--query-folders/get-query-folder-tree#webpage\"},\"dateModified\":\"2026-04-10T15:00:43.945Z\",\"publisher\":{\"@id\":\"https://docs.peaka.com/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.peaka.com#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Peaka\",\"creator\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","siteName":"Peaka","nav":{"global":{"anchors":[{"anchor":"Documentation","icon":"book-open-cover","href":"https://docs.peaka.com"},{"anchor":"Community","icon":"discord","href":"https://www.peaka.com/community"},{"anchor":"Blog","icon":"newspaper","href":"https://www.peaka.com/blog"}]},"tabs":[{"tab":"Documentation","href":"https://www.peaka.com/docs/introduction"},{"tab":"API Reference","groups":[{"group":"API Documentation","pages":[{"title":"Introduction","href":"/api-reference/introduction"},{"title":"Servers","href":"/api-reference/servers"},{"title":"Authentication","href":"/api-reference/authentication"},{"title":"Structure","href":"/api-reference/structure"}]},{"group":"Organization -- Organizations","pages":[{"openapi":"get /organizations","title":"List Organizations","href":"/api-reference/organization--organizations/list-organizations"},{"openapi":"get /organizations/{organizationId}","title":"Read Organization","href":"/api-reference/organization--organizations/read-organization"}]},{"group":"Organization -- Workspaces","pages":[{"openapi":"get /organizations/{organizationId}/workspaces","title":"List Workspaces","href":"/api-reference/organization--workspaces/list-workspaces"},{"openapi":"post /organizations/{organizationId}/workspaces","title":"Create Workspace","href":"/api-reference/organization--workspaces/create-workspace"},{"openapi":"get /organizations/{organizationId}/workspaces/{workspaceId}","title":"Read Workspace","href":"/api-reference/organization--workspaces/read-workspace"},{"openapi":"put /organizations/{organizationId}/workspaces/{workspaceId}","title":"Update Workspace","href":"/api-reference/organization--workspaces/update-workspace"},{"openapi":"delete /organizations/{organizationId}/workspaces/{workspaceId}","title":"Delete Workspace","href":"/api-reference/organization--workspaces/delete-workspace"}]},{"group":"Organization -- Projects","pages":[{"openapi":"get /organizations/{organizationId}/workspaces/{workspaceId}/projects","title":"List Projects","href":"/api-reference/organization--projects/list-projects"},{"openapi":"post /organizations/{organizationId}/workspaces/{workspaceId}/projects","title":"Create Project","href":"/api-reference/organization--projects/create-project"},{"openapi":"get /organizations/{organizationId}/workspaces/{workspaceId}/projects/{projectId}","title":"Read Project","href":"/api-reference/organization--projects/read-project"},{"openapi":"put /organizations/{organizationId}/workspaces/{workspaceId}/projects/{projectId}","title":"Update Project","href":"/api-reference/organization--projects/update-project"},{"openapi":"delete /organizations/{organizationId}/workspaces/{workspaceId}/projects/{projectId}","title":"Delete Project","href":"/api-reference/organization--projects/delete-project"}]},{"group":"Projects (Deprecated)","pages":[{"openapi":"get /projects","deprecated":true,"title":"List Projects","href":"/api-reference/projects-deprecated/list-projects"},{"openapi":"post /projects","deprecated":true,"title":"Create Project","href":"/api-reference/projects-deprecated/create-project"},{"openapi":"get /projects/{projectId}","deprecated":true,"title":"Read Project","href":"/api-reference/projects-deprecated/read-project"},{"openapi":"put /projects/{projectId}","deprecated":true,"title":"Update Project","href":"/api-reference/projects-deprecated/update-project"},{"openapi":"delete /projects/{projectId}","deprecated":true,"title":"Delete Project","href":"/api-reference/projects-deprecated/delete-project"}]},{"group":"Projects -- Api Key","pages":[{"openapi":"get /projects/{projectId}/apiKeys","title":"List API Keys","href":"/api-reference/projects--api-key/list-api-keys"},{"openapi":"post /projects/{projectId}/apiKeys","title":"Create API Key","href":"/api-reference/projects--api-key/create-api-key"},{"openapi":"delete /projects/{projectId}/apiKeys/{apiKeyId}","title":"Delete API Key","href":"/api-reference/projects--api-key/delete-api-key"}]},{"group":"Connections","pages":[{"openapi":"get /connections/config","title":"List Connection Config","href":"/api-reference/connections/list-connection-config"},{"openapi":"get /connections/config/{connectionType}","title":"Get Connection Config","href":"/api-reference/connections/get-connection-config"},{"openapi":"get /connections/{projectId}","title":"List Connections","href":"/api-reference/connections/list-connections"},{"openapi":"post /connections/{projectId}","title":"Create Connection","href":"/api-reference/connections/create-connection"},{"openapi":"post /connections/{projectId}/oauth2","title":"Oauth2 Callback","href":"/api-reference/connections/oauth2-callback"},{"openapi":"get /connections/{projectId}/{connectionId}","title":"Get Connection","href":"/api-reference/connections/get-connection"},{"openapi":"put /connections/{projectId}/{connectionId}","title":"Update Connection","href":"/api-reference/connections/update-connection"},{"openapi":"delete /connections/{projectId}/{connectionId}","title":"Delete Connection","href":"/api-reference/connections/delete-connection"},{"openapi":"get /connections/{projectId}/{connectionId}/detail","title":"Get Connection Detail","href":"/api-reference/connections/get-connection-detail"}]},{"group":"Data -- Catalogs","pages":[{"openapi":"get /data/projects/{projectId}/catalogs","title":"List Catalogs","href":"/api-reference/data--catalogs/list-catalogs"},{"openapi":"post /data/projects/{projectId}/catalogs","title":"Create Catalog","href":"/api-reference/data--catalogs/create-catalog"},{"openapi":"get /data/projects/{projectId}/catalogs/{catalogId}","title":"Read Catalog","href":"/api-reference/data--catalogs/read-catalog"},{"openapi":"delete /data/projects/{projectId}/catalogs/{catalogId}","title":"Delete Catalog","href":"/api-reference/data--catalogs/delete-catalog"},{"openapi":"get /data/projects/{projectId}/catalogs/{catalogId}/schemas","title":"List Schemas","href":"/api-reference/data--catalogs/list-schemas"},{"openapi":"get /data/projects/{projectId}/catalogs/{catalogId}/schemas/{schemaName}/tables","title":"List Tables","href":"/api-reference/data--catalogs/list-tables"},{"openapi":"get /data/projects/{projectId}/catalogs/{catalogId}/schemas/{schemaName}/tables/{tableName}/columns","title":"List Columns","href":"/api-reference/data--catalogs/list-columns"},{"openapi":"get /data/projects/{projectId}/catalogs/{catalogId}/schemas/{schemaName}/tables/{tableName}/isCached","title":"Table is Cached","href":"/api-reference/data--catalogs/table-is-cached"},{"openapi":"get /data/projects/{projectId}/catalogs/{catalogId}/schemas/{schemaName}/tables/{tableName}/statistics","title":"Table Statistics","href":"/api-reference/data--catalogs/table-statistics"},{"openapi":"post /data/projects/{projectId}/catalogs/{catalogId}/share","title":"Share Catalog","href":"/api-reference/data--catalogs/share-catalog"},{"openapi":"post /data/projects/{projectId}/search","title":"Search","href":"/api-reference/data--catalogs/search"}]},{"group":"Data -- Internal Tables","pages":[{"openapi":"get /data/projects/{projectId}/bitable","title":"List BI Tables","href":"/api-reference/data--internal-tables/list-bi-tables"},{"openapi":"post /data/projects/{projectId}/bitable/{tableName}","title":"Create BI Table","href":"/api-reference/data--internal-tables/create-bi-table"},{"openapi":"delete /data/projects/{projectId}/bitable/{tableName}","title":"Delete BI Table","href":"/api-reference/data--internal-tables/delete-bi-table"},{"openapi":"get /data/projects/{projectId}/bitable/{tableName}/columns","title":"List BI Columns","href":"/api-reference/data--internal-tables/list-bi-columns"},{"openapi":"post /data/projects/{projectId}/bitable/{tableName}/columns","title":"Add BI Column","href":"/api-reference/data--internal-tables/add-bi-column"},{"openapi":"put /data/projects/{projectId}/bitable/{tableName}/columns/{columnName}","title":"Update BI Column","href":"/api-reference/data--internal-tables/update-bi-column"},{"openapi":"delete /data/projects/{projectId}/bitable/{tableName}/columns/{columnName}","title":"Delete BI Column","href":"/api-reference/data--internal-tables/delete-bi-column"},{"openapi":"get /data/projects/{projectId}/table","title":"List Tables","href":"/api-reference/data--internal-tables/list-tables"},{"openapi":"post /data/projects/{projectId}/table/{tableName}","title":"Create Table","href":"/api-reference/data--internal-tables/create-table"},{"openapi":"delete /data/projects/{projectId}/table/{tableName}","title":"Delete Table","href":"/api-reference/data--internal-tables/delete-table"},{"openapi":"get /data/projects/{projectId}/table/{tableName}/columns","title":"List Columns","href":"/api-reference/data--internal-tables/list-columns"},{"openapi":"post /data/projects/{projectId}/table/{tableName}/columns","title":"Add Column","href":"/api-reference/data--internal-tables/add-column"},{"openapi":"put /data/projects/{projectId}/table/{tableName}/columns/{columnName}","title":"Update Column","href":"/api-reference/data--internal-tables/update-column"},{"openapi":"delete /data/projects/{projectId}/table/{tableName}/columns/{columnName}","title":"Delete Column","href":"/api-reference/data--internal-tables/delete-column"},{"openapi":"post /data/projects/{projectId}/table/{tableName}/import","title":"Import CSV","href":"/api-reference/data--internal-tables/import-csv"},{"openapi":"get /data/projects/{projectId}/table/{tableName}/sample","title":"Get Sample CSV","href":"/api-reference/data--internal-tables/get-sample-csv"}]},{"group":"Data -- Queries","pages":[{"openapi":"get /data/projects/{projectId}/queries","title":"List Queries","href":"/api-reference/data--queries/list-queries"},{"openapi":"post /data/projects/{projectId}/queries","title":"Create Query","href":"/api-reference/data--queries/create-query"},{"openapi":"post /data/projects/{projectId}/queries/execute","title":"Execute Query","href":"/api-reference/data--queries/execute-query"},{"openapi":"get /data/projects/{projectId}/queries/{queryId}","title":"Read Query","href":"/api-reference/data--queries/read-query"},{"openapi":"put /data/projects/{projectId}/queries/{queryId}","title":"Update Query","href":"/api-reference/data--queries/update-query"},{"openapi":"delete /data/projects/{projectId}/queries/{queryId}","title":"Delete Query","href":"/api-reference/data--queries/delete-query"},{"openapi":"patch /data/projects/{projectId}/queries/{queryId}/path","title":"Update Query Path","href":"/api-reference/data--queries/update-query-path"}]},{"group":"Data -- Query Folders","pages":[{"openapi":"get /data/projects/{projectId}/queries/folders","title":"List Query Folders","href":"/api-reference/data--query-folders/list-query-folders"},{"openapi":"post /data/projects/{projectId}/queries/folders","title":"Create Query Folder","description":"Creates a new query folder at the root level. The folder name is used to build the path (e.g. folderName \"Reports\" becomes path \"/Reports\"). Intermediate parent folders are created automatically if a nested path is provided.","href":"/api-reference/data--query-folders/create-query-folder"},{"openapi":"get /data/projects/{projectId}/queries/folders/tree","title":"Get Query Folder Tree","href":"/api-reference/data--query-folders/get-query-folder-tree"},{"openapi":"get /data/projects/{projectId}/queries/folders/{folderId}","title":"Read Query Folder","description":"Returns a single folder by its ID, including its direct child folders and the queries it contains.","href":"/api-reference/data--query-folders/read-query-folder"},{"openapi":"put /data/projects/{projectId}/queries/folders/{folderId}","title":"Add/Remove Queries In/From Folder","href":"/api-reference/data--query-folders/addremove-queries-infrom-folder"},{"openapi":"delete /data/projects/{projectId}/queries/folders/{folderId}","title":"Delete Query Folder","href":"/api-reference/data--query-folders/delete-query-folder"},{"openapi":"patch /data/projects/{projectId}/queries/folders/{folderId}/name","title":"Rename Query Folder","href":"/api-reference/data--query-folders/rename-query-folder"},{"openapi":"patch /data/projects/{projectId}/queries/folders/{folderId}/path","title":"Move Query Folder","href":"/api-reference/data--query-folders/move-query-folder"},{"openapi":"post /data/projects/{projectId}/queries/folders/{parentFolderId}","title":"Create Query Folder Under Parent","href":"/api-reference/data--query-folders/create-query-folder-under-parent"}]},{"group":"Data -- Semantic Catalogs","pages":[{"openapi":"post /data/projects/{projectId}/semantic-catalogs","title":"Create a semantic catalog","href":"/api-reference/data--semantic-catalogs/create-a-semantic-catalog"},{"openapi":"post /data/projects/{projectId}/semantic-catalogs/{catalogId}","title":"Create a semantic table","href":"/api-reference/data--semantic-catalogs/create-a-semantic-table"},{"openapi":"post /data/projects/{projectId}/semantic-catalogs/{catalogId}/share","title":"Share Semantic Catalog","href":"/api-reference/data--semantic-catalogs/share-semantic-catalog"},{"openapi":"delete /data/projects/{projectId}/semantic-catalogs/{catalogId}/table/{tableId}","title":"Delete a semantic table","href":"/api-reference/data--semantic-catalogs/delete-a-semantic-table"}]},{"group":"Data -- Cache","pages":[{"openapi":"post /data/projects/{projectId}/cache","title":"Create Cache","href":"/api-reference/data--cache/create-cache"},{"openapi":"post /data/projects/{projectId}/cache/batch","title":"Create Batch Cache","href":"/api-reference/data--cache/create-batch-cache"},{"openapi":"get /data/projects/{projectId}/cache/status","title":"Get All Cache Statuses of a Project","href":"/api-reference/data--cache/get-all-cache-statuses-of-a-project"},{"openapi":"get /data/projects/{projectId}/cache/{cacheId}","title":"Get Cache Settings","href":"/api-reference/data--cache/get-cache-settings"},{"openapi":"put /data/projects/{projectId}/cache/{cacheId}","title":"Update Cache Settings","href":"/api-reference/data--cache/update-cache-settings"},{"openapi":"delete /data/projects/{projectId}/cache/{cacheId}","title":"Delete Cache","href":"/api-reference/data--cache/delete-cache"},{"openapi":"post /data/projects/{projectId}/cache/{cacheId}/cancelFullRefreshUpdate","title":"Cancel Running Full Refresh","href":"/api-reference/data--cache/cancel-running-full-refresh"},{"openapi":"post /data/projects/{projectId}/cache/{cacheId}/cancelIncrementalUpdate","title":"Cancel Running Incremental Update","href":"/api-reference/data--cache/cancel-running-incremental-update"},{"openapi":"get /data/projects/{projectId}/cache/{cacheId}/executionHistory","title":"Get Cache Execution History","href":"/api-reference/data--cache/get-cache-execution-history"},{"openapi":"post /data/projects/{projectId}/cache/{cacheId}/fullRefreshUpdate","title":"Trigger Full Refresh Cache Update","href":"/api-reference/data--cache/trigger-full-refresh-cache-update"},{"openapi":"post /data/projects/{projectId}/cache/{cacheId}/incrementalUpdate","title":"Trigger Incremental Cache Update","href":"/api-reference/data--cache/trigger-incremental-cache-update"},{"openapi":"get /data/projects/{projectId}/cache/{cacheId}/status","title":"Get Cache Status","href":"/api-reference/data--cache/get-cache-status"},{"openapi":"get /data/projects/{projectId}/catalog/{catalogId}/cache/status","title":"Get All Cache Statuses of a Catalog","href":"/api-reference/data--cache/get-all-cache-statuses-of-a-catalog"},{"openapi":"get /data/projects/{projectId}/catalog/{catalogId}/schema/{schemaName}/cache/status","title":"Get All Cache Statuses of a Schema","href":"/api-reference/data--cache/get-all-cache-statuses-of-a-schema"}]},{"group":"Data -- Exports","pages":[{"openapi":"post /data/projects/{projectId}/queries/{queryId}/exports","title":"Export Query (async)","href":"/api-reference/data--exports/export-query-async"},{"openapi":"post /data/projects/{projectId}/catalogs/{catalogId}/schemas/{schemaName}/tables/{tableName}/exports","title":"Export Table (async)","href":"/api-reference/data--exports/export-table-async"},{"openapi":"get /data/projects/{projectId}/exports","title":"List Exports","href":"/api-reference/data--exports/list-exports"},{"openapi":"get /data/projects/{projectId}/exports/{exportId}","title":"Read Export","href":"/api-reference/data--exports/read-export"},{"openapi":"delete /data/projects/{projectId}/exports/{exportId}","title":"Cancel Export","href":"/api-reference/data--exports/cancel-export"}]},{"group":"Data -- Parametric Tables","pages":[{"openapi":"get /data/projects/{projectId}/catalogs/{catalogId}/parametricTables","title":"List Parametric Tables","href":"/api-reference/data--parametric-tables/list-parametric-tables"},{"openapi":"post /data/projects/{projectId}/catalogs/{catalogId}/parametricTables","title":"Create Parametric Table","href":"/api-reference/data--parametric-tables/create-parametric-table"},{"openapi":"delete /data/projects/{projectId}/catalogs/{catalogId}/parametricTables","title":"Delete Parametric Table","href":"/api-reference/data--parametric-tables/delete-parametric-table"}]},{"group":"Embedded Peaka Api","pages":[{"openapi":"get /ui/initSession","deprecated":true,"title":"Init Session (Deprecated)","href":"/api-reference/embedded-peaka-api/init-session-deprecated"},{"openapi":"post /ui/initSession","title":"Init Session","href":"/api-reference/embedded-peaka-api/init-session"}]},{"group":"Supported Drivers","pages":[{"openapi":"get /supportedDrivers","title":"List Supported Drivers","href":"/api-reference/supported-drivers/list-supported-drivers"},{"openapi":"get /supportedDrivers/jdbc","title":"Get JDBC Driver","href":"/api-reference/supported-drivers/get-jdbc-driver"},{"openapi":"get /supportedDrivers/sql_alchemy","title":"Get SQL Alchemy Driver","href":"/api-reference/supported-drivers/get-sql-alchemy-driver"}]},{"group":"Data -- Metadata","pages":[{"openapi":"get /metadata/{projectId}","title":"Get Project Metadata","href":"/api-reference/data--metadata/get-project-metadata"},{"openapi":"put /metadata/{projectId}/categorical/{catalogId}/{schemaName}/{tableName}/{columnName}","title":"Generate categorical values from the column.","href":"/api-reference/data--metadata/generate-categorical-values-from-the-column"},{"openapi":"delete /metadata/{projectId}/categorical/{catalogId}/{schemaName}/{tableName}/{columnName}","title":"Delete categorical values from the column meta and remove the scheduled job","href":"/api-reference/data--metadata/delete-categorical-values-from-the-column-meta-and-remove-the-scheduled-job"},{"openapi":"get /metadata/{projectId}/golden-sql/query","title":"Semantic query golden sqls for the project.","href":"/api-reference/data--metadata/semantic-query-golden-sqls-for-the-project"},{"openapi":"get /metadata/{projectId}/golden-sqls","title":"List of golden sqls for the project.","href":"/api-reference/data--metadata/list-of-golden-sqls-for-the-project"},{"openapi":"post /metadata/{projectId}/golden-sqls","title":"Create golden sql for the project","href":"/api-reference/data--metadata/create-golden-sql-for-the-project"},{"openapi":"delete /metadata/{projectId}/golden-sqls/{id}","title":"Delete golden sql from the project.","href":"/api-reference/data--metadata/delete-golden-sql-from-the-project"},{"openapi":"get /metadata/{projectId}/query","title":"Semantic query metadata for the project.","href":"/api-reference/data--metadata/semantic-query-metadata-for-the-project"},{"openapi":"get /metadata/{projectId}/questions/generate","title":"Generate sample ai questions for the project","href":"/api-reference/data--metadata/generate-sample-ai-questions-for-the-project"},{"openapi":"post /metadata/{projectId}/refresh","title":"Refresh Project Metadata","href":"/api-reference/data--metadata/refresh-project-metadata"},{"openapi":"get /metadata/{projectId}/refresh/callback","title":"Get Metadata Refresh Job Callback","href":"/api-reference/data--metadata/get-metadata-refresh-job-callback"},{"openapi":"post /metadata/{projectId}/refresh/callback","title":"Register Metadata Refresh Job Callback","href":"/api-reference/data--metadata/register-metadata-refresh-job-callback"},{"openapi":"delete /metadata/{projectId}/refresh/callback","title":"Unregister Metadata Refresh Job Callback","href":"/api-reference/data--metadata/unregister-metadata-refresh-job-callback"},{"openapi":"get /metadata/{projectId}/refresh/{catalogId}","title":"Get Metadata Refresh Job Status","href":"/api-reference/data--metadata/get-metadata-refresh-job-status"},{"openapi":"get /metadata/{projectId}/relations/{catalogId}","title":"Get Project Catalog Metadata Relations","href":"/api-reference/data--metadata/get-project-catalog-metadata-relations"},{"openapi":"post /metadata/{projectId}/relations/{catalogId}/{schemaName}/{tableName}/{columnName}","title":"Add Relation To Metadata","href":"/api-reference/data--metadata/add-relation-to-metadata"},{"openapi":"put /metadata/{projectId}/relations/{catalogId}/{schemaName}/{tableName}/{relationId}","title":"Update Relation From Metadata","href":"/api-reference/data--metadata/update-relation-from-metadata"},{"openapi":"delete /metadata/{projectId}/relations/{catalogId}/{schemaName}/{tableName}/{relationId}","title":"Delete Relation From Metadata","href":"/api-reference/data--metadata/delete-relation-from-metadata"},{"openapi":"post /metadata/{projectId}/semantics/{catalogId}/{schemaName}/{tableName}","title":"Generate semantics for the table","href":"/api-reference/data--metadata/generate-semantics-for-the-table"},{"openapi":"put /metadata/{projectId}/{catalogId}","title":"Update Metadata ai usage per catalog level","href":"/api-reference/data--metadata/update-metadata-ai-usage-per-catalog-level"},{"openapi":"put /metadata/{projectId}/{catalogId}/{schemaName}","title":"Update Metadata ai usage per schema level","href":"/api-reference/data--metadata/update-metadata-ai-usage-per-schema-level"},{"openapi":"put /metadata/{projectId}/{catalogId}/{schemaName}/{tableName}","title":"Update Metadata","href":"/api-reference/data--metadata/update-metadata"}]},{"group":"AI -- AgentV2","pages":[{"openapi":"get /ai-agent/workflow/png","title":"Get png image of current ai workflow","href":"/api-reference/ai--agentv2/get-png-image-of-current-ai-workflow"},{"openapi":"post /ai-agent/{projectId}/chat","title":"Chat with agent","href":"/api-reference/ai--agentv2/chat-with-agent"},{"openapi":"post /ai-agent/{projectId}/chat/stream","title":"Chat with agent via stream","href":"/api-reference/ai--agentv2/chat-with-agent-via-stream"},{"openapi":"get /ai-agent/{projectId}/threads","title":"List ai-agent threads","href":"/api-reference/ai--agentv2/list-ai-agent-threads"},{"openapi":"get /ai-agent/{projectId}/threads/{threadId}","title":"Get ai-agent thread","href":"/api-reference/ai--agentv2/get-ai-agent-thread"},{"openapi":"put /ai-agent/{projectId}/threads/{threadId}","title":"Update ai-agent thread display name","href":"/api-reference/ai--agentv2/update-ai-agent-thread-display-name"},{"openapi":"delete /ai-agent/{projectId}/threads/{threadId}","title":"Delete ai-agent thread","href":"/api-reference/ai--agentv2/delete-ai-agent-thread"}]},{"group":"Data -- SQL","pages":[{"openapi":"post /sql/transpile/{dialect}","title":"Transpile SQL","href":"/api-reference/data--sql/transpile-sql"}]},{"group":"Data -- Materialized Queries","pages":[{"openapi":"get /data/projects/{projectId}/materialized-queries/status","title":"List Materialized Query Statuses","href":"/api-reference/data--materialized-queries/list-materialized-query-statuses"},{"openapi":"post /data/projects/{projectId}/materialized-queries/{queryId}/cancel","title":"Cancel Materialized Query Refresh","href":"/api-reference/data--materialized-queries/cancel-materialized-query-refresh"},{"openapi":"post /data/projects/{projectId}/materialized-queries/{queryId}/refresh","title":"Refresh Materialized Query","href":"/api-reference/data--materialized-queries/refresh-materialized-query"},{"openapi":"get /data/projects/{projectId}/materialized-queries/{queryId}/status","title":"Read Materialized Query Status","href":"/api-reference/data--materialized-queries/read-materialized-query-status"}]}]},{"tab":"MCP","href":"https://www.peaka.com/docs/mcp/overview"},{"tab":"Embedded Peaka","href":"https://www.peaka.com/docs/embedded-peaka/introduction"},{"tab":"SQL Reference","href":"https://www.peaka.com/docs/sql/introduction"},{"tab":"Integrations","href":"https://www.peaka.com/docs/integrations/activecampaign"},{"tab":"BI Tools","href":"https://www.peaka.com/docs/bi-tools/looker-studio"},{"tab":"DB Drivers","href":"https://www.peaka.com/docs/db-drivers/python"},{"tab":"JEXL","href":"https://www.peaka.com/docs/jexl/using-jexl"},{"tab":"Flows","href":"https://www.peaka.com/docs/flows/how-to-create-a-flow"},{"tab":"Cookbook","href":"https://www.peaka.com/docs/cookbook/how-to-combine-connector-and-peaka-table-data"}]},"title":"Get Query Folder Tree - Peaka","buildId":"dpl_2xiSHD9XEvLsPGPcfoMtkLTB3dy9","deploymentId":"dpl_2xiSHD9XEvLsPGPcfoMtkLTB3dy9","dynamics":["c2aa737661","2b790eda92","b0f84f53ff","a74be98ba7","a9bb46feb3"],"chunks":["OpenApiReferenceProvider-DmVyH30O.js","utils-BHQqGGOd.js","cloneDeep-izs3Hzxb.js","_Uint8Array-BVIqJ90l.js","isObjectLike-C8vmzPEN.js","isArray-Dcu1dQ5t.js","utils-CD-E4BIt.js","toString-BX-iyh8G.js","isSymbol-CSH9U2Gm.js","addUniqueKeysToSchema-Bp5Lq9Ds.js","snippetPresets-C4xAVCFP.js","style-to-object-BY3JEAdk.js","v4-DIgz8zy6.js","ApiExamples-CgXVLxUC.js","isEqual-BfaiBbcl.js","usePlaygroundInputsStore-BF8I5oUf.js","shallow-Byd0lWnC.js","getApiPlaygroundDisplay-BGOZG1OK.js","CodeSnippet-CpvQL0CY.js","CodeSnippets-B8wkBKXa.js","Page-CBCH2P7b.js","getPastedJson-Ry3scI3Y.js","icon-D7a9HcdD.js","MethodPill-CJ8pmHhz.js","DuplicateIcon-rh1HJF0t.js","createIcon-DvGznqYs.js","DynamicMarkdown-Cc6AuSHS.js","SectionHeading-B4A0S-ep.js","axios-vUo_bRtp.js","zoom-image-lightbox-BNnMwe0F.js","lightbox-handle-r17bVUz3.js","Markdown-Cc16CX65.js","clsx-Cs6nMGht.js","lib-DuNMoZ05.js","lib-B8HbPgcC.js","html-void-elements-mCSPHezU.js","dist-zbf22OZA.js","katex-YMM-FMeD.js","marked.esm-CZWythHk.js","AssistantPageLink-C_fs-y5n.js"]}