tillage_data

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

Overview

Name	tillage_data
Type	Resource
Id	azure_extras.agrifood_farming.tillage_data

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:

Name	Accessible by	Required Params	Optional Params	Description
create_or_update	insert	party_id, tillage_data_id, endpoint		Creates or updates an tillage data resource under a particular party.
create_or_update	replace	party_id, tillage_data_id, endpoint		Creates or updates an tillage data resource under a particular party.
delete	delete	party_id, tillage_data_id, endpoint		Deletes a specified tillage data resource under a particular party.
get_raw	exec	party_id, tillage_data_id, endpoint		Get a specified tillage data resource under a particular party.
list_raw	exec	endpoint	minTillageDepth, maxTillageDepth, minTillagePressure, maxTillagePressure, minOperationStartDateTime, maxOperationStartDateTime, minOperationEndDateTime, maxOperationEndDateTime, minOperationModifiedDateTime, maxOperationModifiedDateTime, minArea, maxArea, minCreatedDateTime, maxCreatedDateTime, minLastModifiedDateTime, maxLastModifiedDateTime, skipToken	Returns a paginated list of tillage data resources across all parties.
list_by_party_id	exec	party_id, endpoint	minTillageDepth, maxTillageDepth, minTillagePressure, maxTillagePressure, minOperationStartDateTime, maxOperationStartDateTime, minOperationEndDateTime, maxOperationEndDateTime, minOperationModifiedDateTime, maxOperationModifiedDateTime, minArea, maxArea, minCreatedDateTime, maxCreatedDateTime, minLastModifiedDateTime, maxLastModifiedDateTime, skipToken	Returns a paginated list of tillage data resources under a particular farm.
get_cascade_delete_job_details	exec	job_id, endpoint		Get cascade delete job for tillage data resource.
create_cascade_delete_job	exec	job_id, partyId, tillageDataId, endpoint		Create cascade delete job for tillage data resource.

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.

Name	Datatype	Description
endpoint	string	The service endpoint host (no scheme). (default: )
job_id	string	Job Id supplied by end user. Required.
partyId	string	Id of the party. Required.
party_id	string	ID of the associated party. Required.
tillageDataId	string	Id of the tillage data. Required.
tillage_data_id	string	ID of the tillage data resource. Required.
maxArea	number	Maximum area for which operation was applied (inclusive). Default value is None.
maxCreatedDateTime	string (date-time)	Maximum creation date of resource (inclusive). Default value is None.
maxLastModifiedDateTime	string (date-time)	Maximum last modified date of resource (inclusive). Default value is None.
maxOperationEndDateTime	string (date-time)	Maximum end date-time of the operation data, sample format: yyyy-MM-ddTHH:mm:ssZ (inclusive). Default value is None.
maxOperationModifiedDateTime	string (date-time)	Maximum modified date-time of the operation data, sample format: yyyy-MM-ddTHH:mm:ssZ (inclusive). Default value is None.
maxOperationStartDateTime	string (date-time)	Maximum start date-time of the operation data, sample format: yyyy-MM-ddTHH:mm:ssZ (inclusive). Default value is None.
maxTillageDepth	number	Maximum measured tillage depth (inclusive). Default value is None.
maxTillagePressure	number	Maximum pressure applied to a tillage implement (inclusive). Default value is None.
minArea	number	Minimum area for which operation was applied (inclusive). Default value is None.
minCreatedDateTime	string (date-time)	Minimum creation date of resource (inclusive). Default value is None.
minLastModifiedDateTime	string (date-time)	Minimum last modified date of resource (inclusive). Default value is None.
minOperationEndDateTime	string (date-time)	Minimum end date-time of the operation data, sample format: yyyy-MM-ddTHH:mm:ssZ (inclusive). Default value is None.
minOperationModifiedDateTime	string (date-time)	Minimum modified date-time of the operation data, sample format: yyyy-MM-ddTHH:mm:ssZ (inclusive). Default value is None.
minOperationStartDateTime	string (date-time)	Minimum start date-time of the operation data, sample format: yyyy-MM-ddTHH:mm:ssZ (inclusive). Default value is None.
minTillageDepth	number	Minimum measured tillage depth (inclusive). Default value is None.
minTillagePressure	number	Minimum pressure applied to a tillage implement (inclusive). Default value is None.
skipToken	string	Skip token for getting next set of results. Default value is None.

INSERT examples

create_or_update

