solutions

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

Overview

Name	solutions
Type	Resource
Id	azure_extras.agrifood.solutions

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. E.g. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}".
name	string	The name of the resource.
	object	Unmatched properties from the message are deserialized to this collection.
eTag	string	The ETag value to implement optimistic concurrency.
marketplacePublisherId	string	SaaS application Publisher Id. Required.
offerId	string	SaaS application Offer Id. Required.
partnerId	string	Partner Id of the Solution.
planId	string	SaaS application Plan Id. Required.
saasSubscriptionId	string	SaaS subscriptionId of the installed SaaS application. Required.
saasSubscriptionName	string	SaaS subscription name of the installed SaaS application. Required.
solutionId	string	Solution Id.
systemData	object	Azure Resource Manager metadata containing createdBy and modifiedBy information.
termId	string	SaaS application Term Id. Required.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

list

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. E.g. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}".
name	string	The name of the resource.
	object	Unmatched properties from the message are deserialized to this collection.
eTag	string	The ETag value to implement optimistic concurrency.
marketplacePublisherId	string	SaaS application Publisher Id. Required.
offerId	string	SaaS application Offer Id. Required.
partnerId	string	Partner Id of the Solution.
planId	string	SaaS application Plan Id. Required.
saasSubscriptionId	string	SaaS subscriptionId of the installed SaaS application. Required.
saasSubscriptionName	string	SaaS subscription name of the installed SaaS application. Required.
solutionId	string	Solution Id.
systemData	object	Azure Resource Manager metadata containing createdBy and modifiedBy information.
termId	string	SaaS application Term Id. Required.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	resource_group_name, farm_beats_resource_name, subscription_id, solution_id		Get installed Solution details by Solution id.
list	select	resource_group_name, farm_beats_resource_name, subscription_id	minCreatedDateTime, maxCreatedDateTime, minLastModifiedDateTime, maxLastModifiedDateTime, $maxPageSize, $skipToken	Get installed Solutions details.
create_or_update	insert	resource_group_name, farm_beats_resource_name, subscription_id, solution_id		Install Or Update Solution.
create_or_update	replace	resource_group_name, farm_beats_resource_name, subscription_id, solution_id		Install Or Update Solution.
delete	delete	resource_group_name, farm_beats_resource_name, subscription_id, solution_id		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
farm_beats_resource_name	string	FarmBeats resource name. Required.
resource_group_name	string	The name of the resource group. The name is case insensitive. Required.
solution_id	string
subscription_id	string
$maxPageSize	integer	Maximum number of items needed (inclusive). Minimum = 10, Maximum = 1000, Default value = 50. Default value is 50.
$skipToken	string	Skip token for getting next set of results. 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.
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.

SELECT examples

get

Get installed Solution details by Solution id.

SELECT
id,
name,
,
eTag,
marketplacePublisherId,
offerId,
partnerId,
planId,
saasSubscriptionId,
saasSubscriptionName,
solutionId,
systemData,
termId,
type
FROM azure_extras.agrifood.solutions
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND farm_beats_resource_name = '{{ farm_beats_resource_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
AND solution_id = '{{ solution_id }}' -- required
;

list

Get installed Solutions details.

SELECT
id,
name,
,
eTag,
marketplacePublisherId,
offerId,
partnerId,
planId,
saasSubscriptionId,
saasSubscriptionName,
solutionId,
systemData,
termId,
type
FROM azure_extras.agrifood.solutions
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND farm_beats_resource_name = '{{ farm_beats_resource_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
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.agrifood.solutions (
properties,
resource_group_name,
farm_beats_resource_name,
subscription_id,
solution_id
)
SELECT 
'{{ properties }}',
'{{ resource_group_name }}',
'{{ farm_beats_resource_name }}',
'{{ subscription_id }}',
'{{ solution_id }}'
RETURNING
id,
name,
eTag,
properties,
systemData,
type
;

Manifest

# Description fields are for documentation purposes
- name: solutions
props:
  - name: resource_group_name
    value: "{{ resource_group_name }}"
    description: Required parameter for the solutions resource.
  - name: farm_beats_resource_name
    value: "{{ farm_beats_resource_name }}"
    description: Required parameter for the solutions resource.
  - name: subscription_id
    value: "{{ subscription_id }}"
    description: Required parameter for the solutions resource.
  - name: solution_id
    value: "{{ solution_id }}"
    description: Required parameter for the solutions resource.
  - name: properties
    description: |
      Solution resource properties.
    value:
      : "{{  }}"
      solutionId: "{{ solutionId }}"
      partnerId: "{{ partnerId }}"
      saasSubscriptionId: "{{ saasSubscriptionId }}"
      saasSubscriptionName: "{{ saasSubscriptionName }}"
      marketplacePublisherId: "{{ marketplacePublisherId }}"
      planId: "{{ planId }}"
      offerId: "{{ offerId }}"
      termId: "{{ termId }}"

REPLACE examples

create_or_update

Install Or Update Solution.

REPLACE azure_extras.agrifood.solutions
SET 
properties = '{{ properties }}'
WHERE 
resource_group_name = '{{ resource_group_name }}' --required
AND farm_beats_resource_name = '{{ farm_beats_resource_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
AND solution_id = '{{ solution_id }}' --required
RETURNING
id,
name,
eTag,
properties,
systemData,
type;

DELETE examples

delete

Uninstall Solution.

DELETE FROM azure_extras.agrifood.solutions
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND farm_beats_resource_name = '{{ farm_beats_resource_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
AND solution_id = '{{ solution_id }}' --required
;