Skip to main content

nodes

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

Overview

Namenodes
TypeResource
Idgoogle.prod_tt_sasportal.nodes

Fields

The following fields are returned by SELECT queries:

Successful response

NameDatatypeDescription
namestringOutput only. Resource name.
displayNamestringThe node's display name.
sasUserIdsarrayUser ids used by the devices belonging to this node.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
nodes_nodes_nodes_listselectnodesId, nodesId1pageSize, pageToken, filterLists nodes.
nodes_nodes_listselectnodesIdpageSize, pageToken, filterLists nodes.
nodes_nodes_nodes_createinsertnodesId, nodesId1Creates a new node.
nodes_nodes_createinsertnodesIdCreates a new node.
customers_nodes_patchupdatecustomersId, nodesIdupdateMaskUpdates an existing node.
nodes_nodes_patchupdatenodesId, nodesId1updateMaskUpdates an existing node.
nodes_nodes_deletedeletenodesId, nodesId1Deletes a node.
customers_nodes_moveexeccustomersId, nodesIdMoves a node under another node or customer.
nodes_nodes_moveexecnodesId, nodesId1Moves a node under another node or customer.

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
customersIdstring
nodesIdstring
nodesId1string
filterstring
pageSizeinteger (int32)
pageTokenstring
updateMaskstring (google-fieldmask)

SELECT examples

Lists nodes.

SELECT
name,
displayName,
sasUserIds
FROM google.prod_tt_sasportal.nodes
WHERE nodesId = '{{ nodesId }}' -- required
AND nodesId1 = '{{ nodesId1 }}' -- required
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}'
AND filter = '{{ filter }}';

INSERT examples

Creates a new node.

INSERT INTO google.prod_tt_sasportal.nodes (
data__name,
data__displayName,
data__sasUserIds,
nodesId,
nodesId1
)
SELECT
'{{ name }}',
'{{ displayName }}',
'{{ sasUserIds }}',
'{{ nodesId }}',
'{{ nodesId1 }}'
RETURNING
name,
displayName,
sasUserIds
;

UPDATE examples

Updates an existing node.

UPDATE google.prod_tt_sasportal.nodes
SET
data__name = '{{ name }}',
data__displayName = '{{ displayName }}',
data__sasUserIds = '{{ sasUserIds }}'
WHERE
customersId = '{{ customersId }}' --required
AND nodesId = '{{ nodesId }}' --required
AND updateMask = '{{ updateMask}}'
RETURNING
name,
displayName,
sasUserIds;

DELETE examples

Deletes a node.

DELETE FROM google.prod_tt_sasportal.nodes
WHERE nodesId = '{{ nodesId }}' --required
AND nodesId1 = '{{ nodesId1 }}' --required;

Lifecycle Methods

Moves a node under another node or customer.

EXEC google.prod_tt_sasportal.nodes.customers_nodes_move 
@customersId='{{ customersId }}' --required,
@nodesId='{{ nodesId }}' --required
@@json=
'{
"destination": "{{ destination }}"
}';