Inventrol

Click here for a complete list of operations.

InsertUpdateUploadedExcel

Test

The test form is only available for requests from the local machine.

SOAP 1.1

The following is a sample SOAP 1.1 request and response. The placeholders shown need to be replaced with actual values.

POST /Inventrol.asmx HTTP/1.1
Host: inventrolapi.smarts3.com
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://localhost:49750/Inventrol.asmx/InsertUpdateUploadedExcel"

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Body>
    <InsertUpdateUploadedExcel xmlns="http://localhost:49750/Inventrol.asmx">
      <objUploadedExcel>
        <Id>int</Id>
        <Name>string</Name>
        <Address>string</Address>
        <Phone>string</Phone>
        <Email>string</Email>
        <Website>string</Website>
        <UserId>int</UserId>
        <BrandId>int</BrandId>
        <ContactPerson>string</ContactPerson>
        <ContactPhone>string</ContactPhone>
        <CocktailId>int</CocktailId>
        <RestaurantId>int</RestaurantId>
        <MaterialId>int</MaterialId>
        <ActivityId>int</ActivityId>
        <SalePrice>decimal</SalePrice>
        <UploadDate>dateTime</UploadDate>
        <FileName>string</FileName>
        <UserName>string</UserName>
        <Password>string</Password>
        <ReportName>string</ReportName>
        <CloneYield>decimal</CloneYield>
        <SubRecipeId>int</SubRecipeId>
        <SubSubRecipeId>int</SubSubRecipeId>
        <Cocktail_Id>int</Cocktail_Id>
        <RSalePrice>decimal</RSalePrice>
        <Reportview>string</Reportview>
      </objUploadedExcel>
    </InsertUpdateUploadedExcel>
  </soap:Body>
</soap:Envelope>

HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Body>
    <InsertUpdateUploadedExcelResponse xmlns="http://localhost:49750/Inventrol.asmx">
      <InsertUpdateUploadedExcelResult>
        <SMS_NumberofRowsAffected>int</SMS_NumberofRowsAffected>
        <SMS_Message>string</SMS_Message>
        <SMS_KeyId>int</SMS_KeyId>
        <SMS_TotalRows>int</SMS_TotalRows>
      </InsertUpdateUploadedExcelResult>
    </InsertUpdateUploadedExcelResponse>
  </soap:Body>
</soap:Envelope>

SOAP 1.2

The following is a sample SOAP 1.2 request and response. The placeholders shown need to be replaced with actual values.

POST /Inventrol.asmx HTTP/1.1
Host: inventrolapi.smarts3.com
Content-Type: application/soap+xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope">
  <soap12:Body>
    <InsertUpdateUploadedExcel xmlns="http://localhost:49750/Inventrol.asmx">
      <objUploadedExcel>
        <Id>int</Id>
        <Name>string</Name>
        <Address>string</Address>
        <Phone>string</Phone>
        <Email>string</Email>
        <Website>string</Website>
        <UserId>int</UserId>
        <BrandId>int</BrandId>
        <ContactPerson>string</ContactPerson>
        <ContactPhone>string</ContactPhone>
        <CocktailId>int</CocktailId>
        <RestaurantId>int</RestaurantId>
        <MaterialId>int</MaterialId>
        <ActivityId>int</ActivityId>
        <SalePrice>decimal</SalePrice>
        <UploadDate>dateTime</UploadDate>
        <FileName>string</FileName>
        <UserName>string</UserName>
        <Password>string</Password>
        <ReportName>string</ReportName>
        <CloneYield>decimal</CloneYield>
        <SubRecipeId>int</SubRecipeId>
        <SubSubRecipeId>int</SubSubRecipeId>
        <Cocktail_Id>int</Cocktail_Id>
        <RSalePrice>decimal</RSalePrice>
        <Reportview>string</Reportview>
      </objUploadedExcel>
    </InsertUpdateUploadedExcel>
  </soap12:Body>
</soap12:Envelope>

HTTP/1.1 200 OK
Content-Type: application/soap+xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope">
  <soap12:Body>
    <InsertUpdateUploadedExcelResponse xmlns="http://localhost:49750/Inventrol.asmx">
      <InsertUpdateUploadedExcelResult>
        <SMS_NumberofRowsAffected>int</SMS_NumberofRowsAffected>
        <SMS_Message>string</SMS_Message>
        <SMS_KeyId>int</SMS_KeyId>
        <SMS_TotalRows>int</SMS_TotalRows>
      </InsertUpdateUploadedExcelResult>
    </InsertUpdateUploadedExcelResponse>
  </soap12:Body>
</soap12:Envelope>