BizTalk Adapter for USPS

Build 20.0.7587

TrackShipment

Returns tracking data for requested idValue of IdentifierType type. This procedure does not need to fetch input from your tables. Its output is a result set containing track event records. Each record will automatically be inserted into the TrackHistory table.

Procedure Specific Information

The stored procedure will add its output as records to the following table:

  • TrackHistory

Execute

In order to execute this procedure, one must specify TrackingId (using a valid Tracking Number). See the example below:

EXECUTE TrackShipment TrackingId = '00040000999999999999'

Input

Name Type Description
TrackingId String Tracking number or other identifier to track a shipment.
EndiciaRequestId String The ID used to identify a particular request/response pair when tracking Endicia packages. This must be provided when using Endicia.

Result Set Columns

Name Type Description
TrackingNumber String Tracking number of package or shipment provided by user. This is consistent between all of a shipment's events.
TrackDate Datetime The date on which the tracking was requested. This is consistent between all of a shipment's events.
EventId Integer Identifier the tracked event. This varies between a shipment's events.
EventDate String Date of the tracked event. This varies between a shipment's events.
EventCompany String Company name if delivered to a company for a given TrackingNumber.
EventCity String City where event occurred. This varies between a shipment's events.
EventState String State where event occurred. This varies between a shipment's events.
EventZipCode String Zip code where event occurred. This varies between a shipment's events.
EventCountryCode String Country code where event occurred. This varies between a shipment's events.
Other String Other information about the tracking event.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587