Skip to main content
Updated in 2025.25 Live Agent exposes an OData 4 analytics endpoint to retrieve analytics records. OData, the best way to REST, is a powerful API framework. The OData endpoints allows you to retrieve the most relevant data models from Live Agent by using GET requests. It covers all your enterprise analytics needs to make fine-grained queries in your spreadsheets or build rich dashboards for your bots with your favorite data visualization tool. The Live Agent OData endpoint supports only GET requests and doesn’t support any other request types, such as PATCH, DELETE, or POST.

Supported Versions

OData endpoint versionLive Agent versionStatusNew in Version
2.02025.25.0 and laterSupportedThe Team and AgentAvailabilityRecord collections were added. A new field, priority, was added to the Conversation model, and the changes introduced in 1.1 were rolled back.
1.12025.18.0 or laterSupportedRollback to pre-1.0 fields: - Restored fields: Conversation (identifier, contact_last_seen_at), Inbox (greeting_enabled, greeting_message, email_address), Message (status, source_id), User (encrypted_password, reset_password_token, reset_password_sent_at, remember_created_at, current_sign_in_ip, last_sign_in_ip, confirmation_token) - No longer supported: Conversation (assigned_at, ended_at), Label (conversation_ids), User (last_sign_out_at)
1.01.0.0 and laterSupportedInitial release.

Usage and Authentication

To connect to the OData endpoint, get a Live Agent Access Token:
  1. In the left-side menu of the Live Agent interface, go to Profile Settings.
  2. In the Access Token section, copy the existing token.
  3. Paste this token into your OData request.
An OData URL is composed of the service root, API version, service path, data collection, and Live Agent access token parameter as follows:
GET /<api-version>/odata/<OData data model>?<odata query> HTTP/1.1
Host: <odata domain>
Authorization: Bearer <Live Agent access token>
The authentication can also be done using a query param such as follows:
/<api-version>/odata/<OData data model>?<odata query>&$top=1&$skip=0&apikey=<Live Agent access token>
The OData endpoint is available on a different domain from your Cognigy User Interface domain. For example, https://odata-liveagent-trial.cognigy.ai/v1.0/odata.For example, on our trial server, the OData endpoint URL for the Analytics Inputs Collection is https://odata-liveagent-trial.cognigy.ai/v1.0/odata/Message?. For on-premises installations, replace the odata-trial.cognigy.ai domain name with the domain name configured for your local installation.
When using Power BI or Excel, you might be asked to authenticate. Simply choose anonymous authentication and pass the Live Agent access token as a query parameter &apikey=<Live Agent access-token>

Endpoint Versions

This endpoint version is available in Live Agent 2025.25.0 and later. In this version, the following OData collections are available:To see all the available OData models, use the following Endpoint: https://<hostname>/v1.1/odata/The URL for accessing the OData endpoint 1.1 is the following: https://<hostname>/v1.1/odata/<collection>

Querying

The Endpoint supports the following OData Query Language operators:
  • $skip1
  • $top1
  • $filter
  • $select
  • $orderby
  • $expand

Example Queries

https://odata-liveagent-trial.cognigy.ai/v2.0/odata/Conversation(1)?$select=inbox_id,account_id&$top=1&$skip=0&apikey=<access-token> Return the columns inbox_id and account_id for the Conversation with id=1.https://odata-liveagent-trial.cognigy.ai/v2.0/odata/Conversation?$select=id,account_id&$top=1&$skip=0&apikey=<access-token> Return the columns’ ID and account_id for all Conversations.https://odata-liveagent-trial.cognigy.ai/v2.0/odata/Conversation?$select=id,account_id&$top=1&$skip=0&$filter=created_at le '2021-11-23T00:00:00'&$top=1&$skip=0&apikey=<access-token> Return the columns’ ID and account_id for all the Conversations filtered by the created_at column being lower or equal to ‘2021-11-23T00:00:00’

Reference Documentation

For complete reference documentation, refer to the extensive collection of resources at OData.org and the Oasis OData URL Convention Documentation.

Data Protection & Analytics

Only users with an admin role in Live Agent will be able to query OData Models.

Live Agent OData Collections

This section details the data types that exist within the OData Collections that can be retrieved from the OData endpoint. The following Collections are available:

Message

