Skip to content

aws.marketplace_catalog.list_entities

Example SQL Queries

SELECT * FROM
aws.marketplace_catalog.list_entities
WHERE
"catalog" = 'VALUE'
AND "entity_type" = 'VALUE';

Description

Provides the list of entities of a given type.

Table Definition

Column NameColumn Data Type
catalog Required Input Column

The catalog related to the request. Fixed value: AWSMarketplace

VARCHAR
entity_type Required Input Column

The type of the entity.

VARCHAR
entity_type_filters Input Column

A Union object containing filter shapes for all EntityTypes. Each EntityTypeFilter shape will have filters applicable for that EntityType that can be used to search or filter entities.

STRUCT(
"data_product_filters" STRUCT(
"entity_id" STRUCT(
"value_list" VARCHAR[]
),
"product_title" STRUCT(
"value_list" VARCHAR[],
"wild_card_value" VARCHAR
),
"visibility" STRUCT(
"value_list" VARCHAR[]
),
"last_modified_date" STRUCT(
"date_range" STRUCT(
"after_value" VARCHAR,
"before_value" VARCHAR
)
)
),
"saa_s_product_filters" STRUCT(
"entity_id" STRUCT(
"value_list" VARCHAR[]
),
"product_title" STRUCT(
"value_list" VARCHAR[],
"wild_card_value" VARCHAR
),
"visibility" STRUCT(
"value_list" VARCHAR[]
),
"last_modified_date" STRUCT(
"date_range" STRUCT(
"after_value" VARCHAR,
"before_value" VARCHAR
)
)
),
"ami_product_filters" STRUCT(
"entity_id" STRUCT(
"value_list" VARCHAR[]
),
"last_modified_date" STRUCT(
"date_range" STRUCT(
"after_value" VARCHAR,
"before_value" VARCHAR
)
),
"product_title" STRUCT(
"value_list" VARCHAR[],
"wild_card_value" VARCHAR
),
"visibility" STRUCT(
"value_list" VARCHAR[]
)
),
"offer_filters" STRUCT(
"entity_id" STRUCT(
"value_list" VARCHAR[]
),
"name" STRUCT(
"value_list" VARCHAR[],
"wild_card_value" VARCHAR
),
"product_id" STRUCT(
"value_list" VARCHAR[]
),
"resale_authorization_id" STRUCT(
"value_list" VARCHAR[]
),
"release_date" STRUCT(
"date_range" STRUCT(
"after_value" VARCHAR,
"before_value" VARCHAR
)
),
"availability_end_date" STRUCT(
"date_range" STRUCT(
"after_value" VARCHAR,
"before_value" VARCHAR
)
),
"buyer_accounts" STRUCT(
"wild_card_value" VARCHAR
),
"state" STRUCT(
"value_list" VARCHAR[]
),
"targeting" STRUCT(
"value_list" VARCHAR[]
),
"last_modified_date" STRUCT(
"date_range" STRUCT(
"after_value" VARCHAR,
"before_value" VARCHAR
)
)
),
"container_product_filters" STRUCT(
"entity_id" STRUCT(
"value_list" VARCHAR[]
),
"last_modified_date" STRUCT(
"date_range" STRUCT(
"after_value" VARCHAR,
"before_value" VARCHAR
)
),
"product_title" STRUCT(
"value_list" VARCHAR[],
"wild_card_value" VARCHAR
),
"visibility" STRUCT(
"value_list" VARCHAR[]
)
),
"resale_authorization_filters" STRUCT(
"entity_id" STRUCT(
"value_list" VARCHAR[]
),
"name" STRUCT(
"value_list" VARCHAR[],
"wild_card_value" VARCHAR
),
"product_id" STRUCT(
"value_list" VARCHAR[],
"wild_card_value" VARCHAR
),
"created_date" STRUCT(
"date_range" STRUCT(
"after_value" VARCHAR,
"before_value" VARCHAR
),
"value_list" VARCHAR[]
),
"availability_end_date" STRUCT(
"date_range" STRUCT(
"after_value" VARCHAR,
"before_value" VARCHAR
),
"value_list" VARCHAR[]
),
"manufacturer_account_id" STRUCT(
"value_list" VARCHAR[],
"wild_card_value" VARCHAR
),
"product_name" STRUCT(
"value_list" VARCHAR[],
"wild_card_value" VARCHAR
),
"manufacturer_legal_name" STRUCT(
"value_list" VARCHAR[],
"wild_card_value" VARCHAR
),
"reseller_account_id" STRUCT(
"value_list" VARCHAR[],
"wild_card_value" VARCHAR
),
"reseller_legal_name" STRUCT(
"value_list" VARCHAR[],
"wild_card_value" VARCHAR
),
"status" STRUCT(
"value_list" VARCHAR[]
),
"offer_extended_status" STRUCT(
"value_list" VARCHAR[]
),
"last_modified_date" STRUCT(
"date_range" STRUCT(
"after_value" VARCHAR,
"before_value" VARCHAR
)
)
)
)
Show child fields
entity_type_filters.ami_product_filters

