GET api/ordTrackingFreightVw
Get all values from the TrackingFreightVw view
Request Information
URI Parameters
None.
Body Parameters
None.
Response Information
Resource Description
ordTrackingFreightVwDb| Name | Description | Type | Additional information |
|---|---|---|---|
| OrderID | integer |
None. |
|
| WONumber | integer |
None. |
|
| FreightLegID | integer |
None. |
|
| FreightLegSequence | integer |
None. |
|
| TrackingStatus | string |
None. |
|
| TrackingStatusStep | integer |
None. |
|
| TrackingStatusColor | string |
None. |
|
| Forwarder | string |
None. |
|
| BillTo | string |
None. |
|
| BillToEntityID | integer |
None. |
|
| Shipper | string |
None. |
|
| Consignee | string |
None. |
|
| Destination | string |
None. |
|
| PreferredShippingServiceLevel | string |
None. |
|
| LegShipper | string |
None. |
|
| LegOrigin | string |
None. |
|
| Carrier | string |
None. |
|
| LegConsignee | string |
None. |
|
| LegDestination | string |
None. |
|
| CarrierReferenceNumber | string |
None. |
|
| ScheduledPickUpDate | date |
None. |
|
| ActualPickUpDate | date |
None. |
|
| ScheduledDeliveryDate | date |
None. |
|
| ActualDeliveryDate | date |
None. |
|
| TrackingCount | integer |
None. |
|
| TracksToday | integer |
None. |
|
| PONumber | string |
None. |
|
| ReferenceNumber | string |
None. |
|
| CrossReferenceID | integer |
None. |
|
| results | Collection of ValidationResult |
None. |
Response Formats
application/json, text/json
Sample:
{
"results": null,
"OrderID": 1,
"WONumber": 1,
"FreightLegID": 1,
"FreightLegSequence": 1,
"TrackingStatus": "sample string 2",
"TrackingStatusStep": 3,
"TrackingStatusColor": "sample string 4",
"Forwarder": "sample string 5",
"BillTo": "sample string 6",
"BillToEntityID": 7,
"Shipper": "sample string 8",
"Consignee": "sample string 9",
"Destination": "sample string 10",
"PreferredShippingServiceLevel": "sample string 11",
"LegShipper": "sample string 12",
"LegOrigin": "sample string 13",
"Carrier": "sample string 14",
"LegConsignee": "sample string 15",
"LegDestination": "sample string 16",
"CarrierReferenceNumber": "sample string 17",
"ScheduledPickUpDate": "2025-12-06T23:39:43.3797361+00:00",
"ActualPickUpDate": "2025-12-06T23:39:43.3797361+00:00",
"ScheduledDeliveryDate": "2025-12-06T23:39:43.3806696+00:00",
"ActualDeliveryDate": "2025-12-06T23:39:43.3806696+00:00",
"TrackingCount": 1,
"TracksToday": 1,
"PONumber": "sample string 18",
"ReferenceNumber": "sample string 19",
"CrossReferenceID": 1
}
application/xml, text/xml
Sample:
<ordTrackingFreightVwDb xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/WebAPI.Data.Tables">
<results xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.ComponentModel.DataAnnotations" i:nil="true" xmlns="http://schemas.datacontract.org/2004/07/WebAPI.Data.Utility" />
<ActualDeliveryDate xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
<d2p1:DateTime>2025-12-06T23:39:43.3806696Z</d2p1:DateTime>
<d2p1:OffsetMinutes>0</d2p1:OffsetMinutes>
</ActualDeliveryDate>
<ActualPickUpDate xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
<d2p1:DateTime>2025-12-06T23:39:43.3797361Z</d2p1:DateTime>
<d2p1:OffsetMinutes>0</d2p1:OffsetMinutes>
</ActualPickUpDate>
<BillTo>sample string 6</BillTo>
<BillToEntityID>7</BillToEntityID>
<Carrier>sample string 14</Carrier>
<CarrierReferenceNumber>sample string 17</CarrierReferenceNumber>
<Consignee>sample string 9</Consignee>
<CrossReferenceID>1</CrossReferenceID>
<Destination>sample string 10</Destination>
<Forwarder>sample string 5</Forwarder>
<FreightLegID>1</FreightLegID>
<FreightLegSequence>1</FreightLegSequence>
<LegConsignee>sample string 15</LegConsignee>
<LegDestination>sample string 16</LegDestination>
<LegOrigin>sample string 13</LegOrigin>
<LegShipper>sample string 12</LegShipper>
<OrderID>1</OrderID>
<PONumber>sample string 18</PONumber>
<PreferredShippingServiceLevel>sample string 11</PreferredShippingServiceLevel>
<ReferenceNumber>sample string 19</ReferenceNumber>
<ScheduledDeliveryDate xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
<d2p1:DateTime>2025-12-06T23:39:43.3806696Z</d2p1:DateTime>
<d2p1:OffsetMinutes>0</d2p1:OffsetMinutes>
</ScheduledDeliveryDate>
<ScheduledPickUpDate xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
<d2p1:DateTime>2025-12-06T23:39:43.3797361Z</d2p1:DateTime>
<d2p1:OffsetMinutes>0</d2p1:OffsetMinutes>
</ScheduledPickUpDate>
<Shipper>sample string 8</Shipper>
<TrackingCount>1</TrackingCount>
<TrackingStatus>sample string 2</TrackingStatus>
<TrackingStatusColor>sample string 4</TrackingStatusColor>
<TrackingStatusStep>3</TrackingStatusStep>
<TracksToday>1</TracksToday>
<WONumber>1</WONumber>
</ordTrackingFreightVwDb>