vw_marketplace_agreements

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

Overview

Name	vw_marketplace_agreements
Type	View
Id	azure_extras.marketplace_ordering.vw_marketplace_agreements

Fields

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition

Sqlite3

SELECT
id as id,
name as name,
systemData as system_data,
type as type,
JSON_EXTRACT(properties, '$.publisher') as "publisher",
JSON_EXTRACT(properties, '$.product') as "product",
JSON_EXTRACT(properties, '$.plan') as "plan",
JSON_EXTRACT(properties, '$.licenseTextLink') as "license_text_link",
JSON_EXTRACT(properties, '$.privacyPolicyLink') as "privacy_policy_link",
JSON_EXTRACT(properties, '$.marketplaceTermsLink') as "marketplace_terms_link",
JSON_EXTRACT(properties, '$.retrieveDatetime') as "retrieve_datetime",
JSON_EXTRACT(properties, '$.signature') as "signature",
JSON_EXTRACT(properties, '$.accepted') as "accepted",
subscriptionId,
offerType,
publisherId,
offerId,
planId
FROM azure_extras.marketplace_ordering.marketplace_agreements
WHERE subscriptionId = 'replace-me';

Postgres

SELECT
id as id,
name as name,
systemData as system_data,
type as type,
json_extract_path_text(properties, '$.publisher') as "publisher",
json_extract_path_text(properties, '$.product') as "product",
json_extract_path_text(properties, '$.plan') as "plan",
json_extract_path_text(properties, '$.licenseTextLink') as "license_text_link",
json_extract_path_text(properties, '$.privacyPolicyLink') as "privacy_policy_link",
json_extract_path_text(properties, '$.marketplaceTermsLink') as "marketplace_terms_link",
json_extract_path_text(properties, '$.retrieveDatetime') as "retrieve_datetime",
json_extract_path_text(properties, '$.signature') as "signature",
json_extract_path_text(properties, '$.accepted') as "accepted",
subscriptionId,
offerType,
publisherId,
offerId,
planId
FROM azure_extras.marketplace_ordering.marketplace_agreements
WHERE subscriptionId = 'replace-me';