devices

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

Overview

Name	devices
Type	Resource
Id	google.prod_tt_sasportal.devices

Fields

The following fields are returned by SELECT queries:

customers_devices_get

Successful response

Name	Datatype	Description
name	string	Output only. The resource path name.
activeConfig	object	Output only. Current configuration of the device as registered to the SAS. (id: SasPortalDeviceConfig)
currentChannels	array	Output only. Current channels with scores.
deviceMetadata	object	Device parameters that can be overridden by both SAS Portal and SAS registration requests. (id: SasPortalDeviceMetadata)
displayName	string	Device display name.
fccId	string	The FCC identifier of the device. Refer to https://www.fcc.gov/oet/ea/fccid for FccID format. Accept underscores and periods because some test-SAS customers use them.
grantRangeAllowlists	array	Only ranges that are within the allowlists are available for new grants.
grants	array	Output only. Grants held by the device.
preloadedConfig	object	Configuration of the device, as specified via SAS Portal API. (id: SasPortalDeviceConfig)
serialNumber	string	A serial number assigned to the device by the device manufacturer.
state	string	Output only. Device state.

customers_nodes_devices_list

Successful response

Name	Datatype	Description
name	string	Output only. The resource path name.
activeConfig	object	Output only. Current configuration of the device as registered to the SAS. (id: SasPortalDeviceConfig)
currentChannels	array	Output only. Current channels with scores.
deviceMetadata	object	Device parameters that can be overridden by both SAS Portal and SAS registration requests. (id: SasPortalDeviceMetadata)
displayName	string	Device display name.
fccId	string	The FCC identifier of the device. Refer to https://www.fcc.gov/oet/ea/fccid for FccID format. Accept underscores and periods because some test-SAS customers use them.
grantRangeAllowlists	array	Only ranges that are within the allowlists are available for new grants.
grants	array	Output only. Grants held by the device.
preloadedConfig	object	Configuration of the device, as specified via SAS Portal API. (id: SasPortalDeviceConfig)
serialNumber	string	A serial number assigned to the device by the device manufacturer.
state	string	Output only. Device state.

customers_deployments_devices_list

Successful response

Name	Datatype	Description
name	string	Output only. The resource path name.
activeConfig	object	Output only. Current configuration of the device as registered to the SAS. (id: SasPortalDeviceConfig)
currentChannels	array	Output only. Current channels with scores.
deviceMetadata	object	Device parameters that can be overridden by both SAS Portal and SAS registration requests. (id: SasPortalDeviceMetadata)
displayName	string	Device display name.
fccId	string	The FCC identifier of the device. Refer to https://www.fcc.gov/oet/ea/fccid for FccID format. Accept underscores and periods because some test-SAS customers use them.
grantRangeAllowlists	array	Only ranges that are within the allowlists are available for new grants.
grants	array	Output only. Grants held by the device.
preloadedConfig	object	Configuration of the device, as specified via SAS Portal API. (id: SasPortalDeviceConfig)
serialNumber	string	A serial number assigned to the device by the device manufacturer.
state	string	Output only. Device state.

nodes_devices_get

Successful response

Name	Datatype	Description
name	string	Output only. The resource path name.
activeConfig	object	Output only. Current configuration of the device as registered to the SAS. (id: SasPortalDeviceConfig)
currentChannels	array	Output only. Current channels with scores.
deviceMetadata	object	Device parameters that can be overridden by both SAS Portal and SAS registration requests. (id: SasPortalDeviceMetadata)
displayName	string	Device display name.
fccId	string	The FCC identifier of the device. Refer to https://www.fcc.gov/oet/ea/fccid for FccID format. Accept underscores and periods because some test-SAS customers use them.
grantRangeAllowlists	array	Only ranges that are within the allowlists are available for new grants.
grants	array	Output only. Grants held by the device.
preloadedConfig	object	Configuration of the device, as specified via SAS Portal API. (id: SasPortalDeviceConfig)
serialNumber	string	A serial number assigned to the device by the device manufacturer.
state	string	Output only. Device state.

