POST api/HCS/GetWetChemExcelReport?criteriajson={criteriajson}

Request Information

URI Parameters

Name	Description	Type	Additional information
criteriajson		string	Required

Body Parameters

WetChemMultiObject

Name	Description	Type	Additional information
WetChemSummary		Collection of WetChemSummary	None.
WeekItemOverrides		Collection of WeekItemOverride	None.

Request Formats

application/json, text/json

Sample:

{
  "WetChemSummary": [
    {
      "ITEMNMBR": "sample string 1",
      "ITEMDESC": "sample string 2",
      "LineID": "sample string 3",
      "UMSCHED": "sample string 4",
      "QtyTankFarm": 5.0,
      "QtyTankHeel": 6.0,
      "QtyTankHigh": 7.0,
      "QtyFriday": [
        1.0,
        2.0
      ],
      "QtySaturday": [
        1.0,
        2.0
      ],
      "QtySunday": [
        1.0,
        2.0
      ],
      "QtyMonday": [
        1.0,
        2.0
      ],
      "QtyTuesday": [
        1.0,
        2.0
      ],
      "QtyWednesday": [
        1.0,
        2.0
      ],
      "QtyThursday": [
        1.0,
        2.0
      ],
      "QtyScheduled": [
        1.0,
        2.0
      ],
      "QtyAvailable": [
        1.0,
        2.0
      ]
    },
    {
      "ITEMNMBR": "sample string 1",
      "ITEMDESC": "sample string 2",
      "LineID": "sample string 3",
      "UMSCHED": "sample string 4",
      "QtyTankFarm": 5.0,
      "QtyTankHeel": 6.0,
      "QtyTankHigh": 7.0,
      "QtyFriday": [
        1.0,
        2.0
      ],
      "QtySaturday": [
        1.0,
        2.0
      ],
      "QtySunday": [
        1.0,
        2.0
      ],
      "QtyMonday": [
        1.0,
        2.0
      ],
      "QtyTuesday": [
        1.0,
        2.0
      ],
      "QtyWednesday": [
        1.0,
        2.0
      ],
      "QtyThursday": [
        1.0,
        2.0
      ],
      "QtyScheduled": [
        1.0,
        2.0
      ],
      "QtyAvailable": [
        1.0,
        2.0
      ]
    }
  ],
  "WeekItemOverrides": [
    {
      "ITEMNMBR": "sample string 1",
      "ITEMDESC": "sample string 2",
      "LineID": "sample string 3",
      "StartDate": "sample string 4",
      "OrigWeekTotal": 5.0,
      "QtyFri": [
        1.0,
        2.0
      ],
      "QtySat": [
        1.0,
        2.0
      ],
      "QtySun": [
        1.0,
        2.0
      ],
      "QtyMon": [
        1.0,
        2.0
      ],
      "QtyTue": [
        1.0,
        2.0
      ],
      "QtyWed": [
        1.0,
        2.0
      ],
      "QtyThu": [
        1.0,
        2.0
      ],
      "QtyWeekTotal": [
        1.0,
        2.0
      ]
    },
    {
      "ITEMNMBR": "sample string 1",
      "ITEMDESC": "sample string 2",
      "LineID": "sample string 3",
      "StartDate": "sample string 4",
      "OrigWeekTotal": 5.0,
      "QtyFri": [
        1.0,
        2.0
      ],
      "QtySat": [
        1.0,
        2.0
      ],
      "QtySun": [
        1.0,
        2.0
      ],
      "QtyMon": [
        1.0,
        2.0
      ],
      "QtyTue": [
        1.0,
        2.0
      ],
      "QtyWed": [
        1.0,
        2.0
      ],
      "QtyThu": [
        1.0,
        2.0
      ],
      "QtyWeekTotal": [
        1.0,
        2.0
      ]
    }
  ]
}

application/xml, text/xml

Sample:

