--- updatedAt: 2026-08-27T13:50:24.000Z agentTools: projectIndex: https://developers.tidio.com/llms.txt --- # Get ticket_message_details This endpoint provides you with the raw data for your ticket messages. # OpenAPI definition ```json { "openapi": "3.0.3", "info": { "description": "This is a dynamic API generated by PostgREST", "title": "TIDIO Analytics API", "version": "14.4" }, "externalDocs": { "description": "PostgREST Documentation", "url": "https://postgrest.org/en/v14/references/api.html" }, "servers": [ { "url": "https://taa.data.tidio.com" } ], "tags": [ { "name": "Ticket message details" } ], "security": [ { "ClientId": [], "ClientSecret": [] } ], "paths": { "/ticket_message_details": { "get": { "tags": [ "Ticket message details" ], "summary": "Get ticket_message_details", "description": "This endpoint provides you with the raw data for your ticket messages.", "parameters": [ { "name": "_unique_id", "description": "Technical field used as primary key of the model.", "required": false, "in": "query", "schema": { "type": "string" } }, { "name": "ticket_message_id", "description": "Unique identifier for each ticket message.", "required": false, "in": "query", "schema": { "type": "string" } }, { "name": "contact_id", "description": "Unique identifier for the contact.", "required": false, "in": "query", "schema": { "type": "string" } }, { "name": "ticket_id", "description": "Unique identifier for the ticket.", "required": false, "in": "query", "schema": { "type": "string" } }, { "name": "time_sent", "description": "Timestamp when the message was sent.", "required": false, "in": "query", "schema": { "type": "string" } }, { "name": "message_type", "description": "Type of the ticket message. Possible values: internal, public.", "required": false, "in": "query", "schema": { "type": "string" } }, { "name": "message_content", "description": "Content of the ticket message.", "required": false, "in": "query", "schema": { "type": "string" } }, { "name": "actor", "description": "Actor who sent the message. Possible values: 'Lyro AI Agent', 'visitor', 'worfklow' or 'agent'.", "required": false, "in": "query", "schema": { "type": "string" } }, { "name": "agent_id", "description": "Internal identifier for the agent handling the message. NULL if generated by AI or visitor.", "required": false, "in": "query", "schema": { "type": "string" } }, { "name": "_updated_at", "description": "Technical timestamp (UTC, NTZ)", "required": false, "in": "query", "schema": { "type": "string" } }, { "name": "select", "description": "Filtering Columns", "required": false, "in": "query", "schema": { "type": "string" } }, { "name": "order", "description": "Ordering", "required": false, "in": "query", "schema": { "type": "string" } }, { "name": "Range", "description": "Limiting and Pagination", "required": false, "in": "header", "schema": { "type": "string" } }, { "name": "Range-Unit", "description": "Limiting and Pagination", "required": false, "in": "header", "schema": { "default": "items", "type": "string" } }, { "name": "offset", "description": "Limiting and Pagination", "required": false, "in": "query", "schema": { "type": "string" } }, { "name": "limit", "description": "Maximum rows to return. Pre-filled with 100 to keep the request fast. The API applies no implicit limit -- an unbounded query against a large table exceeds the 25s statement timeout and returns 408, so raise this in steps and page rather than clearing it.", "required": true, "in": "query", "schema": { "type": "string", "default": "100", "example": "100" }, "example": "100" }, { "name": "Prefer", "description": "Preference", "required": false, "in": "header", "schema": { "enum": [ "count=none" ], "type": "string" } } ], "responses": { "200": { "description": "OK", "content": { "application/json": { "schema": { "items": { "description": "This endpoint provides you with the raw data for your ticket messages.", "properties": { "_unique_id": { "description": "Technical field used as primary key of the model.", "type": "number", "x-postgres-format": "numeric" }, "ticket_message_id": { "description": "Unique identifier for each ticket message.", "type": "string", "x-postgres-format": "text" }, "project_id": { "description": "Unique identifier for the project.", "type": "number", "x-postgres-format": "numeric" }, "contact_id": { "description": "Unique identifier for the contact.", "type": "number", "x-postgres-format": "numeric" }, "ticket_id": { "description": "Unique identifier for the ticket.", "type": "number", "x-postgres-format": "numeric" }, "time_sent": { "description": "Timestamp when the message was sent.", "format": "date-time", "type": "string" }, "message_type": { "description": "Type of the ticket message. Possible values: internal, public.", "type": "string", "x-postgres-format": "text" }, "message_content": { "description": "Content of the ticket message.", "type": "string", "x-postgres-format": "text" }, "actor": { "description": "Actor who sent the message. Possible values: 'Lyro AI Agent', 'visitor', 'worfklow' or 'agent'.", "type": "string", "x-postgres-format": "text" }, "agent_id": { "description": "Internal identifier for the agent handling the message. NULL if generated by AI or visitor.", "type": "number", "x-postgres-format": "numeric" }, "_updated_at": { "description": "Technical timestamp (UTC, NTZ)", "format": "date-time", "type": "string" } }, "type": "object" }, "type": "array" } } } }, "206": { "description": "Partial Content" }, "408": { "description": "Request Timeout. The query took longer than the database's 25s statement limit -- almost always an unbounded read of a large table. Add a `limit`, narrow the date filter, or page with `Range`/keyset instead of scanning the whole table. `Prefer: count=exact` also forces a full scan; use `count=planned` on the large tables.", "content": { "application/json": { "schema": { "type": "object", "properties": { "detail": { "type": "string", "example": "Request to database timed out after 25s. Please adjust your query." } } } } } } }, "x-readme": { "code-samples": [ { "language": "curl", "name": "Fetch rows (keyset paging)", "code": "# Next page: append &_unique_id=gt.\ncurl \"https://taa.data.tidio.com/ticket_message_details?select=_unique_id,ticket_message_id,ticket_id,time_sent,actor,message_type,message_content&order=_unique_id.asc&limit=500\" \\\n -H \"X-Tidio-Openapi-Client-Id: $TIDIO_CLIENT_ID\" \\\n -H \"X-Tidio-Openapi-Client-Secret: $TIDIO_CLIENT_SECRET\"" } ] } } } }, "components": { "securitySchemes": { "ClientId": { "type": "apiKey", "in": "header", "name": "X-Tidio-Openapi-Client-Id" }, "ClientSecret": { "type": "apiKey", "in": "header", "name": "X-Tidio-Openapi-Client-Secret" } } }, "x-readme": { "samples-languages": [ "curl" ] } } ```