ActiveClubSolutionsCustomerWebServices


Click here for a complete list of operations.

AddUpdateInventoryRecord

This function allows the External System to pass inserts or updates of Inventory to the Active Club system. If ACSInventoryId exists in ACS the record is updated otherwise if ACSInventoryId is null then the inventory is inserted. Only fields that have actually changed will be updated in ACS which supports field level change logging by user.
The ACS EXTERNALREFERENCE field will be set to ExternalSystemInventoryId, the ACS EXTERNALREFDATE and EXTERNALREFTIME updated with today's date and time.

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 /webservices/customerservice.asmx HTTP/1.1
Host: www.secureclub.net
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "https://secureclub.net/webservices/AddUpdateInventoryRecord"

<?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:Header>
    <AuthorizationHeader xmlns="https://secureclub.net/webservices/">
      <DatabaseName>string</DatabaseName>
      <Username>string</Username>
      <Password>string</Password>
    </AuthorizationHeader>
  </soap:Header>
  <soap:Body>
    <AddUpdateInventoryRecord xmlns="https://secureclub.net/webservices/">
      <AddUpdateInventoryRequest>
        <ACSInventoryId>string</ACSInventoryId>
        <ExternalSystemInventoryId>string</ExternalSystemInventoryId>
        <Inventory>
          <id>string</id>
          <label>string</label>
          <type>string</type>
          <subtype>string</subtype>
          <name>string</name>
          <description>string</description>
          <price>double</price>
          <accountid>string</accountid>
          <accountname>string</accountname>
          <notes>string</notes>
          <weight>double</weight>
          <numofpackages>int</numofpackages>
          <onhand>long</onhand>
          <allocated>long</allocated>
          <onorder>long</onorder>
          <available>long</available>
          <shippinghandling>double</shippinghandling>
          <attribute1>string</attribute1>
          <attribute2>string</attribute2>
          <attribute3>string</attribute3>
          <attribute4>string</attribute4>
          <attribute5>string</attribute5>
          <attribute6>string</attribute6>
          <attribute7>string</attribute7>
          <attribute8>string</attribute8>
          <attribute9>string</attribute9>
          <attribute10>string</attribute10>
          <ruleamounttype>string</ruleamounttype>
          <rulesused>string</rulesused>
          <grouptype>string</grouptype>
          <packaging>string</packaging>
          <isalcohol>string</isalcohol>
          <noofbottles>int</noofbottles>
          <volumeofalcohol>double</volumeofalcohol>
          <alcoholpackaging>string</alcoholpackaging>
          <alcoholtype>string</alcoholtype>
          <inventoryid>string</inventoryid>
          <inventorytype>string</inventorytype>
          <inventoryname>string</inventoryname>
          <litersofalcohol>double</litersofalcohol>
          <clubprice>double</clubprice>
          <clubdiscount>double</clubdiscount>
          <taxable>string</taxable>
          <pickuprule>string</pickuprule>
          <taxclass>string</taxclass>
          <brand>string</brand>
          <shiprule>string</shiprule>
          <discountrule>string</discountrule>
          <sandhdiscount>double</sandhdiscount>
          <clubpriceoption>int</clubpriceoption>
          <externalreference>string</externalreference>
          <cogsaccountid>string</cogsaccountid>
          <cogsaccountname>string</cogsaccountname>
          <cogsprice>double</cogsprice>
          <length>long</length>
          <width>long</width>
          <height>long</height>
          <insuredvalue>double</insuredvalue>
          <groupname>string</groupname>
          <groupid>string</groupid>
          <vintage>long</vintage>
          <winetype>string</winetype>
          <varietal>string</varietal>
          <appellation>string</appellation>
          <harvestdate>string</harvestdate>
          <caseprice>double</caseprice>
          <image>string</image>
          <barrelaging1span>string</barrelaging1span>
          <barrelaging1perc>long</barrelaging1perc>
          <barrelaging1type>string</barrelaging1type>
          <barrelaging2span>string</barrelaging2span>
          <barrelaging2perc>long</barrelaging2perc>
          <barrelaging2type>string</barrelaging2type>
          <barrelaging3span>string</barrelaging3span>
          <barrelaging3perc>long</barrelaging3perc>
          <barrelaging3type>string</barrelaging3type>
          <barrelaging4span>string</barrelaging4span>
          <barrelaging4perc>long</barrelaging4perc>
          <barrelaging4type>string</barrelaging4type>
          <barrelaging5span>string</barrelaging5span>
          <barrelaging5perc>long</barrelaging5perc>
          <barrelaging5type>string</barrelaging5type>
          <varietal1comppercent>long</varietal1comppercent>
          <varietal1compdesc>string</varietal1compdesc>
          <varietal2comppercent>long</varietal2comppercent>
          <varietal2compdesc>string</varietal2compdesc>
          <varietal3comppercent>long</varietal3comppercent>
          <varietal3compdesc>string</varietal3compdesc>
          <varietal4comppercent>long</varietal4comppercent>
          <varietal4compdesc>string</varietal4compdesc>
          <varietal5comppercent>long</varietal5comppercent>
          <varietal5compdesc>string</varietal5compdesc>
          <varietal6comppercent>long</varietal6comppercent>
          <varietal6compdesc>string</varietal6compdesc>
          <varietal7comppercent>long</varietal7comppercent>
          <varietal7compdesc>string</varietal7compdesc>
          <varietal8comppercent>long</varietal8comppercent>
          <varietal8compdesc>string</varietal8compdesc>
          <varietal9comppercent>long</varietal9comppercent>
          <varietal9compdesc>string</varietal9compdesc>
          <displayoncart>string</displayoncart>
          <thumbnailimage>string</thumbnailimage>
          <clonalselection>string</clonalselection>
          <barcode>string</barcode>
          <casesproduced>string</casesproduced>
          <award1honor>string</award1honor>
          <award1desc>string</award1desc>
          <award2honor>string</award2honor>
          <award2desc>string</award2desc>
          <award3honor>string</award3honor>
          <award3desc>string</award3desc>
          <award4honor>string</award4honor>
          <award4desc>string</award4desc>
          <award5honor>string</award5honor>
          <award5desc>string</award5desc>
          <award6honor>string</award6honor>
          <award6desc>string</award6desc>
          <award7honor>string</award7honor>
          <award7desc>string</award7desc>
          <assetaccountid>string</assetaccountid>
          <assetaccountname>string</assetaccountname>
          <donotdiscount>string</donotdiscount>
          <casequantity>long</casequantity>
          <category>string</category>
          <reportgroup>string</reportgroup>
          <creationdate>string</creationdate>
          <lastupdated>string</lastupdated>
          <futuresdate>string</futuresdate>
          <librarywine>string</librarywine>
          <reservewine>string</reservewine>
          <bottlespercase>long</bottlespercase>
          <casesperpallet>long</casesperpallet>
          <itemcounting>string</itemcounting>
          <grouptypename>string</grouptypename>
        </Inventory>
      </AddUpdateInventoryRequest>
    </AddUpdateInventoryRecord>
  </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>
    <AddUpdateInventoryRecordResponse xmlns="https://secureclub.net/webservices/">
      <AddUpdateInventoryRecordResult>
        <ACSInventoryId>string</ACSInventoryId>
        <ResponseStatus>
          <StatusCode>int</StatusCode>
          <StatusDescription>string</StatusDescription>
          <StatusRecordCount>int</StatusRecordCount>
        </ResponseStatus>
      </AddUpdateInventoryRecordResult>
    </AddUpdateInventoryRecordResponse>
  </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 /webservices/customerservice.asmx HTTP/1.1
