Aftership
Aftership is a shipment tracking application and API for eCommerce retailers and buyers.
Aftership integration replicates data using the Aftership Tracking, Returns and Shipping API.
レプリケーションに利用可能なオブジェクトのリストについては、 [スキーマ] セクションを参照してください。Preparing for authentication
To access your data, you need to authenticate the connection with your account credentials.
To create your API key:
- Log into your Aftership account.
- Navigate to Developers > API keys > Create API key.
- Enter the following information:
- Name: Enter a name for your API key.
- Signature Header: Select API key.
- API permissions: Select Read permission for all scopes, except for Tracking - Estimated delivery dates, where only Write permission is available.
- Click Save.
- Copy and paste your API key into a secured file.
Creating the connection
詳細については、「SaaSアプリケーションへの接続」を参照してください。
- 必要な接続プロパティを入力します。
接続名に接続の名前を入力します。
接続メタデータを開くを選択して、作成時の接続のメタデータを定義します。
[作成] をクリックします。
| Setting | Description |
|---|---|
| Data gateway | ユース ケースに応じて Data Movement gateway を選択します。 情報メモ Qlik Talend Cloud スターター サブスクリプションでは Data Movement gateway をサポートしていないため、この項目は使用できません。別のサブスクリプション ティアを利用しており、Data Movement gateway を使用しない場合は、 [None] (なし) を選択します。 Data Movement gateway の利点とそれを必要とするユース ケースの詳細については、「Qlik データ ゲートウェイ - データ移動」を参照してください。 |
| Start Date | ソースからターゲットにデータをレプリケートする必要がある日付を |
| API Key | API key. |
Schema
Depending on your destination, table and column names may not appear as they are outlined below.
Replication of all tables and objects requires an Aftership Pro—or higher—subscription.
trackings
Replication Method | CDC |
Primary Key | id |
| Useful links |
couriers
Replication Method | Full Table |
Primary Key | id |
| Useful links |
courier_connections
Replication Method | CDC |
Primary Key | id |
| Useful links |
item_returns
Replication Method | Full Table |
Primary Key | id |
| Useful links |
item_tags
Replication Method | CDC |
Primary Key | id |
| Useful links |
query_claims
Replication Method | CDC |
Primary Key | id |
| Useful links |
query_coverages
Replication Method | CDC |
Primary Key | id |
| Useful links |
stores
Replication Method | CDC |
Primary Key | id |
| Useful links |
orders
Replication Method | CDC |
Primary Key | id |
| Useful links |
products
Replication Method | Full Table |
Primary Key | id |
| Useful links |
fulfillments
Replication Method | CDC |
Primary Key | id |
| Useful links |
memberships
Replication Method | Full Table |
Primary Key | id |
| Useful links |
roles
Replication Method | Full Table |
Primary Key | code |
| Useful links |
shipping_rates
Replication Method | CDC |
Primary Key | id |
| Useful links |
shipping_labels
Replication Method | CDC |
Primary Key | id |
| Useful links |
shipping_manifests
Replication Method | CDC |
Primary Key | id |
| Useful links |
shipping_couriers
Replication Method | Full Table |
Primary Key | slug |
| Useful links |
cancel_labels
Replication Method | CDC |
Primary Key | id |
| Useful links |
pickups
Replication Method | CDC |
Primary Key | id |
| Useful links |
cancel_pickups
Replication Method | CDC |
Primary Key | id |
| Useful links |
shipper_accounts
Replication Method | CDC |
Primary Key | id |
| Useful links |
locations
Replication Method | Full Table |
Primary Key | location_id |
| Useful links |