A filter for AMI products.

Show child fields
entity_type_filters.ami_product_filters.entity_id

Unique identifier for the AMI product.

Show child fields
entity_type_filters.ami_product_filters.entity_id.value_list[]
entity_type_filters.ami_product_filters.last_modified_date

The last date on which the AMI product was modified.

Show child fields
entity_type_filters.ami_product_filters.last_modified_date.date_range

Dates between which the AMI product was last modified.

Show child fields
entity_type_filters.ami_product_filters.last_modified_date.date_range.after_value

Date after which the AMI product was last modified.

entity_type_filters.ami_product_filters.last_modified_date.date_range.before_value

Date before which the AMI product was last modified.

entity_type_filters.ami_product_filters.product_title

The title of the AMI product.

Show child fields
entity_type_filters.ami_product_filters.product_title.value_list[]
entity_type_filters.ami_product_filters.product_title.wild_card_value

A string that will be the wildCard input for product tile filter. It matches the provided value as a substring in the actual value.

entity_type_filters.ami_product_filters.visibility

The visibility of the AMI product.

Show child fields
entity_type_filters.ami_product_filters.visibility.value_list[]
entity_type_filters.container_product_filters

A filter for container products.

Show child fields
entity_type_filters.container_product_filters.entity_id

Unique identifier for the container product.

Show child fields
entity_type_filters.container_product_filters.entity_id.value_list[]
entity_type_filters.container_product_filters.last_modified_date

The last date on which the container product was modified.

Show child fields
entity_type_filters.container_product_filters.last_modified_date.date_range

Dates between which the container product was last modified.

Show child fields
entity_type_filters.container_product_filters.last_modified_date.date_range.after_value

Date after which the container product was last modified.

entity_type_filters.container_product_filters.last_modified_date.date_range.before_value

Date before which the container product was last modified.

entity_type_filters.container_product_filters.product_title

The title of the container product.

Show child fields
entity_type_filters.container_product_filters.product_title.value_list[]
entity_type_filters.container_product_filters.product_title.wild_card_value

A string that will be the wildCard input for product tile filter. It matches the provided value as a substring in the actual value.

entity_type_filters.container_product_filters.visibility

The visibility of the container product.

Show child fields
entity_type_filters.container_product_filters.visibility.value_list[]
entity_type_filters.data_product_filters

A filter for data products.

Show child fields
entity_type_filters.data_product_filters.entity_id

Unique identifier for the data product.

Show child fields
entity_type_filters.data_product_filters.entity_id.value_list[]
entity_type_filters.data_product_filters.last_modified_date

The last date on which the data product was modified.

Show child fields
entity_type_filters.data_product_filters.last_modified_date.date_range

Dates between which the data product was last modified.

Show child fields
entity_type_filters.data_product_filters.last_modified_date.date_range.after_value

Date after which the data product was last modified.

entity_type_filters.data_product_filters.last_modified_date.date_range.before_value

