Skip to main content

conversations

Creates, updates, deletes, gets or lists a conversations resource.

Overview

Nameconversations
TypeResource
Idazure.ai_discovery.conversations

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
namestringThe conversation name. Required.
createdAtstring (date-time)The timestamp when the resource was created.
createdBystringThe ID of the user who created this resource.
createdByTypestringThe type of user who created this resource. Known values are: "User", "Application", and "System". (User, Application, System)
displayNamestringThe title.
investigationNamestringThe Name of the associated Investigation.
lastModifiedAtstring (date-time)The timestamp when the resource was last updated.
lastModifiedBystringThe ID of the user who updated this resource.
lastModifiedByTypestringThe type of user who updated this resource. Known values are: "User", "Application", and "System". (User, Application, System)
projectNamestringThe name of the associated Project.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectconversation_name, endpointFetch a Conversation by name.
listselectendpointinvestigationName, projectName, createdSinceList Conversation resources.
createinsertendpointCreates a Conversation.
updateupdateconversation_name, endpointUpdates a Conversation.
deletedeleteconversation_name, endpointDeletes a Conversation.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
conversation_namestringThe conversation name. Required.
endpointstringThe service endpoint host (no scheme), e.g. myaccount.table.cosmos.azure.com:443 - value of the client endpoint parameter. (default: )
createdSincestring (date-time)The oldest creation timestamp to keep. Default value is None.
investigationNamestringThe name of the associated Investigation. Default value is None.
projectNamestringThe name of the associated Project. Default value is None.

SELECT examples

Fetch a Conversation by name.

SELECT
name,
createdAt,
createdBy,
createdByType,
displayName,
investigationName,
lastModifiedAt,
lastModifiedBy,
lastModifiedByType,
projectName
FROM azure.ai_discovery.conversations
WHERE conversation_name = '{{ conversation_name }}' -- required
AND endpoint = '{{ endpoint }}' -- required
;

INSERT examples

Creates a Conversation.

INSERT INTO azure.ai_discovery.conversations (
endpoint
)
SELECT
'{{ endpoint }}'
RETURNING
name,
createdAt,
createdBy,
createdByType,
displayName,
investigationName,
lastModifiedAt,
lastModifiedBy,
lastModifiedByType,
projectName
;

UPDATE examples

Updates a Conversation.

UPDATE azure.ai_discovery.conversations
SET
displayName = '{{ displayName }}',
investigationName = '{{ investigationName }}',
projectName = '{{ projectName }}'
WHERE
conversation_name = '{{ conversation_name }}' --required
AND endpoint = '{{ endpoint }}' --required
RETURNING
name,
createdAt,
createdBy,
createdByType,
displayName,
investigationName,
lastModifiedAt,
lastModifiedBy,
lastModifiedByType,
projectName;

DELETE examples

Deletes a Conversation.

DELETE FROM azure.ai_discovery.conversations
WHERE conversation_name = '{{ conversation_name }}' --required
AND endpoint = '{{ endpoint }}' --required
;