Skip to main content

customer_nodes

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

Overview​

Namecustomer_nodes
TypeResource
Idgoogle.sasportal.customer_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
customers_nodes_nodes_listselectcustomersId, nodesIdfilter, pageSize, pageTokenLists nodes.
customers_nodes_listselectcustomersIdfilter, pageSize, pageTokenLists nodes.
customers_nodes_nodes_createinsertcustomersId, nodesIdCreates a new node.
customers_nodes_createinsertcustomersIdCreates a new node.
customers_nodes_deletedeletecustomersId, nodesIdDeletes a node.

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
filterstring
pageSizeinteger (int32)
pageTokenstring

SELECT examples​

Lists nodes.

SELECT
name,
displayName,
sasUserIds
FROM google.sasportal.customer_nodes
WHERE customersId = '{{ customersId }}' -- required
AND nodesId = '{{ nodesId }}' -- required
AND filter = '{{ filter }}'
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}'
;

INSERT examples​

Creates a new node.

INSERT INTO google.sasportal.customer_nodes (
data__displayName,
data__name,
data__sasUserIds,
customersId,
nodesId
)
SELECT
'{{ displayName }}',
'{{ name }}',
'{{ sasUserIds }}',
'{{ customersId }}',
'{{ nodesId }}'
RETURNING
name,
displayName,
sasUserIds
;

DELETE examples​

Deletes a node.

DELETE FROM google.sasportal.customer_nodes
WHERE customersId = '{{ customersId }}' --required
AND nodesId = '{{ nodesId }}' --required
;