Get connections
https://api.lytics.io/v2/connectionGet a list of all connections for the account
{
"_meta": {},
"data": [
{
"account_id": "string",
"aid": 0,
"auth_ids": [
"string"
],
"author_id": "string",
"config": {
"bucket": "string",
"connection_url": "string",
"database": "string",
"dataset": "string",
"file": "string",
"project": "string",
"ssl_mode": "string"
},
"connection_config_id": "string",
"connection_config_slug": "string",
"created": "string",
"deleted": "string",
"description": "string",
"id": "string",
"label": "string",
"provider_id": "string",
"provider_slug": "string",
"updated": "string",
"updated_by_user_id": "string"
}
],
"request_id": "string",
"status": 0
}Create connection
https://api.lytics.io/v2/connectionCreate a connection
{
"auth_ids": [
"string"
],
"config": {
"bucket": "string",
"connection_url": "string",
"database": "string",
"dataset": "string",
"file": "string",
"project": "string",
"ssl_mode": "string"
},
"connection_config_id": "string",
"connection_config_slug": "string",
"description": "string",
"label": "string",
"provider_id": "string",
"provider_slug": "string"
}{
"_meta": {},
"data": {
"account_id": "string",
"aid": 0,
"auth_ids": [
"string"
],
"author_id": "string",
"config": {
"bucket": "string",
"connection_url": "string",
"database": "string",
"dataset": "string",
"file": "string",
"project": "string",
"ssl_mode": "string"
},
"connection_config_id": "string",
"connection_config_slug": "string",
"created": "string",
"deleted": "string",
"description": "string",
"id": "string",
"label": "string",
"provider_id": "string",
"provider_slug": "string",
"updated": "string",
"updated_by_user_id": "string"
},
"request_id": "string",
"status": 0
}Get connection
https://api.lytics.io/v2/connection/{id}Get a connection by ID
{
"_meta": {},
"data": {
"account_id": "string",
"aid": 0,
"auth_ids": [
"string"
],
"author_id": "string",
"config": {
"bucket": "string",
"connection_url": "string",
"database": "string",
"dataset": "string",
"file": "string",
"project": "string",
"ssl_mode": "string"
},
"connection_config_id": "string",
"connection_config_slug": "string",
"created": "string",
"deleted": "string",
"description": "string",
"id": "string",
"label": "string",
"provider_id": "string",
"provider_slug": "string",
"updated": "string",
"updated_by_user_id": "string"
},
"request_id": "string",
"status": 0
}Update connection
https://api.lytics.io/v2/connection/{id}Update a connection
{
"auth_ids": [
"string"
],
"description": "string",
"label": "string"
}{
"_meta": {},
"data": {
"account_id": "string",
"aid": 0,
"auth_ids": [
"string"
],
"author_id": "string",
"config": {
"bucket": "string",
"connection_url": "string",
"database": "string",
"dataset": "string",
"file": "string",
"project": "string",
"ssl_mode": "string"
},
"connection_config_id": "string",
"connection_config_slug": "string",
"created": "string",
"deleted": "string",
"description": "string",
"id": "string",
"label": "string",
"provider_id": "string",
"provider_slug": "string",
"updated": "string",
"updated_by_user_id": "string"
},
"request_id": "string",
"status": 0
}Delete connection
https://api.lytics.io/v2/connection/{id}Delete a connection
{
"_meta": {},
"data": {},
"request_id": "string",
"status": 0
}Count the rows a query returns
https://api.lytics.io/v2/connection/{id}/countCount the rows a query against an external data source returns, without fetching them. The query is checked the same way as a scan; counting stops after a minute.
{
"query": "string"
}{
"_meta": {},
"data": {
"row_count": 0
},
"request_id": "string",
"status": 0
}Query an external data source
https://api.lytics.io/v2/connection/{id}/scanQuery an external data source to get sample result set for members of a Cloud Connect model.
{
"primary_keys": [
"string"
],
"query": "string"
}{
"_meta": {},
"data": {
"columns": [
{
"column_datatype": "string",
"column_name": "string"
}
],
"row_count": 0,
"rows": null
},
"request_id": "string",
"status": 0
}Get the tables for a connection
https://api.lytics.io/v2/connection/{id}/schemaReturns all the table names for the given connection
{
"_meta": {},
"data": [
{
"error": "string",
"fully_qualified_name": "string",
"num_columns": 0,
"table_name": "string"
}
],
"request_id": "string",
"status": 0
}Get the schema for a table on the connection
https://api.lytics.io/v2/connection/{id}/schema/{table}Returns all the columns for a table on the given connection
{
"_meta": {},
"data": [
{
"column_datatype": "string",
"column_name": "string"
}
],
"request_id": "string",
"status": 0
}