sensors

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

Overview

Name	sensors
Type	Resource
Id	azure_extras.agrifood_farming.sensors

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
create_or_update	insert	sensor_partner_id, sensor_id, endpoint		Create a sensor entity.
create_or_update	replace	sensor_partner_id, sensor_id, endpoint		Create a sensor entity.
delete	delete	sensor_partner_id, sensor_id, endpoint		Deletes a sensor entity.
get_raw	exec	sensor_partner_id, sensor_id, endpoint		Gets a sensor entity.
list_raw	exec	sensor_partner_id, endpoint	minCreatedDateTime, maxCreatedDateTime, minLastModifiedDateTime, maxLastModifiedDateTime, skipToken	Returns a paginated list of sensor resources.
get_connection_string	exec	sensor_partner_id, sensor_id, endpoint		Gets a sensor connection string.
renew_connection_string	exec	sensor_partner_id, sensor_id, endpoint		Renews a sensor connection string.

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
endpoint	string	The service endpoint host (no scheme). (default: )
sensor_id	string	Id of the sensor resource. Required.
sensor_partner_id	string	Id of the sensor partner. Required.
maxCreatedDateTime	string (date-time)	Maximum creation date of resource (inclusive). Default value is None.
maxLastModifiedDateTime	string (date-time)	Maximum last modified date of resource (inclusive). Default value is None.
minCreatedDateTime	string (date-time)	Minimum creation date of resource (inclusive). Default value is None.
minLastModifiedDateTime	string (date-time)	Minimum last modified date of resource (inclusive). Default value is None.
skipToken	string	Skip token for getting next set of results. Default value is None.

INSERT examples

create_or_update

Create a sensor entity.

INSERT INTO azure_extras.agrifood_farming.sensors (
sensor_partner_id,
sensor_id,
endpoint
)
SELECT 
'{{ sensor_partner_id }}',
'{{ sensor_id }}',
'{{ endpoint }}'
;

Manifest

# Description fields are for documentation purposes
- name: sensors
props:
  - name: sensor_partner_id
    value: "{{ sensor_partner_id }}"
    description: Required parameter for the sensors resource.
  - name: sensor_id
    value: "{{ sensor_id }}"
    description: Required parameter for the sensors resource.
  - name: endpoint
    value: "{{ endpoint }}"
    description: Required parameter for the sensors resource.

REPLACE examples

create_or_update

Create a sensor entity.

REPLACE azure_extras.agrifood_farming.sensors
SET 
-- No updatable properties
WHERE 
sensor_partner_id = '{{ sensor_partner_id }}' --required
AND sensor_id = '{{ sensor_id }}' --required
AND endpoint = '{{ endpoint }}' --required;

DELETE examples

delete

Deletes a sensor entity.

DELETE FROM azure_extras.agrifood_farming.sensors
WHERE sensor_partner_id = '{{ sensor_partner_id }}' --required
AND sensor_id = '{{ sensor_id }}' --required
AND endpoint = '{{ endpoint }}' --required
;

Lifecycle Methods

get_raw

Gets a sensor entity.

EXEC azure_extras.agrifood_farming.sensors.get_raw 
@sensor_partner_id='{{ sensor_partner_id }}' --required, 
@sensor_id='{{ sensor_id }}' --required, 
@endpoint='{{ endpoint }}' --required
;

list_raw

Returns a paginated list of sensor resources.

EXEC azure_extras.agrifood_farming.sensors.list_raw 
@sensor_partner_id='{{ sensor_partner_id }}' --required, 
@endpoint='{{ endpoint }}' --required, 
@minCreatedDateTime='{{ minCreatedDateTime }}', 
@maxCreatedDateTime='{{ maxCreatedDateTime }}', 
@minLastModifiedDateTime='{{ minLastModifiedDateTime }}', 
@maxLastModifiedDateTime='{{ maxLastModifiedDateTime }}', 
@skipToken='{{ skipToken }}'
;

get_connection_string

Gets a sensor connection string.

EXEC azure_extras.agrifood_farming.sensors.get_connection_string 
@sensor_partner_id='{{ sensor_partner_id }}' --required, 
@sensor_id='{{ sensor_id }}' --required, 
@endpoint='{{ endpoint }}' --required
;

renew_connection_string

Renews a sensor connection string.

EXEC azure_extras.agrifood_farming.sensors.renew_connection_string 
@sensor_partner_id='{{ sensor_partner_id }}' --required, 
@sensor_id='{{ sensor_id }}' --required, 
@endpoint='{{ endpoint }}' --required
;