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

NameDatatypeDescription
idtextResource ID.
nametextResource name.
acceptedtextfield from the properties object
license_text_linktextfield from the properties object
marketplace_terms_linktextfield from the properties object
offerIdtextfield from the properties object
offerTypetextfield from the properties object
plantextfield from the properties object
planIdtextfield from the properties object
privacy_policy_linktextfield from the properties object
producttextfield from the properties object
publishertextfield from the properties object
publisherIdtextfield from the properties object
retrieve_datetimetextfield from the properties object
signaturetextfield from the properties object
subscriptionIdtextfield from the properties object
system_datatextfield from the properties object
typetextResource type.

Methods

NameAccessible byRequired ParamsDescription
getSELECTofferId, offerType, planId, publisherId, subscriptionIdGet marketplace terms.
listSELECTsubscriptionIdList marketplace agreements in the subscription.
createINSERTofferId, offerType, planId, publisherId, subscriptionIdSave marketplace terms.
cancelEXECofferId, planId, publisherId, subscriptionIdCancel marketplace terms.
signEXECofferId, planId, publisherId, subscriptionIdSign marketplace terms.

SELECT examples

List marketplace agreements in the subscription.

SELECT
id,
name,
accepted,
license_text_link,
marketplace_terms_link,
offerId,
offerType,
plan,
planId,
privacy_policy_link,
product,
publisher,
publisherId,
retrieve_datetime,
signature,
subscriptionId,
system_data,
type
FROM azure_extras.marketplace_ordering.vw_marketplace_agreements
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

Use the following StackQL query and manifest file to create a new marketplace_agreements resource.

/*+ create */
INSERT INTO azure_extras.marketplace_ordering.marketplace_agreements (
offerId,
offerType,
planId,
publisherId,
subscriptionId,
properties
)
SELECT
'{{ offerId }}',
'{{ offerType }}',
'{{ planId }}',
'{{ publisherId }}',
'{{ subscriptionId }}',
'{{ properties }}'
;