harvest_data

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

Overview

Name	harvest_data
Type	Resource
Id	azure_extras.agrifood_farming.harvest_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, harvest_data_id, endpoint		Creates or updates harvest data resource under a particular party.
create_or_update	replace	party_id, harvest_data_id, endpoint		Creates or updates harvest data resource under a particular party.
delete	delete	party_id, harvest_data_id, endpoint		Deletes a specified harvest data resource under a particular party.
get_raw	exec	party_id, harvest_data_id, endpoint		Get a specified harvest data resource under a particular party.
list_raw	exec	endpoint	minTotalYield, maxTotalYield, minAvgYield, maxAvgYield, minTotalWetMass, maxTotalWetMass, minAvgWetMass, maxAvgWetMass, minAvgMoisture, maxAvgMoisture, minAvgSpeed, maxAvgSpeed, minOperationStartDateTime, maxOperationStartDateTime, minOperationEndDateTime, maxOperationEndDateTime, minOperationModifiedDateTime, maxOperationModifiedDateTime, minArea, maxArea, minCreatedDateTime, maxCreatedDateTime, minLastModifiedDateTime, maxLastModifiedDateTime, skipToken	Returns a paginated list of harvest data resources across all parties.
list_by_party_id	exec	party_id, endpoint	minTotalYield, maxTotalYield, minAvgYield, maxAvgYield, minTotalWetMass, maxTotalWetMass, minAvgWetMass, maxAvgWetMass, minAvgMoisture, maxAvgMoisture, minAvgSpeed, maxAvgSpeed, minOperationStartDateTime, maxOperationStartDateTime, minOperationEndDateTime, maxOperationEndDateTime, minOperationModifiedDateTime, maxOperationModifiedDateTime, minArea, maxArea, minCreatedDateTime, maxCreatedDateTime, minLastModifiedDateTime, maxLastModifiedDateTime, skipToken	Returns a paginated list of harvest data resources under a particular farm.
get_cascade_delete_job_details	exec	job_id, endpoint		Get cascade delete job for harvest data resource.
create_cascade_delete_job	exec	job_id, partyId, harvestDataId, endpoint		Create cascade delete job for harvest 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: )
harvestDataId	string	Id of the harvest data. Required.
harvest_data_id	string	ID of the harvest data resource. Required.
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.
maxArea	number	Maximum area for which operation was applied (inclusive). Default value is None.
maxAvgMoisture	number	Maximum AvgMoisture value (inclusive). Default value is None.
maxAvgSpeed	number	Maximum AvgSpeed value (inclusive). Default value is None.
maxAvgWetMass	number	Maximum AvgWetMass value (inclusive). Default value is None.
maxAvgYield	number	Maximum AvgYield value (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.
maxTotalWetMass	number	Maximum Total WetMass value (inclusive). Default value is None.
maxTotalYield	number	Maximum Yield value (inclusive). Default value is None.
minArea	number	Minimum area for which operation was applied (inclusive). Default value is None.
minAvgMoisture	number	Minimum AvgMoisture value(inclusive). Default value is None.
minAvgSpeed	number	Minimum AvgSpeed value(inclusive). Default value is None.
minAvgWetMass	number	Minimum AvgWetMass value(inclusive). Default value is None.
minAvgYield	number	Minimum AvgYield value(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.
minTotalWetMass	number	Minimum Total WetMass value(inclusive). Default value is None.
minTotalYield	number	Minimum Yield value(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 harvest data resource under a particular party.

INSERT INTO azure_extras.agrifood_farming.harvest_data (
party_id,
harvest_data_id,
endpoint
)
SELECT 
'{{ party_id }}',
'{{ harvest_data_id }}',
'{{ endpoint }}'
;

Manifest

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

REPLACE examples

create_or_update

Creates or updates harvest data resource under a particular party.

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

DELETE examples

delete

Deletes a specified harvest data resource under a particular party.

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

Lifecycle Methods

get_raw

Get a specified harvest data resource under a particular party.

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

list_raw

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

EXEC azure_extras.agrifood_farming.harvest_data.list_raw 
@endpoint='{{ endpoint }}' --required, 
@minTotalYield='{{ minTotalYield }}', 
@maxTotalYield='{{ maxTotalYield }}', 
@minAvgYield='{{ minAvgYield }}', 
@maxAvgYield='{{ maxAvgYield }}', 
@minTotalWetMass='{{ minTotalWetMass }}', 
@maxTotalWetMass='{{ maxTotalWetMass }}', 
@minAvgWetMass='{{ minAvgWetMass }}', 
@maxAvgWetMass='{{ maxAvgWetMass }}', 
@minAvgMoisture='{{ minAvgMoisture }}', 
@maxAvgMoisture='{{ maxAvgMoisture }}', 
@minAvgSpeed='{{ minAvgSpeed }}', 
@maxAvgSpeed='{{ maxAvgSpeed }}', 
@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 harvest data resources under a particular farm.

EXEC azure_extras.agrifood_farming.harvest_data.list_by_party_id 
@party_id='{{ party_id }}' --required, 
@endpoint='{{ endpoint }}' --required, 
@minTotalYield='{{ minTotalYield }}', 
@maxTotalYield='{{ maxTotalYield }}', 
@minAvgYield='{{ minAvgYield }}', 
@maxAvgYield='{{ maxAvgYield }}', 
@minTotalWetMass='{{ minTotalWetMass }}', 
@maxTotalWetMass='{{ maxTotalWetMass }}', 
@minAvgWetMass='{{ minAvgWetMass }}', 
@maxAvgWetMass='{{ maxAvgWetMass }}', 
@minAvgMoisture='{{ minAvgMoisture }}', 
@maxAvgMoisture='{{ maxAvgMoisture }}', 
@minAvgSpeed='{{ minAvgSpeed }}', 
@maxAvgSpeed='{{ maxAvgSpeed }}', 
@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 harvest data resource.

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

create_cascade_delete_job

Create cascade delete job for harvest data resource.

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