views

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

Overview

Name	views
Type	Resource
Id	azure_extras.customer_insights.views

Fields

vw_views

Name	Datatype	Description
id	text	Resource ID.
name	text	Resource name.
changed	text	field from the properties object
created	text	field from the properties object
definition	text	field from the properties object
display_name	text	field from the properties object
hubName	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
tenant_id	text	field from the properties object
type	text	Resource type.
userId	text	field from the properties object
user_id	text	field from the properties object
viewName	text	field from the properties object
view_name	text	field from the properties object

views

Name	Datatype	Description
id	string	Resource ID.
name	string	Resource name.
properties	object	The view in Customer 360 web application.
type	string	Resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	hubName, resourceGroupName, subscriptionId, userId, viewName	Gets a view in the hub.
list_by_hub	SELECT	hubName, resourceGroupName, subscriptionId, userId	Gets all available views for given user in the specified hub.
create_or_update	INSERT	hubName, resourceGroupName, subscriptionId, viewName	Creates a view or updates an existing view in the hub.
delete	DELETE	hubName, resourceGroupName, subscriptionId, userId, viewName	Deletes a view in the specified hub.

SELECT examples

Gets all available views for given user in the specified hub.

vw_views

SELECT
id,
name,
changed,
created,
definition,
display_name,
hubName,
resourceGroupName,
subscriptionId,
tenant_id,
type,
userId,
user_id,
viewName,
view_name
FROM azure_extras.customer_insights.vw_views
WHERE hubName = '{{ hubName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND userId = '{{ userId }}';

views

SELECT
id,
name,
properties,
type
FROM azure_extras.customer_insights.views
WHERE hubName = '{{ hubName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND userId = '{{ userId }}';

INSERT example

Use the following StackQL query and manifest file to create a new views resource.

All Properties

/*+ create */
INSERT INTO azure_extras.customer_insights.views (
hubName,
resourceGroupName,
subscriptionId,
viewName,
properties
)
SELECT 
'{{ hubName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ viewName }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: viewName
          value: string
        - name: userId
          value: string
        - name: tenantId
          value: string
        - name: displayName
          value: object
        - name: definition
          value: string
        - name: changed
          value: string
        - name: created
          value: string
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string

DELETE example

Deletes the specified views resource.

/*+ delete */
DELETE FROM azure_extras.customer_insights.views
WHERE hubName = '{{ hubName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND userId = '{{ userId }}'
AND viewName = '{{ viewName }}';