Home / API Documentation

Get Products used per job on completed WOs

Method: GET api/v1/Inventory/GetProductsByCompletedWOByDateRange?fromdate={fromdate}&todate={todate}&companyid={companyid}&page={page}&pagelimit={pagelimit}

Response Format:

application/json

Required Parameters Description Additional information
fromdate

Define this parameter in the request URI.

todate

Define this parameter in the request URI.

companyid

Define this parameter in the request URI.

page

Define this parameter in the request URI.

pagelimit

Define this parameter in the request URI.

application/json, text/json

Sample Response:
                        [
  {
    "woheaderid": 1,
    "utctimestamp": "2025-02-23T06:33:22.1519895+00:00",
    "createdby": "sample string 2",
    "scheduledate": "2025-02-23T06:33:22.1519895+00:00",
    "printeddate": "2025-02-23T06:33:22.1519895+00:00",
    "status": 3,
    "eventlink": 4,
    "batchid": 5,
    "programid": 6,
    "lastchangedby": "sample string 7",
    "utclastchanged": "2025-02-23T06:33:22.1519895+00:00",
    "releaseid": 8,
    "assignedto": 9,
    "creategroupid": "abd71618-198f-4f3b-80bd-1d47df2a7434",
    "timerangeid": 10,
    "duration": 11,
    "scheduletime": 12,
    "workpool": 13,
    "confirmed": 14,
    "originalrouteid": 15,
    "approvedby": "sample string 16",
    "approveddate": "2025-02-23T06:33:22.1519895+00:00",
    "covansysconfirmationid": 17,
    "modifiedby": "sample string 18",
    "asap": true,
    "changedfrom": "sample string 20",
    "reconfirmed": true,
    "isproofofmail": true,
    "hashval": "sample string 23",
    "contactsalesperson": 24,
    "nextcontactdate": "2025-02-23T06:33:22.1519895+00:00",
    "wotype": 25,
    "signatureobtained": true,
    "scheduletimedays": 27,
    "usecop": true,
    "woschedulingtargetsid": 29,
    "tdwithindays": 30,
    "tdlocktoroute": 31,
    "tdexcludedroutes": "sample string 32",
    "pivotdate": "2025-02-23T06:33:22.1519895+00:00",
    "pivottime": 33,
    "pivottimeoptionid": 34,
    "tdlocktodate": 35,
    "usecoa": true,
    "lockModal": true,
    "tdlocktomonth": true,
    "ponumber": "sample string 39",
    "completeddate": "2025-02-23T06:33:22.1519895+00:00",
    "branchid": 40,
    "accountnum": "sample string 41",
    "eventtypeid": 42,
    "eventid": 43,
    "eventname": "sample string 44",
    "woamount": 1.0,
    "canceldate": "2025-02-23T06:33:22.1519895+00:00",
    "nextwodate": "2025-02-23T06:33:22.1519895+00:00",
    "primarysource": 45,
    "secondarysource": 46,
    "routename": "sample string 47",
    "servzipcode": "sample string 48",
    "addressid": 49,
    "primarysalesperson": 50,
    "secondarysalesperson": 51,
    "products": [
      {
        "itemid": 1,
        "itemnum": "sample string 2",
        "itemdescription": "sample string 3",
        "useunit": "sample string 4",
        "usepriceperunit": 5.0,
        "utctimestamp": "2025-02-23T06:33:22.1525052+00:00",
        "utclastchanged": "2025-02-23T06:33:22.1525052+00:00",
        "lastchangedby": "sample string 6",
        "isactive": true,
        "itemcategory": 8,
        "activeingredient": "sample string 9",
        "activepct": 1.0,
        "epa": "sample string 10",
        "dosegerate": "sample string 11",
        "glnumberid": 12,
        "expirationdays": 13,
        "stockdescription": "sample string 14",
        "inventorystockid": 15,
        "usageuom": "sample string 16",
        "usagepemixuom": 1.0,
        "ismixture": true,
        "permitno": "sample string 18",
        "manufacturer": "sample string 19",
        "lotno": "sample string 20",
        "applicationrate": "sample string 21",
        "targettypeid": 22,
        "formulationid": 23,
        "taxgroupid": 24,
        "ischargeable": true,
        "quantity": 1.0,
        "materialrange": 26,
        "materialrend": 1.0,
        "materialrstart": 1.0,
        "treatmentnotes": "sample string 27",
        "branchcode": "sample string 28",
        "lengthareachecked": true,
        "dbhchecked": true,
        "rootzonechecked": true,
        "chemicalgroup": 32,
        "validationdate": "2025-02-23T06:33:22.1525052+00:00",
        "emergencyphonenumber": "sample string 33"
      },
      {
        "itemid": 1,
        "itemnum": "sample string 2",
        "itemdescription": "sample string 3",
        "useunit": "sample string 4",
        "usepriceperunit": 5.0,
        "utctimestamp": "2025-02-23T06:33:22.1525052+00:00",
        "utclastchanged": "2025-02-23T06:33:22.1525052+00:00",
        "lastchangedby": "sample string 6",
        "isactive": true,
        "itemcategory": 8,
        "activeingredient": "sample string 9",
        "activepct": 1.0,
        "epa": "sample string 10",
        "dosegerate": "sample string 11",
        "glnumberid": 12,
        "expirationdays": 13,
        "stockdescription": "sample string 14",
        "inventorystockid": 15,
        "usageuom": "sample string 16",
        "usagepemixuom": 1.0,
        "ismixture": true,
        "permitno": "sample string 18",
        "manufacturer": "sample string 19",
        "lotno": "sample string 20",
        "applicationrate": "sample string 21",
        "targettypeid": 22,
        "formulationid": 23,
        "taxgroupid": 24,
        "ischargeable": true,
        "quantity": 1.0,
        "materialrange": 26,
        "materialrend": 1.0,
        "materialrstart": 1.0,
        "treatmentnotes": "sample string 27",
        "branchcode": "sample string 28",
        "lengthareachecked": true,
        "dbhchecked": true,
        "rootzonechecked": true,
        "chemicalgroup": 32,
        "validationdate": "2025-02-23T06:33:22.1525052+00:00",
        "emergencyphonenumber": "sample string 33"
      }
    ]
  },
  {
    "woheaderid": 1,
    "utctimestamp": "2025-02-23T06:33:22.1519895+00:00",
    "createdby": "sample string 2",
    "scheduledate": "2025-02-23T06:33:22.1519895+00:00",
    "printeddate": "2025-02-23T06:33:22.1519895+00:00",
    "status": 3,
    "eventlink": 4,
    "batchid": 5,
    "programid": 6,
    "lastchangedby": "sample string 7",
    "utclastchanged": "2025-02-23T06:33:22.1519895+00:00",
    "releaseid": 8,
    "assignedto": 9,
    "creategroupid": "abd71618-198f-4f3b-80bd-1d47df2a7434",
    "timerangeid": 10,
    "duration": 11,
    "scheduletime": 12,
    "workpool": 13,
    "confirmed": 14,
    "originalrouteid": 15,
    "approvedby": "sample string 16",
    "approveddate": "2025-02-23T06:33:22.1519895+00:00",
    "covansysconfirmationid": 17,
    "modifiedby": "sample string 18",
    "asap": true,
    "changedfrom": "sample string 20",
    "reconfirmed": true,
    "isproofofmail": true,
    "hashval": "sample string 23",
    "contactsalesperson": 24,
    "nextcontactdate": "2025-02-23T06:33:22.1519895+00:00",
    "wotype": 25,
    "signatureobtained": true,
    "scheduletimedays": 27,
    "usecop": true,
    "woschedulingtargetsid": 29,
    "tdwithindays": 30,
    "tdlocktoroute": 31,
    "tdexcludedroutes": "sample string 32",
    "pivotdate": "2025-02-23T06:33:22.1519895+00:00",
    "pivottime": 33,
    "pivottimeoptionid": 34,
    "tdlocktodate": 35,
    "usecoa": true,
    "lockModal": true,
    "tdlocktomonth": true,
    "ponumber": "sample string 39",
    "completeddate": "2025-02-23T06:33:22.1519895+00:00",
    "branchid": 40,
    "accountnum": "sample string 41",
    "eventtypeid": 42,
    "eventid": 43,
    "eventname": "sample string 44",
    "woamount": 1.0,
    "canceldate": "2025-02-23T06:33:22.1519895+00:00",
    "nextwodate": "2025-02-23T06:33:22.1519895+00:00",
    "primarysource": 45,
    "secondarysource": 46,
    "routename": "sample string 47",
    "servzipcode": "sample string 48",
    "addressid": 49,
    "primarysalesperson": 50,
    "secondarysalesperson": 51,
    "products": [
      {
        "itemid": 1,
        "itemnum": "sample string 2",
        "itemdescription": "sample string 3",
        "useunit": "sample string 4",
        "usepriceperunit": 5.0,
        "utctimestamp": "2025-02-23T06:33:22.1525052+00:00",
        "utclastchanged": "2025-02-23T06:33:22.1525052+00:00",
        "lastchangedby": "sample string 6",
        "isactive": true,
        "itemcategory": 8,
        "activeingredient": "sample string 9",
        "activepct": 1.0,
        "epa": "sample string 10",
        "dosegerate": "sample string 11",
        "glnumberid": 12,
        "expirationdays": 13,
        "stockdescription": "sample string 14",
        "inventorystockid": 15,
        "usageuom": "sample string 16",
        "usagepemixuom": 1.0,
        "ismixture": true,
        "permitno": "sample string 18",
        "manufacturer": "sample string 19",
        "lotno": "sample string 20",
        "applicationrate": "sample string 21",
        "targettypeid": 22,
        "formulationid": 23,
        "taxgroupid": 24,
        "ischargeable": true,
        "quantity": 1.0,
        "materialrange": 26,
        "materialrend": 1.0,
        "materialrstart": 1.0,
        "treatmentnotes": "sample string 27",
        "branchcode": "sample string 28",
        "lengthareachecked": true,
        "dbhchecked": true,
        "rootzonechecked": true,
        "chemicalgroup": 32,
        "validationdate": "2025-02-23T06:33:22.1525052+00:00",
        "emergencyphonenumber": "sample string 33"
      },
      {
        "itemid": 1,
        "itemnum": "sample string 2",
        "itemdescription": "sample string 3",
        "useunit": "sample string 4",
        "usepriceperunit": 5.0,
        "utctimestamp": "2025-02-23T06:33:22.1525052+00:00",
        "utclastchanged": "2025-02-23T06:33:22.1525052+00:00",
        "lastchangedby": "sample string 6",
        "isactive": true,
        "itemcategory": 8,
        "activeingredient": "sample string 9",
        "activepct": 1.0,
        "epa": "sample string 10",
        "dosegerate": "sample string 11",
        "glnumberid": 12,
        "expirationdays": 13,
        "stockdescription": "sample string 14",
        "inventorystockid": 15,
        "usageuom": "sample string 16",
        "usagepemixuom": 1.0,
        "ismixture": true,
        "permitno": "sample string 18",
        "manufacturer": "sample string 19",
        "lotno": "sample string 20",
        "applicationrate": "sample string 21",
        "targettypeid": 22,
        "formulationid": 23,
        "taxgroupid": 24,
        "ischargeable": true,
        "quantity": 1.0,
        "materialrange": 26,
        "materialrend": 1.0,
        "materialrstart": 1.0,
        "treatmentnotes": "sample string 27",
        "branchcode": "sample string 28",
        "lengthareachecked": true,
        "dbhchecked": true,
        "rootzonechecked": true,
        "chemicalgroup": 32,
        "validationdate": "2025-02-23T06:33:22.1525052+00:00",
        "emergencyphonenumber": "sample string 33"
      }
    ]
  }
];