Skip to main content

customer_nodes

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

Overview

Namecustomer_nodes
TypeResource
Idgoogle.prod_tt_sasportal.customer_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
customers_nodes_nodes_listselectcustomersId, nodesIdpageSize, pageToken, filterLists nodes.
customers_nodes_listselectcustomersIdpageSize, pageToken, filterLists 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.prod_tt_sasportal.customer_nodes
WHERE customersId = '{{ customersId }}' -- required
AND nodesId = '{{ nodesId }}' -- required
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}'
AND filter = '{{ filter }}';

INSERT examples

Creates a new node.

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

DELETE examples

Deletes a node.

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