LabelTracking
Returns tracking information for the specified label.
View-Specific Information
Select
The provider 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 provider.
- 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. |