ActiveClubSolutionsCustomerWebServices


Click here for a complete list of operations.

CellarPassCustomerLookup

This function will return an array of Customer records that match the requested SQL where clause which is constructed in the CPCustomer object.
   examples of a CPCustomer object:-
      CPCustomer.ACSCustomerId = "CS0000019"
      CPCustomer.EmailAddress = "sample@gmail.com";

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/CellarPassCustomerLookup"

<?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>
    <CellarPassCustomerLookup xmlns="https://secureclub.net/webservices/">
      <CPCustomer>
        <ACSCustomerId>string</ACSCustomerId>
        <AccountType>string</AccountType>
        <FirstName>string</FirstName>
        <LastName>string</LastName>
        <Phone>string</Phone>
        <EmailAddress>string</EmailAddress>
        <Zipcode>string</Zipcode>
        <Notes>string</Notes>
        <MembershipArray>
          <CPCustomerMembership>
            <ClubName>string</ClubName>
            <ClubType>string</ClubType>
            <Status>string</Status>
            <StartDate>string</StartDate>
            <ExpirationDate>string</ExpirationDate>
            <CancelReason>string</CancelReason>
            <SuspendDate>string</SuspendDate>
            <RestartDate>string</RestartDate>
          </CPCustomerMembership>
          <CPCustomerMembership>
            <ClubName>string</ClubName>
            <ClubType>string</ClubType>
            <Status>string</Status>
            <StartDate>string</StartDate>
            <ExpirationDate>string</ExpirationDate>
            <CancelReason>string</CancelReason>
            <SuspendDate>string</SuspendDate>
            <RestartDate>string</RestartDate>
          </CPCustomerMembership>
        </MembershipArray>
        <MembershipArraySize>int</MembershipArraySize>
      </CPCustomer>
    </CellarPassCustomerLookup>
  </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>
    <CellarPassCustomerLookupResponse xmlns="https://secureclub.net/webservices/">
      <CellarPassCustomerLookupResult>
        <ResponseStatus>
          <StatusCode>int</StatusCode>
          <StatusDescription>string</StatusDescription>
          <StatusRecordCount>int</StatusRecordCount>
        </ResponseStatus>
        <CustomerArray>
          <CPCustomer>
            <ACSCustomerId>string</ACSCustomerId>
            <AccountType>string</AccountType>
            <FirstName>string</FirstName>
            <LastName>string</LastName>
            <Phone>string</Phone>
            <EmailAddress>string</EmailAddress>
            <Zipcode>string</Zipcode>
            <Notes>string</Notes>
            <MembershipArray xsi:nil="true" />
            <MembershipArraySize>int</MembershipArraySize>
          </CPCustomer>
          <CPCustomer>
            <ACSCustomerId>string</ACSCustomerId>
            <AccountType>string</AccountType>
            <FirstName>string</FirstName>
            <LastName>string</LastName>
            <Phone>string</Phone>
            <EmailAddress>string</EmailAddress>
            <Zipcode>string</Zipcode>
            <Notes>string</Notes>
            <MembershipArray xsi:nil="true" />
            <MembershipArraySize>int</MembershipArraySize>
          </CPCustomer>
        </CustomerArray>
        <CustomerArraySize>int</CustomerArraySize>
      </CellarPassCustomerLookupResult>
    </CellarPassCustomerLookupResponse>
  </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>
    <CellarPassCustomerLookup xmlns="https://secureclub.net/webservices/">
      <CPCustomer>
        <ACSCustomerId>string</ACSCustomerId>
        <AccountType>string</AccountType>
        <FirstName>string</FirstName>
        <LastName>string</LastName>
        <Phone>string</Phone>
        <EmailAddress>string</EmailAddress>
        <Zipcode>string</Zipcode>
        <Notes>string</Notes>
        <MembershipArray>
          <CPCustomerMembership>
            <ClubName>string</ClubName>
            <ClubType>string</ClubType>
            <Status>string</Status>
            <StartDate>string</StartDate>
            <ExpirationDate>string</ExpirationDate>
            <CancelReason>string</CancelReason>
            <SuspendDate>string</SuspendDate>
            <RestartDate>string</RestartDate>
          </CPCustomerMembership>
          <CPCustomerMembership>
            <ClubName>string</ClubName>
            <ClubType>string</ClubType>
            <Status>string</Status>
            <StartDate>string</StartDate>
            <ExpirationDate>string</ExpirationDate>
            <CancelReason>string</CancelReason>
            <SuspendDate>string</SuspendDate>
            <RestartDate>string</RestartDate>
          </CPCustomerMembership>
        </MembershipArray>
        <MembershipArraySize>int</MembershipArraySize>
      </CPCustomer>
    </CellarPassCustomerLookup>
  </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>
    <CellarPassCustomerLookupResponse xmlns="https://secureclub.net/webservices/">
      <CellarPassCustomerLookupResult>
        <ResponseStatus>
          <StatusCode>int</StatusCode>
          <StatusDescription>string</StatusDescription>
          <StatusRecordCount>int</StatusRecordCount>
        </ResponseStatus>
        <CustomerArray>
          <CPCustomer>
            <ACSCustomerId>string</ACSCustomerId>
            <AccountType>string</AccountType>
            <FirstName>string</FirstName>
            <LastName>string</LastName>
            <Phone>string</Phone>
            <EmailAddress>string</EmailAddress>
            <Zipcode>string</Zipcode>
            <Notes>string</Notes>
            <MembershipArray xsi:nil="true" />
            <MembershipArraySize>int</MembershipArraySize>
          </CPCustomer>
          <CPCustomer>
            <ACSCustomerId>string</ACSCustomerId>
            <AccountType>string</AccountType>
            <FirstName>string</FirstName>
            <LastName>string</LastName>
            <Phone>string</Phone>
            <EmailAddress>string</EmailAddress>
            <Zipcode>string</Zipcode>
            <Notes>string</Notes>
            <MembershipArray xsi:nil="true" />
            <MembershipArraySize>int</MembershipArraySize>
          </CPCustomer>
        </CustomerArray>
        <CustomerArraySize>int</CustomerArraySize>
      </CellarPassCustomerLookupResult>
    </CellarPassCustomerLookupResponse>
  </soap12:Body>
</soap12:Envelope>