POST api/rawproductsales/getRawSales

Request Information

URI Parameters

None.

Body Parameters

RawSalesDetailRow
NameDescriptionTypeAdditional 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:48:59.5555034+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:48:59.5555034+00:00",
  "endDate": "2026-11-21T14:48:59.5555034+00:00",
  "includeHistory": true,
  "runId": "6b8fced2-7835-4626-861d-181a1ee41b17",
  "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:48:59.5555034+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:48:59.5555034+00:00</invoice_date>
  <invoice_num>sample string 5</invoice_num>
  <pounds>24</pounds>
  <qty>17</qty>
  <runId>6b8fced2-7835-4626-861d-181a1ee41b17</runId>
  <salesman>sample string 8</salesman>
  <skip>34</skip>
  <startDate>2026-11-21T14:48:59.5555034+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
NameDescriptionTypeAdditional 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": "f17473b6-0f7d-4d58-bc21-9d72f55170aa",
  "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:48:59.6048009+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:48:59.6048009+00:00",
      "endDate": "2026-11-21T14:48:59.6048009+00:00",
      "includeHistory": true,
      "runId": "1586045d-d9e2-4596-9519-d5c94e13710c",
      "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:48:59.6048009+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:48:59.6048009+00:00",
      "endDate": "2026-11-21T14:48:59.6048009+00:00",
      "includeHistory": true,
      "runId": "1586045d-d9e2-4596-9519-d5c94e13710c",
      "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:48:59.6048009+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:48:59.6048009+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>1586045d-d9e2-4596-9519-d5c94e13710c</d2p1:runId>
      <d2p1:salesman>sample string 8</d2p1:salesman>
      <d2p1:skip>34</d2p1:skip>
      <d2p1:startDate>2026-11-21T14:48:59.6048009+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:48:59.6048009+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:48:59.6048009+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>1586045d-d9e2-4596-9519-d5c94e13710c</d2p1:runId>
      <d2p1:salesman>sample string 8</d2p1:salesman>
      <d2p1:skip>34</d2p1:skip>
      <d2p1:startDate>2026-11-21T14:48:59.6048009+00:00</d2p1:startDate>
      <d2p1:take>35</d2p1:take>
      <d2p1:warehouse>sample string 7</d2p1:warehouse>
    </d2p1:RawSalesDetailRow>
  </Rows>
  <RunId>f17473b6-0f7d-4d58-bc21-9d72f55170aa</RunId>
  <TotalCost>4</TotalCost>
  <TotalRows>2</TotalRows>
  <TotalSales>3</TotalSales>
  <TotalTons>5</TotalTons>
</SalesDetailResult>