Skip to main content

sensor_mappings

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

Overview

Namesensor_mappings
TypeResource
Idazure_extras.agrifood_farming.sensor_mappings

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:

NameAccessible byRequired ParamsOptional ParamsDescription
create_or_updateinsertsensor_mapping_id, endpointCreate a sensor mapping entity.
create_or_updatereplacesensor_mapping_id, endpointCreate a sensor mapping entity.
deletedeletesensor_mapping_id, endpointDeletes a sensor mapping entity.
get_rawexecsensor_mapping_id, endpointGets a sensor mapping entity.
list_rawexecendpointminCreatedDateTime, maxCreatedDateTime, minLastModifiedDateTime, maxLastModifiedDateTime, skipTokenReturns a paginated list of sensor mapping resources.

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
endpointstringThe service endpoint host (no scheme). (default: )
sensor_mapping_idstringId of the sensor mapping resource. Required.
maxCreatedDateTimestring (date-time)Maximum creation date of resource (inclusive). Default value is None.
maxLastModifiedDateTimestring (date-time)Maximum last modified date of resource (inclusive). Default value is None.
minCreatedDateTimestring (date-time)Minimum creation date of resource (inclusive). Default value is None.
minLastModifiedDateTimestring (date-time)Minimum last modified date of resource (inclusive). Default value is None.
skipTokenstringSkip token for getting next set of results. Default value is None.

INSERT examples

Create a sensor mapping entity.

INSERT INTO azure_extras.agrifood_farming.sensor_mappings (
sensor_mapping_id,
endpoint
)
SELECT
'{{ sensor_mapping_id }}',
'{{ endpoint }}'
;

REPLACE examples

Create a sensor mapping entity.

REPLACE azure_extras.agrifood_farming.sensor_mappings
SET
-- No updatable properties
WHERE
sensor_mapping_id = '{{ sensor_mapping_id }}' --required
AND endpoint = '{{ endpoint }}' --required;

DELETE examples

Deletes a sensor mapping entity.

DELETE FROM azure_extras.agrifood_farming.sensor_mappings
WHERE sensor_mapping_id = '{{ sensor_mapping_id }}' --required
AND endpoint = '{{ endpoint }}' --required
;

Lifecycle Methods

Gets a sensor mapping entity.

EXEC azure_extras.agrifood_farming.sensor_mappings.get_raw 
@sensor_mapping_id='{{ sensor_mapping_id }}' --required,
@endpoint='{{ endpoint }}' --required
;