Host: www.secureclub.net
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:Header>
    <AuthorizationHeader xmlns="https://secureclub.net/webservices/">
      <DatabaseName>string</DatabaseName>
      <Username>string</Username>
      <Password>string</Password>
    </AuthorizationHeader>
  </soap12:Header>
  <soap12:Body>
    <AddUpdateInventoryRecord xmlns="https://secureclub.net/webservices/">
      <AddUpdateInventoryRequest>
        <ACSInventoryId>string</ACSInventoryId>
        <ExternalSystemInventoryId>string</ExternalSystemInventoryId>
        <Inventory>
          <id>string</id>
          <label>string</label>
          <type>string</type>
          <subtype>string</subtype>
          <name>string</name>
          <description>string</description>
          <price>double</price>
          <accountid>string</accountid>
          <accountname>string</accountname>
          <notes>string</notes>
          <weight>double</weight>
          <numofpackages>int</numofpackages>
          <onhand>long</onhand>
          <allocated>long</allocated>
          <onorder>long</onorder>
          <available>long</available>
          <shippinghandling>double</shippinghandling>
          <attribute1>string</attribute1>
          <attribute2>string</attribute2>
          <attribute3>string</attribute3>
          <attribute4>string</attribute4>
          <attribute5>string</attribute5>
          <attribute6>string</attribute6>
          <attribute7>string</attribute7>
          <attribute8>string</attribute8>
          <attribute9>string</attribute9>
          <attribute10>string</attribute10>
          <ruleamounttype>string</ruleamounttype>
          <rulesused>string</rulesused>
          <grouptype>string</grouptype>
          <packaging>string</packaging>
          <isalcohol>string</isalcohol>
          <noofbottles>int</noofbottles>
          <volumeofalcohol>double</volumeofalcohol>
          <alcoholpackaging>string</alcoholpackaging>
          <alcoholtype>string</alcoholtype>
          <inventoryid>string</inventoryid>
          <inventorytype>string</inventorytype>
          <inventoryname>string</inventoryname>
          <litersofalcohol>double</litersofalcohol>
          <clubprice>double</clubprice>
          <clubdiscount>double</clubdiscount>
          <taxable>string</taxable>
          <pickuprule>string</pickuprule>
          <taxclass>string</taxclass>
          <brand>string</brand>
          <shiprule>string</shiprule>
          <discountrule>string</discountrule>
          <sandhdiscount>double</sandhdiscount>
          <clubpriceoption>int</clubpriceoption>
          <externalreference>string</externalreference>
          <cogsaccountid>string</cogsaccountid>
          <cogsaccountname>string</cogsaccountname>
          <cogsprice>double</cogsprice>
          <length>long</length>
          <width>long</width>
          <height>long</height>
          <insuredvalue>double</insuredvalue>
          <groupname>string</groupname>
          <groupid>string</groupid>
          <vintage>long</vintage>
          <winetype>string</winetype>
          <varietal>string</varietal>
          <appellation>string</appellation>
          <harvestdate>string</harvestdate>
          <caseprice>double</caseprice>
          <image>string</image>
          <barrelaging1span>string</barrelaging1span>
          <barrelaging1perc>long</barrelaging1perc>
          <barrelaging1type>string</barrelaging1type>
          <barrelaging2span>string</barrelaging2span>
          <barrelaging2perc>long</barrelaging2perc>
          <barrelaging2type>string</barrelaging2type>
          <barrelaging3span>string</barrelaging3span>
          <barrelaging3perc>long</barrelaging3perc>
          <barrelaging3type>string</barrelaging3type>
          <barrelaging4span>string</barrelaging4span>
          <barrelaging4perc>long</barrelaging4perc>
          <barrelaging4type>string</barrelaging4type>
          <barrelaging5span>string</barrelaging5span>
          <barrelaging5perc>long</barrelaging5perc>
          <barrelaging5type>string</barrelaging5type>
          <varietal1comppercent>long</varietal1comppercent>
          <varietal1compdesc>string</varietal1compdesc>
          <varietal2comppercent>long</varietal2comppercent>
          <varietal2compdesc>string</varietal2compdesc>
          <varietal3comppercent>long</varietal3comppercent>
          <varietal3compdesc>string</varietal3compdesc>
          <varietal4comppercent>long</varietal4comppercent>
          <varietal4compdesc>string</varietal4compdesc>
          <varietal5comppercent>long</varietal5comppercent>
          <varietal5compdesc>string</varietal5compdesc>
          <varietal6comppercent>long</varietal6comppercent>
          <varietal6compdesc>string</varietal6compdesc>
          <varietal7comppercent>long</varietal7comppercent>
          <varietal7compdesc>string</varietal7compdesc>
          <varietal8comppercent>long</varietal8comppercent>
          <varietal8compdesc>string</varietal8compdesc>
          <varietal9comppercent>long</varietal9comppercent>
          <varietal9compdesc>string</varietal9compdesc>
          <displayoncart>string</displayoncart>
          <thumbnailimage>string</thumbnailimage>
          <clonalselection>string</clonalselection>
          <barcode>string</barcode>
          <casesproduced>string</casesproduced>
          <award1honor>string</award1honor>
          <award1desc>string</award1desc>
          <award2honor>string</award2honor>
          <award2desc>string</award2desc>
          <award3honor>string</award3honor>
          <award3desc>string</award3desc>
          <award4honor>string</award4honor>
          <award4desc>string</award4desc>
          <award5honor>string</award5honor>
          <award5desc>string</award5desc>
          <award6honor>string</award6honor>
          <award6desc>string</award6desc>
          <award7honor>string</award7honor>
          <award7desc>string</award7desc>
          <assetaccountid>string</assetaccountid>
          <assetaccountname>string</assetaccountname>
          <donotdiscount>string</donotdiscount>
          <casequantity>long</casequantity>
          <category>string</category>
          <reportgroup>string</reportgroup>
          <creationdate>string</creationdate>
          <lastupdated>string</lastupdated>
          <futuresdate>string</futuresdate>
          <librarywine>string</librarywine>
          <reservewine>string</reservewine>
          <bottlespercase>long</bottlespercase>
          <casesperpallet>long</casesperpallet>
          <itemcounting>string</itemcounting>
          <grouptypename>string</grouptypename>
        </Inventory>
      </AddUpdateInventoryRequest>
    </AddUpdateInventoryRecord>
  </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>
    <AddUpdateInventoryRecordResponse xmlns="https://secureclub.net/webservices/">
      <AddUpdateInventoryRecordResult>
        <ACSInventoryId>string</ACSInventoryId>
        <ResponseStatus>
          <StatusCode>int</StatusCode>
          <StatusDescription>string</StatusDescription>
          <StatusRecordCount>int</StatusRecordCount>
        </ResponseStatus>
      </AddUpdateInventoryRecordResult>
    </AddUpdateInventoryRecordResponse>
  </soap12:Body>
</soap12:Envelope>