application_data

Creates, updates, deletes, gets or lists an application_data resource.

Overview

Name	application_data
Type	Resource
Id	azure_extras.agrifood_farming.application_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, application_data_id, endpoint		Creates or updates an application data resource under a particular party.
create_or_update	replace	party_id, application_data_id, endpoint		Creates or updates an application data resource under a particular party.
delete	delete	party_id, application_data_id, endpoint		Deletes a specified application data resource under a particular party.
get_raw	exec	party_id, application_data_id, endpoint		Get a specified application data resource under a particular party.
list_raw	exec	endpoint	minAvgMaterial, maxAvgMaterial, minTotalMaterial, maxTotalMaterial, minOperationStartDateTime, maxOperationStartDateTime, minOperationEndDateTime, maxOperationEndDateTime, minOperationModifiedDateTime, maxOperationModifiedDateTime, minArea, maxArea, minCreatedDateTime, maxCreatedDateTime, minLastModifiedDateTime, maxLastModifiedDateTime, skipToken	Returns a paginated list of application data resources across all parties.
list_by_party_id	exec	party_id, endpoint	minAvgMaterial, maxAvgMaterial, minTotalMaterial, maxTotalMaterial, minOperationStartDateTime, maxOperationStartDateTime, minOperationEndDateTime, maxOperationEndDateTime, minOperationModifiedDateTime, maxOperationModifiedDateTime, minArea, maxArea, minCreatedDateTime, maxCreatedDateTime, minLastModifiedDateTime, maxLastModifiedDateTime, skipToken	Returns a paginated list of application data resources under a particular party.
get_cascade_delete_job_details	exec	job_id, endpoint		Get cascade delete job for application data resource.
create_cascade_delete_job	exec	job_id, partyId, applicationDataId, endpoint		Create cascade delete job for application 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
applicationDataId	string	Id of the application data. Required.
application_data_id	string	ID of the application data resource. Required.
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.
maxArea	number	Maximum area for which operation was applied (inclusive). Default value is None.
maxAvgMaterial	number	Maximum average amount of material applied during the application (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.
maxTotalMaterial	number	Maximum total amount of material applied during the application (inclusive). Default value is None.
minArea	number	Minimum area for which operation was applied (inclusive). Default value is None.
minAvgMaterial	number	Minimum average amount of material applied during the application (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.
minTotalMaterial	number	Minimum total amount of material applied during the application (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 application data resource under a particular party.

INSERT INTO azure_extras.agrifood_farming.application_data (
party_id,
application_data_id,
endpoint
)
SELECT 
'{{ party_id }}',
'{{ application_data_id }}',
'{{ endpoint }}'
;

Manifest

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

REPLACE examples

create_or_update

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

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

DELETE examples

delete

Deletes a specified application data resource under a particular party.

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

Lifecycle Methods

get_raw

Get a specified application data resource under a particular party.

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

list_raw

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

EXEC azure_extras.agrifood_farming.application_data.list_raw 
@endpoint='{{ endpoint }}' --required, 
@minAvgMaterial='{{ minAvgMaterial }}', 
@maxAvgMaterial='{{ maxAvgMaterial }}', 
@minTotalMaterial='{{ minTotalMaterial }}', 
@maxTotalMaterial='{{ maxTotalMaterial }}', 
@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 application data resources under a particular party.

EXEC azure_extras.agrifood_farming.application_data.list_by_party_id 
@party_id='{{ party_id }}' --required, 
@endpoint='{{ endpoint }}' --required, 
@minAvgMaterial='{{ minAvgMaterial }}', 
@maxAvgMaterial='{{ maxAvgMaterial }}', 
@minTotalMaterial='{{ minTotalMaterial }}', 
@maxTotalMaterial='{{ maxTotalMaterial }}', 
@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 application data resource.

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

create_cascade_delete_job

Create cascade delete job for application data resource.

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