GET api/ordTrackingFreightVw

Get all values from the TrackingFreightVw view

Request Information

URI Parameters

None.

Body Parameters

None.

Response Information

Resource Description

ordTrackingFreightVwDb
NameDescriptionTypeAdditional 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>