LabelTracking
Returns tracking information for the specified label.
View-Specific Information
Select
The add-in will use the ShipStation API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the add-in.
- LabelId supports the following operator: =.
SELECT * FROM LabelTracking WHERE LabelId = 'se-2345'
Columns
| Name | Type | References | Description |
| LabelId [KEY] | String | A string that uniquely identifies the label. | |
| TrackingNumber | String | A tracking number for a package. The format depends on the carrier. | |
| TrackingUrl | String | The carrier tracking URL, if available. | |
| StatusCode | String | The high-level tracking status codes.
The allowed values are UN, AC, IT, DE, EX, AT, NY, SP. | |
| StatusDetailCode | String | The tracking status detail codes.
The allowed values are COLLECTION_FAILED, AWAITING_DESPATCH, COLLECTION_REQUESTED, DESPATCHED, ELEC_ADVICE_RECD_BY_CARRIER, NOT_YET_RECEIVED_BY_CARRIER, COLLECTION_MADE, ATTEMPTED_DELIVERY, ATTEMPTED_DELIVERY_2ND, ATTEMPTED_DELIVERY_3RD, COD_AMOUNT_NOT_PAID, COD_AMOUNT_PAID, CUSTOMER_CARDED, CUSTOMER_IDENTIFICATION_FAILED, INVALID_METHOD_OF_PAYMENT, NO_ACCESS_TO_RECIPIENTS_ADDRESS, OUT_FOR_DELIVERY, DELIVERED, DELIVERED_DAMAGED, DELIVERED_IN_PART, DELIVERED_SPECIFIED_SAFE_PLACE, DELIVERED_TO_ALTERNATIVE_DELIVERY_LOCATION, DELIVERED_TO_NEIGHBOUR, DELIVERED_TO_PO_BOX, PARCEL_COLLECTED_FROM_PICKUP_POINT, POST_TRANSIT_STATUS, PROOF_OF_DELIVERY, CANCELLED, CANCELLED_BEFORE_DESPATCH, CUSTOMER_MOVED, HAZARDOUS_PROHIBITED, NOT_COLLECTED_FROM_PICKUP_POINT, NOT_DELIVERED, NOT_DELIVERED_ADDRESSEE_DECEASED, PARCEL_DAMAGED, PARCEL_DISPOSED, PARCEL_LOST, PARCEL_OUTSIDE_OF_SERVICE_CAPABILITY, REFUSED_BY_CUSTOMER, RETURN_TO_SENDER, ADDRESS_QUERY, CARRIER_DELAYS, CUSTOMS_CLEARED, CUSTOMS_PROCESSING, DELAYED_NOT_CARRIER, DELIVERY_ARRANGED_WITH_RECIPIENT, HELD_BY_CARRIER, HELD_BY_CARRIER_FOR_CLEARANCE_PRE_PROCESSING, HELD_BY_CUSTOMS, HELD_BY_EXPORT_CUSTOMS, HELD_BY_IMPORT_CUSTOMS, HUB_SCAN_OUT, IN_TRANSIT, INCORRECT_DECLARATION, INFORMATION, MISSORTED, PARCEL_OVER_LABELLED, PARCEL_REPACKED, PARCEL_UPDATE_NOTIFICATION_VIA_EMAIL, PARCEL_UPDATE_NOTIFICATION_VIA_SMS, RECEIVED_BY_CARRIER, RECEIVED_LOCAL_DELIVERY_DEPOT, ROUTING_ERROR, SUB_CONTRACTOR_EVENT, SUB_CONTRACTOR_RECEIVED, RECD_BY_CARRIER_NO_ELEC_ADVICE, AWAITING_ELECTRONIC_ADVICE, AWAITING_COLLECTION_FROM_PICKUP_POINT, COLLECT_AT_LOCAL_PO, CUSTOMER_TO_COLLECT_FROM_CARRIER, DELIVERED_TO_LOCKER_COLLECTION_POINT, CARRIER_STATUS_NOT_MAPPED. | |
| CarrierCode | String | A shipping carrier, such as fedex, dhl_express, stamps_com, etc. | |
| CarrierId | String |
Carriers.Id | The unique Id of the carrier account that was used to create this label. |
| StatusDescription | String | The tracking status description. | |
| StatusDetailDescription | String | The detailed tracking status description. | |
| CarrierStatusCode | String | The carrier-specific status code. | |
| CarrierDetailCode | String | The carrier-specific detail code. | |
| CarrierStatusDescription | String | The carrier-specific status description. | |
| ShipDate | Datetime | The date the label was shipped. | |
| EstimatedDeliveryDate | Datetime | The estimated delivery date. | |
| ActualDeliveryDate | Datetime | The actual delivery date. | |
| ExceptionDescription | String | A description of any delivery exception. | |
| Events | String | The events that occurred during the lifetime of this tracking number. |