GET Api/GetOpenOrdersBySearchExcel?dealerId={dealerId}&StatusId={StatusId}&FromDate={FromDate}&ToDate={ToDate}&PartNumber={PartNumber}&OrderNumber={OrderNumber}
Request Information
URI Parameters
| Name | Description | Type | Additional information |
|---|---|---|---|
| dealerId | integer |
Required |
|
| StatusId | integer |
Required |
|
| FromDate | string |
None. |
|
| ToDate | string |
None. |
|
| PartNumber | string |
None. |
|
| OrderNumber | string |
None. |
Body Parameters
None.
Response Information
Resource Description
v_OrdersView| Name | Description | Type | Additional information |
|---|---|---|---|
| SalesOrderHeaderId | integer |
None. |
|
| OrderNumber | string |
String length: inclusive between 0 and 20 |
|
| CustomerRef | string |
String length: inclusive between 0 and 50 |
|
| CreatedByUserId | integer |
None. |
|
| OrderType | string |
String length: inclusive between 0 and 100 |
|
| OrderStatus | string |
String length: inclusive between 0 and 50 |
|
| OldOrderNumber | string |
String length: inclusive between 0 and 20 |
|
| DealerId | integer |
None. |
|
| CreateDate | date |
None. |
|
| SalesOrderLineId | integer |
None. |
|
| PartNumber | string |
String length: inclusive between 0 and 20 |
|
| StatusId | integer |
None. |
|
| UserName | string |
None. |
Response Formats
application/json, text/json
Sample:
{
"salesOrderHeaderId": 1,
"orderNumber": "sample string 2",
"customerRef": "sample string 3",
"createdByUserId": 4,
"orderType": "sample string 5",
"orderStatus": "sample string 6",
"oldOrderNumber": "sample string 7",
"dealerId": 8,
"createDate": "2025-09-01T00:40:49.5163631+00:00",
"salesOrderLineId": 10,
"partNumber": "sample string 11",
"statusId": 12,
"userName": "sample string 13"
}