devices

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

Overview

Name	devices
Type	Resource
Id	google.sasportal.devices

Fields

Name	Datatype	Description
name	string	Output only. The resource path name.
activeConfig	object	Information about the device configuration.
currentChannels	array	Output only. Current channels with scores.
deviceMetadata	object	Device data overridable by both SAS Portal and registration requests.
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	Information about the device configuration.
serialNumber	string	A serial number assigned to the device by the device manufacturer.
state	string	Output only. Device state.

Methods

Name	Accessible by	Required Params	Description
customers_deployments_devices_list	SELECT	customersId, deploymentsId	Lists devices under a node or customer.
customers_devices_get	SELECT	customersId, devicesId	Gets details about a device.
customers_devices_list	SELECT	customersId	Lists devices under a node or customer.
customers_nodes_devices_list	SELECT	customersId, nodesId	Lists devices under a node or customer.
deployments_devices_get	SELECT	deploymentsId, devicesId	Gets details about a device.
nodes_deployments_devices_list	SELECT	deploymentsId, nodesId	Lists devices under a node or customer.
nodes_devices_get	SELECT	devicesId, nodesId	Gets details about a device.
nodes_devices_list	SELECT	nodesId	Lists devices under a node or customer.
nodes_nodes_devices_list	SELECT	nodesId, nodesId1	Lists devices under a node or customer.
customers_deployments_devices_create	INSERT	customersId, deploymentsId	Creates a device under a node or customer.
customers_devices_create	INSERT	customersId	Creates a device under a node or customer.
customers_nodes_devices_create	INSERT	customersId, nodesId	Creates a device under a node or customer.
nodes_deployments_devices_create	INSERT	deploymentsId, nodesId	Creates a device under a node or customer.
nodes_devices_create	INSERT	nodesId	Creates a device under a node or customer.
nodes_nodes_devices_create	INSERT	nodesId, nodesId1	Creates a device under a node or customer.
customers_devices_delete	DELETE	customersId, devicesId	Deletes a device.
deployments_devices_delete	DELETE	deploymentsId, devicesId	Deletes a device.
nodes_devices_delete	DELETE	devicesId, nodesId	Deletes a device.
customers_devices_patch	UPDATE	customersId, devicesId	Updates a device.
deployments_devices_patch	UPDATE	deploymentsId, devicesId	Updates a device.
nodes_devices_patch	UPDATE	devicesId, nodesId	Updates 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.
deployments_devices_move	EXEC	deploymentsId, devicesId	Moves a device under another node or customer.
deployments_devices_sign_device	EXEC	deploymentsId, devicesId	Signs a device.
nodes_devices_move	EXEC	devicesId, nodesId	Moves a device under another node or customer.
nodes_devices_sign_device	EXEC	devicesId, nodesId	Signs a device.

SELECT examples

Lists devices under a node or customer.

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

INSERT example

Use the following StackQL query and manifest file to create a new devices resource.

All Properties

/*+ create */
INSERT INTO google.sasportal.devices (
nodesId,
grants,
displayName,
preloadedConfig,
fccId,
deviceMetadata,
activeConfig,
name,
grantRangeAllowlists,
serialNumber,
state
)
SELECT 
'{{ nodesId }}',
'{{ grants }}',
'{{ displayName }}',
'{{ preloadedConfig }}',
'{{ fccId }}',
'{{ deviceMetadata }}',
'{{ activeConfig }}',
'{{ name }}',
'{{ grantRangeAllowlists }}',
'{{ serialNumber }}',
'{{ state }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: grants
      value:
        - - name: grantId
            value: string
          - name: frequencyRange
            value:
              - name: lowFrequencyMhz
                value: number
              - name: highFrequencyMhz
                value: number
          - name: state
            value: string
          - name: channelType
            value: string
          - name: maxEirp
            value: number
          - name: suspensionReason
            value:
              - string
          - name: moveList
            value:
              - - name: dpaId
                  value: string
          - name: expireTime
            value: string
          - name: lastHeartbeatTransmitExpireTime
            value: string
    - name: displayName
      value: string
    - name: currentChannels
      value:
        - - name: score
            value: number
    - name: preloadedConfig
      value:
        - name: updateTime
          value: string
        - name: model
          value:
            - name: firmwareVersion
              value: string
            - name: hardwareVersion
              value: string
            - name: name
              value: string
            - name: softwareVersion
              value: string
            - name: vendor
              value: string
        - name: callSign
          value: string
        - name: measurementCapabilities
          value:
            - string
        - name: state
          value: string
        - name: airInterface
          value:
            - name: radioTechnology
              value: string
            - name: supportedSpec
              value: string
        - name: installationParams
          value:
            - name: verticalAccuracy
              value: number
            - name: horizontalAccuracy
              value: number
            - name: heightType
              value: string
            - name: latitude
              value: number
            - name: antennaGain
              value: number
            - name: longitude
              value: number
            - name: cpeCbsdIndication
              value: boolean
            - name: eirpCapability
              value: integer
            - name: antennaBeamwidth
              value: integer
            - name: antennaDowntilt
              value: integer
            - name: height
              value: number
            - name: antennaAzimuth
              value: integer
            - name: antennaModel
              value: string
            - name: indoorDeployment
              value: boolean
        - name: userId
          value: string
        - name: isSigned
          value: boolean
        - name: category
          value: string
    - name: fccId
      value: string
    - name: deviceMetadata
      value:
        - name: nrqzValidation
          value:
            - name: cpiId
              value: string
            - name: state
              value: string
            - name: longitude
              value: number
            - name: latitude
              value: number
            - name: caseId
              value: string
        - name: antennaModel
          value: string
        - name: nrqzValidated
          value: boolean
        - name: commonChannelGroup
          value: string
        - name: interferenceCoordinationGroup
          value: string
    - name: name
      value: string
    - name: grantRangeAllowlists
      value:
        - - name: lowFrequencyMhz
            value: number
          - name: highFrequencyMhz
            value: number
    - name: serialNumber
      value: string
    - name: state
      value: string

UPDATE example

Updates a devices resource.

/*+ update */
UPDATE google.sasportal.devices
SET 
grants = '{{ grants }}',
displayName = '{{ displayName }}',
preloadedConfig = '{{ preloadedConfig }}',
fccId = '{{ fccId }}',
deviceMetadata = '{{ deviceMetadata }}',
activeConfig = '{{ activeConfig }}',
name = '{{ name }}',
grantRangeAllowlists = '{{ grantRangeAllowlists }}',
serialNumber = '{{ serialNumber }}',
state = '{{ state }}'
WHERE 
devicesId = '{{ devicesId }}'
AND nodesId = '{{ nodesId }}';

DELETE example

Deletes the specified devices resource.

/*+ delete */
DELETE FROM google.sasportal.devices
WHERE devicesId = '{{ devicesId }}'
AND nodesId = '{{ nodesId }}';