Skip to main content

sensor_partner_integrations

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

Overview

Namesensor_partner_integrations
TypeResource
Idazure_extras.agrifood_farming.sensor_partner_integrations

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_partner_id, integration_id, endpointCreate or update an integration with a sensor partner.
create_or_updatereplacesensor_partner_id, integration_id, endpointCreate or update an integration with a sensor partner.
deletedeletesensor_partner_id, integration_id, endpointDeletes a partner integration model entity.
get_rawexecsensor_partner_id, integration_id, endpointGets a partner integration model entity.
list_rawexecsensor_partner_id, endpointminCreatedDateTime, maxCreatedDateTime, minLastModifiedDateTime, maxLastModifiedDateTime, skipTokenGets partner integration models.
check_consentexecsensor_partner_id, integration_id, key, endpointChecks consent for partner integration.
generate_consent_linkexecsensor_partner_id, integration_id, endpointGenerates partner integration consent link.

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: )
integration_idstringId of the integration object. Required.
keystringPartner integration key. Required.
sensor_partner_idstringId of the sensor partner. 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 or update an integration with a sensor partner.

INSERT INTO azure_extras.agrifood_farming.sensor_partner_integrations (
sensor_partner_id,
integration_id,
endpoint
)
SELECT
'{{ sensor_partner_id }}',
'{{ integration_id }}',
'{{ endpoint }}'
;

REPLACE examples

Create or update an integration with a sensor partner.

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

DELETE examples

Deletes a partner integration model entity.

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

Lifecycle Methods

Gets a partner integration model entity.

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