Aftership V2
Aftership ETL connector for data replication
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 | |
- 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.
- 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
Couriers
Purpose: Return a list of 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
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 |
Last modified 6mo ago