curl --request GET \
--url https://developer.synq.io/api/entities/folders/v1/browse \
--header 'Authorization: Bearer <token>'import requests
url = "https://developer.synq.io/api/entities/folders/v1/browse"
headers = {"Authorization": "Bearer <token>"}
response = requests.get(url, headers=headers)
print(response.text)const options = {method: 'GET', headers: {Authorization: 'Bearer <token>'}};
fetch('https://developer.synq.io/api/entities/folders/v1/browse', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://developer.synq.io/api/entities/folders/v1/browse",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "GET",
CURLOPT_HTTPHEADER => [
"Authorization: Bearer <token>"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"net/http"
"io"
)
func main() {
url := "https://developer.synq.io/api/entities/folders/v1/browse"
req, _ := http.NewRequest("GET", url, nil)
req.Header.Add("Authorization", "Bearer <token>")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.get("https://developer.synq.io/api/entities/folders/v1/browse")
.header("Authorization", "Bearer <token>")
.asString();require 'uri'
require 'net/http'
url = URI("https://developer.synq.io/api/entities/folders/v1/browse")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Get.new(url)
request["Authorization"] = 'Bearer <token>'
response = http.request(request)
puts response.read_body{
"folders": [
{
"folderEntityId": "<string>",
"ref": {
"rootEntityId": "<string>",
"folders": [
"<string>"
]
},
"name": "<string>",
"fullName": [
"<string>"
],
"type": "ENTITY_TYPE_UNSPECIFIED",
"platform": "DATA_PLATFORM_TYPE_UNSPECIFIED",
"childFolderCount": 123,
"memberCount": 123,
"role": "FOLDER_ROLE_UNSPECIFIED",
"elidedFolders": [
{
"folderEntityId": "<string>",
"ref": {
"rootEntityId": "<string>",
"folders": [
"<string>"
]
},
"name": "<string>",
"type": "ENTITY_TYPE_UNSPECIFIED"
}
]
}
],
"memberEntityIds": [
"<string>"
]
}Browse
Browse the hierarchy one level at a time. With no parent, returns the
roots (top-level integrations / containers). With a parent folder, returns
that folder’s direct sub-folders and the entity ids of its direct,
non-folder members.
One level per call — sub-folders are returned as Folders (each with a
child_folder_count), which you Browse into in turn; there is no nested
tree in the response. filter narrows the returned members to entities
matching a query.
curl --request GET \
--url https://developer.synq.io/api/entities/folders/v1/browse \
--header 'Authorization: Bearer <token>'import requests
url = "https://developer.synq.io/api/entities/folders/v1/browse"
headers = {"Authorization": "Bearer <token>"}
response = requests.get(url, headers=headers)
print(response.text)const options = {method: 'GET', headers: {Authorization: 'Bearer <token>'}};
fetch('https://developer.synq.io/api/entities/folders/v1/browse', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://developer.synq.io/api/entities/folders/v1/browse",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "GET",
CURLOPT_HTTPHEADER => [
"Authorization: Bearer <token>"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"net/http"
"io"
)
func main() {
url := "https://developer.synq.io/api/entities/folders/v1/browse"
req, _ := http.NewRequest("GET", url, nil)
req.Header.Add("Authorization", "Bearer <token>")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.get("https://developer.synq.io/api/entities/folders/v1/browse")
.header("Authorization", "Bearer <token>")
.asString();require 'uri'
require 'net/http'
url = URI("https://developer.synq.io/api/entities/folders/v1/browse")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Get.new(url)
request["Authorization"] = 'Bearer <token>'
response = http.request(request)
puts response.read_body{
"folders": [
{
"folderEntityId": "<string>",
"ref": {
"rootEntityId": "<string>",
"folders": [
"<string>"
]
},
"name": "<string>",
"fullName": [
"<string>"
],
"type": "ENTITY_TYPE_UNSPECIFIED",
"platform": "DATA_PLATFORM_TYPE_UNSPECIFIED",
"childFolderCount": 123,
"memberCount": 123,
"role": "FOLDER_ROLE_UNSPECIFIED",
"elidedFolders": [
{
"folderEntityId": "<string>",
"ref": {
"rootEntityId": "<string>",
"folders": [
"<string>"
]
},
"name": "<string>",
"type": "ENTITY_TYPE_UNSPECIFIED"
}
]
}
],
"memberEntityIds": [
"<string>"
]
}Authorizations
Query Parameters
Opaque id of the entity the folder hierarchy hangs under — an integration
root or container (for example a warehouse instance, a database, or a
transformation project). Take it verbatim from FolderRef.root_entity_id
of a folder you already read, or from an entity id returned elsewhere.
Ordered folder names from the root down to this folder (root first, leaf last), for example ["staging", "sales"]. Empty means the ref points at the root entity itself. Folder names are kept as separate segments (not joined with "/") because some platforms allow "/" inside a single folder name.
Opaque id of the entity, set on every identifier the API returns. Round-trip it verbatim; the format is not part of this contract and may change, and it is never constructed by hand.
OUTPUT ONLY. On a request this field is ignored — the structured variant is
what resolves. That is what lets you hand an identifier straight back
unchanged, or edit its structured fields, without the two disagreeing about
which entity you meant. To name an entity BY opaque id on a request, set the
synq_path variant to that id: it carries exactly this string, and it is
also how an entity whose platform has no structured variant is named.
1024Opaque identifier of the dbt Core project. Usually the Coalesce Quality integration id (a UUID), but may also be the dbt project name from manifest.json when the integration is configured to identify assets by project name. Treat it as an opaque string, not a UUID.
Required. Host of the Redshift endpoint, as in the connection, for example
my-cluster.abc123.eu-west-1.redshift.amazonaws.com. A port suffix is
accepted and ignored. The bare cluster name (my-cluster) is not enough,
because one name can exist in more than one account or region. A response
returns the host in its normalized form, which is also accepted on input.
The rule below also refuses an empty value. It is not required, because
required stops the other rules and its error does not say what to send.
Required. Host of the Redshift endpoint, as in the connection, for example
my-cluster.abc123.eu-west-1.redshift.amazonaws.com. A port suffix is
accepted and ignored. The bare cluster name (my-cluster) is not enough,
because one name can exist in more than one account or region. A response
returns the host in its normalized form, which is also accepted on input.
The rule below also refuses an empty value. It is not required, because
required stops the other rules and its error does not say what to send.
redshift_table.cluster.full_host // cluster must be the full host of the Redshift endpoint from the connection, for example my-cluster.abc123.eu-west-1.redshift.amazonaws.com
Fabric workspace GUID, decoded from the endpoint host in instance.
Optional and informational: the table is addressed by
instance/database/schema/table, so leave it empty if you don't have it —
it does not affect how the identifier resolves.
Default Coalesce Quality types
ENTITY_TYPE_UNSPECIFIED, ENTITY_TYPE_BQ_TABLE, ENTITY_TYPE_BQ_VIEW, ENTITY_TYPE_BQ_PROCEDURE, ENTITY_TYPE_BQ_FUNCTION, ENTITY_TYPE_LOOKER_LOOK, ENTITY_TYPE_LOOKER_EXPLORE, ENTITY_TYPE_LOOKER_VIEW, ENTITY_TYPE_LOOKER_DASHBOARD, ENTITY_TYPE_LOOKER_INSTANCE, ENTITY_TYPE_DBT_MODEL, ENTITY_TYPE_DBT_TEST, ENTITY_TYPE_DBT_SOURCE, ENTITY_TYPE_DBT_PROJECT, ENTITY_TYPE_DBT_METRIC, ENTITY_TYPE_DBT_SNAPSHOT, ENTITY_TYPE_DBT_SEED, ENTITY_TYPE_DBT_ANALYSIS, ENTITY_TYPE_DBT_EXPOSURE, ENTITY_TYPE_DBT_GROUP, ENTITY_TYPE_DBT_SEMANTIC_MODEL, ENTITY_TYPE_DBT_CLOUD_PROJECT, ENTITY_TYPE_DBT_CLOUD_JOB, ENTITY_TYPE_SNOWFLAKE_TABLE, ENTITY_TYPE_SNOWFLAKE_VIEW, ENTITY_TYPE_SNOWFLAKE_STREAM, ENTITY_TYPE_SNOWFLAKE_DYNAMIC_TABLE, ENTITY_TYPE_SNOWFLAKE_TASK, ENTITY_TYPE_SNOWFLAKE_EXTERNAL_TABLE, ENTITY_TYPE_SNOWFLAKE_MATERIALIZED_VIEW, ENTITY_TYPE_SNOWFLAKE_PROCEDURE, ENTITY_TYPE_SNOWFLAKE_FUNCTION, ENTITY_TYPE_SNOWFLAKE_SEMANTIC_VIEW, ENTITY_TYPE_SNOWFLAKE_STAGE, ENTITY_TYPE_SNOWFLAKE_STREAMLIT, ENTITY_TYPE_SNOWFLAKE_NOTEBOOK, ENTITY_TYPE_SNOWFLAKE_WAREHOUSE, ENTITY_TYPE_SNOWFLAKE_PIPE, ENTITY_TYPE_SNOWFLAKE_CORTEX_SEARCH_SERVICE, ENTITY_TYPE_REDSHIFT_TABLE, ENTITY_TYPE_REDSHIFT_VIEW, ENTITY_TYPE_REDSHIFT_PROCEDURE, ENTITY_TYPE_REDSHIFT_FUNCTION, ENTITY_TYPE_TABLEAU_EMBEDDED, ENTITY_TYPE_TABLEAU_PUBLISHED, ENTITY_TYPE_TABLEAU_CUSTOM_SQL, ENTITY_TYPE_TABLEAU_TABLE, ENTITY_TYPE_TABLEAU_SHEET, ENTITY_TYPE_TABLEAU_DASHBOARD, ENTITY_TYPE_TABLEAU_WORKBOOK, ENTITY_TYPE_TABLEAU_SITE, ENTITY_TYPE_AIRFLOW_DAG, ENTITY_TYPE_AIRFLOW_TASK, ENTITY_TYPE_CLICKHOUSE_TABLE, ENTITY_TYPE_CLICKHOUSE_VIEW, ENTITY_TYPE_ANOMALY_MONITOR, ENTITY_TYPE_ANOMALY_MONITOR_SEGMENT, ENTITY_TYPE_SQLTEST_TEST, ENTITY_TYPE_RECON_SUITE, ENTITY_TYPE_RECON_CASE, ENTITY_TYPE_LINEAGE_FOLD, ENTITY_TYPE_POSTGRES_TABLE, ENTITY_TYPE_POSTGRES_VIEW, ENTITY_TYPE_MYSQL_TABLE, ENTITY_TYPE_MYSQL_VIEW, ENTITY_TYPE_DATABRICKS_WAREHOUSE, ENTITY_TYPE_DATABRICKS_TABLE, ENTITY_TYPE_DATABRICKS_VIEW, ENTITY_TYPE_DATABRICKS_JOB, ENTITY_TYPE_DATABRICKS_JOB_TASK, ENTITY_TYPE_DATABRICKS_NOTEBOOK, ENTITY_TYPE_DATABRICKS_QUERY, ENTITY_TYPE_DATABRICKS_DASHBOARD, ENTITY_TYPE_DATABRICKS_METRIC_VIEW, ENTITY_TYPE_DATABRICKS_APP, ENTITY_TYPE_SQLMESH_PROJECT, ENTITY_TYPE_SQLMESH_SQL_MODEL, ENTITY_TYPE_SQLMESH_PYTHON_MODEL, ENTITY_TYPE_SQLMESH_EXTERNAL, ENTITY_TYPE_SQLMESH_SEED, ENTITY_TYPE_SQLMESH_AUDIT, ENTITY_TYPE_SQLMESH_UNIT_TEST, ENTITY_TYPE_SQLMESH_ENVIRONMENT, ENTITY_TYPE_SQLMESH_SNAPSHOT, ENTITY_TYPE_DUCKDB_TABLE, ENTITY_TYPE_DUCKDB_VIEW, ENTITY_TYPE_TRINO_TABLE, ENTITY_TYPE_TRINO_VIEW, ENTITY_TYPE_ATLAN_ASSET, ENTITY_TYPE_ATLAN_INTEGRATION, ENTITY_TYPE_COALESCE_PROJECT, ENTITY_TYPE_COALESCE_ENVIRONMENT, ENTITY_TYPE_COALESCE_NODE, ENTITY_TYPE_COALESCE_NODE_TEST, ENTITY_TYPE_COALESCE_JOB, ENTITY_TYPE_CASTORDOC_TABLE, ENTITY_TYPE_CASTORDOC_DASHBOARD, ENTITY_TYPE_CASTORDOC_VIEW, ENTITY_TYPE_CASTORDOC_TILE, ENTITY_TYPE_CASTORDOC_VIZ_MODEL, ENTITY_TYPE_POWERBI_REPORT, ENTITY_TYPE_POWERBI_TILE, ENTITY_TYPE_POWERBI_DATASET, ENTITY_TYPE_POWERBI_DASHBOARD, ENTITY_TYPE_POWERBI_TENANT, ENTITY_TYPE_THOUGHTSPOT_LIVEBOARD, ENTITY_TYPE_THOUGHTSPOT_WORKSHEET, ENTITY_TYPE_SIGMA_WORKBOOK, ENTITY_TYPE_SIGMA_DATA_MODEL, ENTITY_TYPE_SIGMA_ORGANIZATION, ENTITY_TYPE_DOMO_PAGE, ENTITY_TYPE_DOMO_DATASET, ENTITY_TYPE_MSSQL_TABLE, ENTITY_TYPE_MSSQL_VIEW, ENTITY_TYPE_MSSQL_PROCEDURE, ENTITY_TYPE_MSSQL_FUNCTION, ENTITY_TYPE_ORACLE_TABLE, ENTITY_TYPE_ORACLE_VIEW, ENTITY_TYPE_ORACLE_PROCEDURE, ENTITY_TYPE_ORACLE_FUNCTION, ENTITY_TYPE_ATHENA_TABLE, ENTITY_TYPE_ATHENA_VIEW, ENTITY_TYPE_FABRIC_TABLE, ENTITY_TYPE_FABRIC_VIEW, ENTITY_TYPE_FABRIC_PROCEDURE, ENTITY_TYPE_FABRIC_FUNCTION, ENTITY_TYPE_DB2_TABLE, ENTITY_TYPE_DB2_VIEW, ENTITY_TYPE_DB2_PROCEDURE, ENTITY_TYPE_DB2_FUNCTION, ENTITY_TYPE_LOOKER_STUDIO_CUSTOMER, ENTITY_TYPE_LOOKER_STUDIO_REPORT, ENTITY_TYPE_LOOKER_STUDIO_DATA_SOURCE, ENTITY_TYPE_CUSTOM_ENTITY_GENERIC, ENTITY_TYPE_CUSTOM_ENTITY_CUSTOM_TYPE_MIN, ENTITY_TYPE_CUSTOM_ENTITY_CUSTOM_TYPE_MAX Traits to select by, instead of — or alongside — naming types.
A trait is a property a type has, so is_monitorable means "everything a
monitor can run on" without listing the forty-odd types that satisfy it
today. The list it stands for is worked out each time the selection runs,
so a selection saved this way covers a new platform's tables as soon as we
support them, and you never have to revisit it.
Entities carrying any of the traits match. When types is also set the two
narrow each other: the entity must be one of the named types AND carry one
of the traits.
Accepted values, and what each one means, come from the selection-query
grammar the API publishes (describe_resolver_ql, or the query editor's
reference). A name that is not in it selects nothing rather than being
ignored, so a typo narrows the result to empty instead of widening it —
check a trait against the grammar before storing a selection. In a query
written as text this is with_type(traits="is_monitorable"), and there a
name outside the grammar is rejected outright.
A trait may also be a type alias, spelled alias:<name> where <name> is
one of the aliases the grammar lists among the entity types, e.g.
alias:table. It selects every type the alias stands for, worked out each
time the selection runs like any other trait. A selection written as
with_type("table") is stored this way and reads back with
traits: ["alias:table"]; writing that back keeps the same selection. In a
query written as text an alias is always with_type("table"), never
traits="alias:table".
Workspace SQL analytics endpoint host, e.g. ".datawarehouse.fabric.microsoft.com". Identifies the Fabric workspace the integration connects to. Fabric is workspace-scoped with cross-database queries, so the workspace host alone identifies the platform (like Databricks' workspace URL); a specific warehouse/table is addressed by FabricTableIdentifier.
Fabric workspace GUID — the identifier used by the Fabric REST API for
workspace-scoped resources. The Fabric endpoint host in instance encodes
the tenant and workspace GUIDs; this is the decoded workspace GUID, provided
so you don't have to decode it yourself. instance remains the identifying
value. Optional: empty when the host isn't a standard Fabric endpoint.
DATA_PLATFORM_TYPE_UNSPECIFIED, DATA_PLATFORM_TYPE_BIGQUERY, DATA_PLATFORM_TYPE_LOOKER, DATA_PLATFORM_TYPE_DBT, DATA_PLATFORM_TYPE_DBT_CLOUD, DATA_PLATFORM_TYPE_DBT_SELF_HOSTED, DATA_PLATFORM_TYPE_SNOWFLAKE, DATA_PLATFORM_TYPE_GCP, DATA_PLATFORM_TYPE_GIT, DATA_PLATFORM_TYPE_GITHUB, DATA_PLATFORM_TYPE_REDSHIFT, DATA_PLATFORM_TYPE_TABLEAU, DATA_PLATFORM_TYPE_AIRFLOW, DATA_PLATFORM_TYPE_CLICKHOUSE, DATA_PLATFORM_TYPE_POSTGRES, DATA_PLATFORM_TYPE_MYSQL, DATA_PLATFORM_TYPE_DATABRICKS, DATA_PLATFORM_TYPE_SQLMESH, DATA_PLATFORM_TYPE_DUCKDB, DATA_PLATFORM_TYPE_TRINO, DATA_PLATFORM_TYPE_ATLAN, DATA_PLATFORM_TYPE_COALESCE, DATA_PLATFORM_TYPE_CASTORDOC, DATA_PLATFORM_TYPE_FIVETRAN, DATA_PLATFORM_TYPE_DAGSTER, DATA_PLATFORM_TYPE_AIRBYTE, DATA_PLATFORM_TYPE_STITCH, DATA_PLATFORM_TYPE_SNOWPLOW, DATA_PLATFORM_TYPE_POWERBI, DATA_PLATFORM_TYPE_THOUGHTSPOT, DATA_PLATFORM_TYPE_SIGMA, DATA_PLATFORM_TYPE_DOMO, DATA_PLATFORM_TYPE_MSSQL, DATA_PLATFORM_TYPE_ORACLE, DATA_PLATFORM_TYPE_ATHENA, DATA_PLATFORM_TYPE_FABRIC, DATA_PLATFORM_TYPE_DB2, DATA_PLATFORM_TYPE_LOOKER_STUDIO, DATA_PLATFORM_TYPE_HEX, DATA_PLATFORM_TYPE_OMNI, DATA_PLATFORM_TYPE_METABASE, DATA_PLATFORM_TYPE_GOOGLE_SHEETS, DATA_PLATFORM_TYPE_GRAFANA, DATA_PLATFORM_TYPE_STREAMLIT, DATA_PLATFORM_TYPE_ASTRATO, DATA_PLATFORM_TYPE_SNOWFLAKE_CORTEX, DATA_PLATFORM_TYPE_SNOWFLAKE_INTELLIGENCE, DATA_PLATFORM_TYPE_CUBE, DATA_PLATFORM_TYPE_CENSUS, DATA_PLATFORM_TYPE_HIGHTOUCH, DATA_PLATFORM_TYPE_WORKATO, DATA_PLATFORM_TYPE_ESTUARY, DATA_PLATFORM_TYPE_DLT, DATA_PLATFORM_TYPE_TERRAFORM, DATA_PLATFORM_TYPE_HEVO, DATA_PLATFORM_TYPE_DATASTREAM, DATA_PLATFORM_TYPE_QLIK, DATA_PLATFORM_TYPE_SALESFORCE, DATA_PLATFORM_TYPE_SYNQ When false or unset, matches only the direct members of the folder(s). When true, matches the entire recursive subtree (members of subfolders too).
Exception: when only the legacy path source is set and deep is unset,
it defaults to true (preserves the behaviour of queries authored before this
flag existed). With folders or folder_of, unset means false (shallow).
The entities to select. An id may not be blank.
An empty list selects no entities, exactly as an empty identifier_list
does. Be deliberate about it, because it is not the same as leaving the part
out: a part that selects nothing still counts, so it empties an AND, adds
nothing to an OR, and removes nothing from an EXCEPT. If what you mean is
"do not restrict on specific entities", omit the part instead of sending it
empty.
Ids may be up to 1024 characters — the same limit as Identifier.entity_id,
where you read them from, so any id the API returned is accepted here.
1 - 1024Response
Success