Skip to main content

seasonal_fields

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

Overview

Nameseasonal_fields
TypeResource
Idazure_extras.agrifood_farming.seasonal_fields

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, seasonal_field_id, endpointCreates or Updates a seasonal field resource under a particular party.
create_or_updatereplaceparty_id, seasonal_field_id, endpointCreates or Updates a seasonal field resource under a particular party.
deletedeleteparty_id, seasonal_field_id, endpointDeletes a specified seasonal-field resource under a particular party.
get_rawexecparty_id, seasonal_field_id, endpointGets a specified seasonal field resource under a particular party.
list_rawexecendpointminCreatedDateTime, maxCreatedDateTime, minLastModifiedDateTime, maxLastModifiedDateTime, skipTokenReturns a paginated list of seasonal field resources across all parties.
list_by_party_idexecparty_id, endpointminCreatedDateTime, maxCreatedDateTime, minLastModifiedDateTime, maxLastModifiedDateTime, skipTokenReturns a paginated list of seasonal field resources under a particular party.
get_cascade_delete_job_detailsexecjob_id, endpointGet cascade delete job for specified seasonal field.
create_cascade_delete_jobexecjob_id, partyId, seasonalFieldId, endpointCreate a cascade delete job for specified seasonal field.

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.
partyIdstringID of the associated party. Required.
party_idstringId of the associated party. Required.
seasonalFieldIdstringID of the seasonalField to be deleted. Required.
seasonal_field_idstringId of the seasonal field. 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 seasonal field resource under a particular party.

INSERT INTO azure_extras.agrifood_farming.seasonal_fields (
party_id,
seasonal_field_id,
endpoint
)
SELECT
'{{ party_id }}',
'{{ seasonal_field_id }}',
'{{ endpoint }}'
;

REPLACE examples

Creates or Updates a seasonal field resource under a particular party.

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

DELETE examples

Deletes a specified seasonal-field resource under a particular party.

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

Lifecycle Methods

Gets a specified seasonal field resource under a particular party.

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