How to Setup AfterShip Integration

This integration will allow you to connect with AfterShip and start collecting your data. It is a matter of minutes to send your shipments data to feed your BI, your data warehouse, or your custom analytics stack.

Here are the steps involved:

  1. Connecting AfterShip
  2. Set the Replication Frequency
  3. Load your AfterShip data into your data warehouse
  4. AfterShip expected Data Model and schema

Getting Started – Setup AfterShip integration at Blendo

1. To add this integration, go to Blendo dashboard. Click Add a Source and click on AfterShip.

 

Connect AfterShip as data sourceIn the next screen, you will need to type your AfterShip API key.

Settings you need from AfterShip

We will need the API Key from AfterShip.

2. Login to your AfterShip account from a new tab.

3. Click on the gear icon (Settings menu) in the left sidebar.

aftership integration

4. Click on API (a). Copy Your API Key (b) or generate a new one (c,d)

AfterShip integration

5. Paste the API key into the relevant box provided in Blendo and click Validate & Save.

6. Then you will return back to the home dashboard. Click on your new AfterShip data source.

 

Set the Replication Frequency

7. If you want to change the replication schedule go to the Schedule section and click on Reschedule.

 

8. In the next pop-up select one of the options available and click Apply.

Load your AfterShip data into your data warehouse

Here is how to start loading your AfterShip data into your data warehouse:

Import your AfterShip data into your data warehouse - Blendo.co

AfterShip Data Model & Schema Information

Blendo will now connect to your AfterShip data source. It will sync your historical data and all the future updates into your destination data warehouse. You will get analytics ready tables and syncs that make sure you will get recent and consistent data.

Let’s see:

  1. How Blendo syncs AfterShip data
  2. The tables with AfterShip data that we create in your destination data warehouse

How Blendo syncs AfterShip data

Historical Data

When Blendo first connects to AfterShip Data source, will pull all your historical data.

Sync Schedule

Blendo syncs AfterShip data based on the schedule and frequency you choose. The default setting is every 1 hour but is configurable from inside the app.

Replication Process

The first time Blendo syncs your AfterShip data performs a full replication. Then your AfterShip data is replicated incrementally. Note that Blendo will only read your data.

After you finish the integration with AfterShip, you might see its status as Importing from source, Exporting to the destination, or Completed.

What AfterShip data do I have available?

Blendo creates analytics ready tables with recent and consistent data. Bellow is a diagram of the schema and you may also find a CSV with all the columns and fields in more detail.

AfterShip Resource Blendo Table Name Description
Couriers couriers Get a list of our supported couriers.
Trackings Checkpoints trackings_checkpoints Get tracking information of the last checkpoint of a tracking.
Trackings trackings Create trackings, update trackings, and get tracking results.

Custom Fields

Blendo will create a column for any of your custom fields and will sync it accordignly.

Expected AfterShip Data Model & Schema Information >>

AfterShip Data Model & Schema

Questions? Contact us!

in Connecting SaaS Data Sources