nodes_nodes_devices_list

Successful response

Name	Datatype	Description
name	string	Output only. The resource path name.
activeConfig	object	Output only. Current configuration of the device as registered to the SAS. (id: SasPortalDeviceConfig)
currentChannels	array	Output only. Current channels with scores.
deviceMetadata	object	Device parameters that can be overridden by both SAS Portal and SAS registration requests. (id: SasPortalDeviceMetadata)
displayName	string	Device display name.
fccId	string	The FCC identifier of the device. Refer to https://www.fcc.gov/oet/ea/fccid for FccID format. Accept underscores and periods because some test-SAS customers use them.
grantRangeAllowlists	array	Only ranges that are within the allowlists are available for new grants.
grants	array	Output only. Grants held by the device.
preloadedConfig	object	Configuration of the device, as specified via SAS Portal API. (id: SasPortalDeviceConfig)
serialNumber	string	A serial number assigned to the device by the device manufacturer.
state	string	Output only. Device state.

nodes_deployments_devices_list

Successful response

Name	Datatype	Description
name	string	Output only. The resource path name.
activeConfig	object	Output only. Current configuration of the device as registered to the SAS. (id: SasPortalDeviceConfig)
currentChannels	array	Output only. Current channels with scores.
deviceMetadata	object	Device parameters that can be overridden by both SAS Portal and SAS registration requests. (id: SasPortalDeviceMetadata)
displayName	string	Device display name.
fccId	string	The FCC identifier of the device. Refer to https://www.fcc.gov/oet/ea/fccid for FccID format. Accept underscores and periods because some test-SAS customers use them.
grantRangeAllowlists	array	Only ranges that are within the allowlists are available for new grants.
grants	array	Output only. Grants held by the device.
preloadedConfig	object	Configuration of the device, as specified via SAS Portal API. (id: SasPortalDeviceConfig)
serialNumber	string	A serial number assigned to the device by the device manufacturer.
state	string	Output only. Device state.

deployments_devices_get

Successful response

Name	Datatype	Description
name	string	Output only. The resource path name.
activeConfig	object	Output only. Current configuration of the device as registered to the SAS. (id: SasPortalDeviceConfig)
currentChannels	array	Output only. Current channels with scores.
deviceMetadata	object	Device parameters that can be overridden by both SAS Portal and SAS registration requests. (id: SasPortalDeviceMetadata)
displayName	string	Device display name.
fccId	string	The FCC identifier of the device. Refer to https://www.fcc.gov/oet/ea/fccid for FccID format. Accept underscores and periods because some test-SAS customers use them.
grantRangeAllowlists	array	Only ranges that are within the allowlists are available for new grants.
grants	array	Output only. Grants held by the device.
preloadedConfig	object	Configuration of the device, as specified via SAS Portal API. (id: SasPortalDeviceConfig)
serialNumber	string	A serial number assigned to the device by the device manufacturer.
state	string	Output only. Device state.

customers_devices_list

Successful response

Name	Datatype	Description
name	string	Output only. The resource path name.
activeConfig	object	Output only. Current configuration of the device as registered to the SAS. (id: SasPortalDeviceConfig)
currentChannels	array	Output only. Current channels with scores.
deviceMetadata	object	Device parameters that can be overridden by both SAS Portal and SAS registration requests. (id: SasPortalDeviceMetadata)
displayName	string	Device display name.
fccId	string	The FCC identifier of the device. Refer to https://www.fcc.gov/oet/ea/fccid for FccID format. Accept underscores and periods because some test-SAS customers use them.
grantRangeAllowlists	array	Only ranges that are within the allowlists are available for new grants.
grants	array	Output only. Grants held by the device.
preloadedConfig	object	Configuration of the device, as specified via SAS Portal API. (id: SasPortalDeviceConfig)
serialNumber	string	A serial number assigned to the device by the device manufacturer.
state	string	Output only. Device state.

nodes_devices_list

Successful response

