wsEvents


Click here for a complete list of operations.

searchEventsSQL

This lets you search for iMIS Events using sql parameters, returning only event level data.

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/wsEvents.asmx HTTP/1.1
Host: demo.atsol.org
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://www.atsol.org/wsEvents/searchEventsSQL"

<?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>
    <AuthHeader xmlns="http://www.atsol.org/wsEvents/">
      <AuthToken>string</AuthToken>
    </AuthHeader>
  </soap:Header>
  <soap:Body>
    <searchEventsSQL xmlns="http://www.atsol.org/wsEvents/">
      <From>string</From>
      <Where>string</Where>
      <SQLParameters>
        <SqlParameter>
          <CompareInfo>None or IgnoreCase or IgnoreNonSpace or IgnoreKanaType or IgnoreWidth or BinarySort or BinarySort2</CompareInfo>
          <XmlSchemaCollectionDatabase>string</XmlSchemaCollectionDatabase>
          <XmlSchemaCollectionOwningSchema>string</XmlSchemaCollectionOwningSchema>
          <XmlSchemaCollectionName>string</XmlSchemaCollectionName>
          <ForceColumnEncryption>boolean</ForceColumnEncryption>
          <LocaleId>int</LocaleId>
          <SqlDbType>BigInt or Binary or Bit or Char or DateTime or Decimal or Float or Image or Int or Money or NChar or NText or NVarChar or Real or UniqueIdentifier or SmallDateTime or SmallInt or SmallMoney or Text or Timestamp or TinyInt or VarBinary or VarChar or Variant or Xml or Udt or Structured or Date or Time or DateTime2 or DateTimeOffset</SqlDbType>
          <SqlValue />
          <UdtTypeName>string</UdtTypeName>
          <TypeName>string</TypeName>
          <Offset>int</Offset>
        </SqlParameter>
        <SqlParameter>
          <CompareInfo>None or IgnoreCase or IgnoreNonSpace or IgnoreKanaType or IgnoreWidth or BinarySort or BinarySort2</CompareInfo>
          <XmlSchemaCollectionDatabase>string</XmlSchemaCollectionDatabase>
          <XmlSchemaCollectionOwningSchema>string</XmlSchemaCollectionOwningSchema>
          <XmlSchemaCollectionName>string</XmlSchemaCollectionName>
          <ForceColumnEncryption>boolean</ForceColumnEncryption>
          <LocaleId>int</LocaleId>
          <SqlDbType>BigInt or Binary or Bit or Char or DateTime or Decimal or Float or Image or Int or Money or NChar or NText or NVarChar or Real or UniqueIdentifier or SmallDateTime or SmallInt or SmallMoney or Text or Timestamp or TinyInt or VarBinary or VarChar or Variant or Xml or Udt or Structured or Date or Time or DateTime2 or DateTimeOffset</SqlDbType>
          <SqlValue />
          <UdtTypeName>string</UdtTypeName>
          <TypeName>string</TypeName>
          <Offset>int</Offset>
        </SqlParameter>
      </SQLParameters>
    </searchEventsSQL>
  </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>
    <searchEventsSQLResponse xmlns="http://www.atsol.org/wsEvents/">
      <searchEventsSQLResult>
        <Events>
          <Event>
            <EventCode>string</EventCode>
            <Status>string</Status>
            <EventCoordID>string</EventCoordID>
            <Title>string</Title>
            <Description>string</Description>
            <AdditionalDescription>string</AdditionalDescription>
            <Coordinators>string</Coordinators>
            <StartDate>dateTime</StartDate>
            <EndDate>dateTime</EndDate>
            <ShowOnWeb>boolean</ShowOnWeb>
            <Address>string</Address>
            <Notes>string</Notes>
            <EventImageName>string</EventImageName>
            <EventUrl>string</EventUrl>
            <EventType>string</EventType>
            <IsWebViewOnly>boolean</IsWebViewOnly>
            <IsEmailRegistration>boolean</IsEmailRegistration>
            <EarlyBirdCutOffDate>dateTime</EarlyBirdCutOffDate>
            <RegularCutOffDate>dateTime</RegularCutOffDate>
            <HeadCount>int</HeadCount>
            <RegistrantCount>int</RegistrantCount>
            <MaximumAttendees>int</MaximumAttendees>
            <Functions xsi:nil="true" />
            <Address1>string</Address1>
            <Address2>string</Address2>
            <Address3>string</Address3>
            <City>string</City>
            <StateProvince>string</StateProvince>
            <TimeZone>string</TimeZone>
            <OnlineStartDate>dateTime</OnlineStartDate>
            <OnlineCutOffDate>dateTime</OnlineCutOffDate>
            <OnlineEditCutOffDate>dateTime</OnlineEditCutOffDate>
            <OnlineCutOffMessage>string</OnlineCutOffMessage>
            <RegistrantClassType>string</RegistrantClassType>
            <RegistrantClassStoredProcedure>string</RegistrantClassStoredProcedure>
            <RegisterSomeoneElseOption>boolean</RegisterSomeoneElseOption>
            <PermanentChange>boolean</PermanentChange>
            <PostalCode>string</PostalCode>
            <Country>string</Country>
            <Directions>string</Directions>
            <UserDefined1>string</UserDefined1>
            <UserDefined2>string</UserDefined2>
            <UserDefined3>string</UserDefined3>
            <UserDefined4>string</UserDefined4>
            <UserDefined5>string</UserDefined5>
            <UserDefined6>string</UserDefined6>
            <UserDefined7>string</UserDefined7>
            <UserDefined8>string</UserDefined8>
            <UserDefined9>string</UserDefined9>
            <UserDefined10>string</UserDefined10>
            <FinancialEntityCode>string</FinancialEntityCode>
            <EventQuestions xsi:nil="true" />
            <TaxAuthority xsi:nil="true" />
            <TaxAuthorityCode>string</TaxAuthorityCode>
            <IsTaxByAddress>boolean</IsTaxByAddress>
          </Event>
          <Event>
            <EventCode>string</EventCode>
            <Status>string</Status>
            <EventCoordID>string</EventCoordID>
            <Title>string</Title>
            <Description>string</Description>
            <AdditionalDescription>string</AdditionalDescription>
            <Coordinators>string</Coordinators>
            <StartDate>dateTime</StartDate>
            <EndDate>dateTime</EndDate>
            <ShowOnWeb>boolean</ShowOnWeb>
            <Address>string</Address>
            <Notes>string</Notes>
            <EventImageName>string</EventImageName>
            <EventUrl>string</EventUrl>
            <EventType>string</EventType>
            <IsWebViewOnly>boolean</IsWebViewOnly>
            <IsEmailRegistration>boolean</IsEmailRegistration>
            <EarlyBirdCutOffDate>dateTime</EarlyBirdCutOffDate>
            <RegularCutOffDate>dateTime</RegularCutOffDate>
            <HeadCount>int</HeadCount>
            <RegistrantCount>int</RegistrantCount>
            <MaximumAttendees>int</MaximumAttendees>
            <Functions xsi:nil="true" />
            <Address1>string</Address1>
            <Address2>string</Address2>
            <Address3>string</Address3>
            <City>string</City>
            <StateProvince>string</StateProvince>
            <TimeZone>string</TimeZone>
            <OnlineStartDate>dateTime</OnlineStartDate>
            <OnlineCutOffDate>dateTime</OnlineCutOffDate>
            <OnlineEditCutOffDate>dateTime</OnlineEditCutOffDate>
            <OnlineCutOffMessage>string</OnlineCutOffMessage>
            <RegistrantClassType>string</RegistrantClassType>
            <RegistrantClassStoredProcedure>string</RegistrantClassStoredProcedure>
            <RegisterSomeoneElseOption>boolean</RegisterSomeoneElseOption>
            <PermanentChange>boolean</PermanentChange>
            <PostalCode>string</PostalCode>
            <Country>string</Country>
            <Directions>string</Directions>
            <UserDefined1>string</UserDefined1>
            <UserDefined2>string</UserDefined2>
            <UserDefined3>string</UserDefined3>
            <UserDefined4>string</UserDefined4>
            <UserDefined5>string</UserDefined5>
            <UserDefined6>string</UserDefined6>
            <UserDefined7>string</UserDefined7>
            <UserDefined8>string</UserDefined8>
            <UserDefined9>string</UserDefined9>
            <UserDefined10>string</UserDefined10>
            <FinancialEntityCode>string</FinancialEntityCode>
            <EventQuestions xsi:nil="true" />
            <TaxAuthority xsi:nil="true" />
            <TaxAuthorityCode>string</TaxAuthorityCode>
            <IsTaxByAddress>boolean</IsTaxByAddress>
          </Event>
        </Events>
        <ResultCode>short</ResultCode>
        <ResultMessage>string</ResultMessage>
      </searchEventsSQLResult>
    </searchEventsSQLResponse>
  </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/wsEvents.asmx HTTP/1.1
