Aftership Tables
The provider models the data in API into a list of tables that can be queried using standard SQL statements.
Generally, querying API tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.
Aftership Tables
| Name | Description |
| AllCouriers | Return a list of all couriers. |
| LastCheckpoint | Get tracking information of the last checkpoint of a tracking |
| MyCouriers | Return a list of couriers activated at your AfterShip account. |
| Notifications | Get contacts (sms or email) to be notified when the status of a tracking has changed. |
| Trackings | Get the tracking details of the shipment. |