Name	Datatype	Description
name	string	Output only. The resource path name.
activeConfig	object	Output only. Current configuration of the device as registered to the SAS. (id: SasPortalDeviceConfig)
currentChannels	array	Output only. Current channels with scores.
deviceMetadata	object	Device parameters that can be overridden by both SAS Portal and SAS registration requests. (id: SasPortalDeviceMetadata)
displayName	string	Device display name.
fccId	string	The FCC identifier of the device. Refer to https://www.fcc.gov/oet/ea/fccid for FccID format. Accept underscores and periods because some test-SAS customers use them.
grantRangeAllowlists	array	Only ranges that are within the allowlists are available for new grants.
grants	array	Output only. Grants held by the device.
preloadedConfig	object	Configuration of the device, as specified via SAS Portal API. (id: SasPortalDeviceConfig)
serialNumber	string	A serial number assigned to the device by the device manufacturer.
state	string	Output only. Device state.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
customers_devices_get	select	customersId, devicesId		Gets details about a device.
customers_nodes_devices_list	select	customersId, nodesId	pageSize, pageToken, filter	Lists devices under a node or customer.
customers_deployments_devices_list	select	customersId, deploymentsId	pageSize, pageToken, filter	Lists devices under a node or customer.
nodes_devices_get	select	nodesId, devicesId		Gets details about a device.
nodes_nodes_devices_list	select	nodesId, nodesId1	pageSize, pageToken, filter	Lists devices under a node or customer.
nodes_deployments_devices_list	select	nodesId, deploymentsId	pageSize, pageToken, filter	Lists devices under a node or customer.
deployments_devices_get	select	deploymentsId, devicesId		Gets details about a device.
customers_devices_list	select	customersId	pageSize, pageToken, filter	Lists devices under a node or customer.
nodes_devices_list	select	nodesId	pageSize, pageToken, filter	Lists devices under a node or customer.
customers_nodes_devices_create	insert	customersId, nodesId		Creates a device under a node or customer.
customers_deployments_devices_create	insert	customersId, deploymentsId		Creates a device under a node or customer.
nodes_nodes_devices_create	insert	nodesId, nodesId1		Creates a device under a node or customer.
nodes_deployments_devices_create	insert	nodesId, deploymentsId		Creates a device under a node or customer.
customers_devices_create	insert	customersId		Creates a device under a node or customer.
nodes_devices_create	insert	nodesId		Creates a device under a node or customer.
customers_devices_patch	update	customersId, devicesId	updateMask	Updates a device.
nodes_devices_patch	update	nodesId, devicesId	updateMask	Updates a device.
deployments_devices_patch	update	deploymentsId, devicesId	updateMask	Updates a device.
customers_devices_delete	delete	customersId, devicesId		Deletes a device.
nodes_devices_delete	delete	nodesId, devicesId		Deletes a device.
deployments_devices_delete	delete	deploymentsId, devicesId		Deletes a device.
customers_devices_move	exec	customersId, devicesId		Moves a device under another node or customer.
customers_devices_sign_device	exec	customersId, devicesId		Signs a device.
nodes_devices_move	exec	nodesId, devicesId		Moves a device under another node or customer.
nodes_devices_sign_device	exec	nodesId, devicesId		Signs a device.
deployments_devices_move	exec	deploymentsId, devicesId		Moves a device under another node or customer.
deployments_devices_sign_device	exec	deploymentsId, devicesId		Signs a device.

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.

Name	Datatype	Description
customersId	string
deploymentsId	string
devicesId	string
nodesId	string
nodesId1	string
filter	string
pageSize	integer (int32)
pageToken	string
updateMask	string (google-fieldmask)

SELECT examples

customers_devices_get

Gets details about a device.

SELECT
name,
activeConfig,
currentChannels,
deviceMetadata,
displayName,
fccId,
grantRangeAllowlists,
grants,
preloadedConfig,
serialNumber,
state
FROM google.prod_tt_sasportal.devices
WHERE customersId = '{{ customersId }}' -- required
AND devicesId = '{{ devicesId }}' -- required;

customers_nodes_devices_list

