GET api/ordQuotesFreightVw
Get all values from the QuotesFreightVw view
Request Information
URI Parameters
None.
Body Parameters
None.
Response Information
Resource Description
ordQuotesFreightVwDb| Name | Description | Type | Additional information |
|---|---|---|---|
| OrderID | integer |
Required |
|
| QuoteID | integer |
None. |
|
| BillToEntityID | integer |
None. |
|
| DateQuoted | date |
None. |
|
| DateSubmitted | date |
None. |
|
| ForwarderUserID | integer |
None. |
|
| Forwarder | string |
Max length: 101 |
|
| WONumber | integer |
None. |
|
| OriginCity | string |
None. |
|
| OriginStateProvinceCode | string |
None. |
|
| DestinationCity | string |
Max length: 100 |
|
| DestinationStateProvinceCode | string |
Max length: 2 |
|
| QuotedAmt | decimal number |
None. |
|
| BillTo | string |
Max length: 100 |
|
| Status | string |
Max length: 20 |
|
| StatusColor | string |
None. |
|
| CrossReferenceID | integer |
None. |
|
| results | Collection of ValidationResult |
None. |
Response Formats
application/json, text/json
Sample:
{
"results": null,
"OrderID": 1,
"QuoteID": 1,
"BillToEntityID": 2,
"DateQuoted": "2025-12-06T23:41:22.2237811+00:00",
"DateSubmitted": "2025-12-06T23:41:22.2237811+00:00",
"ForwarderUserID": 1,
"Forwarder": "sample string 3",
"WONumber": 1,
"OriginCity": "sample string 4",
"OriginStateProvinceCode": "sample string 5",
"DestinationCity": "sample string 6",
"DestinationStateProvinceCode": "sample string 7",
"QuotedAmt": 1.0,
"BillTo": "sample string 8",
"Status": "sample string 9",
"StatusColor": "sample string 10",
"CrossReferenceID": 1
}
application/xml, text/xml
Sample:
<ordQuotesFreightVwDb 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 8</BillTo>
<BillToEntityID>2</BillToEntityID>
<CrossReferenceID>1</CrossReferenceID>
<DateQuoted xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
<d2p1:DateTime>2025-12-06T23:41:22.2237811Z</d2p1:DateTime>
<d2p1:OffsetMinutes>0</d2p1:OffsetMinutes>
</DateQuoted>
<DateSubmitted xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
<d2p1:DateTime>2025-12-06T23:41:22.2237811Z</d2p1:DateTime>
<d2p1:OffsetMinutes>0</d2p1:OffsetMinutes>
</DateSubmitted>
<DestinationCity>sample string 6</DestinationCity>
<DestinationStateProvinceCode>sample string 7</DestinationStateProvinceCode>
<Forwarder>sample string 3</Forwarder>
<ForwarderUserID>1</ForwarderUserID>
<OrderID>1</OrderID>
<OriginCity>sample string 4</OriginCity>
<OriginStateProvinceCode>sample string 5</OriginStateProvinceCode>
<QuoteID>1</QuoteID>
<QuotedAmt>1</QuotedAmt>
<Status>sample string 9</Status>
<StatusColor>sample string 10</StatusColor>
<WONumber>1</WONumber>
</ordQuotesFreightVwDb>