Date before which the data product was last modified.

entity_type_filters.data_product_filters.product_title

The title of the data product.

Show child fields
entity_type_filters.data_product_filters.product_title.value_list[]
entity_type_filters.data_product_filters.product_title.wild_card_value

A string that will be the wildCard input for product tile filter. It matches the provided value as a substring in the actual value.

entity_type_filters.data_product_filters.visibility

The visibility of the data product.

Show child fields
entity_type_filters.data_product_filters.visibility.value_list[]
entity_type_filters.offer_filters

A filter for offers.

Show child fields
entity_type_filters.offer_filters.availability_end_date

Allows filtering on the AvailabilityEndDate of an offer.

Show child fields
entity_type_filters.offer_filters.availability_end_date.date_range

Allows filtering on the AvailabilityEndDate of an offer with date range as input.

Show child fields
entity_type_filters.offer_filters.availability_end_date.date_range.after_value

Allows filtering on the AvailabilityEndDate of an offer after a date.

entity_type_filters.offer_filters.availability_end_date.date_range.before_value

Allows filtering on the AvailabilityEndDate of an offer before a date.

entity_type_filters.offer_filters.buyer_accounts

Allows filtering on the BuyerAccounts of an offer.

Show child fields
entity_type_filters.offer_filters.buyer_accounts.wild_card_value

Allows filtering on the BuyerAccounts of an offer with wild card input.

entity_type_filters.offer_filters.entity_id

Allows filtering on EntityId of an offer.

Show child fields
entity_type_filters.offer_filters.entity_id.value_list[]
entity_type_filters.offer_filters.last_modified_date

Allows filtering on the LastModifiedDate of an offer.

Show child fields
entity_type_filters.offer_filters.last_modified_date.date_range

Allows filtering on the LastModifiedDate of an offer with date range as input.

Show child fields
entity_type_filters.offer_filters.last_modified_date.date_range.after_value

Allows filtering on the LastModifiedDate of an offer after a date.

entity_type_filters.offer_filters.last_modified_date.date_range.before_value

Allows filtering on the LastModifiedDate of an offer before a date.

entity_type_filters.offer_filters.name

Allows filtering on the Name of an offer.

Show child fields
entity_type_filters.offer_filters.name.value_list[]
entity_type_filters.offer_filters.name.wild_card_value

Allows filtering on the Name of an offer with wild card input.

entity_type_filters.offer_filters.product_id

Allows filtering on the ProductId of an offer.

Show child fields
entity_type_filters.offer_filters.product_id.value_list[]
entity_type_filters.offer_filters.release_date

Allows filtering on the ReleaseDate of an offer.

Show child fields
entity_type_filters.offer_filters.release_date.date_range

Allows filtering on the ReleaseDate of an offer with date range as input.

Show child fields
entity_type_filters.offer_filters.release_date.date_range.after_value

Allows filtering on the ReleaseDate of offers after a date.

entity_type_filters.offer_filters.release_date.date_range.before_value

Allows filtering on the ReleaseDate of offers before a date.

entity_type_filters.offer_filters.resale_authorization_id

Allows filtering on the ResaleAuthorizationId of an offer.

Not all offers have a ResaleAuthorizationId. The response will only include offers for which you have permissions.

Show child fields
entity_type_filters.offer_filters.resale_authorization_id.value_list[]
entity_type_filters.offer_filters.state

Allows filtering on the State of an offer.

Show child fields
entity_type_filters.offer_filters.state.value_list[]
entity_type_filters.offer_filters.targeting

Allows filtering on the Targeting of an offer.

Show child fields
entity_type_filters.offer_filters.targeting.value_list[]
entity_type_filters.resale_authorization_filters

A filter for Resale Authorizations.

Show child fields
entity_type_filters.resale_authorization_filters.availability_end_date

Allows filtering on the AvailabilityEndDate of a ResaleAuthorization.

Show child fields
entity_type_filters.resale_authorization_filters.availability_end_date.date_range

