Skip to main content

phone_number_orders

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

Overview

Namephone_number_orders
TypeResource
Idaws.chime.phone_number_orders

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
created_timestampstring (date-time)The phone number order creation time stamp, in ISO 8601 format.
ordered_phone_numbersarrayThe ordered phone number details, such as the phone number in E.164 format and the phone number status.
phone_number_order_idstringThe phone number order ID. (pattern: <code>[a-fA-F0-9]{8}(?:-[a-fA-F0-9]{4}){3}-[a-fA-F0-9]{12}</code>)
product_typestringThe phone number order product type. (BusinessCalling, VoiceConnector, SipMediaApplicationDialIn)
statusstringThe status of the phone number order. (Processing, Successful, Failed, Partial)
updated_timestampstring (date-time)The updated phone number order time stamp, in ISO 8601 format.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_phone_number_orderselectphone_number_order_id, regionRetrieves details for the specified phone number order, such as the order creation timestamp, phone numbers in E.164 format, product type, and order status.
list_phone_number_ordersselectregionnext-token, max-resultsLists the phone number orders for the administrator's Amazon Chime account.
create_phone_number_orderinsertregion, ProductType, E164PhoneNumbersCreates an order for phone numbers to be provisioned. For toll-free numbers, you cannot use the Amazon Chime Business Calling product type. For numbers outside the U.S., you must use the Amazon Chime SIP Media Application Dial-In product type.

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
phone_number_order_idstringThe ID for the phone number order.
regionstringAWS region (default: us-east-1)
max-resultsintegerThe maximum number of results to return in a single call.
next-tokenstringThe token to use to retrieve the next page of results.

SELECT examples

Retrieves details for the specified phone number order, such as the order creation timestamp, phone numbers in E.164 format, product type, and order status.

SELECT
created_timestamp,
ordered_phone_numbers,
phone_number_order_id,
product_type,
status,
updated_timestamp
FROM aws.chime.phone_number_orders
WHERE phone_number_order_id = '{{ phone_number_order_id }}' -- required
AND region = '{{ region }}' -- required
;

INSERT examples

Creates an order for phone numbers to be provisioned. For toll-free numbers, you cannot use the Amazon Chime Business Calling product type. For numbers outside the U.S., you must use the Amazon Chime SIP Media Application Dial-In product type.

INSERT INTO aws.chime.phone_number_orders (
ProductType,
E164PhoneNumbers,
region
)
SELECT
'{{ ProductType }}' /* required */,
'{{ E164PhoneNumbers }}' /* required */,
'{{ region }}'
RETURNING
phone_number_order
;