Skip to main content

plant_tissue_analyses

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

Overview

Nameplant_tissue_analyses
TypeResource
Idazure_extras.agrifood_farming.plant_tissue_analyses

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

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.
plantTissueAnalysisIdstringID of the plant tissue analysis to be deleted. Required.
plant_tissue_analysis_idstringId of the plant tissue analysis. 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 plant tissue analysis resource.

INSERT INTO azure_extras.agrifood_farming.plant_tissue_analyses (
party_id,
plant_tissue_analysis_id,
endpoint
)
SELECT
'{{ party_id }}',
'{{ plant_tissue_analysis_id }}',
'{{ endpoint }}'
;

REPLACE examples

Creates or updates a plant tissue analysis resource.

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

DELETE examples

Deletes a specified plant tissue analysis resource under a particular party.

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

Lifecycle Methods

Gets a specified plant tissue analysis resource under a particular party.

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