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
Signin to Daton
Select Aftership from Integrations page
Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later
Provide your Aftership API Key.
After providing the API Key Daton will periodically extract data from Aftership.
Post successful authentication you will be prompted to choose from the list of available tables
Then select all required fields for each table
Submit the integration.
Workflow
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
Users would be able to edit/pause/re-activate/delete integration anytime
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
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
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
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 updated