Lists devices under a node or customer.

SELECT
name,
activeConfig,
currentChannels,
deviceMetadata,
displayName,
fccId,
grantRangeAllowlists,
grants,
preloadedConfig,
serialNumber,
state
FROM google.prod_tt_sasportal.devices
WHERE customersId = '{{ customersId }}' -- required
AND nodesId = '{{ nodesId }}' -- required
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}'
AND filter = '{{ filter }}';

customers_deployments_devices_list

Lists devices under a node or customer.

SELECT
name,
activeConfig,
currentChannels,
deviceMetadata,
displayName,
fccId,
grantRangeAllowlists,
grants,
preloadedConfig,
serialNumber,
state
FROM google.prod_tt_sasportal.devices
WHERE customersId = '{{ customersId }}' -- required
AND deploymentsId = '{{ deploymentsId }}' -- required
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}'
AND filter = '{{ filter }}';

nodes_devices_get

Gets details about a device.

SELECT
name,
activeConfig,
currentChannels,
deviceMetadata,
displayName,
fccId,
grantRangeAllowlists,
grants,
preloadedConfig,
serialNumber,
state
FROM google.prod_tt_sasportal.devices
WHERE nodesId = '{{ nodesId }}' -- required
AND devicesId = '{{ devicesId }}' -- required;

nodes_nodes_devices_list

Lists devices under a node or customer.

SELECT
name,
activeConfig,
currentChannels,
deviceMetadata,
displayName,
fccId,
grantRangeAllowlists,
grants,
preloadedConfig,
serialNumber,
state
FROM google.prod_tt_sasportal.devices
WHERE nodesId = '{{ nodesId }}' -- required
AND nodesId1 = '{{ nodesId1 }}' -- required
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}'
AND filter = '{{ filter }}';

nodes_deployments_devices_list

Lists devices under a node or customer.

SELECT
name,
activeConfig,
currentChannels,
deviceMetadata,
displayName,
fccId,
grantRangeAllowlists,
grants,
preloadedConfig,
serialNumber,
state
FROM google.prod_tt_sasportal.devices
WHERE nodesId = '{{ nodesId }}' -- required
AND deploymentsId = '{{ deploymentsId }}' -- required
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}'
AND filter = '{{ filter }}';

deployments_devices_get

Gets details about a device.

SELECT
name,
activeConfig,
currentChannels,
deviceMetadata,
displayName,
fccId,
grantRangeAllowlists,
grants,
preloadedConfig,
serialNumber,
state
FROM google.prod_tt_sasportal.devices
WHERE deploymentsId = '{{ deploymentsId }}' -- required
AND devicesId = '{{ devicesId }}' -- required;

customers_devices_list

Lists devices under a node or customer.

SELECT
name,
activeConfig,
currentChannels,
deviceMetadata,
displayName,
fccId,
grantRangeAllowlists,
grants,
preloadedConfig,
serialNumber,
state
FROM google.prod_tt_sasportal.devices
WHERE customersId = '{{ customersId }}' -- required
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}'
AND filter = '{{ filter }}';

nodes_devices_list

Lists devices under a node or customer.

SELECT
name,
activeConfig,
currentChannels,
deviceMetadata,
displayName,
fccId,
grantRangeAllowlists,
grants,
preloadedConfig,
serialNumber,
state
FROM google.prod_tt_sasportal.devices
WHERE nodesId = '{{ nodesId }}' -- required
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}'
AND filter = '{{ filter }}';

INSERT examples

customers_nodes_devices_create

Creates a device under a node or customer.

INSERT INTO google.prod_tt_sasportal.devices (
data__name,
data__fccId,
data__serialNumber,
data__preloadedConfig,
data__activeConfig,
data__state,
data__grants,
data__displayName,
data__deviceMetadata,
data__grantRangeAllowlists,
customersId,
nodesId
)
SELECT 
'{{ name }}',
'{{ fccId }}',
'{{ serialNumber }}',
'{{ preloadedConfig }}',
'{{ activeConfig }}',
'{{ state }}',
'{{ grants }}',
'{{ displayName }}',
'{{ deviceMetadata }}',
'{{ grantRangeAllowlists }}',
'{{ customersId }}',
'{{ nodesId }}'
RETURNING
name,
activeConfig,
currentChannels,
deviceMetadata,
displayName,
fccId,
grantRangeAllowlists,
grants,
preloadedConfig,
serialNumber,
state
;

