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.

Need help with something?

Talk to data expert

This subtopic provides a structured reference to assist you in working with Daton's Aftership V2 connector and the associated fields and tables.

The following is the list of tables or APIs associated with the Aftership V2 connector:

Couriers

Purpose: Return a list of all couriers.

Replication: Full Replication

Replication Key: NA

Fields

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

Replication: Full Replication

Replication Key: NA

Fields