Skip to main content

offers

Creates, updates, deletes, gets or lists an offers resource.

Overview

Nameoffers
TypeResource
Idaws.marketplace_discovery.offers

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
agreement_proposal_idstringAn encoded string to be passed by the acceptor of the terms when creating an agreement. (pattern: <code>[A-Za-z0-9_/-]+</code>)
associated_entitiesarrayThe products and offer sets associated with this offer.
available_from_timestring (date-time)The date and time when the offer became available to the buyer.
badgesarrayBadges indicating special attributes of the offer, such as private pricing, future dated, or replacement offer.
catalogstringThe name of the catalog that the offer belongs to. (pattern: <code>[\w-]+</code>)
expiration_timestring (date-time)The date and time until when the offer can be procured. This value is null for offers that never expire.
offer_idstringThe unique identifier of the offer. (pattern: <code>[\w-]+</code>)
offer_namestringThe display name of the offer. This is free-form text provided by the seller.
pricing_modelobjectA pricing model that determines how buyers are charged for a listing, such as usage-based, contract, BYOL, or free.
replacement_agreement_idstringThe identifier of the existing agreement that this offer would replace. Enables agreement-based offer functionality. (pattern: <code>[A-Za-z0-9_/-]+</code>)
seller_of_recordobjectThe entity responsible for selling the product under this offer.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_offerselectregionProvides details about an offer, such as the pricing model, seller of record, availability dates, badges, and associated products.

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
regionstringAWS region (default: us-east-1)

SELECT examples

Provides details about an offer, such as the pricing model, seller of record, availability dates, badges, and associated products.

SELECT
agreement_proposal_id,
associated_entities,
available_from_time,
badges,
catalog,
expiration_time,
offer_id,
offer_name,
pricing_model,
replacement_agreement_id,
seller_of_record
FROM aws.marketplace_discovery.offers
WHERE region = '{{ region }}' -- required
;