Allows filtering on AvailabilityEndDate of a ResaleAuthorization with date range as input

Show child fields
entity_type_filters.resale_authorization_filters.availability_end_date.date_range.after_value

Allows filtering on AvailabilityEndDate of a ResaleAuthorization after a date.

entity_type_filters.resale_authorization_filters.availability_end_date.date_range.before_value

Allows filtering on AvailabilityEndDate of a ResaleAuthorization before a date.

entity_type_filters.resale_authorization_filters.availability_end_date.value_list[]
entity_type_filters.resale_authorization_filters.created_date

Allows filtering on the CreatedDate of a ResaleAuthorization.

Show child fields
entity_type_filters.resale_authorization_filters.created_date.date_range

Allows filtering on CreatedDate of a ResaleAuthorization with date range as input.

Show child fields
entity_type_filters.resale_authorization_filters.created_date.date_range.after_value

Allows filtering on CreatedDate of a ResaleAuthorization after a date.

entity_type_filters.resale_authorization_filters.created_date.date_range.before_value

Allows filtering on CreatedDate of a ResaleAuthorization before a date.

entity_type_filters.resale_authorization_filters.created_date.value_list[]
entity_type_filters.resale_authorization_filters.entity_id

Allows filtering on the EntityId of a ResaleAuthorization.

Show child fields
entity_type_filters.resale_authorization_filters.entity_id.value_list[]
entity_type_filters.resale_authorization_filters.last_modified_date

Allows filtering on the LastModifiedDate of a ResaleAuthorization.

Show child fields
entity_type_filters.resale_authorization_filters.last_modified_date.date_range

Allows filtering on the LastModifiedDate of a ResaleAuthorization with date range as input.

Show child fields
entity_type_filters.resale_authorization_filters.last_modified_date.date_range.after_value

Allows filtering on the LastModifiedDate of a ResaleAuthorization after a date.

entity_type_filters.resale_authorization_filters.last_modified_date.date_range.before_value

Allows filtering on the LastModifiedDate of a ResaleAuthorization before a date.

entity_type_filters.resale_authorization_filters.manufacturer_account_id

Allows filtering on the ManufacturerAccountId of a ResaleAuthorization.

Show child fields
entity_type_filters.resale_authorization_filters.manufacturer_account_id.value_list[]
entity_type_filters.resale_authorization_filters.manufacturer_account_id.wild_card_value

Allows filtering on the ManufacturerAccountId of a ResaleAuthorization with wild card input.

entity_type_filters.resale_authorization_filters.manufacturer_legal_name

Allows filtering on the ManufacturerLegalName of a ResaleAuthorization.

Show child fields
entity_type_filters.resale_authorization_filters.manufacturer_legal_name.value_list[]
entity_type_filters.resale_authorization_filters.manufacturer_legal_name.wild_card_value

Allows filtering on the ManufacturerLegalName of a ResaleAuthorization with wild card input.

entity_type_filters.resale_authorization_filters.name

Allows filtering on the Name of a ResaleAuthorization.

Show child fields
entity_type_filters.resale_authorization_filters.name.value_list[]
entity_type_filters.resale_authorization_filters.name.wild_card_value

Allows filtering on the Name of a ResaleAuthorization with wild card input.

entity_type_filters.resale_authorization_filters.offer_extended_status

Allows filtering on the OfferExtendedStatus of a ResaleAuthorization.

Show child fields
entity_type_filters.resale_authorization_filters.offer_extended_status.value_list[]
entity_type_filters.resale_authorization_filters.product_id

Allows filtering on the ProductId of a ResaleAuthorization.

Show child fields
entity_type_filters.resale_authorization_filters.product_id.value_list[]
entity_type_filters.resale_authorization_filters.product_id.wild_card_value

Allows filtering on the ProductId of a ResaleAuthorization with wild card input.

entity_type_filters.resale_authorization_filters.product_name

Allows filtering on the ProductName of a ResaleAuthorization.

