POST api/rawproductsales/getRawSales
Request Information
URI Parameters
None.
Body Parameters
RawSalesDetailRow| Name | Description | Type | Additional information |
|---|---|---|---|
| CUSTNMBR | string |
None. |
|
| CUSTNAME | string |
None. |
|
| PRSTADCD | string |
None. |
|
| CustCategory | string |
None. |
|
| invoice_num | string |
None. |
|
| invoice_date | date |
None. |
|
| warehouse | string |
None. |
|
| salesman | string |
None. |
|
| RepName | string |
None. |
|
| RepSegment | string |
None. |
|
| RepGroup | string |
None. |
|
| ext_cost | decimal number |
None. |
|
| ext_retail | decimal number |
None. |
|
| ProdType | string |
None. |
|
| ITEMNMBR | string |
None. |
|
| ITEMDESC | string |
None. |
|
| qty | decimal number |
None. |
|
| UOFM | string |
None. |
|
| base_qty | decimal number |
None. |
|
| base_uofm | string |
None. |
|
| inv_num | string |
None. |
|
| RawItemDesc | string |
None. |
|
| RawVendor | string |
None. |
|
| pounds | decimal number |
None. |
|
| PercTon | decimal number |
None. |
|
| FifoCost | decimal number |
None. |
|
| RawCost | decimal number |
None. |
|
| RawPrice | decimal number |
None. |
|
| SaleMargin | decimal number |
None. |
|
| startDate | date |
None. |
|
| endDate | date |
None. |
|
| includeHistory | boolean |
None. |
|
| runId | globally unique identifier |
None. |
|
| skip | integer |
None. |
|
| take | integer |
None. |
Request Formats
application/json, text/json
Sample:
{
"CUSTNMBR": "sample string 1",
"CUSTNAME": "sample string 2",
"PRSTADCD": "sample string 3",
"CustCategory": "sample string 4",
"invoice_num": "sample string 5",
"invoice_date": "2026-11-21T14:53:25.9248078+00:00",
"warehouse": "sample string 7",
"salesman": "sample string 8",
"RepName": "sample string 9",
"RepSegment": "sample string 10",
"RepGroup": "sample string 11",
"ext_cost": 12.0,
"ext_retail": 13.0,
"ProdType": "sample string 14",
"ITEMNMBR": "sample string 15",
"ITEMDESC": "sample string 16",
"qty": 17.0,
"UOFM": "sample string 18",
"base_qty": 19.0,
"base_uofm": "sample string 20",
"inv_num": "sample string 21",
"RawItemDesc": "sample string 22",
"RawVendor": "sample string 23",
"pounds": 24.0,
"PercTon": 25.0,
"FifoCost": 26.0,
"RawCost": 27.0,
"RawPrice": 28.0,
"SaleMargin": 29.0,
"startDate": "2026-11-21T14:53:25.9248078+00:00",
"endDate": "2026-11-21T14:53:25.9248078+00:00",
"includeHistory": true,
"runId": "05d2c4bd-58fc-45d7-8c5b-007cfe2ac6a1",
"skip": 34,
"take": 35
}
application/xml, text/xml
Sample:
<RawSalesDetailRow xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/GoHarrellsAPI.Models"> <CUSTNAME>sample string 2</CUSTNAME> <CUSTNMBR>sample string 1</CUSTNMBR> <CustCategory>sample string 4</CustCategory> <FifoCost>26</FifoCost> <ITEMDESC>sample string 16</ITEMDESC> <ITEMNMBR>sample string 15</ITEMNMBR> <PRSTADCD>sample string 3</PRSTADCD> <PercTon>25</PercTon> <ProdType>sample string 14</ProdType> <RawCost>27</RawCost> <RawItemDesc>sample string 22</RawItemDesc> <RawPrice>28</RawPrice> <RawVendor>sample string 23</RawVendor> <RepGroup>sample string 11</RepGroup> <RepName>sample string 9</RepName> <RepSegment>sample string 10</RepSegment> <SaleMargin>29</SaleMargin> <UOFM>sample string 18</UOFM> <base_qty>19</base_qty> <base_uofm>sample string 20</base_uofm> <endDate>2026-11-21T14:53:25.9248078+00:00</endDate> <ext_cost>12</ext_cost> <ext_retail>13</ext_retail> <includeHistory>true</includeHistory> <inv_num>sample string 21</inv_num> <invoice_date>2026-11-21T14:53:25.9248078+00:00</invoice_date> <invoice_num>sample string 5</invoice_num> <pounds>24</pounds> <qty>17</qty> <runId>05d2c4bd-58fc-45d7-8c5b-007cfe2ac6a1</runId> <salesman>sample string 8</salesman> <skip>34</skip> <startDate>2026-11-21T14:53:25.9248078+00:00</startDate> <take>35</take> <warehouse>sample string 7</warehouse> </RawSalesDetailRow>
application/x-www-form-urlencoded
Sample:
Sample not available.
Response Information
Resource Description
SalesDetailResult| Name | Description | Type | Additional information |
|---|---|---|---|
| RunId | globally unique identifier |
None. |
|
| TotalRows | integer |
None. |
|
| Rows | Collection of RawSalesDetailRow |
None. |
|
| TotalSales | decimal number |
None. |
|
| TotalCost | decimal number |
None. |
|
| TotalTons | decimal number |
None. |
Response Formats
application/json, text/json
Sample:
{
"RunId": "fef49b8d-18fb-4c93-a22b-b4ea5c3a1456",
"TotalRows": 2,
"Rows": [
{
"CUSTNMBR": "sample string 1",
"CUSTNAME": "sample string 2",
"PRSTADCD": "sample string 3",
"CustCategory": "sample string 4",
"invoice_num": "sample string 5",
"invoice_date": "2026-11-21T14:53:25.9560522+00:00",
"warehouse": "sample string 7",
"salesman": "sample string 8",
"RepName": "sample string 9",
"RepSegment": "sample string 10",
"RepGroup": "sample string 11",
"ext_cost": 12.0,
"ext_retail": 13.0,
"ProdType": "sample string 14",
"ITEMNMBR": "sample string 15",
"ITEMDESC": "sample string 16",
"qty": 17.0,
"UOFM": "sample string 18",
"base_qty": 19.0,
"base_uofm": "sample string 20",
"inv_num": "sample string 21",
"RawItemDesc": "sample string 22",
"RawVendor": "sample string 23",
"pounds": 24.0,
"PercTon": 25.0,
"FifoCost": 26.0,
"RawCost": 27.0,
"RawPrice": 28.0,
"SaleMargin": 29.0,
"startDate": "2026-11-21T14:53:25.9560522+00:00",
"endDate": "2026-11-21T14:53:25.9560522+00:00",
"includeHistory": true,
"runId": "56b1f9b1-1aa8-4330-8e42-c0a811b7d4fd",
"skip": 34,
"take": 35
},
{
"CUSTNMBR": "sample string 1",
"CUSTNAME": "sample string 2",
"PRSTADCD": "sample string 3",
"CustCategory": "sample string 4",
"invoice_num": "sample string 5",
"invoice_date": "2026-11-21T14:53:25.9560522+00:00",
"warehouse": "sample string 7",
"salesman": "sample string 8",
"RepName": "sample string 9",
"RepSegment": "sample string 10",
"RepGroup": "sample string 11",
"ext_cost": 12.0,
"ext_retail": 13.0,
"ProdType": "sample string 14",
"ITEMNMBR": "sample string 15",
"ITEMDESC": "sample string 16",
"qty": 17.0,
"UOFM": "sample string 18",
"base_qty": 19.0,
"base_uofm": "sample string 20",
"inv_num": "sample string 21",
"RawItemDesc": "sample string 22",
"RawVendor": "sample string 23",
"pounds": 24.0,
"PercTon": 25.0,
"FifoCost": 26.0,
"RawCost": 27.0,
"RawPrice": 28.0,
"SaleMargin": 29.0,
"startDate": "2026-11-21T14:53:25.9560522+00:00",
"endDate": "2026-11-21T14:53:25.9560522+00:00",
"includeHistory": true,
"runId": "56b1f9b1-1aa8-4330-8e42-c0a811b7d4fd",
"skip": 34,
"take": 35
}
],
"TotalSales": 3.0,
"TotalCost": 4.0,
"TotalTons": 5.0
}
application/xml, text/xml
Sample:
<SalesDetailResult xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/GoHarrellsAPI.BusinessRules">
<Rows xmlns:d2p1="http://schemas.datacontract.org/2004/07/GoHarrellsAPI.Models">
<d2p1:RawSalesDetailRow>
<d2p1:CUSTNAME>sample string 2</d2p1:CUSTNAME>
<d2p1:CUSTNMBR>sample string 1</d2p1:CUSTNMBR>
<d2p1:CustCategory>sample string 4</d2p1:CustCategory>
<d2p1:FifoCost>26</d2p1:FifoCost>
<d2p1:ITEMDESC>sample string 16</d2p1:ITEMDESC>
<d2p1:ITEMNMBR>sample string 15</d2p1:ITEMNMBR>
<d2p1:PRSTADCD>sample string 3</d2p1:PRSTADCD>
<d2p1:PercTon>25</d2p1:PercTon>
<d2p1:ProdType>sample string 14</d2p1:ProdType>
<d2p1:RawCost>27</d2p1:RawCost>
<d2p1:RawItemDesc>sample string 22</d2p1:RawItemDesc>
<d2p1:RawPrice>28</d2p1:RawPrice>
<d2p1:RawVendor>sample string 23</d2p1:RawVendor>
<d2p1:RepGroup>sample string 11</d2p1:RepGroup>
<d2p1:RepName>sample string 9</d2p1:RepName>
<d2p1:RepSegment>sample string 10</d2p1:RepSegment>
<d2p1:SaleMargin>29</d2p1:SaleMargin>
<d2p1:UOFM>sample string 18</d2p1:UOFM>
<d2p1:base_qty>19</d2p1:base_qty>
<d2p1:base_uofm>sample string 20</d2p1:base_uofm>
<d2p1:endDate>2026-11-21T14:53:25.9560522+00:00</d2p1:endDate>
<d2p1:ext_cost>12</d2p1:ext_cost>
<d2p1:ext_retail>13</d2p1:ext_retail>
<d2p1:includeHistory>true</d2p1:includeHistory>
<d2p1:inv_num>sample string 21</d2p1:inv_num>
<d2p1:invoice_date>2026-11-21T14:53:25.9560522+00:00</d2p1:invoice_date>
<d2p1:invoice_num>sample string 5</d2p1:invoice_num>
<d2p1:pounds>24</d2p1:pounds>
<d2p1:qty>17</d2p1:qty>
<d2p1:runId>56b1f9b1-1aa8-4330-8e42-c0a811b7d4fd</d2p1:runId>
<d2p1:salesman>sample string 8</d2p1:salesman>
<d2p1:skip>34</d2p1:skip>
<d2p1:startDate>2026-11-21T14:53:25.9560522+00:00</d2p1:startDate>
<d2p1:take>35</d2p1:take>
<d2p1:warehouse>sample string 7</d2p1:warehouse>
</d2p1:RawSalesDetailRow>
<d2p1:RawSalesDetailRow>
<d2p1:CUSTNAME>sample string 2</d2p1:CUSTNAME>
<d2p1:CUSTNMBR>sample string 1</d2p1:CUSTNMBR>
<d2p1:CustCategory>sample string 4</d2p1:CustCategory>
<d2p1:FifoCost>26</d2p1:FifoCost>
<d2p1:ITEMDESC>sample string 16</d2p1:ITEMDESC>
<d2p1:ITEMNMBR>sample string 15</d2p1:ITEMNMBR>
<d2p1:PRSTADCD>sample string 3</d2p1:PRSTADCD>
<d2p1:PercTon>25</d2p1:PercTon>
<d2p1:ProdType>sample string 14</d2p1:ProdType>
<d2p1:RawCost>27</d2p1:RawCost>
<d2p1:RawItemDesc>sample string 22</d2p1:RawItemDesc>
<d2p1:RawPrice>28</d2p1:RawPrice>
<d2p1:RawVendor>sample string 23</d2p1:RawVendor>
<d2p1:RepGroup>sample string 11</d2p1:RepGroup>
<d2p1:RepName>sample string 9</d2p1:RepName>
<d2p1:RepSegment>sample string 10</d2p1:RepSegment>
<d2p1:SaleMargin>29</d2p1:SaleMargin>
<d2p1:UOFM>sample string 18</d2p1:UOFM>
<d2p1:base_qty>19</d2p1:base_qty>
<d2p1:base_uofm>sample string 20</d2p1:base_uofm>
<d2p1:endDate>2026-11-21T14:53:25.9560522+00:00</d2p1:endDate>
<d2p1:ext_cost>12</d2p1:ext_cost>
<d2p1:ext_retail>13</d2p1:ext_retail>
<d2p1:includeHistory>true</d2p1:includeHistory>
<d2p1:inv_num>sample string 21</d2p1:inv_num>
<d2p1:invoice_date>2026-11-21T14:53:25.9560522+00:00</d2p1:invoice_date>
<d2p1:invoice_num>sample string 5</d2p1:invoice_num>
<d2p1:pounds>24</d2p1:pounds>
<d2p1:qty>17</d2p1:qty>
<d2p1:runId>56b1f9b1-1aa8-4330-8e42-c0a811b7d4fd</d2p1:runId>
<d2p1:salesman>sample string 8</d2p1:salesman>
<d2p1:skip>34</d2p1:skip>
<d2p1:startDate>2026-11-21T14:53:25.9560522+00:00</d2p1:startDate>
<d2p1:take>35</d2p1:take>
<d2p1:warehouse>sample string 7</d2p1:warehouse>
</d2p1:RawSalesDetailRow>
</Rows>
<RunId>fef49b8d-18fb-4c93-a22b-b4ea5c3a1456</RunId>
<TotalCost>4</TotalCost>
<TotalRows>2</TotalRows>
<TotalSales>3</TotalSales>
<TotalTons>5</TotalTons>
</SalesDetailResult>