GET api/ordOrderFreightVw/{id}

Return a single value from the OrdersFreightVw view using the primary key as ID.

Request Information

URI Parameters

Name	Description	Type	Additional information
id	The OrdersFreightVw Primary Key.	integer	Required

Body Parameters

None.

Response Information

Resource Description

ordOrderFreightVwDb

Name	Type	Additional information
OrderID	integer	Required
EntityID	integer	Required
DateSetup	date	None.
DatePickedUp	date	None.
ForwarderUserID	integer	None.
Forwarder	string	Max length: 101
WONumber	integer	None.
BillTo	string	Max length: 100
Shipper	string	Max length: 100
Consignee	string	Max length: 100
ShipmentRate	decimal number	None.
Status	string	Max length: 20
StatusColor	string	None.
ReferenceNumber	string	None.
CrossReferenceID	integer	None.
PONumber	string	None.
results	Collection of ValidationResult	None.

Response Formats

application/json, text/json

Sample:

{
  "results": null,
  "OrderID": 1,
  "EntityID": 2,
  "DateSetup": "2025-12-06T23:41:27.410745+00:00",
  "DatePickedUp": "2025-12-06T23:41:27.410745+00:00",
  "ForwarderUserID": 1,
  "Forwarder": "sample string 3",
  "WONumber": 1,
  "BillTo": "sample string 4",
  "Shipper": "sample string 5",
  "Consignee": "sample string 6",
  "ShipmentRate": 1.0,
  "Status": "sample string 7",
  "StatusColor": "sample string 8",
  "ReferenceNumber": "sample string 9",
  "CrossReferenceID": 1,
  "PONumber": "sample string 10"
}

application/xml, text/xml

Sample:

<ordOrderFreightVwDb 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" />
  <BillTo>sample string 4</BillTo>
  <Consignee>sample string 6</Consignee>
  <CrossReferenceID>1</CrossReferenceID>
  <DatePickedUp xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:DateTime>2025-12-06T23:41:27.410745Z</d2p1:DateTime>
    <d2p1:OffsetMinutes>0</d2p1:OffsetMinutes>
  </DatePickedUp>
  <DateSetup xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:DateTime>2025-12-06T23:41:27.410745Z</d2p1:DateTime>
    <d2p1:OffsetMinutes>0</d2p1:OffsetMinutes>
  </DateSetup>
  <EntityID>2</EntityID>
  <Forwarder>sample string 3</Forwarder>
  <ForwarderUserID>1</ForwarderUserID>
  <OrderID>1</OrderID>
  <PONumber>sample string 10</PONumber>
  <ReferenceNumber>sample string 9</ReferenceNumber>
  <ShipmentRate>1</ShipmentRate>
  <Shipper>sample string 5</Shipper>
  <Status>sample string 7</Status>
  <StatusColor>sample string 8</StatusColor>
  <WONumber>1</WONumber>
</ordOrderFreightVwDb>