Show child fields
entity_type_filters.resale_authorization_filters.product_name.value_list[]
entity_type_filters.resale_authorization_filters.product_name.wild_card_value

Allows filtering on the ProductName of a ResaleAuthorization with wild card input.

entity_type_filters.resale_authorization_filters.reseller_account_id

Allows filtering on the ResellerAccountID of a ResaleAuthorization.

Show child fields
entity_type_filters.resale_authorization_filters.reseller_account_id.value_list[]
entity_type_filters.resale_authorization_filters.reseller_account_id.wild_card_value

Allows filtering on the ResellerAccountID of a ResaleAuthorization with wild card input.

entity_type_filters.resale_authorization_filters.reseller_legal_name

Allows filtering on the ResellerLegalName of a ResaleAuthorization.

Show child fields
entity_type_filters.resale_authorization_filters.reseller_legal_name.value_list[]
entity_type_filters.resale_authorization_filters.reseller_legal_name.wild_card_value

Allows filtering on the ResellerLegalName of a ResaleAuthorization with wild card input.

entity_type_filters.resale_authorization_filters.status

Allows filtering on the Status of a ResaleAuthorization.

Show child fields
entity_type_filters.resale_authorization_filters.status.value_list[]
entity_type_filters.saa_s_product_filters

A filter for SaaS products.

Show child fields
entity_type_filters.saa_s_product_filters.entity_id

Unique identifier for the SaaS product.

Show child fields
entity_type_filters.saa_s_product_filters.entity_id.value_list[]
entity_type_filters.saa_s_product_filters.last_modified_date

The last date on which the SaaS product was modified.

Show child fields
entity_type_filters.saa_s_product_filters.last_modified_date.date_range

Dates between which the SaaS product was last modified.

Show child fields
entity_type_filters.saa_s_product_filters.last_modified_date.date_range.after_value

Date after which the SaaS product was last modified.

entity_type_filters.saa_s_product_filters.last_modified_date.date_range.before_value

Date before which the SaaS product was last modified.

entity_type_filters.saa_s_product_filters.product_title

The title of the SaaS product.

Show child fields
entity_type_filters.saa_s_product_filters.product_title.value_list[]
entity_type_filters.saa_s_product_filters.product_title.wild_card_value

A string that will be the wildCard input for product tile filter. It matches the provided value as a substring in the actual value.

entity_type_filters.saa_s_product_filters.visibility

The visibility of the SaaS product.

Show child fields
entity_type_filters.saa_s_product_filters.visibility.value_list[]
entity_type_sort Input Column

A Union object containing Sort shapes for all EntityTypes. Each EntityTypeSort shape will have SortBy and SortOrder applicable for fields on that EntityType. This can be used to sort the results of the filter query.

STRUCT(
"data_product_sort" STRUCT(
"sort_by" VARCHAR,
"sort_order" VARCHAR
),
"saa_s_product_sort" STRUCT(
"sort_by" VARCHAR,
"sort_order" VARCHAR
),
"ami_product_sort" STRUCT(
"sort_by" VARCHAR,
"sort_order" VARCHAR
),
"offer_sort" STRUCT(
"sort_by" VARCHAR,
"sort_order" VARCHAR
),
"container_product_sort" STRUCT(
"sort_by" VARCHAR,
"sort_order" VARCHAR
),
"resale_authorization_sort" STRUCT(
"sort_by" VARCHAR,
"sort_order" VARCHAR
)
)
Show child fields
entity_type_sort.ami_product_sort

A sort for AMI products.

Show child fields
entity_type_sort.ami_product_sort.sort_by

Field to sort the AMI products by.

entity_type_sort.ami_product_sort.sort_order

The sorting order. Can be ASCENDING or DESCENDING. The default value is DESCENDING.

entity_type_sort.container_product_sort

A sort for container products.

Show child fields
entity_type_sort.container_product_sort.sort_by

Field to sort the container products by.

entity_type_sort.container_product_sort.sort_order

The sorting order. Can be ASCENDING or DESCENDING. The default value is DESCENDING.

entity_type_sort.data_product_sort

