Skip to main content

portal_products

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

Overview

Nameportal_products
TypeResource
Idaws.apigatewayv2.portal_products

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
descriptionstringThe description of a portal product.
display_namestringThe display name.
display_orderobjectThe display order.
last_modifiedstring (date-time)The timestamp when the portal product was last modified.
portal_product_arnstringThe ARN of the portal product.
portal_product_idstringThe portal product identifier. (pattern: <code>^[a-z0-9]+$</code>)
tagsobjectThe collection of tags. Each tag element is associated with a given resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_portal_productselectportal_product_id, regionresourceOwnerAccountIdGets a portal product.
list_portal_productsselectregionmaxResults, nextToken, resourceOwnerLists portal products.
create_portal_productinsertregion, DisplayNameCreates a new portal product.
update_portal_productupdateportal_product_id, regionUpdates the portal product.
delete_portal_productdeleteportal_product_id, regionDeletes a portal product.

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
portal_product_idstringThe portal product identifier.
regionstringAWS region (default: us-east-1)
maxResultsstringThe maximum number of elements to be returned for this resource.
nextTokenstringThe next page of elements from this collection. Not valid for the last element of the collection.
resourceOwnerstringThe resource owner of the portal product.
resourceOwnerAccountIdstringThe account ID of the resource owner of the portal product.

SELECT examples

Gets a portal product.

SELECT
description,
display_name,
display_order,
last_modified,
portal_product_arn,
portal_product_id,
tags
FROM aws.apigatewayv2.portal_products
WHERE portal_product_id = '{{ portal_product_id }}' -- required
AND region = '{{ region }}' -- required
AND resourceOwnerAccountId = '{{ resourceOwnerAccountId }}'
;

INSERT examples

Creates a new portal product.

INSERT INTO aws.apigatewayv2.portal_products (
Description,
DisplayName,
Tags,
region
)
SELECT
'{{ Description }}',
'{{ DisplayName }}' /* required */,
'{{ Tags }}',
'{{ region }}'
RETURNING
description,
display_name,
display_order,
last_modified,
portal_product_arn,
portal_product_id,
tags
;

UPDATE examples

Updates the portal product.

UPDATE aws.apigatewayv2.portal_products
SET
Description = '{{ Description }}',
DisplayName = '{{ DisplayName }}',
DisplayOrder = '{{ DisplayOrder }}'
WHERE
portal_product_id = '{{ portal_product_id }}' --required
AND region = '{{ region }}' --required
RETURNING
description,
display_name,
display_order,
last_modified,
portal_product_arn,
portal_product_id,
tags;

DELETE examples

Deletes a portal product.

DELETE FROM aws.apigatewayv2.portal_products
WHERE portal_product_id = '{{ portal_product_id }}' --required
AND region = '{{ region }}' --required
;