Skip to main content

nodes

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

Overview​

Namenodes
TypeResource
Idgoogle.sasportal.nodes

Fields​

The following fields are returned by SELECT queries:

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.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.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.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.sasportal.nodes
WHERE nodesId = '{{ nodesId }}' --required
AND nodesId1 = '{{ nodesId1 }}' --required
;

Lifecycle Methods​

Moves a node under another node or customer.

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