Skip to main content

marketplace_agreements

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

Overview

Namemarketplace_agreements
TypeResource
Idazure_extras.marketplace_ordering.marketplace_agreements

Fields

The following fields are returned by SELECT queries:

Terms returned successfully

NameDatatypeDescription
idstringResource ID.
namestringResource name.
propertiesobjectRepresents the properties of the resource.
systemDataobjectThe system meta data relating to this resource.
typestringResource type.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, offerType, publisherId, offerId, planIdGet marketplace terms.
listselectsubscriptionIdList marketplace agreements in the subscription.
createinsertofferType, subscriptionId, publisherId, offerId, planIdSave marketplace terms.
signexecsubscriptionId, publisherId, offerId, planIdSign marketplace terms.
cancelexecsubscriptionId, publisherId, offerId, planIdCancel marketplace terms.

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
offerIdstringOffer identifier string of image being deployed.
offerTypestringOffer Type, currently only virtualmachine type is supported.
planIdstringPlan identifier string of image being deployed.
publisherIdstringPublisher identifier string of image being deployed.
subscriptionIdstringThe subscription ID that identifies an Azure subscription.

SELECT examples

Get marketplace terms.

SELECT
id,
name,
properties,
systemData,
type
FROM azure_extras.marketplace_ordering.marketplace_agreements
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND offerType = '{{ offerType }}' -- required
AND publisherId = '{{ publisherId }}' -- required
AND offerId = '{{ offerId }}' -- required
AND planId = '{{ planId }}' -- required
;

INSERT examples

Save marketplace terms.

INSERT INTO azure_extras.marketplace_ordering.marketplace_agreements (
data__properties,
offerType,
subscriptionId,
publisherId,
offerId,
planId
)
SELECT
'{{ properties }}',
'{{ offerType }}',
'{{ subscriptionId }}',
'{{ publisherId }}',
'{{ offerId }}',
'{{ planId }}'
RETURNING
id,
name,
properties,
systemData,
type
;

Lifecycle Methods

Sign marketplace terms.

EXEC azure_extras.marketplace_ordering.marketplace_agreements.sign 
@subscriptionId='{{ subscriptionId }}' --required,
@publisherId='{{ publisherId }}' --required,
@offerId='{{ offerId }}' --required,
@planId='{{ planId }}' --required
;