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
;