Skip to main content

interactions

Creates, updates, deletes, gets or lists an interactions resource.

Overview

Nameinteractions
TypeResource
Idazure_extras.customer_insights.interactions

Fields

The following fields are returned by SELECT queries:

OK. Successfully get the interaction.

NameDatatypeDescription
idstringResource ID.
namestringResource name.
propertiesobjectThe Interaction Type Definition
typestringResource type.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresourceGroupName, hubName, interactionName, subscriptionIdlocale-codeGets information about the specified interaction.
list_by_hubselectresourceGroupName, hubName, subscriptionIdlocale-codeGets all interactions in the hub.
create_or_updateinsertresourceGroupName, hubName, interactionName, subscriptionIdCreates an interaction or updates an existing interaction within a hub.
suggest_relationship_linksexecresourceGroupName, hubName, interactionName, subscriptionIdSuggests relationships to create relationship links.

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
hubNamestringThe name of the hub.
interactionNamestringThe name of the interaction.
resourceGroupNamestringThe name of the resource group.
subscriptionIdstringGets subscription credentials which uniquely identify Microsoft Azure subscription. The subscription ID forms part of the URI for every service call.
locale-codestringLocale of interaction to retrieve, default is en-us.

SELECT examples

Gets information about the specified interaction.

SELECT
id,
name,
properties,
type
FROM azure_extras.customer_insights.interactions
WHERE resourceGroupName = '{{ resourceGroupName }}' -- required
AND hubName = '{{ hubName }}' -- required
AND interactionName = '{{ interactionName }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
AND locale-code = '{{ locale-code }}'
;

INSERT examples

Creates an interaction or updates an existing interaction within a hub.

INSERT INTO azure_extras.customer_insights.interactions (
data__properties,
resourceGroupName,
hubName,
interactionName,
subscriptionId
)
SELECT
'{{ properties }}',
'{{ resourceGroupName }}',
'{{ hubName }}',
'{{ interactionName }}',
'{{ subscriptionId }}'
RETURNING
id,
name,
properties,
type
;

Lifecycle Methods

Suggests relationships to create relationship links.

EXEC azure_extras.customer_insights.interactions.suggest_relationship_links 
@resourceGroupName='{{ resourceGroupName }}' --required,
@hubName='{{ hubName }}' --required,
@interactionName='{{ interactionName }}' --required,
@subscriptionId='{{ subscriptionId }}' --required
;