Creates or updates an tillage data resource under a particular party.

INSERT INTO azure_extras.agrifood_farming.tillage_data (
party_id,
tillage_data_id,
endpoint
)
SELECT 
'{{ party_id }}',
'{{ tillage_data_id }}',
'{{ endpoint }}'
;

Manifest

# Description fields are for documentation purposes
- name: tillage_data
props:
  - name: party_id
    value: "{{ party_id }}"
    description: Required parameter for the tillage_data resource.
  - name: tillage_data_id
    value: "{{ tillage_data_id }}"
    description: Required parameter for the tillage_data resource.
  - name: endpoint
    value: "{{ endpoint }}"
    description: Required parameter for the tillage_data resource.

REPLACE examples

create_or_update

Creates or updates an tillage data resource under a particular party.

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

DELETE examples

delete

Deletes a specified tillage data resource under a particular party.

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

Lifecycle Methods

get_raw

Get a specified tillage data resource under a particular party.

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

list_raw

Returns a paginated list of tillage data resources across all parties.

EXEC azure_extras.agrifood_farming.tillage_data.list_raw 
@endpoint='{{ endpoint }}' --required, 
@minTillageDepth='{{ minTillageDepth }}', 
@maxTillageDepth='{{ maxTillageDepth }}', 
@minTillagePressure='{{ minTillagePressure }}', 
@maxTillagePressure='{{ maxTillagePressure }}', 
@minOperationStartDateTime='{{ minOperationStartDateTime }}', 
@maxOperationStartDateTime='{{ maxOperationStartDateTime }}', 
@minOperationEndDateTime='{{ minOperationEndDateTime }}', 
@maxOperationEndDateTime='{{ maxOperationEndDateTime }}', 
@minOperationModifiedDateTime='{{ minOperationModifiedDateTime }}', 
@maxOperationModifiedDateTime='{{ maxOperationModifiedDateTime }}', 
@minArea='{{ minArea }}', 
@maxArea='{{ maxArea }}', 
@minCreatedDateTime='{{ minCreatedDateTime }}', 
@maxCreatedDateTime='{{ maxCreatedDateTime }}', 
@minLastModifiedDateTime='{{ minLastModifiedDateTime }}', 
@maxLastModifiedDateTime='{{ maxLastModifiedDateTime }}', 
@skipToken='{{ skipToken }}'
;

list_by_party_id

Returns a paginated list of tillage data resources under a particular farm.

EXEC azure_extras.agrifood_farming.tillage_data.list_by_party_id 
@party_id='{{ party_id }}' --required, 
@endpoint='{{ endpoint }}' --required, 
@minTillageDepth='{{ minTillageDepth }}', 
@maxTillageDepth='{{ maxTillageDepth }}', 
@minTillagePressure='{{ minTillagePressure }}', 
@maxTillagePressure='{{ maxTillagePressure }}', 
@minOperationStartDateTime='{{ minOperationStartDateTime }}', 
@maxOperationStartDateTime='{{ maxOperationStartDateTime }}', 
@minOperationEndDateTime='{{ minOperationEndDateTime }}', 
@maxOperationEndDateTime='{{ maxOperationEndDateTime }}', 
@minOperationModifiedDateTime='{{ minOperationModifiedDateTime }}', 
@maxOperationModifiedDateTime='{{ maxOperationModifiedDateTime }}', 
@minArea='{{ minArea }}', 
@maxArea='{{ maxArea }}', 
@minCreatedDateTime='{{ minCreatedDateTime }}', 
@maxCreatedDateTime='{{ maxCreatedDateTime }}', 
@minLastModifiedDateTime='{{ minLastModifiedDateTime }}', 
@maxLastModifiedDateTime='{{ maxLastModifiedDateTime }}', 
@skipToken='{{ skipToken }}'
;

get_cascade_delete_job_details

Get cascade delete job for tillage data resource.

EXEC azure_extras.agrifood_farming.tillage_data.get_cascade_delete_job_details 
@job_id='{{ job_id }}' --required, 
@endpoint='{{ endpoint }}' --required
;

create_cascade_delete_job

Create cascade delete job for tillage data resource.

EXEC azure_extras.agrifood_farming.tillage_data.create_cascade_delete_job 
@job_id='{{ job_id }}' --required, 
@partyId='{{ partyId }}' --required, 
@tillageDataId='{{ tillageDataId }}' --required, 
@endpoint='{{ endpoint }}' --required
;