BBGenie Web Service

BBGenie

Click here for a complete list of operations.

oQueryLookupTable2

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 /BBAdmin/WebService/BBGenie.asmx HTTP/1.1
Host: webservices.bookingbuilder.com
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://www.bookingbuilder.com/webservices/oQueryLookupTable2"

<?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>
    <oQueryLookupTable2 xmlns="http://www.bookingbuilder.com/webservices">
      <sEmailAddress>string</sEmailAddress>
      <sPassword>string</sPassword>
      <iGroupID>int</iGroupID>
      <sLookupTableName>string</sLookupTableName>
      <aoConditions>
        <QueryCondition>
          <iOpenParenCount>int</iOpenParenCount>
          <sFieldName>string</sFieldName>
          <sOperator>string</sOperator>
          <sValue>string</sValue>
          <iCloseParenCount>int</iCloseParenCount>
          <sCombiner>string</sCombiner>
        </QueryCondition>
        <QueryCondition>
          <iOpenParenCount>int</iOpenParenCount>
          <sFieldName>string</sFieldName>
          <sOperator>string</sOperator>
          <sValue>string</sValue>
          <iCloseParenCount>int</iCloseParenCount>
          <sCombiner>string</sCombiner>
        </QueryCondition>
      </aoConditions>
    </oQueryLookupTable2>
  </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>
    <oQueryLookupTable2Response xmlns="http://www.bookingbuilder.com/webservices">
      <oQueryLookupTable2Result>
        <bSuccess>boolean</bSuccess>
        <sErrorMessage>string</sErrorMessage>
        <iCountAffected>int</iCountAffected>
        <arLookupTableData>
          <LookupTableData2>
            <ixLTData>int</ixLTData>
            <sData1>string</sData1>
            <sData2>string</sData2>
            <sData3>string</sData3>
            <sData4>string</sData4>
            <sData5>string</sData5>
            <sData6>string</sData6>
            <sData7>string</sData7>
            <sData8>string</sData8>
            <sData9>string</sData9>
            <sData10>string</sData10>
            <sData11>string</sData11>
            <sData12>string</sData12>
            <sData13>string</sData13>
            <sData14>string</sData14>
            <sData15>string</sData15>
            <sData16>string</sData16>
            <sData17>string</sData17>
            <sData18>string</sData18>
            <sData19>string</sData19>
            <sData20>string</sData20>
            <sData21>string</sData21>
            <sData22>string</sData22>
            <sData23>string</sData23>
            <sData24>string</sData24>
            <sData25>string</sData25>
            <dtData1>dateTime</dtData1>
            <dtData2>dateTime</dtData2>
            <dtData3>dateTime</dtData3>
            <dtData4>dateTime</dtData4>
            <dtData5>dateTime</dtData5>
            <dtData6>dateTime</dtData6>
            <dtData7>dateTime</dtData7>
            <dtData8>dateTime</dtData8>
            <dtData9>dateTime</dtData9>
            <dtData10>dateTime</dtData10>
            <dtData11>dateTime</dtData11>
            <dtData12>dateTime</dtData12>
            <dtData13>dateTime</dtData13>
            <dtData14>dateTime</dtData14>
            <dtData15>dateTime</dtData15>
            <dtData16>dateTime</dtData16>
            <dtData17>dateTime</dtData17>
            <dtData18>dateTime</dtData18>
            <dtData19>dateTime</dtData19>
            <dtData20>dateTime</dtData20>
            <dtData21>dateTime</dtData21>
            <dtData22>dateTime</dtData22>
            <dtData23>dateTime</dtData23>
            <dtData24>dateTime</dtData24>
            <dtData25>dateTime</dtData25>
            <dblData1>double</dblData1>
            <dblData2>double</dblData2>
            <dblData3>double</dblData3>
            <dblData4>double</dblData4>
            <dblData5>double</dblData5>
            <dblData6>double</dblData6>
            <dblData7>double</dblData7>
            <dblData8>double</dblData8>
            <dblData9>double</dblData9>
            <dblData10>double</dblData10>
            <dblData11>double</dblData11>
            <dblData12>double</dblData12>
            <dblData13>double</dblData13>
            <dblData14>double</dblData14>
            <dblData15>double</dblData15>
            <dblData16>double</dblData16>
            <dblData17>double</dblData17>
            <dblData18>double</dblData18>
            <dblData19>double</dblData19>
            <dblData20>double</dblData20>
            <dblData21>double</dblData21>
            <dblData22>double</dblData22>
            <dblData23>double</dblData23>
            <dblData24>double</dblData24>
            <dblData25>double</dblData25>
          </LookupTableData2>
          <LookupTableData2>
            <ixLTData>int</ixLTData>
            <sData1>string</sData1>
            <sData2>string</sData2>
            <sData3>string</sData3>
            <sData4>string</sData4>
            <sData5>string</sData5>
            <sData6>string</sData6>
            <sData7>string</sData7>
            <sData8>string</sData8>
            <sData9>string</sData9>
            <sData10>string</sData10>
            <sData11>string</sData11>
            <sData12>string</sData12>
            <sData13>string</sData13>
            <sData14>string</sData14>
            <sData15>string</sData15>
            <sData16>string</sData16>
            <sData17>string</sData17>
            <sData18>string</sData18>
            <sData19>string</sData19>
            <sData20>string</sData20>
            <sData21>string</sData21>
            <sData22>string</sData22>
            <sData23>string</sData23>
            <sData24>string</sData24>
            <sData25>string</sData25>
            <dtData1>dateTime</dtData1>
            <dtData2>dateTime</dtData2>
            <dtData3>dateTime</dtData3>
            <dtData4>dateTime</dtData4>
            <dtData5>dateTime</dtData5>
            <dtData6>dateTime</dtData6>
            <dtData7>dateTime</dtData7>
            <dtData8>dateTime</dtData8>
            <dtData9>dateTime</dtData9>
            <dtData10>dateTime</dtData10>
            <dtData11>dateTime</dtData11>
            <dtData12>dateTime</dtData12>
            <dtData13>dateTime</dtData13>
            <dtData14>dateTime</dtData14>
            <dtData15>dateTime</dtData15>
            <dtData16>dateTime</dtData16>
            <dtData17>dateTime</dtData17>
            <dtData18>dateTime</dtData18>
            <dtData19>dateTime</dtData19>
            <dtData20>dateTime</dtData20>
            <dtData21>dateTime</dtData21>
            <dtData22>dateTime</dtData22>
            <dtData23>dateTime</dtData23>
            <dtData24>dateTime</dtData24>
            <dtData25>dateTime</dtData25>
            <dblData1>double</dblData1>
            <dblData2>double</dblData2>
            <dblData3>double</dblData3>
            <dblData4>double</dblData4>
            <dblData5>double</dblData5>
            <dblData6>double</dblData6>
            <dblData7>double</dblData7>
            <dblData8>double</dblData8>
            <dblData9>double</dblData9>
            <dblData10>double</dblData10>
            <dblData11>double</dblData11>
            <dblData12>double</dblData12>
            <dblData13>double</dblData13>
            <dblData14>double</dblData14>
            <dblData15>double</dblData15>
            <dblData16>double</dblData16>
            <dblData17>double</dblData17>
            <dblData18>double</dblData18>
            <dblData19>double</dblData19>
            <dblData20>double</dblData20>
            <dblData21>double</dblData21>
            <dblData22>double</dblData22>
            <dblData23>double</dblData23>
            <dblData24>double</dblData24>
            <dblData25>double</dblData25>
          </LookupTableData2>
        </arLookupTableData>
      </oQueryLookupTable2Result>
    </oQueryLookupTable2Response>
  </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 /BBAdmin/WebService/BBGenie.asmx HTTP/1.1
