Skip to main content

nutrient_analyses

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

Overview

Namenutrient_analyses
TypeResource
Idazure_extras.agrifood_farming.nutrient_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, nutrient_analysis_id, endpointCreates or updates a nutrient analysis resource.
create_or_updatereplaceparty_id, nutrient_analysis_id, endpointCreates or updates a nutrient analysis resource.
deletedeleteparty_id, nutrient_analysis_id, endpointDeletes a specified nutrient analysis resource under a particular party.
get_rawexecparty_id, nutrient_analysis_id, endpointGets a specified nutrient analysis resource under a particular party.
list_rawexecendpointparentType, minCreatedDateTime, maxCreatedDateTime, minLastModifiedDateTime, maxLastModifiedDateTime, skipTokenReturns a paginated list of nutrient analysis resources across all parties.
list_by_party_idexecparty_id, endpointparentType, minCreatedDateTime, maxCreatedDateTime, minLastModifiedDateTime, maxLastModifiedDateTime, skipTokenReturns a paginated list of nutrient analysis resources under a particular party.

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: )
nutrient_analysis_idstringId of the nutrient analysis. Required.
party_idstringId of the associated party. 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.
parentTypestringType of the parent it belongs to. i.e. PlantTissueAnalysis. Default value is None.
skipTokenstringSkip token for getting next set of results. Default value is None.

INSERT examples

Creates or updates a nutrient analysis resource.

INSERT INTO azure_extras.agrifood_farming.nutrient_analyses (
party_id,
nutrient_analysis_id,
endpoint
)
SELECT
'{{ party_id }}',
'{{ nutrient_analysis_id }}',
'{{ endpoint }}'
;

REPLACE examples

Creates or updates a nutrient analysis resource.

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

DELETE examples

Deletes a specified nutrient analysis resource under a particular party.

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

Lifecycle Methods

Gets a specified nutrient analysis resource under a particular party.

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