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
;