Host: demo.atsol.org
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>
    <AuthHeader xmlns="http://www.atsol.org/wsEvents/">
      <AuthToken>string</AuthToken>
    </AuthHeader>
  </soap12:Header>
  <soap12:Body>
    <searchEventsSQL xmlns="http://www.atsol.org/wsEvents/">
      <From>string</From>
      <Where>string</Where>
      <SQLParameters>
        <SqlParameter>
          <CompareInfo>None or IgnoreCase or IgnoreNonSpace or IgnoreKanaType or IgnoreWidth or BinarySort or BinarySort2</CompareInfo>
          <XmlSchemaCollectionDatabase>string</XmlSchemaCollectionDatabase>
          <XmlSchemaCollectionOwningSchema>string</XmlSchemaCollectionOwningSchema>
          <XmlSchemaCollectionName>string</XmlSchemaCollectionName>
          <ForceColumnEncryption>boolean</ForceColumnEncryption>
          <LocaleId>int</LocaleId>
          <SqlDbType>BigInt or Binary or Bit or Char or DateTime or Decimal or Float or Image or Int or Money or NChar or NText or NVarChar or Real or UniqueIdentifier or SmallDateTime or SmallInt or SmallMoney or Text or Timestamp or TinyInt or VarBinary or VarChar or Variant or Xml or Udt or Structured or Date or Time or DateTime2 or DateTimeOffset</SqlDbType>
          <SqlValue />
          <UdtTypeName>string</UdtTypeName>
          <TypeName>string</TypeName>
          <Offset>int</Offset>
        </SqlParameter>
        <SqlParameter>
          <CompareInfo>None or IgnoreCase or IgnoreNonSpace or IgnoreKanaType or IgnoreWidth or BinarySort or BinarySort2</CompareInfo>
          <XmlSchemaCollectionDatabase>string</XmlSchemaCollectionDatabase>
          <XmlSchemaCollectionOwningSchema>string</XmlSchemaCollectionOwningSchema>
          <XmlSchemaCollectionName>string</XmlSchemaCollectionName>
          <ForceColumnEncryption>boolean</ForceColumnEncryption>
          <LocaleId>int</LocaleId>
          <SqlDbType>BigInt or Binary or Bit or Char or DateTime or Decimal or Float or Image or Int or Money or NChar or NText or NVarChar or Real or UniqueIdentifier or SmallDateTime or SmallInt or SmallMoney or Text or Timestamp or TinyInt or VarBinary or VarChar or Variant or Xml or Udt or Structured or Date or Time or DateTime2 or DateTimeOffset</SqlDbType>
          <SqlValue />
          <UdtTypeName>string</UdtTypeName>
          <TypeName>string</TypeName>
          <Offset>int</Offset>
        </SqlParameter>
      </SQLParameters>
    </searchEventsSQL>
  </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>
    <searchEventsSQLResponse xmlns="http://www.atsol.org/wsEvents/">
      <searchEventsSQLResult>
        <Events>
          <Event>
            <EventCode>string</EventCode>
            <Status>string</Status>
            <EventCoordID>string</EventCoordID>
            <Title>string</Title>
            <Description>string</Description>
            <AdditionalDescription>string</AdditionalDescription>
            <Coordinators>string</Coordinators>
            <StartDate>dateTime</StartDate>
            <EndDate>dateTime</EndDate>
            <ShowOnWeb>boolean</ShowOnWeb>
            <Address>string</Address>
            <Notes>string</Notes>
            <EventImageName>string</EventImageName>
            <EventUrl>string</EventUrl>
            <EventType>string</EventType>
            <IsWebViewOnly>boolean</IsWebViewOnly>
            <IsEmailRegistration>boolean</IsEmailRegistration>
            <EarlyBirdCutOffDate>dateTime</EarlyBirdCutOffDate>
            <RegularCutOffDate>dateTime</RegularCutOffDate>
            <HeadCount>int</HeadCount>
            <RegistrantCount>int</RegistrantCount>
            <MaximumAttendees>int</MaximumAttendees>
            <Functions xsi:nil="true" />
            <Address1>string</Address1>
            <Address2>string</Address2>
            <Address3>string</Address3>
            <City>string</City>
            <StateProvince>string</StateProvince>
            <TimeZone>string</TimeZone>
            <OnlineStartDate>dateTime</OnlineStartDate>
            <OnlineCutOffDate>dateTime</OnlineCutOffDate>
            <OnlineEditCutOffDate>dateTime</OnlineEditCutOffDate>
            <OnlineCutOffMessage>string</OnlineCutOffMessage>
            <RegistrantClassType>string</RegistrantClassType>
            <RegistrantClassStoredProcedure>string</RegistrantClassStoredProcedure>
            <RegisterSomeoneElseOption>boolean</RegisterSomeoneElseOption>
            <PermanentChange>boolean</PermanentChange>
            <PostalCode>string</PostalCode>
            <Country>string</Country>
            <Directions>string</Directions>
            <UserDefined1>string</UserDefined1>
            <UserDefined2>string</UserDefined2>
            <UserDefined3>string</UserDefined3>
            <UserDefined4>string</UserDefined4>
            <UserDefined5>string</UserDefined5>
            <UserDefined6>string</UserDefined6>
            <UserDefined7>string</UserDefined7>
            <UserDefined8>string</UserDefined8>
            <UserDefined9>string</UserDefined9>
            <UserDefined10>string</UserDefined10>
            <FinancialEntityCode>string</FinancialEntityCode>
            <EventQuestions xsi:nil="true" />
            <TaxAuthority xsi:nil="true" />
            <TaxAuthorityCode>string</TaxAuthorityCode>
            <IsTaxByAddress>boolean</IsTaxByAddress>
          </Event>
          <Event>
            <EventCode>string</EventCode>
            <Status>string</Status>
            <EventCoordID>string</EventCoordID>
            <Title>string</Title>
            <Description>string</Description>
            <AdditionalDescription>string</AdditionalDescription>
            <Coordinators>string</Coordinators>
            <StartDate>dateTime</StartDate>
            <EndDate>dateTime</EndDate>
            <ShowOnWeb>boolean</ShowOnWeb>
            <Address>string</Address>
            <Notes>string</Notes>
            <EventImageName>string</EventImageName>
            <EventUrl>string</EventUrl>
            <EventType>string</EventType>
            <IsWebViewOnly>boolean</IsWebViewOnly>
            <IsEmailRegistration>boolean</IsEmailRegistration>
            <EarlyBirdCutOffDate>dateTime</EarlyBirdCutOffDate>
            <RegularCutOffDate>dateTime</RegularCutOffDate>
            <HeadCount>int</HeadCount>
            <RegistrantCount>int</RegistrantCount>
            <MaximumAttendees>int</MaximumAttendees>
            <Functions xsi:nil="true" />
            <Address1>string</Address1>
            <Address2>string</Address2>
            <Address3>string</Address3>
            <City>string</City>
            <StateProvince>string</StateProvince>
            <TimeZone>string</TimeZone>
            <OnlineStartDate>dateTime</OnlineStartDate>
            <OnlineCutOffDate>dateTime</OnlineCutOffDate>
            <OnlineEditCutOffDate>dateTime</OnlineEditCutOffDate>
            <OnlineCutOffMessage>string</OnlineCutOffMessage>
            <RegistrantClassType>string</RegistrantClassType>
            <RegistrantClassStoredProcedure>string</RegistrantClassStoredProcedure>
            <RegisterSomeoneElseOption>boolean</RegisterSomeoneElseOption>
            <PermanentChange>boolean</PermanentChange>
            <PostalCode>string</PostalCode>
            <Country>string</Country>
            <Directions>string</Directions>
            <UserDefined1>string</UserDefined1>
            <UserDefined2>string</UserDefined2>
            <UserDefined3>string</UserDefined3>
            <UserDefined4>string</UserDefined4>
            <UserDefined5>string</UserDefined5>
            <UserDefined6>string</UserDefined6>
            <UserDefined7>string</UserDefined7>
            <UserDefined8>string</UserDefined8>
            <UserDefined9>string</UserDefined9>
            <UserDefined10>string</UserDefined10>
            <FinancialEntityCode>string</FinancialEntityCode>
            <EventQuestions xsi:nil="true" />
            <TaxAuthority xsi:nil="true" />
            <TaxAuthorityCode>string</TaxAuthorityCode>
            <IsTaxByAddress>boolean</IsTaxByAddress>
          </Event>
        </Events>
        <ResultCode>short</ResultCode>
        <ResultMessage>string</ResultMessage>
      </searchEventsSQLResult>
    </searchEventsSQLResponse>
  </soap12:Body>
</soap12:Envelope>