customers_deployments_devices_create

Creates a device under a node or customer.

INSERT INTO google.prod_tt_sasportal.devices (
data__name,
data__fccId,
data__serialNumber,
data__preloadedConfig,
data__activeConfig,
data__state,
data__grants,
data__displayName,
data__deviceMetadata,
data__grantRangeAllowlists,
customersId,
deploymentsId
)
SELECT 
'{{ name }}',
'{{ fccId }}',
'{{ serialNumber }}',
'{{ preloadedConfig }}',
'{{ activeConfig }}',
'{{ state }}',
'{{ grants }}',
'{{ displayName }}',
'{{ deviceMetadata }}',
'{{ grantRangeAllowlists }}',
'{{ customersId }}',
'{{ deploymentsId }}'
RETURNING
name,
activeConfig,
currentChannels,
deviceMetadata,
displayName,
fccId,
grantRangeAllowlists,
grants,
preloadedConfig,
serialNumber,
state
;

nodes_nodes_devices_create

Creates a device under a node or customer.

INSERT INTO google.prod_tt_sasportal.devices (
data__name,
data__fccId,
data__serialNumber,
data__preloadedConfig,
data__activeConfig,
data__state,
data__grants,
data__displayName,
data__deviceMetadata,
data__grantRangeAllowlists,
nodesId,
nodesId1
)
SELECT 
'{{ name }}',
'{{ fccId }}',
'{{ serialNumber }}',
'{{ preloadedConfig }}',
'{{ activeConfig }}',
'{{ state }}',
'{{ grants }}',
'{{ displayName }}',
'{{ deviceMetadata }}',
'{{ grantRangeAllowlists }}',
'{{ nodesId }}',
'{{ nodesId1 }}'
RETURNING
name,
activeConfig,
currentChannels,
deviceMetadata,
displayName,
fccId,
grantRangeAllowlists,
grants,
preloadedConfig,
serialNumber,
state
;

nodes_deployments_devices_create

Creates a device under a node or customer.

INSERT INTO google.prod_tt_sasportal.devices (
data__name,
data__fccId,
data__serialNumber,
data__preloadedConfig,
data__activeConfig,
data__state,
data__grants,
data__displayName,
data__deviceMetadata,
data__grantRangeAllowlists,
nodesId,
deploymentsId
)
SELECT 
'{{ name }}',
'{{ fccId }}',
'{{ serialNumber }}',
'{{ preloadedConfig }}',
'{{ activeConfig }}',
'{{ state }}',
'{{ grants }}',
'{{ displayName }}',
'{{ deviceMetadata }}',
'{{ grantRangeAllowlists }}',
'{{ nodesId }}',
'{{ deploymentsId }}'
RETURNING
name,
activeConfig,
currentChannels,
deviceMetadata,
displayName,
fccId,
grantRangeAllowlists,
grants,
preloadedConfig,
serialNumber,
state
;

customers_devices_create

Creates a device under a node or customer.

INSERT INTO google.prod_tt_sasportal.devices (
data__name,
data__fccId,
data__serialNumber,
data__preloadedConfig,
data__activeConfig,
data__state,
data__grants,
data__displayName,
data__deviceMetadata,
data__grantRangeAllowlists,
customersId
)
SELECT 
'{{ name }}',
'{{ fccId }}',
'{{ serialNumber }}',
'{{ preloadedConfig }}',
'{{ activeConfig }}',
'{{ state }}',
'{{ grants }}',
'{{ displayName }}',
'{{ deviceMetadata }}',
'{{ grantRangeAllowlists }}',
'{{ customersId }}'
RETURNING
name,
activeConfig,
currentChannels,
deviceMetadata,
displayName,
fccId,
grantRangeAllowlists,
grants,
preloadedConfig,
serialNumber,
state
;

