nodes

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

Overview

Name	nodes
Type	Resource
Id	google.prod_tt_sasportal.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
nodes_nodes_list	SELECT	nodesId	Lists nodes.
nodes_nodes_nodes_list	SELECT	nodesId, nodesId1	Lists nodes.
nodes_nodes_create	INSERT	nodesId	Creates a new node.
nodes_nodes_nodes_create	INSERT	nodesId, nodesId1	Creates a new node.
nodes_nodes_delete	DELETE	nodesId, nodesId1	Deletes a node.
customers_nodes_patch	UPDATE	customersId, nodesId	Updates an existing node.
nodes_nodes_patch	UPDATE	nodesId, nodesId1	Updates an existing node.
customers_nodes_move	EXEC	customersId, nodesId	Moves a node under another node or customer.
nodes_nodes_move	EXEC	nodesId, nodesId1	Moves a node under another node or customer.

SELECT examples

Lists nodes.

SELECT
name,
displayName,
sasUserIds
FROM google.prod_tt_sasportal.nodes
WHERE nodesId = '{{ nodesId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO google.prod_tt_sasportal.nodes (
nodesId,
sasUserIds,
name,
displayName
)
SELECT 
'{{ nodesId }}',
'{{ sasUserIds }}',
'{{ name }}',
'{{ displayName }}'
;

Manifest

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

UPDATE example

Updates a nodes resource.

/*+ update */
UPDATE google.prod_tt_sasportal.nodes
SET 
sasUserIds = '{{ sasUserIds }}',
name = '{{ name }}',
displayName = '{{ displayName }}'
WHERE 
nodesId = '{{ nodesId }}'
AND nodesId1 = '{{ nodesId1 }}';

DELETE example

Deletes the specified nodes resource.

/*+ delete */
DELETE FROM google.prod_tt_sasportal.nodes
WHERE nodesId = '{{ nodesId }}'
AND nodesId1 = '{{ nodesId1 }}';