A sort for data products.

Show child fields
entity_type_sort.data_product_sort.sort_by

Field to sort the data products by.

entity_type_sort.data_product_sort.sort_order

The sorting order. Can be ASCENDING or DESCENDING. The default value is DESCENDING.

entity_type_sort.offer_sort

A sort for offers.

Show child fields
entity_type_sort.offer_sort.sort_by

Allows to sort offers.

entity_type_sort.offer_sort.sort_order

Allows to sort offers.

entity_type_sort.resale_authorization_sort

A sort for Resale Authorizations.

Show child fields
entity_type_sort.resale_authorization_sort.sort_by

Allows to sort ResaleAuthorization.

entity_type_sort.resale_authorization_sort.sort_order

Allows to sort ResaleAuthorization.

entity_type_sort.saa_s_product_sort

A sort for SaaS products.

Show child fields
entity_type_sort.saa_s_product_sort.sort_by

Field to sort the SaaS products by.

entity_type_sort.saa_s_product_sort.sort_order

The sorting order. Can be ASCENDING or DESCENDING. The default value is DESCENDING.

filter_list Input Column

An array of filter objects. Each filter object contains two attributes, filterName and filterValues.

STRUCT(
"name" VARCHAR,
"value_list" VARCHAR[]
)[]
Show child fields
filter_list[]
Show child fields
filter_list[].name

For ListEntities, the supported value for this is an EntityId.

For ListChangeSets, the supported values are as follows:

filter_list[].value_list[]
ownership_type Input Column

Filters the returned set of entities based on their owner. The default is SELF. To list entities shared with you through AWS Resource Access Manager (AWS RAM), set to SHARED. Entities shared through the AWS Marketplace Catalog API PutResourcePolicy operation can't be discovered through the SHARED parameter.

VARCHAR
sort Input Column

An object that contains two attributes, SortBy and SortOrder.

STRUCT(
"sort_by" VARCHAR,
"sort_order" VARCHAR
)
Show child fields
sort.sort_by

For ListEntities, supported attributes include LastModifiedDate (default) and EntityId. In addition to LastModifiedDate and EntityId, each EntityType might support additional fields.

For ListChangeSets, supported attributes include StartTime and EndTime.

sort.sort_order

The sorting order. Can be ASCENDING or DESCENDING. The default value is DESCENDING.

_aws_profile Input Column

The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role.

STRUCT(
"type" VARCHAR,
"name" VARCHAR,
"account_id" VARCHAR,
"via_profile_name" VARCHAR,
"assumed_role_arn" VARCHAR,
"organization" STRUCT(
"account_name" VARCHAR,
"id" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[],
"master_account" STRUCT(
"id" VARCHAR,
"email" VARCHAR
),
"parents" STRUCT(
"type" VARCHAR,
"id" VARCHAR,
"name" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[]
)[]
)
)
Show child fields
_aws_profile.account_id

The AWS account id

_aws_profile.assumed_role_arn

The ARN of the assumed role

_aws_profile.name

The unique name of the profile.

_aws_profile.organization

Information about this profile's membership in the AWS organization.

Show child fields
_aws_profile.organization.account_name

The name of account speciifed by the organization

_aws_profile.organization.id

The organization id

_aws_profile.organization.master_account
Show child fields
_aws_profile.organization.master_account.email

The organization master account email address

_aws_profile.organization.master_account.id

The organization master account id

_aws_profile.organization.parents[]
Show child fields
_aws_profile.organization.parents[].id

The id of the parent

_aws_profile.organization.parents[].name

The name of the parent

_aws_profile.organization.parents[].tags[]
Show child fields
_aws_profile.organization.parents[].tags[].key
_aws_profile.organization.parents[].tags[].value
_aws_profile.organization.parents[].type

The type of parent can be an organization unit or a root

_aws_profile.organization.tags[]
Show child fields
_aws_profile.organization.tags[].key
_aws_profile.organization.tags[].value
_aws_profile.type

The type of profile, either 'credentials' or 'assumed_role'