nodes_devices_create

Creates a device under a node or customer.

INSERT INTO google.prod_tt_sasportal.devices (
data__name,
data__fccId,
data__serialNumber,
data__preloadedConfig,
data__activeConfig,
data__state,
data__grants,
data__displayName,
data__deviceMetadata,
data__grantRangeAllowlists,
nodesId
)
SELECT 
'{{ name }}',
'{{ fccId }}',
'{{ serialNumber }}',
'{{ preloadedConfig }}',
'{{ activeConfig }}',
'{{ state }}',
'{{ grants }}',
'{{ displayName }}',
'{{ deviceMetadata }}',
'{{ grantRangeAllowlists }}',
'{{ nodesId }}'
RETURNING
name,
activeConfig,
currentChannels,
deviceMetadata,
displayName,
fccId,
grantRangeAllowlists,
grants,
preloadedConfig,
serialNumber,
state
;

Manifest

# Description fields are for documentation purposes
- name: devices
  props:
    - name: customersId
      value: string
      description: Required parameter for the devices resource.
    - name: nodesId
      value: string
      description: Required parameter for the devices resource.
    - name: deploymentsId
      value: string
      description: Required parameter for the devices resource.
    - name: nodesId1
      value: string
      description: Required parameter for the devices resource.
    - name: name
      value: string
      description: >
        Output only. The resource path name.
        
    - name: fccId
      value: string
      description: >
        The FCC identifier of the device. Refer to https://www.fcc.gov/oet/ea/fccid for FccID format. Accept underscores and periods because some test-SAS customers use them.
        
    - name: serialNumber
      value: string
      description: >
        A serial number assigned to the device by the device manufacturer.
        
    - name: preloadedConfig
      value: object
      description: >
        Configuration of the device, as specified via SAS Portal API.
        
    - name: activeConfig
      value: object
      description: >
        Output only. Current configuration of the device as registered to the SAS.
        
    - name: state
      value: string
      description: >
        Output only. Device state.
        
      valid_values: ['DEVICE_STATE_UNSPECIFIED', 'RESERVED', 'REGISTERED', 'DEREGISTERED']
    - name: grants
      value: array
      description: >
        Output only. Grants held by the device.
        
    - name: displayName
      value: string
      description: >
        Device display name.
        
    - name: deviceMetadata
      value: object
      description: >
        Device parameters that can be overridden by both SAS Portal and SAS registration requests.
        
    - name: grantRangeAllowlists
      value: array
      description: >
        Only ranges that are within the allowlists are available for new grants.
        

UPDATE examples

customers_devices_patch

Updates a device.

UPDATE google.prod_tt_sasportal.devices
SET 
data__name = '{{ name }}',
data__fccId = '{{ fccId }}',
data__serialNumber = '{{ serialNumber }}',
data__preloadedConfig = '{{ preloadedConfig }}',
data__activeConfig = '{{ activeConfig }}',
data__state = '{{ state }}',
data__grants = '{{ grants }}',
data__displayName = '{{ displayName }}',
data__deviceMetadata = '{{ deviceMetadata }}',
data__grantRangeAllowlists = '{{ grantRangeAllowlists }}'
WHERE 
customersId = '{{ customersId }}' --required
AND devicesId = '{{ devicesId }}' --required
AND updateMask = '{{ updateMask}}'
RETURNING
name,
activeConfig,
currentChannels,
deviceMetadata,
displayName,
fccId,
grantRangeAllowlists,
grants,
preloadedConfig,
serialNumber,
state;

nodes_devices_patch

Updates a device.