<WetChemMultiObject xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/HCSAPI.DTOs">
  <WeekItemOverrides>
    <WeekItemOverride>
      <ITEMDESC>sample string 2</ITEMDESC>
      <ITEMNMBR>sample string 1</ITEMNMBR>
      <LineID>sample string 3</LineID>
      <OrigWeekTotal>5</OrigWeekTotal>
      <QtyFri xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:decimal>1</d4p1:decimal>
        <d4p1:decimal>2</d4p1:decimal>
      </QtyFri>
      <QtyMon xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:decimal>1</d4p1:decimal>
        <d4p1:decimal>2</d4p1:decimal>
      </QtyMon>
      <QtySat xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:decimal>1</d4p1:decimal>
        <d4p1:decimal>2</d4p1:decimal>
      </QtySat>
      <QtySun xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:decimal>1</d4p1:decimal>
        <d4p1:decimal>2</d4p1:decimal>
      </QtySun>
      <QtyThu xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:decimal>1</d4p1:decimal>
        <d4p1:decimal>2</d4p1:decimal>
      </QtyThu>
      <QtyTue xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:decimal>1</d4p1:decimal>
        <d4p1:decimal>2</d4p1:decimal>
      </QtyTue>
      <QtyWed xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:decimal>1</d4p1:decimal>
        <d4p1:decimal>2</d4p1:decimal>
      </QtyWed>
      <QtyWeekTotal xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:decimal>1</d4p1:decimal>
        <d4p1:decimal>2</d4p1:decimal>
      </QtyWeekTotal>
      <StartDate>sample string 4</StartDate>
    </WeekItemOverride>
    <WeekItemOverride>
      <ITEMDESC>sample string 2</ITEMDESC>
      <ITEMNMBR>sample string 1</ITEMNMBR>
      <LineID>sample string 3</LineID>
      <OrigWeekTotal>5</OrigWeekTotal>
      <QtyFri xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:decimal>1</d4p1:decimal>
        <d4p1:decimal>2</d4p1:decimal>
      </QtyFri>
      <QtyMon xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:decimal>1</d4p1:decimal>
        <d4p1:decimal>2</d4p1:decimal>
      </QtyMon>
      <QtySat xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:decimal>1</d4p1:decimal>
        <d4p1:decimal>2</d4p1:decimal>
      </QtySat>
      <QtySun xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:decimal>1</d4p1:decimal>
        <d4p1:decimal>2</d4p1:decimal>
      </QtySun>
      <QtyThu xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:decimal>1</d4p1:decimal>
        <d4p1:decimal>2</d4p1:decimal>
      </QtyThu>
      <QtyTue xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:decimal>1</d4p1:decimal>
        <d4p1:decimal>2</d4p1:decimal>
      </QtyTue>
      <QtyWed xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:decimal>1</d4p1:decimal>
        <d4p1:decimal>2</d4p1:decimal>
      </QtyWed>
      <QtyWeekTotal xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:decimal>1</d4p1:decimal>
        <d4p1:decimal>2</d4p1:decimal>
      </QtyWeekTotal>
      <StartDate>sample string 4</StartDate>
    </WeekItemOverride>
  </WeekItemOverrides>
  <WetChemSummary>
    <WetChemSummary>
      <ITEMDESC>sample string 2</ITEMDESC>
      <ITEMNMBR>sample string 1</ITEMNMBR>
      <LineID>sample string 3</LineID>
      <QtyAvailable xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:decimal>1</d4p1:decimal>
        <d4p1:decimal>2</d4p1:decimal>
      </QtyAvailable>
      <QtyFriday xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:decimal>1</d4p1:decimal>
        <d4p1:decimal>2</d4p1:decimal>
      </QtyFriday>
      <QtyMonday xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:decimal>1</d4p1:decimal>
        <d4p1:decimal>2</d4p1:decimal>
      </QtyMonday>
      <QtySaturday xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:decimal>1</d4p1:decimal>
        <d4p1:decimal>2</d4p1:decimal>
      </QtySaturday>
      <QtyScheduled xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:decimal>1</d4p1:decimal>
        <d4p1:decimal>2</d4p1:decimal>
      </QtyScheduled>
      <QtySunday xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:decimal>1</d4p1:decimal>
        <d4p1:decimal>2</d4p1:decimal>
      </QtySunday>
      <QtyTankFarm>5</QtyTankFarm>
      <QtyTankHeel>6</QtyTankHeel>
      <QtyTankHigh>7</QtyTankHigh>
      <QtyThursday xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:decimal>1</d4p1:decimal>
        <d4p1:decimal>2</d4p1:decimal>
      </QtyThursday>
      <QtyTuesday xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:decimal>1</d4p1:decimal>
        <d4p1:decimal>2</d4p1:decimal>
      </QtyTuesday>
      <QtyWednesday xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:decimal>1</d4p1:decimal>
        <d4p1:decimal>2</d4p1:decimal>
      </QtyWednesday>
      <UMSCHED>sample string 4</UMSCHED>
    </WetChemSummary>
    <WetChemSummary>
      <ITEMDESC>sample string 2</ITEMDESC>
      <ITEMNMBR>sample string 1</ITEMNMBR>
      <LineID>sample string 3</LineID>
      <QtyAvailable xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:decimal>1</d4p1:decimal>
        <d4p1:decimal>2</d4p1:decimal>
      </QtyAvailable>
      <QtyFriday xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:decimal>1</d4p1:decimal>
        <d4p1:decimal>2</d4p1:decimal>
      </QtyFriday>
      <QtyMonday xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:decimal>1</d4p1:decimal>
        <d4p1:decimal>2</d4p1:decimal>
      </QtyMonday>
      <QtySaturday xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:decimal>1</d4p1:decimal>
        <d4p1:decimal>2</d4p1:decimal>
      </QtySaturday>
      <QtyScheduled xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:decimal>1</d4p1:decimal>
        <d4p1:decimal>2</d4p1:decimal>
      </QtyScheduled>
      <QtySunday xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:decimal>1</d4p1:decimal>
        <d4p1:decimal>2</d4p1:decimal>
      </QtySunday>
      <QtyTankFarm>5</QtyTankFarm>
      <QtyTankHeel>6</QtyTankHeel>
      <QtyTankHigh>7</QtyTankHigh>
      <QtyThursday xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:decimal>1</d4p1:decimal>
        <d4p1:decimal>2</d4p1:decimal>
      </QtyThursday>
      <QtyTuesday xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:decimal>1</d4p1:decimal>
        <d4p1:decimal>2</d4p1:decimal>
      </QtyTuesday>
      <QtyWednesday xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:decimal>1</d4p1:decimal>
        <d4p1:decimal>2</d4p1:decimal>
      </QtyWednesday>
      <UMSCHED>sample string 4</UMSCHED>
    </WetChemSummary>
  </WetChemSummary>
</WetChemMultiObject>

application/x-www-form-urlencoded

Sample:

Sample not available.

Response Information

Resource Description

string

Response Formats

application/json, text/json

Sample:

"sample string 1"

application/xml, text/xml

Sample:

<string xmlns="http://schemas.microsoft.com/2003/10/Serialization/">sample string 1</string>