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
;