solutions

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

Overview

Name	solutions
Type	Resource
Id	azure_extras.ag_food_platform.solutions

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
eTag	string	The ETag value to implement optimistic concurrency.
properties	object	Solution resource properties.
systemData	object	Metadata pertaining to creation and last modification of the resource.

list

Name	Datatype	Description
eTag	string	The ETag value to implement optimistic concurrency.
properties	object	Solution resource properties.
systemData	object	Metadata pertaining to creation and last modification of the resource.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	subscriptionId, resourceGroupName, dataManagerForAgricultureResourceName, solutionId		Get installed Solution details by Solution id.
list	select	subscriptionId, resourceGroupName, dataManagerForAgricultureResourceName	solutionIds, ids, names, propertyFilters, statuses, minCreatedDateTime, maxCreatedDateTime, minLastModifiedDateTime, maxLastModifiedDateTime, $maxPageSize, $skipToken	Get installed Solutions details.
create_or_update	insert	subscriptionId, resourceGroupName, dataManagerForAgricultureResourceName, solutionId		Install Or Update Solution.
delete	delete	subscriptionId, resourceGroupName, dataManagerForAgricultureResourceName, solutionId		Uninstall Solution.

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
dataManagerForAgricultureResourceName	string	DataManagerForAgriculture resource name.
resourceGroupName	string	The name of the resource group. The name is case insensitive.
solutionId	string	SolutionId for Data Manager For Agriculture Resource.
subscriptionId	string (uuid)	The ID of the target subscription. The value must be an UUID.
$maxPageSize	integer (int32)	Maximum number of items needed (inclusive). Minimum = 10, Maximum = 1000, Default value = 50.
$skipToken	string	Skip token for getting next set of results.
ids	array	Ids of the resource.
maxCreatedDateTime	string (date-time)	Maximum creation date of resource (inclusive).
maxLastModifiedDateTime	string (date-time)	Maximum last modified date of resource (inclusive).
minCreatedDateTime	string (date-time)	Minimum creation date of resource (inclusive).
minLastModifiedDateTime	string (date-time)	Minimum last modified date of resource (inclusive).
names	array	Names of the resource.
propertyFilters	array	Filters on key-value pairs within the Properties object. eg. "{testKey} eq {testValue}".
solutionIds	array	Installed Solution ids.
statuses	array	Statuses of the resource.

SELECT examples

get

Get installed Solution details by Solution id.

SELECT
eTag,
properties,
systemData
FROM azure_extras.ag_food_platform.solutions
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND dataManagerForAgricultureResourceName = '{{ dataManagerForAgricultureResourceName }}' -- required
AND solutionId = '{{ solutionId }}' -- required
;

list

Get installed Solutions details.

SELECT
eTag,
properties,
systemData
FROM azure_extras.ag_food_platform.solutions
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND dataManagerForAgricultureResourceName = '{{ dataManagerForAgricultureResourceName }}' -- required
AND solutionIds = '{{ solutionIds }}'
AND ids = '{{ ids }}'
AND names = '{{ names }}'
AND propertyFilters = '{{ propertyFilters }}'
AND statuses = '{{ statuses }}'
AND minCreatedDateTime = '{{ minCreatedDateTime }}'
AND maxCreatedDateTime = '{{ maxCreatedDateTime }}'
AND minLastModifiedDateTime = '{{ minLastModifiedDateTime }}'
AND maxLastModifiedDateTime = '{{ maxLastModifiedDateTime }}'
AND $maxPageSize = '{{ $maxPageSize }}'
AND $skipToken = '{{ $skipToken }}'
;

INSERT examples

create_or_update

Install Or Update Solution.

INSERT INTO azure_extras.ag_food_platform.solutions (
data__properties,
subscriptionId,
resourceGroupName,
dataManagerForAgricultureResourceName,
solutionId
)
SELECT 
'{{ properties }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ dataManagerForAgricultureResourceName }}',
'{{ solutionId }}'
RETURNING
eTag,
properties,
systemData
;

Manifest

# Description fields are for documentation purposes
- name: solutions
  props:
    - name: subscriptionId
      value: string (uuid)
      description: Required parameter for the solutions resource.
    - name: resourceGroupName
      value: string
      description: Required parameter for the solutions resource.
    - name: dataManagerForAgricultureResourceName
      value: string
      description: Required parameter for the solutions resource.
    - name: solutionId
      value: string
      description: Required parameter for the solutions resource.
    - name: properties
      value: object
      description: |
        Solution resource properties.

DELETE examples

delete

Uninstall Solution.

DELETE FROM azure_extras.ag_food_platform.solutions
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND dataManagerForAgricultureResourceName = '{{ dataManagerForAgricultureResourceName }}' --required
AND solutionId = '{{ solutionId }}' --required
;