Aftership V2

Aftership ETL connector for data replication

Snapshot

Features	Details
Release Status	Released
Source API Version	v4
Table Selection	Yes
Column Selection	Yes
Edit Integration	Yes
Replication Type Selection	No
Authentication Parameters	Aftership API Key
Replication Type	Key based Replication
Replication Key	DATE
Suggested Replication Frequency	24 hrs

Tables/APIs Supported
Couriers	Trackings
User Activatied Couriers

Integrate Aftership with Daton

1. Signin to Daton

2. Select Aftership from Integrations page

3. Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later

4. Provide your Aftership API Key.

5. After providing the API Key Daton will periodically extract data from Aftership.

6. Post successful authentication you will be prompted to choose from the list of available tables

7. Then select all required fields for each table

8. Submit the integration.

Workflow

1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse

2. Users would be able to edit/pause/re-activate/delete integration anytime

3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

Aftership Data

Couriers

Purpose: Return a list of all couriers.

Source API Documentation https://www.aftership.com/docs/tracking/81c69333e60c8-get-all-couriers

Replication: Full Replication

Replication Key: NA

Fields

NAME	DATA TYPE
slug	STRING
name	STRING
other_name	STRING
web_url	STRING
default_language	STRING
support_languages	STRING
service_from_country_iso3	STRING
phone	STRING
required_fields	STRING
optional_fields	STRING

Trackings

Purpose: Get tracking results of multiple trackings

Source API Documentation https://www.aftership.com/docs/tracking/ce171c8e31139-get-trackings

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

fullname	type
id	STRING
created_at	TIMESTAMP
updated_at	TIMESTAMP
last_updated_at	TIMESTAMP
tracking_number	STRING
slug	STRING
active	BOOLEAN
custom_fields	RECORD
customer_name	STRING
delivery_time	NUMERIC
destination_country_iso3	STRING
emails	STRING
note	STRING
order_id	STRING
order_date	TIMESTAMP
smses	STRING
source	STRING
tag	STRING
subtag	STRING
subtag_message	STRING
title	STRING
tracked_count	NUMERIC
unique_token	STRING
return_to_sender	BOOLEAN
courier_tracking_link	STRING
courier_redirect_link	STRING
order_tags	STRING
order_number	STRING
destination_raw_location	STRING
tracking_destination_country	STRING
tracking_postal_code	STRING
tracking_ship_date	DATE
checkpoints	RECORD
latest_estimated_delivery	RECORD
courier_destination_country_iso3	STRING
expected_delivery	TIMESTAMP
origin_country_iso3	STRING
shipment_pickup_date	TIMESTAMP
shipment_delivery_date	TIMESTAMP
shipment_weight	NUMERIC
shipment_weight_unit	STRING
last_mile_tracking_supported	BOOLEAN
first_attempted_at	TIMESTAMP
language	STRING
pickup_location	STRING
next_couriers	RECORD
shipment_pickup_date_dtm	DATETIME
shipment_delivery_date_dtm	DATETIME
first_attempted_at_dtm	DATETIME
shipment_type	STRING
signed_by	STRING
shipment_package_count	NUMERIC
expected_delivery_dtm	DATETIME

User Activated Couriers

Purpose: Return a list of couriers activated at your aftership account

Source API Documentation https://www.aftership.com/docs/tracking/9cb8459b228a9-get-user-activated-couriers

Replication: Full Replication

Replication Key: NA

Fields

fullname	type
slug	STRING
name	STRING
phone	STRING
other_name	STRING
web_url	STRING
optional_fields	STRING
default_language	STRING
support_languages	STRING
service_from_country_iso3	STRING