Description:
https://odata-liveagent-trial.cognigy.ai/v2.0/odata/Message?$top=1&$skip=0
Data Types: When retrieving this data model, the endpoint returns the following fields:
Field NameDescriptionTypeExample
idThe unique message IDNumber9411
contentThe text content of the messageString"hi"
account_idThe ID of the account where the conversation belongsNumber2
inbox_idThe ID of the inbox where the conversation belongsNumber427
conversation_idThe ID of the conversation to which this message belongsNumber1424
message_typeThe type of message: { incoming: 0, outgoing: 1, activity: 2, template: 3 }Number0
created_atThe timestamp when the message was createdDate"2023-01-20T13:01:24.141Z"
updated_atThe timestamp when the message was last updatedDate"2023-01-20T13:01:24.141Z"
privateIndicates if the message is private (visible only to agents)Booleanfalse
content_typeThe content type: text: 0, input_text: 1, input_textarea: 2, input_email: 3Number0
content_attributesJSON object with additional content details, for example, items, external timestampsJSON{"items":[{"text":"hi","data":null}],"external_created_at":1674219684}
sender_typeThe type of sender: "Contact", "Agent", or "cognigy"String"Contact"
sender_idThe unique ID of the senderString"1045"

Conversation

Description: A Conversation is the communication channel opened between an Agent and a client. Example Query:
https://odata-liveagent-trial.cognigy.ai/v2.0/odata/Conversation?$top=1&$skip=0
Data Types: When retrieving this data model, the endpoint returns the following fields:
Field NameDescriptionTypeExample
idThe unique conversation IDNumber74160
account_idThe account ID where the conversation belongsNumber2
inbox_idThe inbox ID where the conversation belongsNumber34608
statusThe conversation status: open: 0, resolved: 1, pending: 2, snoozed: 3, abandoned: 4, deleted: 5Number2
assignee_idThe agent ID assigned to the conversationNumbernull
created_atThe conversation creation dateDate"2023-12-08T13:39:57.528Z"
updated_atThe date when the conversation was last updatedDate"2023-12-08T14:58:04.695Z"
contact_idThe unique client IDNumber"42992"
display_idThe display ID for the conversationNumber6133
agent_last_seen_atThe last seen date of the agentDate"2023-12-19T06:51:27.875Z"
contact_inbox_idThe contact inbox IDNumber"117788"
last_activity_atThe date of the last activity in the conversationDate"2023-12-08T14:58:04.693Z"
team_idThe team ID the conversation belongs toNumbernull
snoozed_untilThe end date until which the conversation is snoozedDatenull
assignee_last_seen_atThe last seen date of the assigned agentDatenull
first_reply_created_atThe date when the first reply was createdDatenull
assigned_atThe date when the conversation was assignedDatenull
ended_atThe date when the conversation endedDatenull
priorityThe priority of the conversation: low: 0, medium: 1, high: 2, urgent: 3, escalation: 4.Numbernull
additional_attributesA JSON object containing any additional attributesJSON""
uuidThe unique identifierString"e41a989a-81c8-49f7-af64-9a85482c67da"
custom_attributesA JSON object containing extra add-on attributesJSON{"enableAgentInject":false,"cognigy_channel_type":"admin-webchat","cognigy_agent_assist_workspace_url":"https://agent-assist-trial.cognigy.ai/?sessionId=session-a369b88c-03fb-4497-a60b-495b94313210&userId=4cc1adcf-df86-401d-86ff-4effd5e3c9b1&URLToken=1234"}
cognigy_session_idThe unique session IDString"session-a369b88c-03fb-4497-a60b-495b94313210"

Inbox

