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

Last updated