> ## Documentation Index > Fetch the complete documentation index at: https://deepline.com/docs/llms.txt > Use this file to discover all available pages before exploring further. # ClickHouse Cloud: Clickhouse Activity Get List > List the activity log of a ClickHouse Cloud organization, optionally between two dates. Includes inputs, outputs, SDK V2 examples, and Deepline cost. List the activity log of a ClickHouse Cloud organization, optionally between two dates. > [!NOTE] > > Tool ID: `clickhouse_activity_get_list` ## Run this action Use the TypeScript SDK for one call. Use `ctx.tools.execute(...)` inside a Play for durable calls, scheduled calls, or CSV processing. ```ts theme={"languages":{"custom":["/languages/deepline-prompt.json"]}} import { Deepline } from 'deepline'; const deepline = await Deepline.connect(); const result = await deepline.tools.execute( 'clickhouse_activity_get_list', { "organizationId": "123e4567-e89b-42d3-a456-426614174000" }, ); console.log(result.toolResponse.raw); ``` ### CLI ```bash theme={"languages":{"custom":["/languages/deepline-prompt.json"]}} deepline tools execute clickhouse_activity_get_list --input '{ "organizationId": "123e4567-e89b-42d3-a456-426614174000" }' --json ``` ## Example response The SDK returns this shape at `result.toolResponse.raw`. The example values illustrate the response. ```json theme={"languages":{"custom":["/languages/deepline-prompt.json"]}} { "data": { "status": 123, "requestId": "123e4567-e89b-42d3-a456-426614174000", "result": [ { "id": "id_123", "createdAt": "2026-01-15T12:00:00Z", "type": "create_organization" } ] } } ``` Use `deepline describe clickhouse_activity_get_list --json` for the latest machine-readable contract. ## Input reference Returns a list of all organization activities. | Name | Type | Required | Default | Details | | - | - | - | - | - | | `payload.organizationId` | `string` | Yes | — | ID of the requested organization. Format: `uuid`. | | `payload.from_date` | `string` | No | — | A starting date for a search Format: `date-time`. | | `payload.to_date` | `string` | No | — | An ending date for a search Format: `date-time`. |
Show raw input schema ### Input JSON Schema ```json theme={"languages":{"custom":["/languages/deepline-prompt.json"]}} { "type": "object", "description": "Returns a list of all organization activities.", "properties": { "organizationId": { "type": "string", "description": "ID of the requested organization.", "format": "uuid" }, "from_date": { "type": "string", "description": "A starting date for a search", "format": "date-time" }, "to_date": { "type": "string", "description": "An ending date for a search", "format": "date-time" } }, "required": [ "organizationId" ], "additionalProperties": false } ```
## Output reference Standard tool result payload. | Name | Type | Required | Default | Details | | - | - | - | - | - | | `result.data` | `object` | Yes | — | Provider response payload. | | `result.data.status` | `number` | No | — | HTTP status code. | | `result.data.requestId` | `string` | No | — | Unique id assigned to every request. UUIDv4 Format: `uuid`. | | `result.data.result` | `array` | No | — | — | | `result.data.result[].id` | `string` | No | — | Unique activity ID. | | `result.data.result[].createdAt` | `string` | No | — | Timestamp of the activity. ISO-8601. Format: `date-time`. | | `result.data.result[].type` | `"create_organization" \| "organization_update_name" \| "transfer_service_in" \| "transfer_service_out" \| "save_payment_method" \| "marketplace_subscription" \| "migrate_marketplace_billing_details_in" \| "migrate_marketplace_billing_details_out" \| "organization_update_tier" \| "organization_invite_create" \| "organization_invite_delete" \| "organization_member_join" \| "organization_member_add" \| "organization_member_leave" \| "organization_member_delete" \| "organization_member_update_role" \| "organization_member_update_roles" \| "organization_member_update_mfa_method" \| "organization_saml_connection_create" \| "organization_saml_connection_update" \| "user_login" \| "user_login_failed" \| "user_logout" \| "key_create" \| "key_delete" \| "openapi_key_update" \| "service_create" \| "service_start" \| "service_stop" \| "service_awaken" \| "service_idle" \| "service_running" \| "service_partially_running" \| "service_delete" \| "service_update_name" \| "service_update_ip_access_list" \| "service_update_autoscaling_memory" \| "service_update_autoscaling_idling" \| "service_update_password" \| "service_update_autoscaling_replicas" \| "service_update_max_allowable_replicas" \| "service_update_backup_configuration" \| "service_update_snapshot_configuration" \| "service_restore_backup" \| "service_update_release_channel" \| "service_update_gpt_usage_consent" \| "service_update_private_endpoints" \| "service_import_to_organization" \| "service_export_from_organization" \| "service_maintenance_start" \| "service_maintenance_end" \| "service_update_core_dump" \| "backup_delete"` | No | — | Type of the activity. Allowed: `create_organization`, `organization_update_name`, `transfer_service_in`, `transfer_service_out`, `save_payment_method`, `marketplace_subscription`, `migrate_marketplace_billing_details_in`, `migrate_marketplace_billing_details_out`, `organization_update_tier`, `organization_invite_create`, `organization_invite_delete`, `organization_member_join`, `organization_member_add`, `organization_member_leave`, `organization_member_delete`, See the live schema for the complete constraint. | | `result.data.result[].actorType` | `"user" \| "support" \| "system" \| "api"` | No | — | Type of the actor: 'user', 'support', 'system', 'api'. Allowed: `user`, `support`, `system`, `api`. | | `result.data.result[].actorId` | `string` | No | — | Unique actor ID. | | `result.data.result[].actorDetails` | `string` | No | — | Additional information about the actor. | | `result.data.result[].actorIpAddress` | `string` | No | — | IP address of the actor. Defined for 'user' and 'api' actor types. | | `result.data.result[].organizationId` | `string` | No | — | Scope of the activity: organization ID this activity is related to. | | `result.data.result[].serviceId` | `string` | No | — | Scope of the activity: service ID this activity is related to. | | `result.data.result[].userAgent` | `string` | No | — | User agent of the actor | | `result.data.result[].targetKeyId` | `string` | No | — | For 'openapi\_key\_update' activities: the ID of the API key that was updated. | | `result.data.result[].keyUpdateType` | `"created" \| "deleted" \| "name-changed" \| "role-changed" \| "state-changed" \| "date-changed" \| "ip-access-list-changed" \| "org-role-changed" \| "default-service-role-changed" \| "service-role-changed" \| "roles-v2-changed"` | No | — | For 'openapi\_key\_update' activities: the type of update that was performed. Allowed: `created`, `deleted`, `name-changed`, `role-changed`, `state-changed`, `date-changed`, `ip-access-list-changed`, `org-role-changed`, `default-service-role-changed`, `service-role-changed`, `roles-v2-changed`. | | `result.meta` | `object` | No | — | Additional response metadata (status, paging). |
Show raw output schema ### Output JSON Schema ```json theme={"languages":{"custom":["/languages/deepline-prompt.json"]}} { "type": "object", "description": "Standard tool result payload.", "properties": { "data": { "type": "object", "description": "Provider response payload.", "properties": { "status": { "type": "number", "description": "HTTP status code." }, "requestId": { "type": "string", "description": "Unique id assigned to every request. UUIDv4", "format": "uuid" }, "result": { "type": "array", "items": { "properties": { "id": { "type": "string", "description": "Unique activity ID." }, "createdAt": { "type": "string", "description": "Timestamp of the activity. ISO-8601.", "format": "date-time" }, "type": { "type": "string", "description": "Type of the activity.", "enum": [ "create_organization", "organization_update_name", "transfer_service_in", "transfer_service_out", "save_payment_method", "marketplace_subscription", "migrate_marketplace_billing_details_in", "migrate_marketplace_billing_details_out", "organization_update_tier", "organization_invite_create", "organization_invite_delete", "organization_member_join", "organization_member_add", "organization_member_leave", "organization_member_delete", "organization_member_update_role", "organization_member_update_roles", "organization_member_update_mfa_method", "organization_saml_connection_create", "organization_saml_connection_update", "user_login", "user_login_failed", "user_logout", "key_create", "key_delete", "openapi_key_update", "service_create", "service_start", "service_stop", "service_awaken", "service_idle", "service_running", "service_partially_running", "service_delete", "service_update_name", "service_update_ip_access_list", "service_update_autoscaling_memory", "service_update_autoscaling_idling", "service_update_password", "service_update_autoscaling_replicas", "service_update_max_allowable_replicas", "service_update_backup_configuration", "service_update_snapshot_configuration", "service_restore_backup", "service_update_release_channel", "service_update_gpt_usage_consent", "service_update_private_endpoints", "service_import_to_organization", "service_export_from_organization", "service_maintenance_start", "service_maintenance_end", "service_update_core_dump", "backup_delete" ] }, "actorType": { "type": "string", "description": "Type of the actor: 'user', 'support', 'system', 'api'.", "enum": [ "user", "support", "system", "api" ] }, "actorId": { "type": "string", "description": "Unique actor ID." }, "actorDetails": { "type": "string", "description": "Additional information about the actor." }, "actorIpAddress": { "type": "string", "description": "IP address of the actor. Defined for 'user' and 'api' actor types." }, "organizationId": { "type": "string", "description": "Scope of the activity: organization ID this activity is related to." }, "serviceId": { "type": "string", "description": "Scope of the activity: service ID this activity is related to." }, "userAgent": { "type": "string", "description": "User agent of the actor" }, "targetKeyId": { "type": "string", "description": "For 'openapi_key_update' activities: the ID of the API key that was updated." }, "keyUpdateType": { "type": "string", "description": "For 'openapi_key_update' activities: the type of update that was performed.", "enum": [ "created", "deleted", "name-changed", "role-changed", "state-changed", "date-changed", "ip-access-list-changed", "org-role-changed", "default-service-role-changed", "service-role-changed", "roles-v2-changed" ] } }, "additionalProperties": false } } }, "additionalProperties": false }, "meta": { "type": "object", "description": "Additional response metadata (status, paging).", "additionalProperties": true } }, "required": [ "data" ], "additionalProperties": false } ```
## Deepline cost * Pricing model: `fixed` (per call). * Estimated Deepline credits: `0` per pricing unit. * Provider-native pricing may still exist outside Deepline credit billing. ## Related documentation * [ClickHouse Cloud provider guide](https://deepline.com/docs/providers/clickhouse/guide.md) * [SDK V2 quickstart](https://deepline.com/docs/sdk-v2/quickstart.md) * [SDK reference](https://deepline.com/docs/sdk-v2/sdk-reference.md) * [Run tools across a CSV](https://deepline.com/docs/sdk-v2/batch-csv.md) This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.