Returns tracking information for a shipment.

View-Specific Information

Select

The connector 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 connector.

• 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.