Skip to main content

address_list_import_jobs

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

Overview

Nameaddress_list_import_jobs
TypeResource
Idaws.mailmanager.address_list_import_jobs

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
address_list_idstringThe unique identifier of the address list the import job was created for. (pattern: <code>[a-zA-Z0-9-]+</code>)
completed_timestampstring (date-time)The timestamp of when the import job was completed.
created_timestampstring (date-time)The timestamp of when the import job was created.
errorstringThe reason for failure of an import job.
failed_items_countintegerThe number of input addresses that failed to be imported into the address list.
import_data_formatobjectThe format of the input for an import job.
imported_items_countintegerThe number of input addresses successfully imported into the address list.
job_idstringThe identifier of the import job. (pattern: <code>[a-zA-Z0-9-]+</code>)
namestringA user-friendly name for the import job. (pattern: <code>[a-zA-Z0-9_.-]+</code>)
pre_signed_urlstringThe pre-signed URL target for uploading the input file.
start_timestampstring (date-time)The timestamp of when the import job was started.
statusstringThe status of the import job. (CREATED, PROCESSING, COMPLETED, FAILED, STOPPED)

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_address_list_import_jobselectregionFetch attributes of an import job.
list_address_list_import_jobsselectregionLists jobs for an address list.
create_address_list_import_jobinsertregion, AddressListId, ImportDataFormatCreates an import job for an address list.

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

Fetch attributes of an import job.

SELECT
address_list_id,
completed_timestamp,
created_timestamp,
error,
failed_items_count,
import_data_format,
imported_items_count,
job_id,
name,
pre_signed_url,
start_timestamp,
status
FROM aws.mailmanager.address_list_import_jobs
WHERE region = '{{ region }}' -- required
;

INSERT examples

Creates an import job for an address list.

INSERT INTO aws.mailmanager.address_list_import_jobs (
ClientToken,
AddressListId,
Name,
ImportDataFormat,
region
)
SELECT
'{{ ClientToken }}',
'{{ AddressListId }}' /* required */,
'{{ Name }}',
'{{ ImportDataFormat }}' /* required */,
'{{ region }}'
RETURNING
job_id,
pre_signed_url
;