Skip to main content

management_zones

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

Overview​

Namemanagement_zones
TypeResource
Idazure_extras.agrifood_farming.management_zones

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_updateinsertparty_id, management_zone_id, endpointCreates or updates a management zone resource.
create_or_updatereplaceparty_id, management_zone_id, endpointCreates or updates a management zone resource.
deletedeleteparty_id, management_zone_id, endpointDeletes a specified management zone resource under a particular party.
get_rawexecparty_id, management_zone_id, endpointGets a specified management zone resource under a particular party.
list_rawexecendpointminCreatedDateTime, maxCreatedDateTime, minLastModifiedDateTime, maxLastModifiedDateTime, skipTokenReturns a paginated list of management zone resources across all parties.
list_by_party_idexecparty_id, endpointminCreatedDateTime, maxCreatedDateTime, minLastModifiedDateTime, maxLastModifiedDateTime, skipTokenReturns a paginated list of management zone resources under a particular party.
get_cascade_delete_job_detailsexecjob_id, endpointGet a cascade delete job for specified job id.
create_cascade_delete_jobexecjob_id, partyId, managementZoneId, endpointCreate a cascade delete job for specified management zone.

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: )
job_idstringJob ID supplied by end user. Required.
managementZoneIdstringID of the management zone to be deleted. Required.
management_zone_idstringId of the management zone. Required.
partyIdstringID of the associated party. Required.
party_idstringId of the associated party. 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​

Creates or updates a management zone resource.

INSERT INTO azure_extras.agrifood_farming.management_zones (
party_id,
management_zone_id,
endpoint
)
SELECT
'{{ party_id }}',
'{{ management_zone_id }}',
'{{ endpoint }}'
;

REPLACE examples​

Creates or updates a management zone resource.

REPLACE azure_extras.agrifood_farming.management_zones
SET
-- No updatable properties
WHERE
party_id = '{{ party_id }}' --required
AND management_zone_id = '{{ management_zone_id }}' --required
AND endpoint = '{{ endpoint }}' --required;

DELETE examples​

Deletes a specified management zone resource under a particular party.

DELETE FROM azure_extras.agrifood_farming.management_zones
WHERE party_id = '{{ party_id }}' --required
AND management_zone_id = '{{ management_zone_id }}' --required
AND endpoint = '{{ endpoint }}' --required
;

Lifecycle Methods​

Gets a specified management zone resource under a particular party.

EXEC azure_extras.agrifood_farming.management_zones.get_raw
@party_id='{{ party_id }}' --required,
@management_zone_id='{{ management_zone_id }}' --required,
@endpoint='{{ endpoint }}' --required
;