_aws_profile.via_profile_name

This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.

ami_product_summary

An object that contains summary information about the AMI product.

STRUCT(
"product_title" VARCHAR,
"visibility" VARCHAR
)
Show child fields
ami_product_summary.product_title

The title of the AMI product.

ami_product_summary.visibility

The lifecycle of the AMI product.

container_product_summary

An object that contains summary information about the container product.

STRUCT(
"product_title" VARCHAR,
"visibility" VARCHAR
)
Show child fields
container_product_summary.product_title

The title of the container product.

container_product_summary.visibility

The lifecycle of the product.

data_product_summary

An object that contains summary information about the data product.

STRUCT(
"product_title" VARCHAR,
"visibility" VARCHAR
)
Show child fields
data_product_summary.product_title

The title of the data product.

data_product_summary.visibility

The lifecycle of the data product.

entity_arn

The ARN associated with the unique identifier for the entity.

VARCHAR
entity_id

The unique identifier for the entity.

VARCHAR
last_modified_date

The last time the entity was published, using ISO 8601 format (2018-02-27T13:45:22Z).

VARCHAR
name

The name for the entity. This value is not unique. It is defined by the seller.

VARCHAR
offer_summary

An object that contains summary information about the offer.

STRUCT(
"name" VARCHAR,
"product_id" VARCHAR,
"resale_authorization_id" VARCHAR,
"release_date" VARCHAR,
"availability_end_date" VARCHAR,
"buyer_accounts" VARCHAR[],
"state" VARCHAR,
"targeting" VARCHAR[]
)
Show child fields
offer_summary.availability_end_date

The availability end date of the offer.

offer_summary.buyer_accounts[]
offer_summary.name

The name of the offer.

offer_summary.product_id

The product ID of the offer.

offer_summary.release_date

The release date of the offer.

offer_summary.resale_authorization_id

The ResaleAuthorizationId of the offer.

offer_summary.state

The status of the offer.

offer_summary.targeting[]
resale_authorization_summary

An object that contains summary information about the Resale Authorization.

STRUCT(
"name" VARCHAR,
"product_id" VARCHAR,
"product_name" VARCHAR,
"manufacturer_account_id" VARCHAR,
"manufacturer_legal_name" VARCHAR,
"reseller_account_id" VARCHAR,
"reseller_legal_name" VARCHAR,
"status" VARCHAR,
"offer_extended_status" VARCHAR,
"created_date" VARCHAR,
"availability_end_date" VARCHAR
)
Show child fields
resale_authorization_summary.availability_end_date

The availability end date of the ResaleAuthorization.

resale_authorization_summary.created_date

The created date of the ResaleAuthorization.

resale_authorization_summary.manufacturer_account_id

The manufacturer account ID of the ResaleAuthorization.

resale_authorization_summary.manufacturer_legal_name

The manufacturer legal name of the ResaleAuthorization.

resale_authorization_summary.name

The name of the ResaleAuthorization.

resale_authorization_summary.offer_extended_status

The offer extended status of the ResaleAuthorization

resale_authorization_summary.product_id

The product ID of the ResaleAuthorization.

resale_authorization_summary.product_name

The product name of the ResaleAuthorization.

resale_authorization_summary.reseller_account_id

The reseller account ID of the ResaleAuthorization.

resale_authorization_summary.reseller_legal_name

The reseller legal name of the ResaleAuthorization

resale_authorization_summary.status

The status of the ResaleAuthorization.

saa_s_product_summary

An object that contains summary information about the SaaS product.

STRUCT(
"product_title" VARCHAR,
"visibility" VARCHAR
)
Show child fields
saa_s_product_summary.product_title

The title of the SaaS product.

saa_s_product_summary.visibility

The lifecycle of the SaaS product.

visibility

The visibility status of the entity to buyers. This value can be Public (everyone can view the entity), Limited (the entity is visible to limited accounts only), or Restricted (the entity was published and then unpublished and only existing buyers can view it).

VARCHAR