Schema Information of Aftership V2 Connector
This subtopic provides a structured reference to assist you in working with Daton's Aftership V2 connector and the associated fields and tables.
Schema Information of Aftership V2 Connector
This subtopic provides a structured reference to assist you in working with Daton's Aftership V2 connector and the associated fields and tables.
Tables/APIs
The following is the list of tables or APIs associated with the Aftership V2 connector:
- Couriers
- User Activatied Couriers
- Trackings
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 |
