Queries
Was this helpful?
Was this helpful?
Queries from an extraction. Learn more about queries .
Warning: This endpoint is deprecated. Please use the List Resources endpoint instead with
filter={"operator":"exact","field":"type","value":"query"}.
GET /query/queries HTTP/1.1
Host: api.secoda.co
Authorization: Bearer string
Accept: */*
{
"links": {
"next": "https://api.secoda.co/resource/all/?page=2",
"previous": "None"
},
"meta": {
"page": 1,
"previous_page": "None",
"next_page": 2
},
"count": 315,
"total_pages": 7,
"results": [
{
"id": "d935a76c-2125-4c30-9389-ef42fa7e23bb",
"created_at": "2023-08-16T23:12:53.245493Z",
"updated_at": "2023-08-16T23:12:53.245507Z",
"entity_type": "table",
"native_type": "Dataset",
"bookmarked_by": [
"d935a76c-2125-4c30-9389-ef42fa7e23bb",
"33733f42-8ff7-460b-9e20-50a2133d3bb0",
"c90dedee-40ee-47ec-9c27-96dc3b2ec363"
],
"icon": "icon-url.png",
"title": "Sample Table",
"title_full": "Sample Database.Sample Schema.Sample Table",
"title_cased": "sampleTable",
"description": "This is a description for a sample table.",
"definition": "text",
"definition_version": 1,
"multiplayers": [
"429693a2-a5e7-4525-b413-ece5e96bc5b3",
"f71585fa-251c-4102-8d81-c97c57c8d435"
],
"multiplayer_last_modified_by": "429693a2-a5e7-4525-b413-ece5e96bc5b3",
"multiplayer_last_modified": "2023-08-16T23:12:53.245507Z",
"owners": [
"429693a2-a5e7-4525-b413-ece5e96bc5b3",
"f71585fa-251c-4102-8d81-c97c57c8d435"
],
"owners_groups": [
"3b2c7185-fb5d-4d94-89d4-3dae08e093a9"
],
"collections": [
"e8ac09ed-e51e-4e61-8eaf-59942c98c260"
],
"tags": [
"f7466f09-33bf-4ac2-9ff2-165fb4b8bdc2",
"a17f4ed0-0e5a-45a9-92c0-6c93c0b8242c"
],
"workspace_id": "f71585fa-251c-4102-8d81-c97c57c8d435",
"total_usage": 483,
"published": false,
"archived": false,
"pii": true,
"verified": false,
"url": "https://example.com/sample-table",
"parent": "df2c0597-13d9-4159-bb6d-00b3f54235dc",
"children_count": 2,
"integration": "ca529385-fbc9-4934-afae-e372affe795b",
"external_updated_at": "2023-08-16T23:12:53.245507Z",
"internal_usage": 3,
"internal_users": [
"04654d61-4f64-4f08-b697-3915b5137c49"
],
"external_users": [
"33733f42-8ff7-460b-9e20-50a2133d3bb0"
],
"external_usage": 38,
"databuilder_id": "b818280a-ae1a-43bf-90d3-dbccf812b025.x68605bd2",
"search_metadata": {
"cluster": "glue",
"database": "awsdatacatalog",
"schema": "secoda-glue",
"type": "table"
},
"sources": [
"8a3af948-026c-45d6-983d-3873f6156f86"
],
"subscribers": [
"33733f42-8ff7-460b-9e20-50a2133d3bb0",
"c90dedee-40ee-47ec-9c27-96dc3b2ec363"
],
"teams": [
"8680f886-97d2-4f4e-92c8-c80b46a3017d"
],
"stale": false,
"current_user_permissions": {
"read": true,
"write": true,
"execute": false
},
"type": "None",
"freq": 0
}
]
}This endpoint allows you to retrieve a query by its unique identifier (query_id).
The unique identifier of the query
871fc00d-828b-4348-9353-c635313ee459GET /query/queries/{query_id} HTTP/1.1
Host: api.secoda.co
Authorization: Bearer string
Accept: */*
{
"id": "d935a76c-2125-4c30-9389-ef42fa7e23bb",
"created_at": "2023-08-16T23:12:53.245493Z",
"updated_at": "2023-08-16T23:12:53.245507Z",
"entity_type": "table",
"native_type": "Dataset",
"bookmarked_by": [
"d935a76c-2125-4c30-9389-ef42fa7e23bb",
"33733f42-8ff7-460b-9e20-50a2133d3bb0",
"c90dedee-40ee-47ec-9c27-96dc3b2ec363"
],
"icon": "icon-url.png",
"title": "Sample Table",
"title_full": "Sample Database.Sample Schema.Sample Table",
"title_cased": "sampleTable",
"description": "This is a description for a sample table.",
"definition": "text",
"definition_version": 1,
"multiplayers": [
"429693a2-a5e7-4525-b413-ece5e96bc5b3",
"f71585fa-251c-4102-8d81-c97c57c8d435"
],
"multiplayer_last_modified_by": "429693a2-a5e7-4525-b413-ece5e96bc5b3",
"multiplayer_last_modified": "2023-08-16T23:12:53.245507Z",
"owners": [
"429693a2-a5e7-4525-b413-ece5e96bc5b3",
"f71585fa-251c-4102-8d81-c97c57c8d435"
],
"owners_groups": [
"3b2c7185-fb5d-4d94-89d4-3dae08e093a9"
],
"collections": [
"e8ac09ed-e51e-4e61-8eaf-59942c98c260"
],
"tags": [
"f7466f09-33bf-4ac2-9ff2-165fb4b8bdc2",
"a17f4ed0-0e5a-45a9-92c0-6c93c0b8242c"
],
"workspace_id": "f71585fa-251c-4102-8d81-c97c57c8d435",
"total_usage": 483,
"published": false,
"archived": false,
"pii": true,
"verified": false,
"url": "https://example.com/sample-table",
"parent": "df2c0597-13d9-4159-bb6d-00b3f54235dc",
"children_count": 2,
"integration": "ca529385-fbc9-4934-afae-e372affe795b",
"external_updated_at": "2023-08-16T23:12:53.245507Z",
"internal_usage": 3,
"internal_users": [
"04654d61-4f64-4f08-b697-3915b5137c49"
],
"external_users": [
"33733f42-8ff7-460b-9e20-50a2133d3bb0"
],
"external_usage": 38,
"databuilder_id": "b818280a-ae1a-43bf-90d3-dbccf812b025.x68605bd2",
"search_metadata": {
"cluster": "glue",
"database": "awsdatacatalog",
"schema": "secoda-glue",
"type": "table"
},
"sources": [
"8a3af948-026c-45d6-983d-3873f6156f86"
],
"subscribers": [
"33733f42-8ff7-460b-9e20-50a2133d3bb0",
"c90dedee-40ee-47ec-9c27-96dc3b2ec363"
],
"teams": [
"8680f886-97d2-4f4e-92c8-c80b46a3017d"
],
"stale": false,
"current_user_permissions": {
"read": true,
"write": true,
"execute": false
},
"type": "None",
"freq": 0
}