Returns tracking information for a shipment.

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.

• TrackingNumber, CarrierCode and CarrierId support the following operator: =.

For example, the following queries are processed server side:

SELECT * FROM TrackingInfo WHERE TrackingNumber = '1234'

SELECT * FROM TrackingInfo WHERE CarrierCode = 'stamps_com'

SELECT * FROM TrackingInfo WHERE CarrierId = 'se-1127650'

Columns

Name	Type	References	Description
TrackingNumber [KEY]	String		The tracking number associated with a shipment.
CarrierCode	String		A shipping carrier, such as fedex, dhl_express, stamps_com, etc.
CarrierId	String	Carriers.Id	A string that uniquely identifies the carrier account.
TrackingUrl	String		The carrier tracking URL, if available.
StatusCode	String		The high-level tracking status code, such as AC (Accepted), IT (In Transit), DE (Delivered), or EX (Exception).
StatusDetailCode	String		The detailed tracking status code.
StatusDescription	String		A human-readable description of the tracking status.
StatusDetailDescription	String		A human-readable description of the detailed tracking status.
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 shipment was sent.
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.