customer_nodes

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

Overview

Name	customer_nodes
Type	Resource
Id	google.sasportal.customer_nodes

Fields

Name	Datatype	Description
name	string	Output only. Resource name.
displayName	string	The node's display name.
sasUserIds	array	User ids used by the devices belonging to this node.

Methods

Name	Accessible by	Required Params	Description
customers_nodes_list	SELECT	customersId	Lists nodes.
customers_nodes_nodes_list	SELECT	customersId, nodesId	Lists nodes.
customers_nodes_create	INSERT	customersId	Creates a new node.
customers_nodes_nodes_create	INSERT	customersId, nodesId	Creates a new node.
customers_nodes_delete	DELETE	customersId, nodesId	Deletes a node.

SELECT examples

Lists nodes.

SELECT
name,
displayName,
sasUserIds
FROM google.sasportal.customer_nodes
WHERE customersId = '{{ customersId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO google.sasportal.customer_nodes (
customersId,
sasUserIds,
displayName,
name
)
SELECT 
'{{ customersId }}',
'{{ sasUserIds }}',
'{{ displayName }}',
'{{ name }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: sasUserIds
      value:
        - string
    - name: displayName
      value: string
    - name: name
      value: string

DELETE example

Deletes the specified customer_nodes resource.

/*+ delete */
DELETE FROM google.sasportal.customer_nodes
WHERE customersId = '{{ customersId }}'
AND nodesId = '{{ nodesId }}';