UPDATE google.prod_tt_sasportal.devices
SET 
data__name = '{{ name }}',
data__fccId = '{{ fccId }}',
data__serialNumber = '{{ serialNumber }}',
data__preloadedConfig = '{{ preloadedConfig }}',
data__activeConfig = '{{ activeConfig }}',
data__state = '{{ state }}',
data__grants = '{{ grants }}',
data__displayName = '{{ displayName }}',
data__deviceMetadata = '{{ deviceMetadata }}',
data__grantRangeAllowlists = '{{ grantRangeAllowlists }}'
WHERE 
nodesId = '{{ nodesId }}' --required
AND devicesId = '{{ devicesId }}' --required
AND updateMask = '{{ updateMask}}'
RETURNING
name,
activeConfig,
currentChannels,
deviceMetadata,
displayName,
fccId,
grantRangeAllowlists,
grants,
preloadedConfig,
serialNumber,
state;

deployments_devices_patch

Updates a device.

UPDATE google.prod_tt_sasportal.devices
SET 
data__name = '{{ name }}',
data__fccId = '{{ fccId }}',
data__serialNumber = '{{ serialNumber }}',
data__preloadedConfig = '{{ preloadedConfig }}',
data__activeConfig = '{{ activeConfig }}',
data__state = '{{ state }}',
data__grants = '{{ grants }}',
data__displayName = '{{ displayName }}',
data__deviceMetadata = '{{ deviceMetadata }}',
data__grantRangeAllowlists = '{{ grantRangeAllowlists }}'
WHERE 
deploymentsId = '{{ deploymentsId }}' --required
AND devicesId = '{{ devicesId }}' --required
AND updateMask = '{{ updateMask}}'
RETURNING
name,
activeConfig,
currentChannels,
deviceMetadata,
displayName,
fccId,
grantRangeAllowlists,
grants,
preloadedConfig,
serialNumber,
state;

DELETE examples

customers_devices_delete

Deletes a device.

DELETE FROM google.prod_tt_sasportal.devices
WHERE customersId = '{{ customersId }}' --required
AND devicesId = '{{ devicesId }}' --required;

nodes_devices_delete

Deletes a device.

DELETE FROM google.prod_tt_sasportal.devices
WHERE nodesId = '{{ nodesId }}' --required
AND devicesId = '{{ devicesId }}' --required;

deployments_devices_delete

Deletes a device.

DELETE FROM google.prod_tt_sasportal.devices
WHERE deploymentsId = '{{ deploymentsId }}' --required
AND devicesId = '{{ devicesId }}' --required;

Lifecycle Methods

customers_devices_move

Moves a device under another node or customer.

EXEC google.prod_tt_sasportal.devices.customers_devices_move 
@customersId='{{ customersId }}' --required, 
@devicesId='{{ devicesId }}' --required 
@@json=
'{
"destination": "{{ destination }}"
}';

customers_devices_sign_device

Signs a device.

EXEC google.prod_tt_sasportal.devices.customers_devices_sign_device 
@customersId='{{ customersId }}' --required, 
@devicesId='{{ devicesId }}' --required 
@@json=
'{
"device": "{{ device }}"
}';

nodes_devices_move

Moves a device under another node or customer.

EXEC google.prod_tt_sasportal.devices.nodes_devices_move 
@nodesId='{{ nodesId }}' --required, 
@devicesId='{{ devicesId }}' --required 
@@json=
'{
"destination": "{{ destination }}"
}';

nodes_devices_sign_device

Signs a device.

EXEC google.prod_tt_sasportal.devices.nodes_devices_sign_device 
@nodesId='{{ nodesId }}' --required, 
@devicesId='{{ devicesId }}' --required 
@@json=
'{
"device": "{{ device }}"
}';

deployments_devices_move

Moves a device under another node or customer.

EXEC google.prod_tt_sasportal.devices.deployments_devices_move 
@deploymentsId='{{ deploymentsId }}' --required, 
@devicesId='{{ devicesId }}' --required 
@@json=
'{
"destination": "{{ destination }}"
}';

deployments_devices_sign_device

Signs a device.

EXEC google.prod_tt_sasportal.devices.deployments_devices_sign_device 
@deploymentsId='{{ deploymentsId }}' --required, 
@devicesId='{{ devicesId }}' --required 
@@json=
'{
"device": "{{ device }}"
}';