AfterShip is an automated shipment tracking solution that helps eCommerce businesses track their online shipments and keep their customers updated on the status of their deliveries from their online shops. AfterShip supports a wide variety of shipping services worldwide, provides users with a dashboard to check the status of shipments across multiple carriers, and sends out emails and notifications automatically at different shipment stages.
Data integration: Skyvia supports importing data to and from AfterShip, exporting AfterShip data to CSV files, replicating AfterShip data to relational databases, and synchronizing AfterShip data with other cloud apps and relational databases.
Backup: Skyvia Backup does not support AfterShip backup.
Query: Skyvia Query supports AfterShip.
To create a connection to AfterShip, you need to specify your API Key. API Key is a REST API key used for connecting to AfterShip. You can manage an API key in the AfterShip interface, more details are available below.
To get your API Key for AfterShip REST API, perform the following steps:
- Sign in to AfterShip.
Click Settings in the menu on the left.
- Select API keys.
Copy your API key.
Paste the obtained API key to the API Key field in the connection editor.
Use the Test Connection button to make sure that the connection is successful and then click Create Connection.
The Notifications table records are uniquely identified by the TrackingID field, the Trackings table foreign key. Thus, when importing data to the Notifications table, the TrackingId is required for mapping.
Emails and SMSes fields in the Notifications table are the arrays. When importing data to these fields, you must map their values in an array format.
The INSERT operation against the Emails and SMSes fields of the Notifications table adds new values to the existing arrays.
For example, there is a Trackings record with the related record in the Notifications object, where the Emails = [“[email protected]”]. You add two more values “[email protected]” and “[email protected]” to the array. To do this, you must specify the Emails value in the following format: [“[email protected]”,”[email protected]”]. As a result, the Emails field will look like: [“[email protected]”,”[email protected]”,”[email protected]”].
The UPDATE operation is used when you want to delete the values from the Emails or SMSes fields.
For example, there is a Trackings record in the Notifications object, where the Emails = [“[email protected]”,”[email protected]”,”[email protected]”]. You remove only one value “[email protected]” and leave the other two as is. To do this, you must specify the Emails value in the following format: [“[email protected]”]. As a result, the Emails field will look like: [“[email protected]”,”[email protected]”].
Incremental Replication and Synchronization
Synchronization and Replication with Incremental Updates are supported only for the Trackings object.
|INSERT, UPDATE, DELETE||Trackings|
Supported Actions and Actions Specifics
Skyvia supports all the common actions for Aftership.