Description: The Inbox is where all Conversations from a specific set of Agents will be placed. Example Query:
https://odata-liveagent-trial.cognigy.ai/v2.0/odata/Inbox?$top=1&$skip=0
Data Types: When retrieving this data model, the endpoint returns the following fields:
Field NameDescriptionTypeExample
idUnique Inbox record IDNumber3
channel_idThe channel ID this Inbox is connected toNumber3
nameInbox nameString"cucumberTest_Project_by_template-default"
account_idAccount ID that owns the InboxNumber2
created_atTimestamp when the Inbox was createdString"2023-01-10T17:36:00.052Z"
updated_atTimestamp when the Inbox was last updatedString"2023-01-10T17:36:00.052Z"
channel_typeCommunication channel type, e.g., API, Webchat, Facebook (Meta)String"Channel::Api"
enable_auto_assignmentWhether conversations are automatically assigned to agentsBooleantrue
working_hours_enabledWhether working hours scheduling is enabledBooleanfalse
out_of_office_messageCustom message displayed when outside working hoursStringnull
timezoneTimezone of the InboxString"UTC"
enable_email_collectWhether email collection is enabledBooleantrue
csat_survey_enabledWhether CSAT survey is enabledBooleanfalse
cognigy_organization_idCognigy Organization IDStringnull
cognigy_project_idCognigy Project IDString"63bda1ff4688585c8fa2ccae"
enable_auto_reassignmentWhether conversations can be automatically reassignedBooleantrue
conversations_show_allWhether agents can see all conversations, even if not assigned to themBooleantrue

Label

Description: Labels are used to mark, identify, or group different Conversations. Example Query:
https://odata-liveagent-trial.cognigy.ai/v2.0/odata/Label?$top=1&$skip=0
Data Types: When retrieving this data model, the endpoint returns the following fields:
Field NameDescriptionTypeExample
idA unique label IDString"1"
titleThe label titleString"qa-60"
descriptionThe label descriptionString"sadc"
colorThe label color in HEX formatString"#111113"
show_on_sidebarIndicates whether the label is shown on the sidebarBooleantrue
account_idThe ID of the account to which the label belongsString"2"
created_atThe label creation timestampDate"2023-01-19T13:31:18.553Z"
updated_atThe label last updated timestampDate"2023-09-18T12:34:19.579Z"
conversation_idsA list of conversation IDs associated with this labelArray of Numbers[77455, 78729, 79906, …]

Reporting Event

Description: The Reporting Event model represents actions or occurrences tracked in the system for reporting and analytics purposes. Example Query:
https://odata-liveagent-trial.cognigy.ai/v2.0/odata/ReportingEvent?$top=10&$skip=0.
Data Types: When retrieving this data model, the endpoint returns the following fields:
Field NameDescriptionTypeExample
idUnique Reporting Event IDNumber4
event_start_timeStart time of the eventDate2023-01-08T18:34:43.162Z
event_end_timeEnd time of the eventDate2023-01-08T18:34:43.162Z
nameName of the eventStringmessage_created, conversation_resolved, first_reply_created, assignee_changed, conversation_inbox_changed
valueValue associated with the event, such as timestampNumber1
created_atThe date and time when the event was createdDate2023-01-08T18:34:43.213Z
updated_atThe date and time when the event was last updatedDate2023-01-08T18:34:43.213Z
account_idID of the account associated with the eventNumber2
conversation_idID of the conversation associated with the eventNumber1
inbox_idID of the inbox associated with the eventNumber1
user_idID of the user associated with the eventNumber3
To avoid potential query timeouts due to large data volumes, use the $top query option to limit the number of returned records.

User

Description: This data model stores information about Live Agent users. Example Query:
https://odata-liveagent-trial.cognigy.ai/v2.0/odata/User?$top=1&$skip=0
Data Types: When retrieving this data model, the endpoint returns the following fields:
Field NameDescriptionTypeExample
idA unique record IDNumber1
providerThe provider, for example, emailStringemail
uidA provided unique identifierString[email protected]
confirmed_atThe date when the confirmation token was confirmedDate2021-12-11 12:41:26.745
confirmation_sent_atThe date when the confirmation token was sentDate2021-12-11 12:41:26.745
unconfirmed_emailAn unconfirmed emailString[email protected]
nameThe user’s nameStringFrancisco
display_nameThe user’s display nameStringPaco
emailThe user’s emailString[email protected]
tokensThe user’s tokensJSON{"MN4iNP38tvwe5wer7pvpnAQ":{"token":"$2a$10$iA7Si0sBV9lMkO2mqvwiD.L90.uTCl27WQbEo/Kc0W","expiry":1644763988}}
created_atThe date when the user was createdDate2021-12-11 12:41:26.745
updated_atThe date when the user was last updatedDate2021-12-11 12:41:26.745
pubsub_tokenThe user’s publish/subscribe tokenStringMiVxY3FKry6oklambiuqL72nn
availabilityThe user’s availabilityNumber1
custom_attributesThe user’s custom attributesJSON{}
cognigy_user_idThe Cognigy user IDString610bEOk617uPiXy9L3HOq8nn6kdjJK2
sign_in_countThe total number of times the user has logged in to Live AgentNumber3
current_sign_in_atThe date and time of the user’s most recent loginDate2021-12-11 12:41:26.745
last_sign_in_atThe date and time of the user’s last loginDate2021-12-11 12:41:26.745
last_sign_out_atThe date and time of the user’s last logout from Live AgentDate2021-12-11 12:41:26.745