Host: webservices.bookingbuilder.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>
    <oQueryLookupTable2 xmlns="http://www.bookingbuilder.com/webservices">
      <sEmailAddress>string</sEmailAddress>
      <sPassword>string</sPassword>
      <iGroupID>int</iGroupID>
      <sLookupTableName>string</sLookupTableName>
      <aoConditions>
        <QueryCondition>
          <iOpenParenCount>int</iOpenParenCount>
          <sFieldName>string</sFieldName>
          <sOperator>string</sOperator>
          <sValue>string</sValue>
          <iCloseParenCount>int</iCloseParenCount>
          <sCombiner>string</sCombiner>
        </QueryCondition>
        <QueryCondition>
          <iOpenParenCount>int</iOpenParenCount>
          <sFieldName>string</sFieldName>
          <sOperator>string</sOperator>
          <sValue>string</sValue>
          <iCloseParenCount>int</iCloseParenCount>
          <sCombiner>string</sCombiner>
        </QueryCondition>
      </aoConditions>
    </oQueryLookupTable2>
  </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>
    <oQueryLookupTable2Response xmlns="http://www.bookingbuilder.com/webservices">
      <oQueryLookupTable2Result>
        <bSuccess>boolean</bSuccess>
        <sErrorMessage>string</sErrorMessage>
        <iCountAffected>int</iCountAffected>
        <arLookupTableData>
          <LookupTableData2>
            <ixLTData>int</ixLTData>
            <sData1>string</sData1>
            <sData2>string</sData2>
            <sData3>string</sData3>
            <sData4>string</sData4>
            <sData5>string</sData5>
            <sData6>string</sData6>
            <sData7>string</sData7>
            <sData8>string</sData8>
            <sData9>string</sData9>
            <sData10>string</sData10>
            <sData11>string</sData11>
            <sData12>string</sData12>
            <sData13>string</sData13>
            <sData14>string</sData14>
            <sData15>string</sData15>
            <sData16>string</sData16>
            <sData17>string</sData17>
            <sData18>string</sData18>
            <sData19>string</sData19>
            <sData20>string</sData20>
            <sData21>string</sData21>
            <sData22>string</sData22>
            <sData23>string</sData23>
            <sData24>string</sData24>
            <sData25>string</sData25>
            <dtData1>dateTime</dtData1>
            <dtData2>dateTime</dtData2>
            <dtData3>dateTime</dtData3>
            <dtData4>dateTime</dtData4>
            <dtData5>dateTime</dtData5>
            <dtData6>dateTime</dtData6>
            <dtData7>dateTime</dtData7>
            <dtData8>dateTime</dtData8>
            <dtData9>dateTime</dtData9>
            <dtData10>dateTime</dtData10>
            <dtData11>dateTime</dtData11>
            <dtData12>dateTime</dtData12>
            <dtData13>dateTime</dtData13>
            <dtData14>dateTime</dtData14>
            <dtData15>dateTime</dtData15>
            <dtData16>dateTime</dtData16>
            <dtData17>dateTime</dtData17>
            <dtData18>dateTime</dtData18>
            <dtData19>dateTime</dtData19>
            <dtData20>dateTime</dtData20>
            <dtData21>dateTime</dtData21>
            <dtData22>dateTime</dtData22>
            <dtData23>dateTime</dtData23>
            <dtData24>dateTime</dtData24>
            <dtData25>dateTime</dtData25>
            <dblData1>double</dblData1>
            <dblData2>double</dblData2>
            <dblData3>double</dblData3>
            <dblData4>double</dblData4>
            <dblData5>double</dblData5>
            <dblData6>double</dblData6>
            <dblData7>double</dblData7>
            <dblData8>double</dblData8>
            <dblData9>double</dblData9>
            <dblData10>double</dblData10>
            <dblData11>double</dblData11>
            <dblData12>double</dblData12>
            <dblData13>double</dblData13>
            <dblData14>double</dblData14>
            <dblData15>double</dblData15>
            <dblData16>double</dblData16>
            <dblData17>double</dblData17>
            <dblData18>double</dblData18>
            <dblData19>double</dblData19>
            <dblData20>double</dblData20>
            <dblData21>double</dblData21>
            <dblData22>double</dblData22>
            <dblData23>double</dblData23>
            <dblData24>double</dblData24>
            <dblData25>double</dblData25>
          </LookupTableData2>
          <LookupTableData2>
            <ixLTData>int</ixLTData>
            <sData1>string</sData1>
            <sData2>string</sData2>
            <sData3>string</sData3>
            <sData4>string</sData4>
            <sData5>string</sData5>
            <sData6>string</sData6>
            <sData7>string</sData7>
            <sData8>string</sData8>
            <sData9>string</sData9>
            <sData10>string</sData10>
            <sData11>string</sData11>
            <sData12>string</sData12>
            <sData13>string</sData13>
            <sData14>string</sData14>
            <sData15>string</sData15>
            <sData16>string</sData16>
            <sData17>string</sData17>
            <sData18>string</sData18>
            <sData19>string</sData19>
            <sData20>string</sData20>
            <sData21>string</sData21>
            <sData22>string</sData22>
            <sData23>string</sData23>
            <sData24>string</sData24>
            <sData25>string</sData25>
            <dtData1>dateTime</dtData1>
            <dtData2>dateTime</dtData2>
            <dtData3>dateTime</dtData3>
            <dtData4>dateTime</dtData4>
            <dtData5>dateTime</dtData5>
            <dtData6>dateTime</dtData6>
            <dtData7>dateTime</dtData7>
            <dtData8>dateTime</dtData8>
            <dtData9>dateTime</dtData9>
            <dtData10>dateTime</dtData10>
            <dtData11>dateTime</dtData11>
            <dtData12>dateTime</dtData12>
            <dtData13>dateTime</dtData13>
            <dtData14>dateTime</dtData14>
            <dtData15>dateTime</dtData15>
            <dtData16>dateTime</dtData16>
            <dtData17>dateTime</dtData17>
            <dtData18>dateTime</dtData18>
            <dtData19>dateTime</dtData19>
            <dtData20>dateTime</dtData20>
            <dtData21>dateTime</dtData21>
            <dtData22>dateTime</dtData22>
            <dtData23>dateTime</dtData23>
            <dtData24>dateTime</dtData24>
            <dtData25>dateTime</dtData25>
            <dblData1>double</dblData1>
            <dblData2>double</dblData2>
            <dblData3>double</dblData3>
            <dblData4>double</dblData4>
            <dblData5>double</dblData5>
            <dblData6>double</dblData6>
            <dblData7>double</dblData7>
            <dblData8>double</dblData8>
            <dblData9>double</dblData9>
            <dblData10>double</dblData10>
            <dblData11>double</dblData11>
            <dblData12>double</dblData12>
            <dblData13>double</dblData13>
            <dblData14>double</dblData14>
            <dblData15>double</dblData15>
            <dblData16>double</dblData16>
            <dblData17>double</dblData17>
            <dblData18>double</dblData18>
            <dblData19>double</dblData19>
            <dblData20>double</dblData20>
            <dblData21>double</dblData21>
            <dblData22>double</dblData22>
            <dblData23>double</dblData23>
            <dblData24>double</dblData24>
            <dblData25>double</dblData25>
          </LookupTableData2>
        </arLookupTableData>
      </oQueryLookupTable2Result>
    </oQueryLookupTable2Response>
  </soap12:Body>
</soap12:Envelope>