devices_signed

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

Overview

Name	devices_signed
Type	Resource
Id	google.prod_tt_sasportal.devices_signed

Fields

The following fields are returned by SELECT queries:

SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
customers_nodes_devices_create_signed	insert	customersId, nodesId		Creates a signed device under a node or customer.
customers_deployments_devices_create_signed	insert	customersId, deploymentsId		Creates a signed device under a node or customer.
nodes_nodes_devices_create_signed	insert	nodesId, nodesId1		Creates a signed device under a node or customer.
nodes_deployments_devices_create_signed	insert	nodesId, deploymentsId		Creates a signed device under a node or customer.
customers_devices_create_signed	insert	customersId		Creates a signed device under a node or customer.
nodes_devices_create_signed	insert	nodesId		Creates a signed device under a node or customer.
customers_devices_update_signed	update	customersId, devicesId		Updates a signed device.
nodes_devices_update_signed	update	nodesId, devicesId		Updates a signed device.
deployments_devices_update_signed	update	deploymentsId, devicesId		Updates a signed 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

INSERT examples

customers_nodes_devices_create_signed

Creates a signed device under a node or customer.

INSERT INTO google.prod_tt_sasportal.devices_signed (
data__encodedDevice,
data__installerId,
customersId,
nodesId
)
SELECT 
'{{ encodedDevice }}',
'{{ installerId }}',
'{{ customersId }}',
'{{ nodesId }}'
RETURNING
name,
activeConfig,
currentChannels,
deviceMetadata,
displayName,
fccId,
grantRangeAllowlists,
grants,
preloadedConfig,
serialNumber,
state
;

customers_deployments_devices_create_signed

Creates a signed device under a node or customer.

INSERT INTO google.prod_tt_sasportal.devices_signed (
data__encodedDevice,
data__installerId,
customersId,
deploymentsId
)
SELECT 
'{{ encodedDevice }}',
'{{ installerId }}',
'{{ customersId }}',
'{{ deploymentsId }}'
RETURNING
name,
activeConfig,
currentChannels,
deviceMetadata,
displayName,
fccId,
grantRangeAllowlists,
grants,
preloadedConfig,
serialNumber,
state
;

nodes_nodes_devices_create_signed

Creates a signed device under a node or customer.

INSERT INTO google.prod_tt_sasportal.devices_signed (
data__encodedDevice,
data__installerId,
nodesId,
nodesId1
)
SELECT 
'{{ encodedDevice }}',
'{{ installerId }}',
'{{ nodesId }}',
'{{ nodesId1 }}'
RETURNING
name,
activeConfig,
currentChannels,
deviceMetadata,
displayName,
fccId,
grantRangeAllowlists,
grants,
preloadedConfig,
serialNumber,
state
;

nodes_deployments_devices_create_signed

Creates a signed device under a node or customer.

INSERT INTO google.prod_tt_sasportal.devices_signed (
data__encodedDevice,
data__installerId,
nodesId,
deploymentsId
)
SELECT 
'{{ encodedDevice }}',
'{{ installerId }}',
'{{ nodesId }}',
'{{ deploymentsId }}'
RETURNING
name,
activeConfig,
currentChannels,
deviceMetadata,
displayName,
fccId,
grantRangeAllowlists,
grants,
preloadedConfig,
serialNumber,
state
;

customers_devices_create_signed

Creates a signed device under a node or customer.

INSERT INTO google.prod_tt_sasportal.devices_signed (
data__encodedDevice,
data__installerId,
customersId
)
SELECT 
'{{ encodedDevice }}',
'{{ installerId }}',
'{{ customersId }}'
RETURNING
name,
activeConfig,
currentChannels,
deviceMetadata,
displayName,
fccId,
grantRangeAllowlists,
grants,
preloadedConfig,
serialNumber,
state
;

nodes_devices_create_signed

Creates a signed device under a node or customer.

INSERT INTO google.prod_tt_sasportal.devices_signed (
data__encodedDevice,
data__installerId,
nodesId
)
SELECT 
'{{ encodedDevice }}',
'{{ installerId }}',
'{{ nodesId }}'
RETURNING
name,
activeConfig,
currentChannels,
deviceMetadata,
displayName,
fccId,
grantRangeAllowlists,
grants,
preloadedConfig,
serialNumber,
state
;

Manifest

# Description fields are for documentation purposes
- name: devices_signed
  props:
    - name: customersId
      value: string
      description: Required parameter for the devices_signed resource.
    - name: nodesId
      value: string
      description: Required parameter for the devices_signed resource.
    - name: deploymentsId
      value: string
      description: Required parameter for the devices_signed resource.
    - name: nodesId1
      value: string
      description: Required parameter for the devices_signed resource.
    - name: encodedDevice
      value: string
      description: >
        Required. JSON Web Token signed using a CPI private key. Payload must be the JSON encoding of the device. The user_id field must be set.
        
    - name: installerId
      value: string
      description: >
        Required. Unique installer id (CPI ID) from the Certified Professional Installers database.
        

UPDATE examples

customers_devices_update_signed

Updates a signed device.

UPDATE google.prod_tt_sasportal.devices_signed
SET 
data__encodedDevice = '{{ encodedDevice }}',
data__installerId = '{{ installerId }}'
WHERE 
customersId = '{{ customersId }}' --required
AND devicesId = '{{ devicesId }}' --required
RETURNING
name,
activeConfig,
currentChannels,
deviceMetadata,
displayName,
fccId,
grantRangeAllowlists,
grants,
preloadedConfig,
serialNumber,
state;

nodes_devices_update_signed

Updates a signed device.

UPDATE google.prod_tt_sasportal.devices_signed
SET 
data__encodedDevice = '{{ encodedDevice }}',
data__installerId = '{{ installerId }}'
WHERE 
nodesId = '{{ nodesId }}' --required
AND devicesId = '{{ devicesId }}' --required
RETURNING
name,
activeConfig,
currentChannels,
deviceMetadata,
displayName,
fccId,
grantRangeAllowlists,
grants,
preloadedConfig,
serialNumber,
state;

deployments_devices_update_signed

Updates a signed device.

UPDATE google.prod_tt_sasportal.devices_signed
SET 
data__encodedDevice = '{{ encodedDevice }}',
data__installerId = '{{ installerId }}'
WHERE 
deploymentsId = '{{ deploymentsId }}' --required
AND devicesId = '{{ devicesId }}' --required
RETURNING
name,
activeConfig,
currentChannels,
deviceMetadata,
displayName,
fccId,
grantRangeAllowlists,
grants,
preloadedConfig,
serialNumber,
state;