Team

Description: This data model stores information about Live Agent teams. Example Query:
https://odata-liveagent-trial.cognigy.ai/v2.0/odata/Team?$top=1&$skip=0
Data Types: When retrieving this data model, the endpoint returns the following fields:
Field NameDescriptionTypeExample
idThe unique ID of the teamString"9"
nameThe name of the teamString"customer support team"
descriptionA description of the teamString"for urgent user requests"
allow_auto_assignWhether conversations can be automatically assigned to the teamBooleantrue
account_idThe account ID the team belongs toString"2"
created_atThe timestamp when the team was createdString"2025-12-08 12:41:26.745
updated_atThe timestamp when the team was last updatedString"2025-12-08 12:41:26.745"
membersAn array of user entitiesArray[...]
members.idThe member ID (internal Live Agent ID)Number57
members.providerThe authentication providerString"cognigy"
members.uidThe user UID from the providerString"63ca7c200d733defd7512584"
members.confirmed_atThe timestamp when the user confirmed their accountString"2025-12-08 12:41:26.745"
members.confirmation_sent_atThe timestamp when the confirmation was sentStringnull
members.unconfirmed_emailThe email pending confirmationStringnull
members.nameThe full name of the userString"John Doe"
members.display_nameThe display name used in the UIString"John"
members.emailThe email addressString"[email protected]"
members.tokensAuthentication tokensStringnull
members.created_atThe timestamp when the user was createdString"2025-12-08 12:41:26.745"
members.updated_atThe timestamp when the user was last updatedString"2025-12-08 12:41:26.745"
members.pubsub_tokenThe token for real-time updatesString"a5DXd5Q84djArRReTNfavEZk"
members.availabilityThe user availability status (0 = offline)Number0
members.custom_attributesCustom attributes in JSON formatString"{}"
members.cognigy_user_idThe user ID from Cognigy.AIString"63ca7c200d733eefd7512584"
members.sign_in_countThe number of times the user signed inNumber17
members.current_sign_in_atThe timestamp of the current login sessionString"2025-12-08 12:41:26.745"
members.last_sign_in_atThe timestamp of the last loginString"2025-12-08 12:41:26.745"
members.last_sign_out_atThe timestamp of the last logoutString"2025-12-08 12:41:26.745"

AgentAvailabilityRecord

Description: This data model stores information about agent availability in Live Agent. Example Query:
https://odata-liveagent-trial.cognigy.ai/v2.0/odata/AgentAvailabilityRecord?$top=1&$skip=0
Data Types: When retrieving this data model, the endpoint returns the following fields:
Field NameDescriptionTypeExample
idThe unique ID of the availability recordString"1"
availabilityThe agent’s availability status (0 = offline, `1 = available)Number0
created_atThe timestamp when the record was createdISO 8601 String"2025-12-03T09:22:32.760Z"
updated_atThe timestamp when the record was last updatedISO 8601 String"2025-12-03T09:22:32.760Z"
account_idThe ID of the account the agent belongs toString"2"
user_idThe ID of the user (agent)String"8953"

Integrations

Excel

When connecting from Microsoft Excel 2016, you must use the Power Query feature, which can be found under Data > Get & Transform > New Query > From Other Sources > From OData Feed. This will connect to our OData 4 feed.

Power BI

Follow the instructions in the Power BI documentation.

Tableau

Cognigy.AI supports OData 4.0, which implies that certain versions of Tableau aren’t compatible.
Find instructions on how to connect an OData Feed in the Tableau documentation.

OData Consumer Ecosystem

For a full list of available OData Consumer options, follow the link to Consumers on OData.org.

Client Libraries in .NET, Java, JavaScript, C++, and Other Platforms

For a full list of available OData Libraries, see the latest directory of available libraries on OData.org.
1: This parameter is required to make a request to the Live Agent OData endpoint.